Advanced Excel
Introduction to MS Excel
Uses and Importance of Excel
Exploring Excel Interface
Basic Excel Operations
Formatting
Format Painter
Number & Symbols
Inserting in Excel
Transforming Data
Working with Formulas
Functions in Excel
Logical Functions
Math Functions
Lookup Functions
Formula Auditing
Data Sorting and Filtering
Slicer & Timeline
Flash Fill
Consolidation
Data Validation
Conditional Formatting
Chart and Graphs
Pivot Table
Pivot Charts
Table and Table Styles
Link
Page Setup & Arrangement in Excel
Macro
Protection of Worksheet
PowerBI
Introduction to Power BI
Role of Power BI in Data Analytics
Power BI Desktop vs Power BI Service
Installing and Setting up Power BI Desktop
Exploring Power BI Interface
Understanding Reports, Dashboards, and Datasets
Connecting to Data Sources
Import vs DirectQuery Mode
Previewing and Loading Data
Launching Power Query Editor
Cleaning and Transforming Data
Removing Duplicates and Unnecessary Columns
Replacing Values and Filling Blanks
Splitting and Merging Columns
Unpivoting and Pivoting Columns
Merging Queries
Appending Queries
Changing Data Types
Creating Data Models
Creating Relationships Between Tables
Understanding Cardinality and Cross Filtering
Creating and Marking a Date Table
Introduction to DAX
Creating Calculated Columns and Measures
Using Variables in DAX
Basic DAX Functions
Logical Functions in DAX
Math and Statistical Functions in DAX
Lookup Functions in DAX
Time Intelligence Functions in DAX
Creating Visualizations in Power BI
Using Bar, Column, Line, and Pie Charts
Working with Table and Matrix Visuals
Using Cards, KPIs, and Gauges
Creating Map and Geographical Visuals
Using Funnel, Waterfall, and Treemaps
Formatting and Customizing Visuals
Using Tooltips and Labels
Using Filters (Visual, Page, Report Level)
Working with Slicers
Creating Drill Down and Drill Up Reports
Using Bookmarks and Buttons
Designing Report Navigation
Creating Interactive Dashboards
Publishing Reports to Power BI Service
Creating Dashboards in Power BI Web
Pinning Visuals to Dashboard
Sharing Reports and Dashboards
Setting up Scheduled Data Refresh
Using Power BI Gateway
Creating Roles and Row-Level Security (RLS)
Testing and Managing RLS in Service
Using Q&A Visual for Natural Language Queries
Using Smart Narratives
Using Key Influencer Visual
Using Decomposition Tree Visual
Using Performance Analyzer
Best Practices for Data Model Optimization
Exporting Reports to PDF or PowerPoint
Following Dashboard Design Guidelines
Final Report Review and Publishing
