Power BI Training

In this course, you'll start by setting up Power BI in your system. Then you'll learn about connecting and shaping data, followed by creating Data Model. Next you will learn how to add calculated fields with Data analysis Expressions (DAX).

You will then learn Visualizing Data with reports. By the end of the course student will be able to load data from different sources and create Data models and achieve expertise in business analytics.

What You Will Learn:

• Chapter 1
• Introducing Power BI Desktop
• Introduction
• Downloading Power BI & Adjusting Settings
• Regional Settings
• Exploring the Power BI Desktop Interface & Workflow
• Chapter 2
• Connecting and Shaping Data
• Types of Data Connectors in Power BI Desktop
• The Power BI Query Editor
• Basic Table Transformations in Power BI, Editing Rows
• Understanding Append Queries, Editing Columns, Replacing Values
• Formatting Data, Pivoting and Unpivoting Columns
• Splitting Columns, Creating a New Group, Introducing the Star Schema
• Duplicating and Referencing Queries, Entering Data Manually
• Merging Queries, Creating an Index Column, Creating Conditional Columns
• Performing Basic Mathematical Operations, Working with Text Tools
• Working with Numerical Values, Working with Date & Time
• Creating a Rolling Calendar, Grouping & Aggregating Records
• Configuring Power BI Data Source Settings
• Chapter 3
• Creating a Data Model
• What is a "Data Model"?, Principles of Database Normalization
• Understanding Data Tables vs. Lookup Tables
• Understanding Table Relationships vs Merged Tables
• Creating Table Relationships, Snowflake" Schemas in Power BI
• Managing & Editing Table Relationships in Power BI Desktop
• Managing Active vs. Inactive Relationships, Understanding Relationship Cardinality
• Connecting Multiple Data Tables, Understanding Filter Flow
• Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
• Hiding Fields from the Power BI Report View, Power BI Data Model Best Practices
• Chapter 4
• Adding Calculated Fields with DAX
• Meet Data Analysis Expressions (DAX)
• Intro to DAX Calculated Columns, Intro to DAX Measures
• Calculated Columns vs. DAX Measures, Implicit vs. Explicit DAX Measures
• Filter Context Examples, Step-by-Step DAX Measure Calculation
• Understanding DAX Syntax & Operators, Common DAX Function Categories
• Basic Date & Time Functions, Conditional & Logical Functions (IF/AND/OR)
• Common Text Functions, Joining Data with RELATED, Basic Math & Stats Functions
• COUNT Functions (COUNTA,DISTINCTCOUNT, COUNTROWS)
• Order Line Items, CALCULATE, CALCULATE & ALL, CALCULATE & FILTER
• Iterator Functions (SUMX, RANKX), Time Intelligence Formulas
• DAX Best Practices in Power BI Desktop
• Chapter 5
• Visualizing Data with Reports
• Exploring the "Report" View in Power BI Desktop
• Adding Simple Objects to the Power BI Report Canvas
• Inserting Basic Charts & Visuals in Power BI
• Power BI Report Formatting Options, Power BI Report Filtering Options
• Exploring Data with Matrix Visuals, Filtering with Date Slicers
• Showing Key Metrics with Cards & KPI Visuals, Inserting Text Cards
• Visualizing Geospatial Data with Maps, Visualizing Data with Treemaps
• Showing Trends with Line & Area Charts, Adding Trend Lines & Forecasts
• Goal Pacing with Gauge Charts, Editing Power BI Report Interactions
• Adding Drill through Filters, Using Power BI Report Bookmarks
• Testing Scenarios with "What-If" Parameters
• Managing & Viewing Roles in Power BI Desktop
• Custom Power BI Visuals (Log-in Required)
• Designing for Phone vs. Desktop Report Viewers
• Publishing to Power BI Service, Power BI Data Visualization Best Practices