topic Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report) in Themes Gallery

FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

Arbaz_Ahmad — Thu, 23 Feb 2023 18:13:55 GMT

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

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

kurtcurt — Tue, 28 Feb 2023 01:50:51 GMT

Dear,

very nice one, could you send me pbix file?

thx so much,

Kurt

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

amyhan324 — Tue, 27 Jun 2023 14:26:30 GMT

Hello,

Can you please attach the pbix file.

Also, what the name of the visual you used for the top section that shows Revenue, COGS, Profit and etc.

Thanks in advance,

Amy

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

Carlos_Policarp — Tue, 27 Jun 2023 14:25:03 GMT

Poderia enviar o arquivo pbix, segue o meu e-mail:

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

EnricoPalma — Tue, 27 Jun 2023 14:23:14 GMT

"Great job! Could you attach the pbix file?"

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

TaiNguyenTan — Tue, 27 Jun 2023 14:22:04 GMT

Could you attach the pbix file

Thanks

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

Anonymous — Tue, 27 Jun 2023 14:20:43 GMT

Hello,

Can you please attach the pbix file

Thank you ~

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

Hamyyy — Tue, 27 Jun 2023 14:19:35 GMT

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

Thank you in advance.

Re: FP20 Analytics Challenge “Mediterranean Camera Company” (Sales Analysis Report)

Anonymous — Tue, 27 Jun 2023 14:16:21 GMT

Arbaz_Ahmad — Tue, 21 Mar 2023 15:39:47 GMT

Hi tobeagoodguy

Check ur email.

Thanks