Mastering Power BI, 2nd Edition: Build business intelligence applications powered with DAX calculations, insightful visualizations, advanced BI techniques, and loads of data sources – 2nd Edition

Take a deep dive into the dynamic world of Power BI!

Key Features

• In-depth knowledge of Power BI, demonstrated through step-by-step exercises.
• Covers data modeling, visualization, and implementing security with complete hands-on training.
• Includes a project that simulates a realistic business environment from start to finish.
• This version teaches about Artificial Intelligence visuals in Power BI.

Description

Mastering Power BI covers the entire Power BI implementation process. The readers will be able to understand all the concepts covered in this book, from data modeling to creating powerful visualizations.

This book begins with concepts and terminology such as the star-schema, dimensions, and facts. It explains multi-table dataset and demonstrates how to load these tables into Power BI. It shows how to load stored data in various formats and create relationships. Readers will also learn more about Data Analysis Expressions (DAX). This book is a must for developers to learn how to extend the usability of Power BI, to explore meaningful and hidden data insights. Throughout the book, you keep on learning about the concepts, techniques, and expert practices on loading and shaping data, visualization design, and security implementation.

The second edition of Mastering Power BI book adheres to the first edition in terms of providing the basics of business intelligence and Power BI; however, it introduces new concepts and features in terms of data transformation, data profiling, custom hierarchies, AI visuals, and many more.

What you will learn

• Learn about Business Intelligence (BI) concepts and their contribution in business analytics.
• Learn to connect, load, and transform data from disparate data sources.
• Create and execute powerful DAX calculations.
• Design various visualizations to prepare insightful reports and dashboards.

Who this book is for

This book is for anyone interested in learning how to use Power BI desktop or starting a career in business intelligence and analytics. While it covers all the fundamentals, it is recommended that the reader be familiar with MS Excel and database concepts.

Table of Contents

1. Understanding the Basics

2. Connect and Shape

3. Advanced Data Transformations

4. Optimize Your Data Model

5. Data Analysis Expressions

6. Visualizations in Power BI

7. Drill Through and Drill Down Reports

8. Artificial Intelligence in Power BI

9. Power BI Service

10. Securing Your Application