FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report) 03-20-2023 06:34 AM - last edited 06-27-2023 07:14 AM

[Arbaz_Ahmad]

Hi

About Challenge -

The Mediterranean Camera Company’s CFO Ms. Toni Hewlett is expecting a report with no more than 2 pages with a horizontal navigation menu.

This is an (EDA) Exploratory Data Analysis and product specifications have been masked.

1. Page 1 should be an Executive overview of the Company Sales performance YTD report.

2. Page 2 should be dedicated to a Products Data Analysis and Time Intelligence report. Any trends/seasonality for any of the Products and or Countries of sales. Does any product sell more over weekends?

About dashboard -

In this dashboard i have mostly used field parameter.

Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in.

I have also used small multiple to show all product category sales trend.

Insights - Key Insights from the Analysis:

1. Quarter 4 has the highest amount of Net Sales and Profit.

2. There is a high amount of profit and sales in October for the Monthly analysis

3. United Kingdom is the top country with net sales

4. France is the top country with the Profit

5. Camera 3 has the highest profit

6. Tuesday is the best day of the Week in terms of profit

7. Q4 has max revenue followed by Q2 , Q3 & Q1.

Thanks,

eyJrIjoiMmM2YjQ5ZGUtZjVmNS00MmQ4LTgzZjMtMTMzZWE3ZmE1ZDc0IiwidCI6ImQ4ZTFiMDVlLTcwYWEtNGVmNy1iODc4LTQ2NmI2ODhmOTUyZiJ9

[Krzysztof_Hyla]

Very cool dashboard! Could you please share pbix copy ?

[nasuwayu]

Super nice dashboard!! Can you please share copy of pbix file for design purposes. Thanks in advance!

[ranzan]

Hi. Fantastic!! Can you please share me copy of pbix file. Thanks so much

[Amrselim1989]

hello sire, could you please share and please tell me what did to you use for those littile line charts

[Anonymous]

Great work, can you please share .pbix file 

[RAHULADESARA]

Hi..Great work!! Impressive. Can you please share copy of pbix file for design purpose. It will be q great. 

Thanks in advance

[Anonymous]

Awesome dashboard
Hey can you kindly send the pbix for design purpose?

Thanks in advance.

[KELLYMENDOZA]

Hi. Very great work!! Can you please share copy of pbix file  Thanks so much

[LivioFair]

Hi, very great work, could you please attach copy of the report .pbix  

Thanks in advance！❤️

Livio

[Anonymous]

hi 

very nice report. could you please attach the report for design purpose

Thanks in advance,

Eshwar R

[Arbaz_Ahmad]

Hi  @Anonymous 

Check ur email.

Thanks

[tobeagoodguy]

Hi. Very great work!! Can you please share copy of pbix file. Thanks so much

[Arbaz_Ahmad]

Hi @tobeagoodguy 

Check ur email.

Thanks

[Anonymous]

Hi..Great work!! Apt theme!! Impressive. Can you please share copy of pbix file for design purpose. Thanks in advance!

[Arbaz_Ahmad]

Hi @Anonymous 

Check ur email.

Thanks

[Hamyyy]

Hi, very great work, could you please attach copy of the report (.pbix):  

Thank you in advance.

[Arbaz_Ahmad]

Hi @Hamyyy 

Check ur email.

Thanks

[anna21022]

Hello, 

Can you please attach the pbix file 

Thank you ~

[Arbaz_Ahmad]

Hi @anna21022 

Check ur email.

Thanks

[TaiNguyenTan]

Could you attach the pbix file 

Thanks

[Arbaz_Ahmad]

Hi @TaiNguyenTan 

Check ur email.

Thanks