MODULE 1: CONNECTING TO DATA USING POWER BI DESKTOP

·      Setting up Power BI Properties

·      The Power BI Interface and Workflow

·      Types of Data Connectors

·      The Query Editor Interface

·      Basic Table Transformations

MODULE 2: DATA SHAPING WITH QUERY EDITOR

·      Text-Specific Tools

·      Number-Specific Tools

·      Date-Specific Tools

·      Index and Conditional Columns

·      Grouping and Aggregating Data

·      Merging Queries

·      Appending Queries

·      Appending Queries from a Folder

MODULE 3: QUERY EDITOR CONFIGURATIONS

·      Data Source Settings

·      Query Refresh Settings

·      Additional Types and Categories

·      Defining Hierarchies

·      Column Quality and Profile

MODULE 4: INTRODUCTION TO DATA MODEL

·      What is a Data Model?

·      Database Normalization

·      Data Tables vs Lookup Tables

·      Relationship vs Merge Tables

MODULE 5: CREATING TABLE RELATIONSHIPS

·      Star Schema

·      Snowflakes Schema

·      Managing and Editing Relationships

·      Active vs Inactive Relationships

·      Relationship Cardinality

·      Connecting Multiple Tables

·      Understanding Filter Flow

·      Hiding Fields from Report View

MODULE 6: MEET DATA ANALYSIS EXPRESSIONS (DAX)

·      Introduction to Calculated Columns and Measures

·      Adding Columns and Measures

·      Implicit and Explicit Measures

·      Using Quick Measures

·      Filter Context Samples

MODULE 7: DAX SYNTAX AND OPERATORS

·      Common DAX Functions and Categories

·      Basic Date and Time Functions

·      Basic Logical Functions

·      Text Functions

MODULE 8: ADVANCED-DATA ANALYSIS EXPRESSIONS

·      Joining Data with Related

·      CALCULATED Function

·      CALCULATE and ALL Function

·      CALCULATE and FILTER Function

·      Iterator X Functions

MODULE 9: INTRODUCTION TO REPORTS AND DASHBOARDS

·      The Report View

·      Inserting Basic Charts and Visual

·      Formatting Options

·      Report Filtering Options

·      Matrix Visuals

·      Bar and Column Chart

·      Text and Date Slicers

·      Cards

·      Map Visuals

·      Line and Area Charts

·      Pie and Donut Chart

MODULE 10: PERFORM REPORT ANALYSIS

·      Explore statistical summary.

·      Use the Analyze feature.

·      Smart Narratives

·      Explore Q and A Visuals

·      Forecast and Trendlines