Re: Contoso by SpartaBI

Community Champion
13472 Views
SpartaBI
Community Champion
Community Champion

Contoso by 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

 

 

 

 

 

 

SpartaBI
Community Champion
Community Champion

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

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

jrpino59
Frequent Visitor

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

avatar user
Anonymous
Not applicable

Wow, this is very cool!

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

@Anonymous 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
Advocate I
Advocate I

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

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
Advocate I
Advocate I

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

SpartaBI
Community Champion
Community Champion

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

NipawanV
Helper I
Helper I

Hi @SpartaBI Is there some possibility to get pbix file for viewing and check on the background how you build this DB.  I would like to learn and adapt for my DB. Many thanks in advance. BR, Nipawan

Hey 🙂 
Unfotunatlly I can't share the files but if you look at the info I wrote above I pointed to both the source of the data and to the report that inspired me and has all the layouts there. These resources are free to download, just look them up on the web according to the details I wrote and let me know if you found them. It will not have all the stuff I have in my report but it will give you a very good start.
The model itself also contains calculation groups and a lot of high level DAX code, but also for that, you just need to go sqlbi.com. I leraned most of what I know from them.
I actually created the model directly on the service with Tabular Editor and I do all the editing live on the published dataset and then connected live to it with PBIX just for the report Layer.
I do plan to create a recorded session/s and share it with everyone, not sure yet ETA. Follow us on https://www.linkedin.com/company/spartabi to get informed.

Saasw
Frequent Visitor

This looks amazing, Is there any way to download this pbix 

 

avatar user
Anonymous
Not applicable

How did you put the footer?

Captura de pantalla (135).png

@Anonymous it's part of the photo and then I added the elements on top of that. I attached to layout examples but if you read the info above I direct to where exactly go to take all the building blocks for this report.

avatar user
Anonymous
Not applicable

I understand excellent trick, I mean it's a frame

@Anonymous yep 🙂 , best for performance, minimize the elements on the page

Heena_9980400
Helper III
Helper III

Hi @SpartaBI !!

You have done a very wonderful dashboard, is there any chance to download it for practice purposes.

Hey. I will PM you

avatar user
Anonymous
Not applicable

Hi @SpartaBI , is a very comprehensive dashbaord! by any chance to download it ? 

avatar user