Data storytelling with Power BI

Today, we will discuss information levels on the dashboard. And  continue working with the example of the "Bad Dashboard". I will select Key Perfomance Indicators and highlight them using cards

In this module we will get acquainted with such  advanced visual from AppSourse as cards with states by OKviz.

In this lesson, quick measures will be discussed.

In this lesson,  we will try creating measures and discuss why all calculations should be done in Power BI neither Excel.

In this lesson, I will suggest you my check list to finish and polish your dashboards.

This is the first practical task in this module. You can find the excel file in the attachment. You need to develop a dashboard for Real Estate Developer

You are offered a one way to create KPI cards based on the dataset from the previous task.

In this lesson, we are going to discuss how to modify the main part of the dashboard from the last task.

In this lesson, we are going to set up different types of interactions between visuals on the dashboard from the previous task.

In this lesson we learn how bookmarks can be created step by step according to the example from the previous lesson.

In this lesson, developing tooltips as pop up windows will be discussed.

We will consider working with such visual as switcher and cases when it should be applied.

We are going to discuss your next task and do some data preparation. You are offered the data about advertizing campaign of two educational online courses. 

You will finish working on this dashboard on your own. You need to think about the structure of the dashboard and the visual tools you are going to use. Although we have briefly considered this dataset, we didn’t touch abilities to create cards with KPIs. You can calculate conversions of clicks to requests and to payments or ratio of expenses and payments as cost-effectiveness. These are possible measures to be shown in the headline.

The main tool we have discussed in the second part of this course is cards with KPIs. That’s why you must use them in this home task. Also, you should modify these charts’ designs. Now they look raw. There are extra headings, auto titles, and other disadvantages discussed in the first part of the course.

Moreover, I recommend presenting rates by courses’ names. Actually, this dashboard should clarify what advertising campaign was the most successful. Compare them by conversions and advertising campaigns’ effectiveness.

As a result, you need to present a dashboard with its title, cards with KPIs showing conversion rates, or cost-effectiveness. Also, you can suggest other indicators on your own. After that, improve the visuals’ design and add filtering by courses’ names. Finally, estimate your dashboard in its entirety Also, try to align all elements symmetrically. Later, we are going to continue the discussion on this topic. For now, your aim is to avoid white spaces on the page and locate elements logically and symmetrically as we have done in the previous lessons.

Today I will remind you about my basic analysis types and suggest you my approach to select the most beneficial visuals for different types of data. Also we will get acquainted with the example of waterfall chart in Excel. Dataset we will use in this lesson you can find in the attachment.

Today, we will compare examples of developing waterfall charts in Excel and Power BI. Dataset we will use in this lesson you can find in the attachment.

The example of The Simple Waterfall implementation from AppSource will be considered. We will compare it with basic waterfall and discover its advantages and disadvantages.

Today we will consider Tornado chart, cases it is useful for and some ways to modify and improve it.

We will discover ways to implement Bullet chart and its variations. I show advantages of OKviz version and emphasize required data structure.

In this homework you need to combine all charts you have created in this module on one dashboard. I will show you its recommended structure and consider the most important details.

Dataset is in the attachment.

We have finished consideration of advanced visual tools provided for this course. This lesson provides a brief overview of the basic visuals which I dont use in real practice. It might be useful sometimes.

We will start this module with several examples of a dashboard's cover pages. You are suggested examples of dashboards' cover pages for real estate developers as well as for agricultural holding.

In this lesson, we will develop cover page for the agricultural holding's dashboard.

In this lesson several examples to design a dashboard are considered.

Today we will implement a dark style to the dashboard for real estate developer. You will see how to change colors of your dashboard quickly using Power Point. 

This is your practical task. You need to develop the dashboard using a contrasting palette. I’ve prepared  picture in the attachment for you. You may try to use it or find another one.

In this module I will tell you about AIDA methodology to present projects.

This is an example of presenting the dashboard for pharmaceutical company based on AIDA approach.

This is your task to present any dashboard using AIDA approach

This lesson is aimed to such a powerful tool to present your ideas as Elevator Pitch. A way to present any analytical report is also considered.

This is an example of presenting pharmaceutical company's dashboard as Elevator Pitch

Today we will discuss how to find insights in your report to highlight. As an example I will tell you about research concerned to distribution of data analysists' salary.

In this lesson we will learn how to connect data collected in Google Forms and Power BI dashboard.

In this lesson we will discuss how to process data collected by Google Forms in Power BI based on example of my survey about students' satisfaction by courses in The Institute of Business Intelligence. 

In this lesson we will continue working with my survey and learn how to use Sankey chart.

Finalizing my course, I will give you a comprehensive task. You will make a research, collect data, analyze it and visualize results, presenting them as a story. The dashboard you will create is suitable for your portfolio.