Data Insights & Analysis Dashboard(POWER BI) Diamond & gold jewellery

₹1500-12500 INR

In corso

Pubblicato

10 mesi fa

₹1500-12500 INR

Pagato al completamento

Your Excel file has multiple sheets with specific purposes. The Primary shhet is raw data , there's a Certified Diamond Details Sheet and Sales Analysis Report and process loss Sheet for specific information and sales insights. I need to do a sales analysis report showing how much each salesman sold, create a global map based on customer countries (using mobile numbers), and calculate the net profit of customers (sales price - cost price). Sales data will come from the sales analysis report, and cost prices can be found in the raw data. Need a report where the physical location (Column H) is different from the brand name (Column AD) and also copare this with alias (Column C, as per the Alias sheet).lso see the alias true meaning and explanation in another sheet) Differentiate between stock items and custom order items. Include filter buttons for each graph and data section, such as "STOCK DATA & CUSTOM ORDER" and "REPAIRING AND MANUFACTURING ACTIVITIES." also TIME ( time is calculate based on document date in raw data) I need a report showing the number of data entries made by each data entry operator per day and the total amount of work they have done I need a report that automatically searches for certified diamonds in the raw data ( check this certi or not based on certified diamond list ) If a certified diamond is found, it should create a separate sheet with its details. Additionally, when I click on a diamond, I should be able to see its corresponding jewelry tag number. total profit ,sales analysis ,aging report

Rif. progetto: 36993052

Info sul progetto

32 proposte

Progetto a distanza

Attivo 9 mesi fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato a:

@derrickmulwa

Hello. I have taken time and read your expectation and objective of this analysis and presentation using Power BI. I have created many appealing and informative dashboards in Power BI. I have seen that you would want to load the data straight into Power BI, with little modifications done in Excel. I do however have a very strong experience in python for data analysis and would like to use it so that you can get the best outcome, e.g. in locating using mobile phone number. I am a data analyst by profession. I would really like to work on this exciting project. Feel free to chat with me so that we can discuss this further.

₹5.000 INR in 2 giorni

0,0

(0 valutazioni)

0,0

32 freelance hanno fatto un'offerta media di ₹7.973 INR

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

₹12.000 INR in 5 giorni

4,9

(646 valutazioni)

8,6

@Akmanyu

Hi There, Good evening! I have gone through your requirement. I have worked on the similar type of requirement in past. Please ping to discuss more on the project. Below is my intro - "First use then believe". I don't want to mention much here but I have 7+ years of extensive experience in different types of visualization tools along with Power BI, Power Apps, Power Automate, Python & AWS with total 9+ years of IT experience. I am not intelligent, but I try to complete the work ASAP as I don't believe in deadline. I don't believe in saying rather my work speaks. It's our first collaboration that's why I have to describe my proposal or else I prefer not to as it won't be needed next time. ✅ You can go through my profile to see my past works in Freelancer site ==> https://www.freelancer.com/u/Akmanyu

₹7.000 INR in 7 giorni

5,0

(72 valutazioni)

5,9

@merinsinha

I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.

₹10.000 INR in 3 giorni

4,6

(203 valutazioni)

6,2

@mhgroup21

Dear Client, I have sound knowledge of Power BI. Also, I previously carried out several projects in Power BI using DAX. I ensure you will be happy after hiring me. Kindly contact me. Check my portfolio, Main Profile - https://www.freelancer.com/u/mhgroup21 Thank you

₹2.500 INR in 1 giorno

5,0

(37 valutazioni)

5,0

@chirag9700

Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have more than 4+ years of experience in PowerApps, PowerAutomate, Microsoft Teams and PowerBI. Expert in design and development. Looking forward to discuss your requirement further. Regards, Chirag.

₹9.000 INR in 1 giorno

4,0

(3 valutazioni)

4,3

@kavitadhingra

I understand your need to analyze sales data and create a report showing how much each salesman sold, create a global map based on customer countries (using mobile numbers), and calculate the net profit of customers (sales price - cost price). I can help you with this project - let me know if you are interested in discussing further! I have 15 years of industry experience in various technologies such as Power BI, SQL Server, Excel, VBA, SQL Server and MS Office. I have worked on multiple Power BI projects with different data sources such as SQL Server, Oracle, Azure Databricks. I also have experience in automating Excel files using Power BI. If you are interested in discussing further please let me know.

₹7.000 INR in 4 giorni

5,0

(3 valutazioni)

2,4

@mmjwritersgroup

Hi, I checked and understood your requirements. I am ready to start Right now. 100% accuracy will be delivered with a time frame and suitable budget. I am fast and dedicated. Let's discuss the job. Thanks.

₹2.000 INR in 1 giorno

0,0

(0 valutazioni)

0,0

@rajaravi2283

I HAVE THE BEST SKILLS OF TYPING,EXCEL,DATA ENTRY, HTML, AND THE DATA INSIGHTS AND ANALYSIS ,I HAVE DONE IT MANY TIMES IN OUR COLLEGE ,YOU HAVE GAVE ME AN OPPORTUNITY TO PRESENT MYSELF, THANK YOU SIR.

₹7.000 INR in 2 giorni

0,0

(0 valutazioni)

0,0

@rakesh1705

