- 4.7
- 5.0
Official Learning Partner
Course Highlights
Complete Real-time and Practical Power BI Training with Real-time Scenarios. Power BI is a cloud-based, elegant end-to-end business analytics tool that enables anyone to visualize, analyze, forecast any type of data with greater speed, efficiency, and understanding.
This Power BI Online Training includes EVERY detail of each Power BI Visual, Usage and Properties as per the latest versions. This Power BI course includes On-premise and Cloud Data Access, REST API, Azure Stream and R Integration including Data Modelling and ETL Techniques with Basic to Advanced Power Query (M Language), DAX Language Functions, Power BI Dashboards, Streaming Datasets, App Workspace, Content Packs, Data Gateways, Alerts, Power BI Report Server Components, Power BI Mobile Reports, Excel Integration, Excel Analysis, KPIs for Big Data Analytics, DataFlows and Microsoft PL 300 Certification are also a part of this Power BI Online Training course in addition to Mock Interviews, Resume Guidance, Concept wise Interview FAQs and ONE Real-time Project.
Training Highlights
- Custom Visuals
- Big Data Sources
- Excel Analysis
- Google Big Query
- Gateways, Rest API
- Tabular Mode
- Tabular Mode OLAP
- Cube Design
- Power BI Mobile
- R, Python, JSON
- Excel Online
- Report Server
- Power BI Admin
- Data Models
- abular Mode DAX
- Excel Analytics
Course Content
Module 1: Power BI
Ch 1: Power BI Intro, Installation
- Power BI & Data Analysis
- 5 Design Tools, 3 Techniques
- 2 Hosting Solutions
- Power BI with Co-Pilot & AI
- Power BI Installation
Ch 2: Report Design Concepts
- Basic Report Design (PBIX)
- Get Data, Canvas (Design)
- Data View, Data Models
- Data Points, Spotlight
- Focus Mode, PDF Exports
Ch 3: Visual Interactions, PBIT
- Visual Interactions & Edits
- Limitations with Visual Edits
- Creating Power BI Templates
- CSV Exports & PBIT Imports
Ch 4: Grouping, Hierarchies
- Creating Groups : Lists
- Creating Groups: Bins
- List Items & Group Edits
- Bin Size & Bin Count
Ch 5: 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 6: Hierarchies & Drill-Down
- Hierarchies: Creation, Use
- Hierarchies: Advantages
- Drill Up, Drill Down
- Conditional Drill Down
- Filtered Drill Down, Table View
Ch 7: Filters & Drill Thru
- Power BI Filters
- Basic, Top & Advanced
- Visual Filters, Page Filters
- Report Level Filters, Clear Filter
- Drill Thru Filters & Usage
Ch 8: Bookmarks, Buttons
- Power BI Bookmarks
- Images: Actions, Bookmarks
- Buttons: Actions, Bookmarks
- Page to Page NavigationsScore Cards, Master Pages
Ch 9: SQL DB Access & Big Data
- SQL DB Access, Queries
- Storage Modes: Direct Query
- Formatting & Date Time
- Storage Modes in Power BI
- Azure (Big Data) Access & Formatting
Ch 10: Power BI Visualizations
- Charts, Bars, Lines, Area
- TreeMaps & HeatMaps
- Funnel, Card, Multrow Card
- PieCharts & Waterfall
- Scatter Chart, Play Axis
- Infographics, Classifications
Ch 11: Power Query Introduction
- Power Query (Mashup)
- ETL Transformations in PBI
- Power Query Expressions
- Table Combine Options
- Merge, Union All Options
- Close, Apply & Visualize
Ch 12: Power Query : Table Tfns
- Table Duplicate, Header Promotion
- Group By Transformation
- Aggregate, Pivot Operation
- Reverse Rows, Count Rows
- Advanced Power Query Mode
Ch 13: Power Query: Column Tfn
- Any Column Transformations
- Data Type Detection, Change
- Rename, Replace, Move
- Fill Up, Fil Down
- Step Edits & Rollbacks
Ch 14: Power Query: Text, Date
- String / Text Transformations
- Split, Merge, Extract, Format
- Numeric and Date Time
- Add Column & Expressions
- Expressions and New Columns
- Column From Examples
Ch 15: Power Query: Parameters
- Parameters in Power Query
- Static Parameters, Defaults
- Dynamic Dropdowns, Lists
- Linking with Table Queries
- Step Edits, Type Conversions
Ch 16: Power BI Cloud: Publish
- Power BI Cloud Concepts
- Workspace Creation, Usage
- Report Publish Cloud
- Report Edits in Cloud
- Semantic Models & Usage
Ch 17: Power BI Cloud Dashboards
- Power BI Dashboards
- Dashboard Creation, Usage
- Pin Visuals, Pin LIVE Pages
- Add Image, Video Tiles
- Q&A & Pin Tiles
Ch 18: Power BI Cloud Operations
- Report Shares, Alerts
- Subscriptions, Exploration
- Downloads & Edits
- Report Cloning in Cloud
- QR Codes, Web Publish
- Lineage & Metrics
Ch 19: Power BI Cloud Gateways
- Data Gateways, Data Refresh
- Install, Configure Gateways
- Data Sources Configurations
- Data Refresh & Scheduling
- Gateway Optimizations
Ch 20: Power BI Cloud Apps
- Power BI Apps: Creation
- App Sections & Content
- Audience Options
- App Security & Sharing
- App Updates, Favourites
- App URL, End User Access
Ch 21: Power BI Report Server
- SQL Server 2025 (Mandatory Installations)
- Power BI Report Server
- Report Server Vs Cloud
- Installation, Configuration
- RS Config Tool Options
- Report Database, TempDB
- Web Service & Server URL
Ch 22: Paginated Reports
- Report Builder Tool
- Paginated Report (RDL)
- Report Expressions (RDL)
- Tablix, Chart Wizards
- Fields & Drill-Down
- RDL Report Publish
Ch 23: DAX Concepts (Basics)
- DAX Concepts: Intro & Realtime Need
- DAX Columns: Creation, Use
- DAX Measures: Creation, Use
- DAX Functions: IIF, ISBLANK
- SUM, CALCULATE Functions
- DAX Cheat Sheet
Ch 24: DAX Quick Measures
- Quick Measures in Power BI
- Average & Filters
- Running Totals
- Star Rating Calculations
- DAX Measures in Data View
- DAX in Visuals
- DAX in Cloud Reports
Ch 25: Data Modelling, DAX
- Dimensions Tables
- Fact Tables & DAX Measures
- Data Models & Relations
- DAX Expressions
- Star & Snowflake Schemas
- DAX Joins & Expressions
Ch 26: DAX Joins, Variables
- CALCULATEX & Variables
- COUNT, COUNTA, etc..
- SUM, SUMX, etc..
- SELECTED MEMEBER
- Filter Context, RETRUN
- Dynamic Report with DAX
Ch 27: 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 28: DAX – Row Level Security
- RLS: Row Level Security
- Data Modelling & Roles
- Verify Roles (Testing)
- Add Cloud Users to Roles
- Dynamic Row Level Security
- Testing RLS in Power BI
Ch 29: Analytical Reports
- Analytical Report Concepts
- Excel Data Analytics
- Excel with Power BI Cloud
- SQL, AVRO, JSON Sources
- Analyse in Excel (Cloud)
- Excel Reports to Cloud
Module 2: AI & CoPilot, PL 300
Ch 30: Power BI AI, CoPilot
- AI Components in Power BI
- CoPilot Practical Uses
- CoPilot with Desktop
- CoPilot with Cloud
- Need for AI Analytics (Fabric)
- PL 300 Exam (Microsoft Certified Data Analyst) Guidance
- PL 300 Exam Mocks
Ch 31: Fabric Concepts
- Fabric Introduction
- Fabric Lakehouse
- Fabric Warehouse
- Fabric Stream House
- Data Loads & Imports
Ch 32: Fabric Data Models
- Fabric Semantic Models
- Fabric Layouts
- Report Design
- Power BI Dashboards
- Data Exploration
- Apps & Publish
Module 3: PL300 Exam Guidance
- PL 300 Exam (Microsoft Certified Data Analyst) Guidance
- PL 300 Exam Mock Exams
- PL 300 Exam Samples (Dumps)
Module 4: Realtime Project
- Realtime Project 1 (ECommerce / Financial Analysis)
- Realtime Project 2 (Health Care / Banking)
PL 300 Certification Training Plans
| Course | Duration |
|---|---|
| PL 300 Certification | 4 Weeks |
Schedules for Core DBA [Chapters 1 to 20]
Schedules for Core DBA, Azure DBA [Chapters 21 to 40]
SQL SCHOOL
24x7 LIVE Online Server (Lab) with Real-time Databases.
Course includes ONE Real-time Project.
Who is SQL School? How far you have been in the training services ?
SQL School is a registered training institute, established in February 2008 at Hyderabad, India. We offer Real-time trainings and projects including Job Support exclusively on Microsoft SQL Server, T-SQL, SQL Server DBA and MSBI (SSIS, SSAS, SSRS) Courses. All our training services are completely practical and real-time. CREDITS of SQL School Training Center
- We are Microsoft Partner. ID# 4338151
- ISO Certified Training Center
- Completely dedicated to Microsoft SQL Server
- All trainings delivered by our Certified Trainers only
- One of the few institutes consistently delivering the trainings for more than 20+ Years online as inhouse
- Real-time projects in
- Healthcare
- Banking
- Insurance
- Retail Sales
- Telecom
- ECommerce
I registered for the Demo but did not get any response?
Make sure you provide all the required information. Upon Approval, you should be receiving an email containing the information on how to join for the demo session. Approval process usually takes minutes to few hours. Please do monitor your spam emails also.
Why you need our Contact Number and Full Name for Demo/Training Registration?
This is to make sure we are connected to the authenticated / trusted attendees as we need to share our Bank Details / Other Payment Information once you are happy with our Training Procedure and demo session. Your contact information is maintained completely confidential as per our Privacy Policy. Payment Receipt(s) and Course Completion Certificate(s) would be furnished with the same details.
What is the Training Registration & Confirmation Process?
Upon submitting demo registration form and attending LIVE demo session, we need to receive your email confirmation on joining for the training. Only then, payment details would be sent and slot would be allocated subject to availability of seats. We have the required tools for ensuring interactivity and quality of our services.
Please Note: Slot Confirmation Subject to Availability Of Seats.
Will you provide the Software required for the Training and Practice?
Yes, during the free demo session itself.
How am I assured quality of the services?
We have been providing the Trainings – Online, Video and Classroom for the last 20+ years – effectively and efficiently for more than 100000 (1 lakh) students and professionals across USA, India, UK, Australia and other countries. We are dedicated to offer realtime and practical project oriented trainings exclusively on SQL Server and related technologies. We do provide 24×7 Lab and Assistance with Job Support – even after the course! To make sure you are gaining confidence on our trainings, participans are requested to attend for a free LIVE demo based on the schedules posted @ Register. Alternatively, participants may request for video demo by mailing us to contact@sqlschool.com Registration process to take place once you are happy with the demo session. Further, payments accepted in installments (via Paypal / Online Banking) to ensure trusted services from SQL School™
YES, We use Enterprise Edition Evaluation Editions (Full Version with complete feature support valid for SIX months) for our trainings. Software and Installation Guidance would be provided for T-SQL, SQL DBA and MSBI / DW courses.
Why Choose SQL School
- 100% Real-Time and Practical
- ISO 9001:2008 Certified
- Weekly Mock Interviews
- 24/7 LIVE Server Access
- Realtime Project FAQs
- Course Completion Certificate
- Placement Assistance
- Job Support
