topic Re: AdventureWorks Sales Dashboard - 2023 Edition in Data Stories Gallery

AdventureWorks Sales Dashboard - 2023 Edition

jianfajun — Fri, 03 Mar 2023 04:27:52 GMT

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

eyJrIjoiYWJkZGYyMTctZTBhMC00M2RlLTllNTQtOWE3MDJjNjZlMGQ3IiwidCI6ImVlNjZhNWNkLTY0MWQtNDA2Ny1hMTMyLTEzNzY2NGExN2ZlMSIsImMiOjEwfQ%3D%3D

Re: AdventureWorks Sales Dashboard - 2023 Edition

Anonymous — Fri, 03 Mar 2023 07:38:26 GMT

Good work! The dashboard is fantastic

Re: AdventureWorks Sales Dashboard - 2023 Edition

Anonymous — Fri, 03 Mar 2023 13:22:09 GMT

This is a phenomenal piece of work. Although there is no single page that is a "center-piece" mindblowing experience, as a suite of dashboards this is without doubt one of the best example dashboards. Well done, this should be the Gold Standard in Dashboard design.

Re: AdventureWorks Sales Dashboard - 2023 Edition

jianfajun — Sat, 04 Mar 2023 12:49:59 GMT

Thanks. Your feedback means a lot to me.

Re: AdventureWorks Sales Dashboard - 2023 Edition

datacode — Wed, 08 Mar 2023 00:00:56 GMT

Great work here! I like how you provide other metrics.

Would you be able to share your pbix file?

Re: AdventureWorks Sales Dashboard - 2023 Edition

learner03 — Wed, 08 Mar 2023 03:36:03 GMT

Can you please share .pbix at apoorva.kapoor03@gmail.com

Re: AdventureWorks Sales Dashboard - 2023 Edition

anaisabelcfer — Wed, 08 Mar 2023 10:27:45 GMT

Fantastic dashboard!! Can you please share .pbix at: anaisabel.cabrerafernandez@gmail.com

Re: AdventureWorks Sales Dashboard - 2023 Edition

jianfajun — Thu, 09 Mar 2023 00:58:41 GMT

Hello, I am sorry that I decide not to share the complete .pbix file at this moment. I am considering make a series of tutorial videos on youtube. Is it an interesting idea?

Re: AdventureWorks Sales Dashboard - 2023 Edition

Jackwuzy — Thu, 09 Mar 2023 06:05:48 GMT

Can you please share .pbix at ziyin.wu@beiersdorf.com

Re: AdventureWorks Sales Dashboard - 2023 Edition

anaisabelcfer — Thu, 09 Mar 2023 08:40:25 GMT

Yes, of course!! Very interesting! Tell me more about it 🙂

Re: AdventureWorks Sales Dashboard - 2023 Edition

Anonymous — Fri, 10 Mar 2023 14:05:46 GMT

How long did it take to create this?

Re: AdventureWorks Sales Dashboard - 2023 Edition

jianfajun — Mon, 13 Mar 2023 08:19:10 GMT

I haven’t counted time specifically, I made this demo by integrating pages from multiple projects. If I start from scratch, I feel it would take several weeks.

Re: AdventureWorks Sales Dashboard - 2023 Edition

Krishna_Mundada — Fri, 17 Mar 2023 05:48:20 GMT

Hello, Can you please share your youtube channel link on sjmfamilydesk@gmail.com

Re: AdventureWorks Sales Dashboard - 2023 Edition

mayank_mangla — Tue, 04 Apr 2023 11:35:08 GMT

Can you share the data with me because it helps me a lot in my study. Please share this dataset at mayankmangla710@gmail.com

Re: AdventureWorks Sales Dashboard - 2023 Edition

NhatNguyen — Tue, 30 May 2023 09:57:41 GMT

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

Re: AdventureWorks Sales Dashboard - 2023 Edition

manishmalode — Tue, 30 May 2023 19:11:39 GMT

Hey Great Work !!!! Can you share the Pbix to manishmalode@gmail.com

Re: AdventureWorks Sales Dashboard - 2023 Edition

mfxzjrs — Wed, 31 May 2023 16:15:54 GMT

This looks amazing! Can you share the pbix to mengmorgan79@gmail.com ? Appreciate it!

Re: AdventureWorks Sales Dashboard - 2023 Edition

anish610 — Fri, 16 Jun 2023 11:07:28 GMT

Easily one of my fav PBI reports ever.
Can you provide link to which data set you used in the description of your post? That will be really helpful.
And I beg you please please do more PBI projects, there is a lot to learn from you in terms of design, analysis, usage of colour and navigation etc.
Kindly let us know where else we can get inspired from your work!
Hope you reply thanks!

Re: AdventureWorks Sales Dashboard - 2023 Edition

Anonymous — Fri, 23 Jun 2023 08:13:40 GMT

Hi!

Wonderful Job!

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

Thanks!

Re: AdventureWorks Sales Dashboard - 2023 Edition

tutu007 — Thu, 06 Jul 2023 12:56:27 GMT

这看起来太棒了！你能把pbix的数据集分享给 1126131569@qq.com吗