Hi myself Rakesh . I am well experienced with data analysis and expressing my analysis with the help of power bi platform, I am quite experience with dax functions. I have already prepared hr dashboard, project control dashboard, sales dashboard etc. I have more than 11 years of overall experience and 5 years of relevant experience in power bi. I know advance excel and power query also. I have seen your file and have an idea how to provide a quality delivery within a short period. Looking forward to have a meeting with you. Regards Rakesh Saha

₹4.500 INR in 2 giorni

0,0

(0 valutazioni)

0,0

@Mirzaansarbaig

Hello sir, my name is Mirzaansarbaig and i saw your requirement and i am interested to do work with you further information please contact me anytime 24/7 available for you i make sure you that I will have nice time with you. Thank you

₹7.500 INR in 3 giorni

0,0

(0 valutazioni)

0,0

@BrahimBentaleb

Hi, I'm an Excel expert with a strong background in data analysis and reporting. I'm confident in handling your project's tasks, including sales analysis, differentiating stock vs. custom orders, data entry operator reports, and certified diamond analysis. My focus is on delivering accurate, user-friendly, and visually appealing results. Let's discuss the details and get started! Best regards,

₹7.000 INR in 1 giorno

0,0

(0 valutazioni)

0,0

@tanvig619

Hi, Having reviewed and comprehended your requirements, I am prepared to commence immediately. I assure you of delivering with utmost precision, within the specified time frame. My dedication and efficiency are unmatched, ensuring successful project completion. Let's connect to discuss the job further. Feel free to reach out at your convenience.

₹7.000 INR in 7 giorni

0,0

(0 valutazioni)

0,0

@Hoyekunlay

Am a Data Analyst by profession and the set of skills needed are the skills I possessed to carry out this work effortlessly with a touch of accuracy.

₹7.000 INR in 7 giorni

0,0

(0 valutazioni)

0,0

@Siyyamalikhan

Experienced Data Scientist with Python, Pandas, NumPy, Selenium, and Beautiful Soup expertise for efficient web scraping , data analysis data visualization . Delivering actionable insights and tailored solutions. Let's unleash the full potential of your data! Contact me today.

₹7.000 INR in 7 giorni

0,0

(0 valutazioni)

0,0

@ariasnico1987

The aforementioned project is very similar to the jobs I do monthly for the company I'm working for. This company is a telecommunications company and we constantly make comparisons through reports extracted in excel (either csv, xlsx, etc). These comparisons are about sales, sales areas, areas of higher and lower productivity, customers with higher or lower purchases, monthly projections, achievement of objectives for employees. I think I am qualified to carry out this project that you mention. Greetings

₹7.000 INR in 5 giorni

0,0

(0 valutazioni)

0,0

@kristianlie204

Hi there, i would like to analyze your excel sheet using power BI and fullfill all your information that you need regrading this project.

₹8.200 INR in 7 giorni

0,0

(0 valutazioni)

0,0

@mehul53

Hi there, Hope you are doing well!! I understood your project requirement details. With overall 17+ years of industry experience and skills in Power BI, SQL Server, Excel, VBA, and MS Office, seem well-equipped to handle the tasks at hand. Analyzing sales data and creating a report showing sales for each salesman would likely involve extracting and transforming the data from various sources. For creating a global map based on customer countries using mobile numbers, you might need to geocode the mobile numbers and then visualize the data on a map in Power BI. Calculating the net profit of customers by subtracting the cost price from the sales price can be achieved with Power BI's DAX (Data Analysis Expressions) language, and your skills in Power BI and Excel will come in handy for this task. Let’s connect for a quick discovery call to understand your project requirements in much more detail and to know your expectations about the project. Thanks and Regards, Mehul Patel.

₹2.000 INR in 7 giorni

0,0

(0 valutazioni)

0,0

@Wahinnovations21

Hi there, I am Sanyukta from Wahinnovations. I have read you proposal. I would like to present a comprehensive proposal to address your Excel file enhancement and reporting needs. I propose to create a suite of dynamic and automated reports that extract valuable insights from your data which enables you to make informed business decisions. My approach for your requirement: Sales Analysis Report: Comprehensive sales analysis by salesman and global customer country mapping. Net profit calculations using sales and cost price data. Physical Location vs. Brand Name vs. Alias: Identify and compare discrepancies between location, brand, and alias. Clear alias explanations, separate sheet provided. Stock vs. Custom Items: Visualize stock vs. custom items with filter buttons. Workload and Data Entry: Track daily data entries per operator. Analyze total work per operator. Certified Diamond Detection: Automate identification of certified diamonds. Separate sheet with details and clickable links. Total Profit & Aging Report: Combine total profit, sales analysis, and aging insights. I would like to discuss more, Please feel free to reach out at your convenience. Best Regards, Sanyukta Wahinnovations

₹7.000 INR in 7 giorni

0,0

(0 valutazioni)

0,0

@jiyasoni491

Hello! My name is jiya and I am a professional web, app, and software developer with 9.5 years of experience in the industry. I specialize in developing high-quality digital solutions that deliver exceptional results for my clients. I understand your need for a sales analysis report, global map based on customer countries using mobile numbers calculation of net profit of customers' sales prices - cost prices. I understand that the data will come from the sales analysis report and cost prices can be found in the raw data. I am confident that my skillset encompass all necessary elements to complete this project including data insights & analysis dashboard ( POWER BI ). My profile includes information about my skills such as Python which makes it easier for me to complete this project. Additionally, I am committed to maintaining clean and maintainable code which ensures scalability security and ease of maintenance for your web, app or software solution.

₹7.000 INR in 7 giorni