MICROSOFT POWER BI
OVERVIEW
Microsoft Power BI is becoming the world’s most powerful self-service business intelligence platform. This business analytical tool delivers insight into any organization and gives you the ability to drive and direct informed and agile business decisions. Power BI is the easiest tool to use for data analysis, reporting and interactivity. You can create your own dataset based on a single or multiple source and transform this data into professional-quality interactive dashboards.
With this training, your teams will be able to convert extensive amounts of unfiltered data into actionable dashboards and reports. It enables you to evaluate important business metrics, foresee future trends, and uncover hidden insights.
LEARNING OUTCOMES
After successfully completing this course, you will be able to:
Learn Power BI Best Practices, Tips, and Tricks
Understand Power BI Desktop and its components
Learn how to connect to different data sources using Query Editor
Learn how to work with different views of the Data Model
Learn to create calculated columns and measures
Learn to use the DAX Formula language to develop powerful calculations
Learn how to create a wider range of charts and visualizations
Learn how to create, modify, and customize interactive dashboards, visualizations, and reports to convey specific business KPIs and measures
INTRODUCING POWER BI DESKTOP
Understanding the Power BI tools
An overview of the workflow
Introducing the different views of the data model
An Introduction to the Query Editor (Extract, Transform & Load)
What is the Query Editor
Looking at the Query Editor Interface
Types of Data Connectors
Transform basic tables
Formatting text, numbers, and dates
Index and Conditional columns
Pivoting and Unpivoting columns
Modifying, merging and appending queries
Query Editor and Power BI best practice
WORKING ON THE DATA MODEL
Introduction to database normalization
FACT tables vs DIMENSION tables
Introducing and understanding relationships
Active vs Inactive Relationships
Understanding Cardinality
Star vs Snowflake Schemas
Connecting Multiple Data Tables
Cross-filter selection and Many-to-many relationships
Hiding fields from the Report view
Data Modeling and Power BI best practices
WORKING WITH DAX
Introduction to DAX
DAX and calculated columns
DAX syntax and operators
Common Power BI functions
Date and Time Intelligence formulas
Logical and Conditional Formulas
Text, Math and Stat functions
DAX and Power BI best practices
WORKING IN REPORT VIEW TO VISUALIZE OUR RESULTS
Introduction to Report View
Understanding the Power View Interface
Adding basic charts
Formatting and filtering options
Matrix visuals
Slicers and Timelines
Creating Cards and KPIs
Power BI Maps
Types of visualizations
Applying different filter types
Managing and Viewing roles
Data Visualization Best Practices