#PL-300

PL – 300 is the Microsoft certification for the Data Analyst. Data Analyst is a promising job role that deals with Data, Analysis, Derived Information and drive to Infographics of enterprise content. This role also involves Data collection, data processing, and data analysis to identify trends, patterns, and relationships that can be used to solve problems and make informed decisions with ease!

Training Highlights

✅ Power BI Desktop & Service
✅ Data Modeling, DAX Functions
✅ Power Query (M), Parameters
✅ Interactive Dashboards, Apps
✅ Big Data Access, DAX
✅ Dynamic Row Level Security (RLS)
✅ Power BI with Azure & Fabric
✅ Power BI Deployment, IAM
✅ End-to-End Real-Time BI Project
✅ 1:1 Mentorship, Interview Guidance

Modules We Learn

✅ Module 1: Power BI
✅ Module 2: Realtime Project

Course Duration: 1 Month

Professional working on a laptop in a dark setting with text highlighting “Unlock New Opportunities as a Power BI Data Analyst (PL-300).”

<br />

Course Content
Course FAQ's

PL 300 Course Contents:

Brochure Download Request a Callback

Module 1: Power BI

Ch 1: Power BI Intro, Installation

Power BI & Data Analysis
Power BI Eco System
Power BI Design Tools
Power BI Installation

Ch 2: Report Design Concepts

Basic Report Design (PBIX)
Data Points, Spotlight
Visual Interactions & Edits
Focus Mode, PDF Exports

Ch 3: Grouping, Hierarchies

Creating Groups: Lists
Creating Groups: Bins
Hierarchies & Drill-Downs
Drill Up, Conditional Drilldown

Ch 4: Slicer & Visual Sync

Slicer Visual in Power BI
Slicer: Format Options
Single Select, Multi Select
Slicer: Select All On / Off
Visual Sync with Slicers

Ch 5: Filters & Drill Thru

Power BI Filters
Basic, Top & Advanced
Visual Filters, Page Filters
Report Level Filters, Clear Filter
Drill Thru Filters & Usage

Ch 6: Bookmarks, Buttons

Power BI Bookmarks
Images: Actions, Bookmarks
Buttons: Actions, Bookmarks
Page to Page Navigations
Score Cards, Master Pages

Ch 7: SQL DB Access & Big Data

SQL DB Access, Queries
Storage Modes: Direct Query
Formatting & Date Time
Storage Modes in Power BI
Data Modeling & Formatting

Ch 8: Power BI Visualizations

Charts, Bars, Lines, Area
Tree Maps & Axis Items
Funnel, Card, Mult-Row Card
Pie Charts & Waterfall
Scatter Chart, Play Axis
Infographics, Classifications

Ch 9: Power Query Transformations – 1

Power Query (Mashup)
ETL Transformations in PBI
Table Combine Options
Merge, Union All Options
Missing Values, Duplicate Records
Wrong Data Types, Outliers
Close, Apply & Visualize

Ch 10: Power Query Transformations – 2

Group By Transformation
Aggregate, Pivot Operation
Reverse Rows, Count Rows
Data Cleaning, Null Handling
Data Type Detection, Change
Rename, Replace, Move
Fill Up, Fil Down

Ch 11: Power Query Transformations – 3

String / Text Transformations
Split, Merge, Extract, Format
Numeric and Date Time
Add Column & Expressions
Column From Examples

Ch 12: Power Query Transformations – 4

Parameters in Power Query
Static Parameters, Defaults
Dynamic Dropdowns, Lists
Linking with Table Queries
Step Edits, Type Conversions

Ch 13: Power BI Cloud & Fabric

Power BI Cloud, Microsoft Fabric
Microsoft Fabric Concepts
Fabric One Lake (DWH, LH, etc.)
Microsoft Fabric Workspace
Power BI Desktop Connections
Report Uploads (PBIX)
Report Edits, Semantic Models

Ch 14: Power BI Cloud Dashboards

Power BI Dashboards
Dashboard Creation, Usage
Pin Visuals, Pin LIVE Pages
Add Image, Video Tiles
Q&A & Pin Tiles

Ch 15: Power BI Cloud Operations

Report Shares, Alerts
Subscriptions, Exploration
Downloads & Edits
Report Cloning in Cloud
QR Codes, Web Publish
Lineage & Metrics

Ch 16: Power BI Cloud Gateways

Data Gateways, Data Refresh
Install, Configure Gateways
Data Refresh & Scheduling
Gateway Optimizations
Incremental Refresh
Large Dataset Optimization

Ch 17: Power BI Cloud Apps

Power BI Apps: Creation
App Sections & Content
Audience & App Security
App Updates, Favorites
App URL, End User Access

Ch 18: Power BI Report Server, RDL

Power BI Report Server
RS Config Tool Options
Report Database, TempDB
Web Service & Server URL
Report Builder Tool
Paginated Report (RDL)
RDL Report Publish

Ch 19: DAX Concepts & Calculations

DAX Concepts: Intro & Realtime Need
DAX Columns: Creation, Use
DAX Measures: Creation, Use
DAX Functions: IIF, ISBLANK
SUM, CALCULATE Functions

Ch 20: DAX Quick Measures

Quick Measures in Power BI
Running Totals
Star Rating Calculations
DAX Measures in Data View
DAX in Cloud Reports

Ch 21: Data Modelling

Dimensions Tables
Fact Tables & DAX Measures
Data Models & DDAX Joins
Star & Snowflake Schemas
Many-to-Many Relationships
Calculation Groups

Ch 22: DAX Joins, Variables

CALCULATEX & Variables
COUNT, COUNTA, etc..
SUM, SUMX, etc..
SELECTED MEMEBER
Filter Context, RETURN

Ch 23: DAX Models & Calculations

VAR, SWITCH, SUMMARIZE
TREATAS, USERELATIONSHIP
CROSSFILTER, GENERATE
RANKX, TOPN, WINDOW
OFFSET, INDEX

Ch 24: DAX Time Intelligence

Need for Time Intelligence
Date Table Generation
Time Intelligence with DAX
PARALLELPERIOD, DATE
CALENDAR, Total Functions
YTD, QTD, MTD with DAX

Ch 25: DAX – Row Level Security

RLS: Row Level Security
Data Modelling & Roles
Add Cloud Users & KPIs
CoPilot with DAX

Ch 26: DAX – Analytical Reports

DAX with Excel
Analytical Reports
Virtual Cube Concepts
Cross Filter Reporting
Alerts, Data Activator

Ch 27: PL 300 Exam Guidance

PL 300 Exam Guidance
Exam Samples
Exam Scenarios

Module 2: Realtime Project

Project Objective

Design and implement a modern Healthcare Data Platform using Power BI Analytics and Reporting services
to process patient, hospital, clinical, and operational data for reporting, analytics, and decision-making.

Technologies Used