Learning Objectives

At the end of this course, the student must be capable on the following skillsets:

• Connecting and shaping data using Query Editor
• Creating a Data Model by connecting tables with BI relationship tools
• Create Dynamic Dashboards using Power BI Visuals

Target Audience

• Data Analyst, Sales, Human Resource, Admin Executives

Prerequisites

• Microsoft Office Excel, Knowledge on Basic Database Management

Course Outline

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
• Common DAX Functions and Categories
• Basic Date and Time Functions
• Basic Logical Functions
• Text Functions

MODULE 7: 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 8: PERFORM REPORT ANALYSIS

• Explore statistical summary.
• Use the Analyze feature
• Smart Narratives
• Explore Q and A Visuals
• Forecast and Trendlines