৳
৳
This course includes
- 15 Hours
- 10 lectures
- Advance Level
- Certificate of Completion
What you'll learn:
- 1. Understand the role of data analytics in business decision-making
- 2. Introduction to Power BI: Components, Architecture, Workflow
- 3. Connect Power BI to multiple data sources (Text/CSV, Excel, Folder, Web, Google Sheet, PDF, SQL, etc)
- 4. Use Power Query to clean, reshape, and transform data
- 5. AI-assisted generation of M Code in Power Query
- 6. Build efficient Data Models and relationships between datasets (Snowflake, Star Schema, Fact/Dim concepts)
- 7. Apply DAX formulas to create Measures for data analysis
- 8. DAX for Calculated Columns and Tables
- 9. AI-assisted DAX formula generation
- 10. Time Intelligence (YTD, QTD, YoY, Date Table Creation)
- 11. Row-Level Security (Static & Dynamic)
- 12. Apply performance optimization techniques for Data Model and DAX
- 13. Design interactive dashboards for professional reporting
- 14. Integrate AI visuals like Smart Narrative, Key Influencers, and Q&A for deeper insights
- 15. AI-assisted color themes and dashboard design enhancement
- 16. Publish, share, and collaborate reports in Power BI Service
- 17. End-to-end Project (Real-life scenario)
- 18. PL-300 exam overview, skills measured, preparation strategy & practice guidance
Course content
10 lectures
15 Hours
Project 1: Superstore Data
Project 2: Sales Data
Project 3: HR Data
Project 4: Loan Data
Project 5: Deposit Data
Requirements
Must have the basic knowledge on data related works
Personal Computer
Internet
Description
The objective of this course is to Provid
-Hands-on experience in cleaning, modelling, analysing, and visualizing data using Power BI & AI-assisted tools
-Complete understanding of PL-300 exam structure, question patterns, and hands-on skills required to pass