Publisher's Synopsis
In this workbook/guide, we will cover many behind-the-scenes capabilities of Power BI. We will use the Power BI Desktop tool to get data, the Power Query Editor to filter the data source, and use the DAX programming language to adjust the results.
******** Obtain Your PDF Copy and Recorded Videos ********
This workbook includes PDF Download and Video Clip of each practice exercise. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. To see an example clip: www.elearnlogic.com
Chapter 1 - Get Data
This will extract a data source from a database such as Excel, Access, etc, The sections covered include Power BI Interface, Field List More Options, Report View / Home Ribbon Tab, Report View / Insert Ribbon Tab, Report View / Modeling Ribbon Tab, and Connection Techniques. Chapter 2 - Query Editor
This will allow us to review extracted data and filter or remove specific records prior to saving them to the Power BI file. The sections covered include Query Editor Interface, Query Editor / Home Ribbon Tab, Query Editor / Transform Ribbon Tab, Query Editor / Add Column Ribbon Tab, and Query Editor/View Ribbon Tab. Chapter 3 - DAX Formula Overview
This chapter will provide an overview of the most important DAX formulas, functions, and capabilities. First, we will review common settings to better create formulas; then, we will review New Column, New Measure, New Table, and Quick Measure. Chapter 4 - DAX Reference Guide
In this chapter, we will document many common functions and provide practice exercises to demonstrate DAX capabilities. The sections covered include Math And Statistical Functions, Formatting Functions, Specialized DAX Functions, and Date And Time DAX Functions.