I have a data analysis task to use the excel pivot tables. Data Analysis Report
Imagine the following scenario - You are hired as the new assistant to the executive board. You are asked to prepare a meeting for tomorrow, in which the board will expect a full briefing based on the data you have been given (raw data set). Remember, they already know the data - your job is to reveal the trends, patterns, find information, dig for the hidden gems that will help the organization improve!
Do the data analysis and creation of visuals in your excel file – save it with a file name reflecting that work - include your name in the file name please. You should end up with tabs like the following snip, at a minimum. Submit this file along with your finalized project.
Tabs: Data, Overview, Sales Overview, Sales Overview Diagram, Top Customers, Top Customers Diagram, Top Products, Top Products Diagram, Top Regions, Top Regions Diagram
At a minimum, you must discuss the following questions, and offer visual support for each:
How have sales developed in 2013 – compared to the year before?
Who are the top 10 customers in each year? What changes can be noted?
What are the top 10 products in each year? What changes can be noted?
How are sales distributed over the regions? Have shifts occurred?
What else might be helpful?
TIP: You should be able to produce visuals that look similar to these snips:
Bu iş için 24 freelancer ortalamada $25 teklif veriyor
Hi, I'm Vanja. I have 6 years of experience as Financial Controller in retail business, so my field of expertise is exactly what you need - analysis of sales trends. My everyday job requires design of different sal Daha Fazla
Bid Summary Reports and graphics for a business board Project Requirements According to the data in the Excel spreadsheet you should extract information to present in different kind of graphics and reports in order to Daha Fazla
Bid Summary Dear Sir, With my experience in the field of data entry, I believe that I would be the perfect candidate for the post that you have advertised Yours sincerely Md. Sohag Hossain Project Requirements Yes, I Daha Fazla
I have been working on similar weekly reports in the past for an Australian utlity company in the past 3 years showcasing trends and opportunities. If you already have someone else in mind before seeing this bid, that' Daha Fazla
Bid Summary To do this job I might write some formulas for Excel and I can manage this easily. I hope to do this work in 1 day but I need to know more details about your project to estimate my working time. Project Daha Fazla
Dear Client, I have done MBA in Finance Management Also I am Microsoft certified in Advance Excel & having excellent knowledge of VBA Macros In my job I have always worked on big data, made dashboards prepared lots o Daha Fazla