Data Visualization using PowerBI Curriculum
Total duration: 6 hr 50 mins
Course Topics Details Duration
Data Warehousing Data Warehousing Concepts: BI and Purpose, Business Intelligence
Concepts and Its Lifecycle, OLTP and OLAP, Data Warehouse
What is PowerBI, Features of PowerBI, Major
Introduction to PowerBI
Components and Licensing, Architecture
Data Importing, Data Importing in CSV, Creating
Data Importing
Table from Scratch, Data Importing from Web
Creating Relationships and Purpose, Custom
Data Modelling Relationships, Auto-detecting the Relationships,
Active and Inactive, Transitive Relationship
Report Properties, Visualization, Style
Manipulations Report, Setting Colours and
Report Design & Editing
Background, Card and Gauge Charts, Bar Chart, Pie
Interactions
Chart, Funnel and Waterfall Charts, Symbols and
Navigation, Edit Interactions
DAX Measures and Columns, Syntax and Indentation,
Measures Row and Context Level Context, Measures and SUM
Function
Data Visualization
Filters, Types of Filters: Visual Level, Page and 6 Hours 50 Mins
using PowerBI
Filters Report Level, Include and Exclude, Using Slicer as a
Filter
Overview of PowerBI Service, Service Interface,
Converting Published Reports into Dashboards, Adding
Power BI Service & Reports and Data Sets in Workspace, Creating
Features Workspace, Setting Admin Roles, Drill Through,
Hierarchies, Bookmarks & Selection Pane, Row-Level
Security (RLS)
Exploring Power Query Editor, Data Quality
Optimization and Applied Steps, Duplicate Vs
Transforming Data Reference, Conditional Column, Indexed and
Duplicate, Custom Column, Overview, Replace, Fill
Up, FIll Down, and Remove, GROUP BY
DAX and Functions, Create a Date Table and Establish
DAX Basics
a Relationship, Date Functions, Table Functions
Row level Context, Use of Calculate function,
DAX Calculate Functions Advanced Functions: ALL, SELECTED, RELATED,
LOOKUPVALUE