Course Contents

Case Study: Through out this course you will assume the role of a Business Analyst who has been just hired to provide meaningful insight to Management based on which they can take key business decision.

We are living in an era where we have access to plethora of information but the problem lies in how to draw a meaningful insight from those available information.

Certainly an Excel sheet with tons of sales data can not help you understand how are sales on weekend in comparison to weekdays to take key decision about stocks maintenance, staff management etc.

If you are someone who is looking for data insights like this then this course is for you where I would help you to understand how to make you dashboard not just information loaded but also visually appealing for your stakeholders.

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

5. Visualizing Data with Dashboards

Inserting charts and visuals, customizing formats, editing interactions, applying filters and bookmarks, etc.

1. Recommended to know the basics of working with data in Excel

2. In the course you will need a work email address to sign up to Microsoft account.

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.