Re: AdventureWorks Sales Dashboard - 2023 Edition

New Member
11660 Views
jianfajun
Advocate II
Advocate II

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

avatar user
Anonymous
Not applicable

Hi, Your dashboard looks great !!! 
Could you please share your pbix file?  My email (rita51316@gmail.com)

Thanks 🙂

robiyanto23
New Member

Great! Would you please share the PBIX ( mr.robiyanto1@gmail.com) ?

9-one
Regular Visitor

Your dashboard looks great.
Could you share your pbix file?

jarel91@yahoo.com.sg

Karo2004
New Member

Por favor ¿Puede compartir el archivo .PBIX para karolfigueroapereira114@gmail.com?

P_Lys
New Member

Hey! I would like to look at the dataset + PBIX. Is it possible, that you share the files :)? patrik220619@gmail.com

JuanseD
Frequent Visitor

Great! Would you please share the PBIX ( juansedavdav95@hotmail.com)?

alexandramamani
New Member

Hi! could you publish the PIBx file ? i would like to use some of the visuals of the reports!! I especially like the heatmap one . Maybe you have a github repo? thanks

shimmy620
New Member

Hello! It looks fantastic! I am really curious how it is built in the backgroud. Could you please share .pbix file? shimmy.kurowski@gmail.com

huggie-123
New Member

Very nice! Could you please share dataset and .pbix with me at Jirapat9970@gmail.com   Thank you!

FloraZhang
New Member

Amazing! Could you please share the dataset and .pbix with me at flora.zhangwei@gmail.com? Thank you!

vishnucholkar
New Member

Awesome, can you please share .pbix at vishnucholkar@gmail.com

Nhat_Dang
New Member

Wow. Great work. Could you share the .pbix file and Dataset with me? My E-mail: minhnhatthanhdang@gmail.com. Thank you!

led2626
New Member

This is amazing!! Thank you very much, It's so different in a good way than other stuff I see. Would it be ok to share the .pbix file and Dataset  with me? it'd be massively appreciated, My E-mail:  lewis.edwards4@hotmail.com

Raj_mpr1
Regular Visitor

Awesome work. its really nice & good to know the possibilities of Power BI.

Since I am new to this field, I need this kind of knowledge sharing. Can you please share the .PBIX & dataset file for mprraju5@gmail.com

avatar user
Anonymous
Not applicable

Wow. Great work. Could you share the .pbix file and Dataset  with me? My E-mail:  milochanaeanalytics@gmail.com

Thank you!

Kvrraju
New Member

Wonderful dashboard! Would it be possible to send me the .pbix file (kvrraju888@gmail.com) thanks!

Kartikss
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 @surkartik30@gmail.com

fiuub
New Member

Could you share the .pbix file with me? My E-mail: 700154@student.inholland.nl

Thank you!

Hatzel
Frequent Visitor

can you share your pbix with me?

Shanmugam1701
New Member

Excellent work!!!!

Requesting to share the pbix file to grshanmugam@hotmail.com

 

Thanks in advance...

goal_guy
Frequent Visitor

Great work; could you please share the pbix file at ( ahmedbilal24@gmail.com
Many Thanks 

avatar user