Have a question?
Send enquiry
Message sent Close
End-User Productivity Training

MICROSOFT POWER BI – BASIC

Instructor
Nick - Admin
0
0 reviews
Add to wishlist
Share
Inquire Now
  • Description
  • Reviews

VIRTUAL INSTRUCTOR LED

COURSE DESCRIPTION

This is an introductory course for Microsoft Power BI where students will learn the Basic commands and configuration of Microsoft Power BI Power Query Editor. Students on this course will learn the Best practices of Data Preparation , Data Transformation and Data Cleaning which is a very critical stage in Data Analysis. At the end of this training students will also learn the Process of Data Modeling and Basic Data Visualization using Power BI Report View.

 

PREREQUISITES

  • Microsoft Office Excel, Knowledge on Basic Database Management

 

TARGET AUDIENCE

  • Data Analyst, Sales, Human Resource, Admin Executives

 

COURSE 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  

 

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 Option
  • 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