Closing Remarks – Retail Dashboard
We will be using the retail dashboard as a basis for learning some of the advanced tricks in Power BI. So don’t discard this dataset yet. Let me know if you have any questions about the dashboard or measures or any other aspect of this lesson in the comments.
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo
First Case Study complete
Awesome course so far!
The demonstration of building a calendar table from dates derived from the fact table in chapter 5 is excellent.
However, in the past I’ve watched you (in Power BI) build a calendar table using the “CALENDARAUTO” function.
Is there a benefit to building the table step-by-step? Is there a flaw in “CALENDARAUTO”?
Thanks!
Amazing Course – Learnt various new things and finally built one while watching the videos. Thanks Chandoo – You’re Awesome as always and proud to be your students
What are your thoughts on “naming” columns – calculated or otherwise. Do you follow any standards like Leszynski naming convention (LNC). I think consistency is important and I appreciate your conversation about fact tables and dimension tables very much. Thanks!
Chandoo,
I love your M language solution to build a Calendar table. These days Power BI has a Model tab with a New Table option. With the DAX CALENDARAUTO() command, I can also create a list of dates. Which do you think is better – the manual solution with M or the auto solution with DAX?
Hi Philip, the CALENDARAUTO() function will scan the data model for columns formatted as dates to determine the min and max dates for creating the calendar table. This is great, as long as you don’t have date columns that you don’t want to use for date-computations. Imagine having a column with the date of birth in the customer table, for example. If your eldest customer was born in 1920, then you end up with a HUGE calendar table. As a rule of thumb, don’t rely on the smart/shortcut features if you can control things yourself. Hope this answers your question.
Hello, teacher.
I tried to add an average reference line to the bar chart myself, but the average data label size was too small, and I didn’t know where to change its size. I tried everything in the format bar, but I couldn’t change the size.
I looked at the case again and I knew how to set the data label for the average. That problem has been solved. thanks
Hi, I’m really curious about a chart shown in the “Executive metrics” dashboard picture at the beginning of some videos.
It’s like a strange donut chart with a combination of red, yellow, blue, grey and black colours, it’s in the bottom left corner, how do you do that? Thanks.
Hello! I am creating the dashboards following the course, Now I have a bunch of dashboards with me. (yay! :D) What is the Power BI equivalent of Tableau public where I can showcase my work and share the link with others?
In case you are still wondering, I use novypro