Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

PowerBI

January 25, 2018

VIDEO – PowerBI Dashboard in a Day (DIAD) – Exercise 2

Recently I completed Microsoft’s DIAD workshop on PowerBI. Below is a video of Exercise 2 (Microsoft Power BI DIAD.PDF pages 17-29).

It covers PowerBI Desktop key steps to transform with query designer, column renames, conditional columns, transpose rotate rows/columns, and more. Cheers!

Video

Screenshots

References

January 6, 2018

VIDEO – PowerBI Dashboard in a Day (DIAD) – Exercise 1

Recently I completed Microsoft’s DIAD workshop on PowerBI. Below is a video of Exercise 1 (Microsoft Power BI DIAD.PDF pages 6-16).

It covers PowerBI Desktop key steps to import data (CSV, XLS, and Folder) with data transformation, column removal, and filtering. Basic building blocks to for any report. Cheers!