Stepupwards

Course Contents

Learn Microsoft Power BI end-to-end.

INTRODUCTION TO POWER BI
- Download Data files first
- Import data from CSV files
- Import data from Excel files
- Import data from Web 1
- Import data from Web 2
- Import Data from Folder
- Dataflows - Introduction
- Dataflows - Create Gateway from Scratch
- Dataflows - Create Entities from CSV file
Power Query: Prep, Clean & Shape Data
- Download resources for this section.
- Remove Rows
- Remove Columns
- Make first row as headers
- How to create calculate columns
- How to remove duplicates
- Unpivot columns and split columns
- Change Data type, Replace Values and Rearrange 1
- Append Queries
- Merge Queries
POWER BI VISUALS
- Visuals Intro
- Visuals-Bar Charts
- Visuals-Line Charts
- Visuals-Pie Chart
- Stacked bar Chart
- Clustered Column Chart
- Visuals-Area Chart and Analytics Tab Explained-0
- Visuals-Area Chart and Analytics Tab Explained-1
- Visuals-Combo Chart
- Visuals-Scatter Chart
- Visuals-Treemap Chart
- Visuals-funnel Chart
- Visuals-Card and Multi-Row Card
- Visuals-Gauge Card
- Visuals-KPIs
- Visuals-Matrix
- Visuals-Table
- Visuals-Text boxes - Shapes - Images
- Visuals-Slicers
- Visuals-Maps
- Custom Visuals - Word Cloud
- Visualization interactions
DATA MODELING IN POWER BI
- Our First Report-0
- Our First Report-1
- Our First Report-2
- Our First Report-3
Publishing and Sharing your first report
- Theme Download file
- Modeling Basics-0
- Modeling Basics-1
- Modeling Basics-2
- Modeling and Relationships-0
- Modeling and Relationships-1
- Other ways to create Relationship
- Normalization - Denormalization-0
- Normalization - Denormalization-1
- OLTP vs OLAP
- Star Schema vs Snowflake Schema-0
INTRODUCTION TO DAX USING POWER BI
- DAX101 - Importing Data for Dax Learning
- DAX101 - Resources for Dax Learning
- DAX101 - What is Dax
- DAX101 - Dax Data Types
- DAX101 - Dax Operators and Syntax
- DAX101 - M vs Dax
- DAX101 - Create a Column
- DAX101 - Rules to Create Measures
- DAX101 - Calculated Columns vs Calculated Measures-0
- DAX101 - Calculated Columns vs Calculated Measures-1
- DAX101 - Sum()
- DAX101 - AVERAGE()-MIN()-MAX()
- DAX101 - SUMX()
- DAX101 - DIVIDE()
- DAX101 - COUNT()-COUNTROWS()
- DAX101 - CALCULATE()-O0
- DAX101 - CALCULATE()-1
- DAX101 - FILTER()
- DAX101 - ALL()
- DAX101 - Time Intelligence - Create Date Table in M (important)
- DAX101 - Time Intelligence - Create Date Table in DAX-0
- DAX101 - Time Intelligence - Create Date Table in DAX-1
- DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()
- DAX101 - Time Intelligence - TOTALYTD()
- DAX101 - Display Last Refresh Date
- DAX101 - Time Intelligence - PREVIOUSMONTH()
- DAX101 - Time Intelligence - DATEADD()
- DAX101 - Quick Measures
POWER BI SERVICES & DASHBOARD
- PowerBl Reports
- PowerBI Workspaces
- PowerBl Datasets
- What are Dashboards
- How to create Workspace and Publish Report
- Create dashboards 6 different ways-0
- Create dashboards 6 different ways-1
- Favorite dashboards, reports, and apps in Power BI
- Subscribe to a Report or Dashboard
- Rename Workspace or Report or Dashboard
- Display Reports or Dashboards in Full screen mode
- Delete Reports or Dashboards
- Dashboard Menus
- Quick Insights
- Setting up Alerts on Cards
- Report page tooltip
ROW LEVEL SECURITY in POWER BI
- PATH Function
- PATHCONTAINS Function
- PATHITEM Function
- PATHITEMREVERSE Function
- PATHLENGTH Function
- RLS - Static Row Level Security
- RLS - Dynamic Row Level Security
- RLS - Organizational Hierarchy 1
- RLS - Organizational Hierarchy 2
- RLS - Organizational Hierarchy 3
SHARING & COLLABORATION
- Sharing and Collaboration
- Sharing Dashboard
- Sharing Workspaces
- Sharing App
- Publish To Web
HANDS ON Project

N/A

Instructor Profile

Ritu Agarwal

Advanced Excel knowledge with success in maintaining and organizing data, including dictionaries, power pivot, power query and cross-reference indexes across a broad range of industries.