Data Analysis Using Excel and Power BI Training Course

Lecture 2.1

Visualizing Data Using Conditional Formatting

Lecture 2.2

Visualizing Data Using Sparkline

Lecture 2.3

Visualizing Data Using Slicer

Lecture 2.4

Using SUM & COUNT Function

Lecture 2.5

Using VLOOKUP Function

Lecture 2.6

Using Nested IF Function

Lecture 2.7

Perform What If Analysis

Lecture 2.8

Perform Goal Seeking

Lecture 3.1

Introducing Pivot Tables & PivotChart

Lecture 3.2

Analyzing Data with PivotChart

Lecture 4.1

Introducing to Power Query

Lecture 4.2

Connecting to Excel Workbook Files

Lecture 4.3

Connecting to CSV Files

Lecture 4.4

Connecting to TEXT Files

Lecture 4.5

Connecting to Access Files

Lecture 4.6

Connecting to Excel Sheets

Lecture 4.7

Connecting to Folders

Lecture 4.8

Transforming Data Using Power Query

Lecture 4.9

Loading Data to the Excel Data Model

Lecture 4.10

Working with Multiple Queries

Lecture 4.11

Custom Columns with M Calculations

Lecture 5.1

Power Pivot Capabilities

Lecture 5.2

Understand Data Model Concept

Lecture 5.3

Create Relationships in Data Model

Lecture 6.1

Understand Data Analysis Expression – DAX

Lecture 6.2

Create Calculated Column

Lecture 6.3

Create Measure

Lecture 6.4

Row Context

Lecture 6.5

Filter Context

Lecture 7.1

Building a Calendar table

Lecture 7.2

Time Intelligence in DAX

Lecture 8.1

Create Dynamics Excel Reports

Lecture 8.2

Create interactive Excel Dashboards

Lecture 9.1

Introduction to business intelligence

Lecture 9.2

Introduction to data analysis

Lecture 9.3

Introduction to data visualization

Lecture 10.1

Introduction Power BI

Lecture 10.2

Create Report

Lecture 10.3

Create Dashboard

Lecture 11.1

Loading Data to Power BI

Lecture 11.2

Uploading & Updating PBIX Reports

Lecture 11.3

Refreshing Power BI Data

Lecture 11.4

Transforming Data Using Power Query in Power BI

Lecture 12.1

Mange Data Model in Power BI

Lecture 12.2

Create Relationships

Lecture 12.3

Create Hierarchies

Lecture 13.1

Create Calculated Column

Lecture 13.2

Create Measure

Lecture 14.1

Building a Calendar table

Lecture 14.2

Time Intelligence in DAX

Lecture 15.1

Creating Reports

Lecture 15.2

Report Filtering

Lecture 15.3

Create a Dashboard

Lecture 15.4

Drill-down

Lecture 15.5

Drill-Through

Lecture 15.6

Formatting Visualizations

Lecture 15.7

Apply conditional formatting

Lecture 15.8

Visual Interactions

Lecture 15.9

Slicers and Advance Card Visuals

Lecture 15.10

Bookmarks & Buttons

Lecture 15.11

Using Q & A

Lecture 16.1

Sharing Power BI Dashboard

Lecture 16.2

Create and Manage a workspace in Power BI Service

Lecture 16.3

Understand the aspects of Power BI security

Lecture 16.4

Configure row-level security roles and group memberships