Data Play – Squirrels in Central Park

In this data play, let’s look at squirrel spotting data in Central Park, New York. We will create a visual story of all the spottings with Power BI. Key concepts you will learn:

  • Working with maps
  • Small multiple style pie charts
  • Bookmarks linked to pictures

We will be creating this: Continue reading “Data Play – Squirrels in Central Park”

Executive Dashboards – StorageMart Case Study

Important notice about this lesson

This lesson is recorded with Power BI 2017 versions. Although the UI is old, most of the DAX, visualization techniques and ideas presented are still valid. I present this lesson a bonus. If you have trouble replicating any steps, please comment so I can help you.

Enjoy.

Now that we have fairly good understanding of various Power BI features, let’s build a comprehensive reporting system for a fictional company – StorageMart. In this module (broken in to 5 lessons), you will learn

  • Process for defining dashboard specifications
  • Designing dashboards
  • Building different report views – for CEO, CFO and CMO
  • Modelling data and creating measures using Power Pivot
  • Calendar Tables & Time intelligence calculations
  • KPI visualization in Power BI
  • Forecasting using Power BI
  • What-if analysis using Power BI parameter tables
  • Heaps of tips and visualization ideas

Continue reading “Executive Dashboards – StorageMart Case Study”

Data Play – London Population in Future

In this data play, we look at publicly available London population projection data (from data.london.gov.uk) and create a visual story. Learn all about,

  • Creating population pyramid charts
  • Using what-if parameters to select input values
  • Applying conditional formatting to highlight selected year(s) values.

We will be creating this:

Sample Data & Continue reading “Data Play – London Population in Future”

Power BI Tricks – Dynamic Visual Titles

Power BI Visual Titles used to be simple text. But with conditional formatting, you can make them dynamic. A dynamic visual title allows us to show more descriptive messages and captions on the visuals. In this video, learn how to set up dynamic titles with conditional formatting in Power Continue reading “Power BI Tricks – Dynamic Visual Titles”

Power BI Tricks – Bookmarks

Bookmarks allow us to store a state of report. Once you create a bookmark, you can activate it to visit that state of report. For example, you can save bookmark after selecting multiple filter options and visual interactions. You can then click on the bookmark (from bookmarks pane) to automatically Continue reading “Power BI Tricks – Bookmarks”

Budget vs. Actual Dashboard in Power BI

Most Power BI reports are built with star schema (ie one fact and multiple dimension tables). What if, you have multiple flattened fact tables and no dimensions? In this case study, we look at AppraisalOwls, a property appraisal company based in Australia and analyze multiple fact tables (budget and actual Continue reading “Budget vs. Actual Dashboard in Power BI”

Retail Dashboard using Power BI – SnackTime Case study

Power BI is great for creating enterprise dashboards and multi-page reports. In this extensive case study, you will uncover many of the Power BI features and applications. The key skills you will gain in this set of lessons (10 videos) are,

Working with Web Data – Election Results compilation with Power Query

This lesson will be an out-and-out Power Query lesson. In this set of videos, you will learn:

  • Connecting to public websites from Power BI thru Power Query
  • Fetching and pre-processing data
  • Collecting data from multiple pages using Power Query functions & parameters
  • Closing remarks

For the purpose of this lesson, Continue reading “Working with Web Data – Election Results compilation with Power Query”