Designing dashboards seems a simple task, thanks to modern BI tools. In reality, designing dashboards that are useful and that people want to use is not so easy. A good dashboard must follow specific rules and design concepts, which this video course aims to teach you.

Here are some goals of the Power BI Dashboard Design Course:

  • It aims to teach you how to design beautiful dashboards that people use every day.
  • It is designed specifically for Microsoft Power BI, but you can learn even if you never used Power BI before.
  • It is a reference guide that you can use later. No software updates will change the concepts that you learn here.
  • It is not just theory, but real examples and comparisons between well-designed and difficult-to-use dashboards.
  • It is not a tutorial on how Power BI works, but you will find some useful references for learning it, if needed.
  • It is not just for designers. Every person who creates dashboards can benefit from it. Even if you are a designer, you will learn usability tips that many of your colleagues usually underestimate.

The course is divided in four parts:

  • The first one explains what is a dashboard (people are usually confused about its exact definition);
  • The second one is a brief introduction to Power BI features, with some resources to start from the scratch;
  • The third one is the most important one, and it includes the 15 rules to design a perfect dashboard;
  • The last one is the chart reference, and you can use it to choose the right charts based on the kind of data you have to display.

The course includes several samples and resources, and additional written material to further explain the topics discussed by the teachers.

The content of this training has been realized by Daniele Perilli.

 

Power BI Visuals Reference

The last section of the course classifies the visuals available in Power BI. This classification is also displayed in a single PDF that you can download for free. You can print or display it to make a guided choice of the right visuals for your dashboards.

Curriculum

  • Presentation of Power BI Dashboard Design Course

    • Presentation of Power BI Dashboard Design Course
      FREE
    • Slides of the video course
    • Sample Rules
    • Sample Chart Reference
    • Dashboard design checklist
    • The Visuals Reference
    • The 15 Rules Reference
  • What people think a dashboard is and what it really is

    • What people think a dashboard is and what it really is
      FREE
    • What is a dashboard?
      FREE
    • Bad dashboard examples
      FREE
    • A good dashboard
    • Recap
      FREE
    • Personal Finance dashboard
  • Introducing Power BI

    • Introducing Power BI
      FREE
    • What is Power BI?
    • Power BI in action
    • Are you starting from scratch?
    • Recap
  • The 15 rules to design a perfect dashboard

    • The 15 rules to design a perfect dashboard
      FREE
    • Introduction to rules
      FREE
  • Design for a target

    • Rule 1 - Design for a target
      FREE
    • Explanation and demo
    • Recap
  • Keep everything at a glance

    • Rule 2 - Keep everything at a glance
      FREE
    • Explanation and demo
    • Choosing the right page size
    • Resizing pictures
    • Using charts with hierarchical data
    • Recap
  • Keep it simple

    • Rule 3 - Keep it simple
      FREE
    • Explanation and demo
      FREE
    • All art is quite useless
      FREE
    • Avoiding dark backgrounds
      FREE
    • Recap
      FREE
  • Align elements

    • Rule 4 - Align elements
      FREE
    • Explanation and demo
    • Prototyping with Chart Placeholder by OKViz
    • Recap
  • Be consistent

    • Rule 5 - Be consistent
      FREE
    • Explanation and demo
    • Recap
  • Highlight the most relevant information

    • Rule 6 - Highlight the most relevant information
      FREE
    • Explanation and demo
    • Recap
  • Be clear

    • Rule 7 - Be clear
      FREE
    • Explanation and demo
    • Recap
  • Start from zero

    • Rule 8 - Start from zero
      FREE
    • Explanation and demo
    • Highlighting a change in a time interval
    • Using Dot Plot by OKViz
    • Recap
  • Shorten the numbers

    • Rule 9 - Shorten the numbers
      FREE
    • Explanation and demo
    • Recap
  • Show the context

    • Rule 10 - Show the context
      FREE
    • Explanation and demo
    • Recap
  • Choose the right colors

    • Rule 11 - Choose the right colors
      FREE
    • Explanation and demo
    • Using colors that people can confuse
    • Introducing Color Helper by OKViz
    • Recap
  • Design dashboards, not reports

    • Rule 12 - Design dashboards, not reports
      FREE
    • Explanation and demo
    • Recap
  • Show variations

    • Rule 13 - Show variations
      FREE
    • Explanation and demo
    • Recap
  • Leave the noise off

    • Rule 14 - Leave the noise off
      FREE
    • Explanation and demo
    • Recap
  • Pick the right charts

    • Rule 15 - Pick the right charts
      FREE
    • Explanation and demo
    • Recap
  • In conclusion

    • In conclusion
  • The chart reference

    • The chart reference
      FREE
    • Bar/Column charts
    • Bar/Column: express a trend
    • Bar/Column: sorting
    • Bar/Column: clustered vs. stacked
    • Bar/Column: coloring
    • Bar/Column: intervals
    • Gauge
    • Bullet Chart by OKViz
      FREE
    • Dot Plot by OKViz
    • Radar Chart
    • Line Chart
    • Area Chart
    • Sparkline by OKViz
      FREE
    • Candlestick by OKViz
    • KPI
    • Card with States by OKViz
      FREE
    • Treemap
    • Pie/Donut charts
    • Waterfall Chart
    • Funnel
    • Maps
    • Synoptic Panel by OKViz
      FREE
    • Histogram
    • Box & Whisker
    • Scatter Chart
    • Line & Column charts
    • Infographic Designer
    • 3D charts
    • Other charts
    • Custom visuals
