-
Book Overview & Buying
-
Table Of Contents
Master in Microsoft Power BI Desktop and Service
By :
Master in Microsoft Power BI Desktop and Service
By:
Overview of this book
In this course, you'll begin by learning the fundamentals of business intelligence and how Power BI transforms data into insights. You'll explore Power BI Desktop, its key components, and get hands-on experience installing the tool. The course covers connecting to various data sources, such as Excel and SQL servers, to prepare you for any data challenge. You'll also dive into Power Query to clean and shape data for analysis.
Next, you'll focus on Power BI data modeling, learning how to build relationships between tables using primary and foreign keys. You'll gain a strong understanding of Data Analysis Expressions (DAX), enabling you to create complex calculations and measures. You'll also master date and time functions, logical functions, and ranking techniques for precise data analysis.
As you move on to creating reports and visualizations, you'll learn to use different Power BI charts, including advanced ones like funnel and waterfall charts. You'll also discover how to customize visuals and add interactivity with slicers and drill-through. The final module will teach you how to publish and share your work using Power BI Service, create dashboards, set up row-level security, and manage datasets. By course end, you'll be able to create and share professional Power BI reports and dashboards.
Table of Contents (7 chapters)
Business Intelligence Concepts and Introduction
Connecting Power BI with Different Data Sources
Power Query for Data Transformation
Power BI Data Modeling – Relationship View and PowerPivot
Data Analysis DAX)
Reports and Visualization Types in Power BI
Power BI Publishing - Reports