Название: Mastering Power BI: Build business intelligence applications powered with DAX calculations, insightful visualizations, advanced BI techniques, and loads of data sources, 2nd Edition
Автор: Chandraish Sinha
Издательство: BPB Publications
Год: 2024
Страниц: 280
Язык: английский
Формат: epub (true)
Размер: 69.4 MB

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.

AI refers to the simulation of human intelligence in machines programmed to think and perform tasks like problem-solving, learning, perception, and decision-making. It encompasses various technologies and techniques, including Machine Learning (ML), Natural Language Processing (NLP), and computer vision, enabling systems to analyze data, recognize patterns, and make informed decisions without explicit programming. In Power BI, AI insights are employed to access a collection of pre-trained ML models that enhance data preparation efforts. AI techniques can be applied Power BI desktop and Query Editor. In Power BI desktop, AI visuals facilitate advanced data analysis and in Query Editor, the Add Column tab provides various AI capabilities to assist in data transformations and insights. AI visuals in Power BI Desktop utilize AI algorithms and capabilities to improve data analysis and visualization. They offer users additional insights by automatically analyzing data patterns, trends, and anomalies, facilitating more informed decision-making.

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.