Power BI with Azure Synapse: Beginner to Master with DAX, Power Query, Azure Synapse, Data Lake, Databricks, AI Dashboards & Power BI Service
(A Complete Hands-On Training on Power BI Fundamentals, Data Modeling, DAX, Power Query, Custom Visualizations, Dashboards, Reports, Power BI Service, Data Gateways, Row-Level Security, and Real-World Business Projects)
This course provides a complete hands-on introduction to data analysis and business intelligence using Microsoft Power BI. You’ll start with the fundamentals of BI and Power BI architecture, then move into practical skills like connecting multiple data sources, transforming data with Power Query, and building interactive reports and dashboards. You’ll also master data modeling, DAX calculations, advanced visualizations, and security features like Row-Level Security. The course further covers collaboration with Power BI Service, publishing and sharing reports, and setting up data gateways for scheduled refresh.
Ideal for aspiring Data Analysts, BI Developers, Business Users, and anyone working with data, this program equips you to transform raw data into actionable insights and become job-ready in Power BI.
About the Instructor:
|
Krishna is a seasoned Data & Business Intelligence professional with over 10+ years of experience in analytics, data visualization, and building BI solutions. He specializes in Microsoft Power BI, and has delivered numerous projects helping businesses convert raw data into meaningful insights through dashboards, reports, and strategic data models. Krishna has deep expertise in Power Query transformations, data modelling, DAX, and custom visualizations. He is experienced in setting up robust BI architectures, implementing row-level security, optimizing performance, and enabling enterprise-scale reporting. For the past several years, Krishna has been delivering hands-on training in Power BI, guiding learners through real-world datasets, business-focused case studies, and practical dashboards. He is committed to helping students and professionals gain practical skills that are directly applicable in their roles. Till now, he has successfully completed 30+ batches and trained over 600 students across different domains. |
Sample Videos:
Power BI with Azure Synapse: Demo video
Power BI with Azure Synapse: Day 1 video
https://youtu.be/msWP9sszN4g
Live Sessions Price:
For LIVE sessions – Offer price after discount is 300 USD 259 89 USD Or USD13000 INR 12900 INR 6900 Rupees
OR
What will I learn by the end of this course?
- Understand Business Intelligence (BI) concepts and the complete Power BI ecosystem (Desktop, Service, Mobile, Gateways).
- Install, set up, and confidently navigate Power BI Desktop.
- Connect to multiple data sources and perform data extraction, transformation, and loading (ETL) with Power Query.
- Build data models and relationships to structure raw data for analysis.
- Write and apply DAX (Data Analysis Expressions) for calculated columns, measures, and advanced business logic.
- Create a wide variety of visualizations (charts, KPIs, maps, slicers, and custom visuals).
- Design interactive reports and dashboards that deliver actionable insights.
- Work with the Power BI Service: publish reports, share dashboards, and collaborate in workspaces.
- Set up scheduled refresh, data gateways, and row-level security to manage enterprise-level BI solutions.
- Apply your knowledge with real-world, hands-on projects that simulate practical business scenarios.
Free Day 2 Session:
25th September @ 9:00 PM – 10 PM (IST) (Indian Timings)
25th September @ 11:30 AM – 12:30 PM (EST) (U.S Timings)
25th September @ 4:30 PM – 5:30 PM (BST) (UK Timings)
Class Schedule:
For Participants in India: Monday to Friday @ 9:00 PM – 10: PM (IST)
For Participants in the US: Monday to Friday @ 11:30 AM – 12:30 PM (EST)
For Participants in the UK: Monday to Friday @ 4:30 PM – 5:30 PM (BST)
What students have to say about Krishna:
|
👩 Ayesha Khan: 👩Divya Polkam: 👨 Davidson: 👨 Md. Aziz: 👩 Maria Gonzalez: 👨 John Kennedy: |
Salient Features:
- 35 Hours of Live Training along with recorded videos
- Lifetime access to the recorded videos
- Course Completion Certificate
Who can enroll for this course?
- Students and Beginners eager to start a career in Data Analysis and Business Intelligence
- Business Analysts & Managers looking to make smarter, data-driven decisions with dashboards and reports
- Data Analysts & Reporting Professionals who want to master Power BI for advanced visualization and insights
- Software Developers interested in learning how to integrate BI reporting into applications
- IT Professionals & System Administrators aiming to add BI and reporting skills to their profile
- Cloud & Infrastructure Engineers who need to visualize and monitor operational data in real time
- Entrepreneurs & Startups wanting to track KPIs and business growth through interactive dashboards
- Educators & Researchers looking to analyze and present data effectively for academic or research work
Course syllabus:
- Module 1: Intro to Power BI Ecosystem
- Power BI – Intro, Why Power BI,
- Power BI Installation and configuration
- Interface and options walkthrough
- Workflow – From data to visualizations
- Resources for additional Learning
- Module 2: Power BI Complete Introduction
- Power BI Installation and configuration
- Interface and options walkthrough
- Workflow – From data to visualizations
- Flow of Work in Power BI/Power BI Architecture
- Power BI Desktop Installation and Hands on practice
- Module 3: Refining and Connecting Data: (Data import, Azure DB, DAX, etc.)
-
- Power BI – Frontend and Backend Components
- Types of Data connectors in Power BI
- Storage & Connection modes – Where is the Data?
- Intro to Power Query Editor – Tools and Basic Table Transformations
- Data Profiling Tools – Data Validation in Power Query Editor
- Text, Numerical and Date & Time Transformation Tools
- Index & Conditional Columns
- Pivoting/Un pivoting and Merging & Appending Tables
- Append Multiple files in a Folder
- Query Refresh Options
- Power Query – Data Transformation/Loading Best Practices
- Module 4: Data Modeling – Creating Meaningful Connections
- Data Model View – Walkthrough
- Data & Table Normalization
- Fact & Dimension Tables – PK and FK
- Relating Tables – Managing and Editing Relations
- Star & Snowflake Schema
- Cardinality – 1 to 1, 1 to *, * to 1 and * to *
- Connecting Multiple Fact tables
- Filter Context & Filter Flow – Bidirectional Filters
- Data Hierarchies
- Data Modeling Best Practices
- Module 5: Data Analysis Expressions (DAX) – Calculated Columns & Measures
-
- Understanding Calculated Columns & Measures
- Measure Calculation – Backend Logic
- Effect of Filter Context on Measures
- DAX General Syntax, Operators & Functions
- Math & Stat Functions – SUM, AVERAGE, etc.
- Counting/Aggregating Functions – COUNT, DISTINCTCOUNT, etc.
- Logical Functions – IF, SWITCH, etc.
- Text Functions – LEN, SEARCH, etc.
- Date & Time Functions – DATEDIFF, EOMONTH, etc.
- Other Miscellaneous Functions – RELATED, CALCULATE, etc.
- Iterator Functions – SUMX
- Time Intelligence – Date Based Comparisons
- DAX Best Practices
- Module 6: Data Visualization and Power BI Service
- Data Communication Planning – What are the end users’ needs?
- Dashboards Design Framework
- Power BI – Report View
- Basic Visuals – Cards, Charts
- Line Charts, Doughnut Charts
- Conditional Formatting – Tables & Matrix Visuals
- Top N Text cards
- Map Visuals
- Slicers and Filtering Options
- Drilling Up/Down & Drill Through Filters
- Report Interaction Controls
- Bookmarks
- Parameters – Numeric Range & Fields
- Custom Tool Tips
- App Source – Custom Visuals
- Managing Roles
- Mobile Layouts & responsive Views
- Power BI Service and Sharing
- Dashboards Development
- Data Gateways setups
- Row Level Security(RLS)
- Dashboard Access Management Eco system to end user.
- Module 7: AI in Visualizations and Report Optimization
- AI Features:
- Anomaly Detection
- Smart Narratives
- Q&A Visual & Training
- Decomposition Tree
- Key Influencer
- Power BI Optimize Ribbon Tools:
- Pause/Refresh Visuals
- Optimization Presets
- Apply All Slicers
- Performance Analyzer
- Module 8: Azure Synapse Data Reporting
- On-Premise SQL Server Data Ingestion – Azure Data Factory
- Azure cloud data transformation – Azure Data Lake Gen2, Data bricks
- Data Load – Azure Synapse Analytics
- Connecting Azure Synapse to Power BI for Report creation
- End-to-End Data refresh Pipeline