Mastering Power BI - 2nd Edition

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.

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.

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.

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

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a company dedicated to providing IT education.

An enthusiastic IT trainer, Chandraish embodies his company’s motto: Inspire, Educate and Evolve.

He is a Business Intelligence (BI) enthusiast and explorer, having successfully implemented multiple large and medium-scale BI solutions. Over his 24-year career, Chandraish has worked extensively with various BI and dashboarding applications, including Power BI, Tableau, QlikView, Qlik Sense, IBM Cognos, Business Objects, and Actuate. His passion lies in data, and he actively explores applications that offer enhanced data insights.