Re: AdventureWorks Sales Dashboard - 2023 Edition

New Member
2702 Views
jianfajun
Advocate I
Advocate I

AdventureWorks Sales Dashboard - 2023 Edition

Hello, I am happy to share my latest work "AdventureWorks Sales Dashboard - 2023 Edition". This project uses Microsoft's official sample dataset, AdventureWorks, which includes order, customer, reseller, and product tables. I think it is a very representative example of using BI software to analyze sales data and discover business insights, so I made a couple of pages. Whether you are a sales manager or a BI engineer, I hope you can find some inspiration.
 
I divided the sales dashboard into four sections: Sales Summary, Products, Internet (B2C customers), and Reseller (B2B customers). The first section (Sales Summary) basically summarizes the overall sales performance and provides some time-related analysis, while the other three sections break down different important dimensions (Products, B2C, B2B) for detailed analysis.
 
Since there are many pages, I will briefly explain the design idea of the homepage. There are many charts on the homepage, which can be roughly divided into three areas: the upper-left shows the overall trends, the lower-left shows product data (such as top 20 products sales%), and the right side shows channel data (such as the proportion of different channels).
 
For a page with large amounts of information, there is usually a problem that new users do not know how to operate. Therefore, how to guide users appropriately is the focus. The solution I provide is to add a "question mark" button in the upper right corner. When users click it, a new layer will pop up and tell users how to use it. You can see the tips for the two-level menus and how to use slicers and customer/reseller drill-through.
 
For the idea of customer/reseller drill-through:
  • When users select one single customer/reseller, they actually want to know more details about this customer/reseller. This is a very natural data demand.
  • My solution is that when a customer/reseller is selected, the drill-through button in the upper right corner will be activated, and it can jump to an independent customer/reseller details page. The details page can include basic information, sales, order volume, profit, and other indicators.
  • After browsing the detail page, users can return to the previous page through the yellow back button in the upper left corner.
 
The above is just a brief explanation of one function. The entire work includes 15 pages, each has some analytical ideas. I am considering writing a series. If you have any questions about this work, you can comment or email me at jianfajun@gmail.com.
 
Enjoy it!
Jianfajun

KailashT
New Member

This dashboard is too amazing. I'm currently working on AdventureWorks dataset as a college student. It will be much more helpful for me if you share me .pbix file. Please kindly share me @kailashteckchandani@gmail.com

DuyPhan
New Member

Hi,

You made an amazing dashboard. I've just started learning Power BI and really want to have some beautiful .pbix file, could you share this to me please ? Thank you in advance

jroger911
New Member

@jianfajun this is excellent, I noticed a lot of people requested to see the pbix file. Is this something you would be willing to share with me as well?

I would love to incorporate some of the features you have that I have not seen before to a portfolio of work I am compiling. Of course, I would cite your work and give you credit for ther inspiration behind some of the feuatures.

 

Thank you in advance,

 

My email is jon.d.rogers@icloud.com

disreagrd

 

My apologies, I just saw your comment from bavk when this was shared.

vtech007
New Member

Hello @jianfajun

 

Very nice report, I would love to learn alot from your design.

 

Could you please share the pbix file with me via my email address : victor.marcaulay@gmail.com

 

Thanks in Advance

quangninh
New Member

hi,

great, can you share to me via quang.ninh@afop.vn

noites
New Member

Hi, great job. Can you share with me, please? sergio.b.dias@hotmail.com

Madina
New Member

Hi!

Wonderful Job!

would it be possible to send me the .pbix file (madokka.kz@gmail.com)?

 

Thanks!

KotKot
Helper III
Helper III

Hi can you please the PBIx file at romon.ft@gmail.com thanks

pmacias91
New Member

 

pololorko22@gmail.coc

 

Thanks!

danielmfuchs
New Member

Congratulations, excellent job!

 

Can you share .pbix with me? I want to study it!

 

Thanks!

ajmani
New Member

Great dashboard, will be great to learn things, can you please the PBIx file at ajmaniip**bleep**a@gmail.com

jshah-sbux
Regular Visitor

can we please have this sample for learning ? jatin7@gmail.com

mcspamj
New Member

Hello Jianfajun,
I asked a while back but never received the pbix.

I would be very grateful if you could email it to me at mcspamj@gmail.com
Kind regards,

Michael

vwongge
New Member

Hi jianfajun,

 

Fantastic report and very comprehensive. Could i please request the pbix file to be emailed at markushano@gmail.com

 

Cheers

Arsephoenix
Frequent Visitor

Hi @jianfajun

 

Awesome report. Covered lot of charts and visuals are amazing. Lot of things to learn from this report.

 

could you please share pbix file to this email:

Manju.phoenix@gmail.com

 

Thanks!

benfer
Regular Visitor

Hi jianfajun,

 

Great report !!

Pls could you share the pbix. There are many things I'd like to learn how to do it

(fbvacas@gmail.com)

Thanks in advance

mcspamj
New Member

Hello Jianfajun,
Please can you send me the PBIX file for the above at my email address: mcspamj@gmail.com
Kind regards,

Michael McS

Westfly567
New Member

The AdventureWorks Sales Dashboard - 2023 Edition is so perfect.

Could you kindly share the pbix file with me to help me develop my dashboard skill? Thanks in advance.

My Email is westfly567@hotmail.com

nandan1990
Frequent Visitor

can you share me the pbix file to nandan.kumar190890@gmail.com

avatar user