Contoso by SpartaBI 07-04-2022 07:48 AM

[SpartaBI]

The dataset for this report is the 'Contoso 100K' from the 'Mastering Tabular Course' resources by the amazing SQLBI.com
The report layouts are the ones used in the famous 'Sales & Returns' report from Microsoft at the end of 2019 and were downloaded from the 'scrims' section in powerbi.tips.
The report has six pages (plus a home page) where each page is a showcase for different analysis requirements for a business.
In each page you will find more information about the analysis and visuals on that page. 
The different pages are:
Main KPIs, Main Funnel, Sales VS Budget, Basket Analsyis, Customer Profiles, and The Customer Roulette. 
The dataset is enriched with several calculation groups -  among them a calculation group for dynamically display numbers, based on their value, in order to show for each number three meaningful digits (18.7M or 5.51 M on the same visual).

The dataset is also enriched with logic to support the budget and funnel scenarios. More info about that in their respective pages.
This report is optimized for the Power BI mobile app.

We'll love to hear your feedback.

Visit us at: www.spartabi.com or  www.linkedin.com/company/spartabi

eyJrIjoiOTE0NWI5MjctMWNlYS00NmE1LWFjNDItMjQ1ZTk5ZmQ4OTdkIiwidCI6IjQ2NGVkZmFhLTc5MmQtNGZmOC04NGYwLTk0MjkwYTgzNjBhZSIsImMiOjl9&embedImagePlaceholder=true

[JuanRoMora]

Hi

Can you plase shar pbix file to f.mora.gonzalezz@gmail.com

Thanks

[SahAmaral_]

Incredible dash!

One question: what visual did you use in The Customer Roulette?

[siri12345]

Hi

Can you plase shar pbix file to friend.uma@gmail.com

Thanks

[TryAOALISome]

 @SpartaBI Hi, It's truely a masterpiece!! And I really need your dashboard to help me understand some DAX and visuals. Get any chance to download the dashboard? Only for study

[SpartaBI]

https://powerbi.microsoft.com/en-us/blog/take_a_tour_of_the_new_sales_returns_sample_report/

[SpartaBI]

@TryAOALISome thank you :))

Check out what I wrote in the info part. I refernce there all the material you need. The famous sales and return report is available for download. Look it up in google and let me know if you need help finding it

[Saasw]

This is really cool. I wanted to know how you have added Decomposition tree pop up in your landing page. Can you refer some resources as I found that to be really appealing @SpartaBI 

[SpartaBI]

Do you mean the pop up experience?

[Saasw]

Yes @SpartaBI for qna and decompisition tree on landing page

[SpartaBI]

Sure, check out what I wrote in the info part. I refernce there all the material you need. The famous sales and return report is available for download. Look it up in google and let me know if you need help finding it

[Saasw]

Hi @SpartaBI , I tried to follow the info part but didn't find anything. Will it be possible for you to please guide me how to access them

[SpartaBI]

https://powerbi.microsoft.com/en-us/blog/take_a_tour_of_the_new_sales_returns_sample_report/

[jrpino59]

Excelente trabajo .  Me podrías indicar como construir la segunda parte del  budget tooltip (la visual utilizada ) anexo la figura . Saludos

[SpartaBI]

@jrpino59 Gracias!
I used this custom visual:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380821?tab=overview

[Sailorzzz]

Wow, this is very cool!

I especially liked the segmentation by Min Sales Treshold, how did you implemented this?

[SpartaBI]

@Sailorzzz Thank you 🙂
A lot of DAX magic :))
Come follow our company, I will soon do a very cool webinar and will update on our page:
https://www.linkedin.com/company/spartabi

[collipium]

I  liked the idea with the information button. I will definetly come to learn more how you built this.  

[SpartaBI]

Thank you @collipium 
Come follow our company, I will soon do a very cool webinar and will update on our page:
https://www.linkedin.com/company/spartabi

[ippi000]

I really liked the idea with the information button. Greatly simplifies navigation.

[SpartaBI]

Thank you @ippi000 🙂
Come follow our company, I will soon do a very cool webinar and will update on our page:
https://www.linkedin.com/company/spartabi