Student Rating
4.8
67 ratings
85%
12%
3%
0%
0%

Student Reviews (72)
  • Joseph Sorrenti (Sep 11, 2018)

    Excellent. The video quality was really good. The examples were clear and concise and easy to understand. The course provided a good foundation for dashboard design and taught techniques that can be implemented immediately. The lectures provided just the right level of detail.

  • Maria Luz Munoz (Sep 6, 2018)

    Thanks, I would say let us make the rules to design dashboards the standards. Very helpful course to avoid falling into the creation of visualizations that nice and colorful but missing clarity.

  • Ezequiel A. Costa (Jul 19, 2018)

    I really enjoyed this course from the beginning to end.

  • Johann Krugell (Jul 16, 2018)

    Fantastic course! Applied the principles shown in the course straight away and received some very positive feedback from the dashboard users. Thank you.

  • Mariano Irvin Lopez Jaramillo (Jul 13, 2018)

    NICE

  • Zubin Ordoñez Delgado (Jul 7, 2018)

    Perfect!!

  • Steve Wilde (Jun 21, 2018)

    Overall this was good. I previously completed my first dashboard and I had already done 95% of the things listed in your 15 items. It was a good confirmation for me. I do however disagree with the donut chart. It is very useful if you're using the interactivity aspect of PBI. Especially when you're looking at something like employee levels within a company. (e.g. Staff, Senior, Manager, Sr. Manager, Director, etc.)

  • Yoann Jeffrey CLOMBE (May 30, 2018)

    15 RULES Amazing Content, Thanks , looking forward to see you at the Montreal Power BI WORLD TOUR in November ;). LAST Part Repetition no Value , No Return on Time.

  • Daniel Åkerhielm (Apr 24, 2018)

    Some of the changes you guys made was made during the other one was speaking or covering the way the things were changed

  • Bill Brown (Apr 13, 2018)

    Found good tips on dashboards and am using them in my presentations about Power BI, in my actual dashboards and designs. Ready to get to the next course.

  • Claudio Trombini (Feb 25, 2018)

    Simply the best!!! Perfect!!!

  • Matthew Smith (Feb 15, 2018)

    Great course!

  • Chantal Souliere (Jan 27, 2018)

    Well structured! Well presented! Simple et efficace. Merci SQLBI!

  • Edwin Rotgans (Dec 28, 2017)

    The course name is misleading: it is a layout course for one-page Power BI Reports.

  • Sony Thomas (Dec 25, 2017)

    Very good presentation. Completed the course by one week. It will help me prepare better dashboards and reports based on the 15 golden rules.

  • Gunther Verleger (Dec 17, 2017)

    Great course - keep up the good work!

  • JORGE BUSTILLO (Dec 10, 2017)

    This course makes the difference between designing a good dashboard and designing the best dashboard.

  • Juan Aranibar (Nov 24, 2017)

    Great course. Probably a final test would be useful in order to you to see the impact. Thanks for the feedback. JCA

  • Jasper Dijkman (Nov 16, 2017)

    Very clear rules and a great guideline while making dashboard design decisions. Links to the literature to deepen one's knowledge would be nice.

  • Martina Sanchez (Oct 23, 2017)

    Great course. I learned a lot. Thanks.

  • Jeffrey Mensah-Roberts (Sep 15, 2017)

    Fantastic is an understatement, can't find a word for the overstatement though, i will try brilliant ! ! Thanks for the early bird offer as well.

  • David Edelman (Aug 24, 2017)

    Very well put together and very informative. I was immediately able to take some of my initial design and transform them using the rules to make impressive dashboards.

  • Roberto Santamaria (Aug 24, 2017)

    Good course! it's clear and usefull to learn making good dashboard. Now it's DAX time!

  • Mariana Calonico (Aug 22, 2017)

    EXCELLENT AND VERY USEFUL. GRAZIE!!!!!

  • Bill Leffler (Aug 21, 2017)

    Excellent for learning and for reference later on. Would recommend to anyone who wants to learn about dash-boarding.

  • Jorge Diaz Infante (Jul 21, 2017)

    Great Course with a lot of examples and material. Now time to improve my current Dashboards. Thanks

  • Hana Palkova (Jul 18, 2017)

    Wonderful course with practical examples which I will apply/use step by step in my real work case where I am preparing PowerBI dashboards for management! Thanks Alberto & Marco! Good work!

  • Cable (Jul 15, 2017)

    Very useful course. Thanks.

  • Thomas Martens (Jul 11, 2017)

    Even if I consider myself as a data visualization expert this course provides new insight especially how to "tweak" certain visuals to accomplish the visualization.

  • Hafiz Gafurov (Jul 6, 2017)

    Good course. There is many great ideas.

  • Ben Lay (Jul 5, 2017)

    Great information laid out in an easy to understand way.

  • Paulo Rocha (Jul 4, 2017)

    I highly recommend this course to everyone who is in BI area and congratulate Alberto and Marco for providing us such a comprehensive and well structured material. Keep up the good work!

  • Yusuf Hamzah (Jul 4, 2017)

    Even if you are a very artistic person and very proficient with Excel, I would still recommend the course. It is explained very clearly. You might not agree with all the rationale but still the exposition (of good or bad) is acceptable. It consolidates and polishes my Excel reporting skills in a much more refined way.

  • Peter Hofmann (Jun 20, 2017)

    This is a wonderful course! I like the way it explains the best usage of visuals and get's to the point that dashboards are supposed to provide information to the user. At this point I have enough arguments to go back to my business users and ask "what information is this dashboard providing you or the audience you wish to target"? In my opinion the money I spent for the course is well worth it! Thanks to the team at SQLBi for putting this together.

  • Mark Bond (Jun 20, 2017)

    A great reference point for designing dashboards. The checklist is very useful.

  • Kenny McMillan (Jun 18, 2017)

    Very nice course and I have already started to alter my dashboards based on the recommendations. The section on colour blindness was very helpful. Would be nice to have a section on R visuals also in the future. Very helpful handouts also contained in the course. Bravo

  • Gerson Viergutz (Jun 9, 2017)

    Amazing. Congratulation.

  • Eric Theil (Jun 6, 2017)

    Received some excellent tips, advice, and guidance during this course. Highly recommend for anyone getting started with representing data visually.

  • John McNally (Jun 6, 2017)

    Superb work by the SQLBI team. Alberto and Marco explain the visual design skills that are needed to create effective dashboards. They distill the design approach into 15 Rules and describe each one with clarity. The course starts out with a "pretty" looking dashboard (typical of what you might encounter on the web or in slide presentations), and is slowly decomposed, repaired, and improved. Through this process, the viewer gains valuable insight into the reasons why some visuals do not work. This is just as important as knowing which visuals do work, and under what circumstances. Having recently read several books on dashboard design, I can see how masterfully the SQLBI team presents this material. The course covers the best practices and fundamental skills for the effective display of quantitative information on a dashboard. Highly recommended!

  • Walter Biffi (Jun 5, 2017)

    I found the overall material interesting and appropriate but a bit pricy. I like the approach taken by showing how to find miss used visuals and using the outline rules to refactor an existing document. However, I think that the final result was still too crowded and difficult to read. There was still too much information to digest and not enough breathing white spaces, too clattered. I am a consumer of your various material and I do appreciate everything you're providing to the community. Thank you!

    • Balancing density and readability is one of the challenges of a dashboard - the risk is creating too many of them. It's certainly useful to get constructive feedback, we'll consider it in future revisions. Thanks!

      Reply by SQLBI (Jun 5, 2017)

  • Chris Turnbull (Jun 1, 2017)

    Absolutely fantastic, the best £60 that I have ever spent. I have seen a lot of Dashboard Courses but this is done in a very different way. Not only do Alberto and Marco tell you what you should be doing but just as importantly they tell you not what to do and why. The methodology of starting with a bad Dashboard and turning it into something special is absolute genius. Thanks boys