Power BI Desktop – Introduction and Solutions

As the first step, you gather the data from various sources and prepare, process, enhance or reduce these in order to transfer them to a data model for evaluation.

The chapter about data models presents many examples of calculations (measures and columns). Based on the examples and their descriptions the user will become familiar with many functions and formulas that, in the interplay with the data model, give testimony to their power. The reader will quickly experience the capabilities of Power BI Desktop and get an appreciation of the benefit for his or her work. The text describes the development of formulas, the context principle, the relevance of a calendar table, the exemplary creation of hierarchies and further process steps that will optimize the model.

The main focus of the book lies in the interactive visualization of data and how dynamic reports are created and structured. Based on different practical examples, small and large, the reader will run the course of the entire process from data source to finished report and visualization.

From the contents:

Introduction of Power BI Desktop; Set up Power BI Desktop, Test Drive, First Steps;

Call up, Transform and Structure Data; Set Up and Expand the Data Model;

Create Relationships; DAX Fundamentals in Power BI Desktop;

Categorize Data in Power BI Desktop; Calculated Columns in the Data Model;

Add Calculated Fields (Measures) to the Data Model; Work with DAX Functions;

Data Analysis over Time; Filter Data, Apply Data Cuts and Visualize Results;

Reports and Diagrams with Power BI Desktop; Complete Work Process Based on 

Practical Examples