End-User Productivity Training

MICROSOFT POWER BI

Instructor

Nick - Admin

0 reviews

Add to wishlist

Inquire Now

Description
Reviews

DURATION: 5 Days Training / Virtual Instructor-Led

COURSE DETAILS

Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, and then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. In addition, scale across the enterprise, with governance and security built in.

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
Creating DAX, Measures and Calculated Columns for Data Analytics
Create Dynamic Dashboards using Power BI Visuals

MODULE 1: AN OVERVIEW OF SELF-SERVICE BUSINESS INTELLIGENCE

Overview of Business Intelligence
Overview of Data Analysis
Overview of Data Visualization
Guidelines to creating good data visualization
Overview of Self-Service BI
Practical Application: Exploring a Simple BI Solution

MODULE 2 INTRODUCTION TO POWER BI

What is Power BI?
Practical Application: Creating and Navigation through a Power BI Dashboard
Setting up Power BI Properties
The Power BI Interface and Workflow

MODULE 3: POWER BI DATA SOURCE

Configuring and Connecting to Power BI Data
Excel as a Data Source for Power BI
Practical Application: Importing Data into Power BI
Excel files imported into Power BI
Creating and Viewing reports from Excel files

MODULE 4: SHAPING AND COMBING DATA (ETL-EXTRACT TRANSFORM LOAD DATA)

Executing Power BI Desktop Queries
Transforming (Shaping Data)
Combining Data (or Data Consolidation) Techniques
Practical Application: Shaping and Combining Data
Transforming or Shaping Power BI Data
Data Consolidation or Combination using Power BI Data

MODULE 5: MODELLING DATA

Understanding Power BI Data Model
Understanding Data Relationships
Data Tables vs Lookup Tables
Relationship vs Merge Tables
Star Schema and Snowflakes Schema
Managing and Editing Relationships
Active vs Inactive Relationships
Relationship Cardinality
Understanding Filter Flow
Hiding Fields from Report View

MODULE 6: DATA ANALYSIS EXPRESSIONS

Introduction to Calculated Columns and Measures
Adding Columns and Measures
Implicit and Explicit Measures
Filter Context Samples
Step by Step Measure Calculation
Common DAX Functions and Categories
Basic Date and Time Functions
Basic Logical Functions
Text Functions

MODULE 7: ADVANCED DATA ANALYSIS EXPRESSIONS

Joining Data with Related
Math and Stats Functions
COUNT Functions
CALCULATED Function
CALCULATE and ALL Function
CALCULATE and FILTER Function
Iterator X Functions
DAX Time Intelligence Formulas

MODULE 8: POWER BI AND CREATIVE DATA VISUALIZATIONS WITH DATA INTERACTION

How to create Power BI Reports
Adding Simple Objects
Inserting Basic Charts and Visual
Creating and Viewing Power BI Reports
Formatting Options
Report Filtering Options
Editing Report Interactions
Adding Drill-through Filter

MODULE 9: DATA ANALYSIS TOOLS IN POWER BI REPORTS

Exploring the Q & A Functions
Analyze and Summarize Reports
What If Parameter
Built-In Forecast tools of Power BI Reports
Adding Bookmarks
Adding Tooltips
Using AI Visuals
Publish Project in Microsoft Power BI Service

MODULE 10: DEPLOYING PROJECT IN POWER BI SERVICE

What is Power BI Service
Power BI Desktop vs Service
Create a Power BI Account
Power BI Workspaces
Building Blocks of Power BI Service