70-461, 761: Querying Microsoft SQL Server with Transact-SQL Course Syllabus

A comprehensive, hands-on course designed to take beginners through the core components of Power BI, from data connectivity to advanced reporting and exam preparation. With a total time commitment of approximately 6 weeks, this course blends theoretical knowledge with practical exercises using real-world datasets. Each module builds on the previous one, culminating in a final project that demonstrates mastery of Power BI skills relevant to data analysis roles and the Microsoft 70-778 certification.

Module 1: Introduction to Power BI

Estimated time: 2 hours

• Understand the Power BI ecosystem (Desktop, Service, and Mobile)
• Explore key features and real-world applications
• Learn the business value of data visualization

Module 2: Data Sources and Data Loading

Estimated time: 10 hours

• Connect Power BI to sources like Excel, SQL, Web, and cloud services
• Distinguish between Import and DirectQuery modes
• Handle data refresh and connection settings

Module 3: Data Transformation with Power Query Editor

Estimated time: 10 hours

• Clean, filter, and shape data using Power Query
• Perform transformations like pivoting, merging, and splitting
• Use the M language for custom data manipulation

Module 4: Data Modeling and Relationships

Estimated time: 10 hours

• Define relationships between tables and build a logical model
• Create hierarchies and understand cardinality
• Apply star and snowflake schema concepts

Module 5: Writing DAX for Calculations and Measures

Estimated time: 10 hours

• Write calculated columns and measures using DAX
• Use functions like CALCULATE, FILTER, and SUMX
• Apply advanced DAX for time intelligence and aggregation

Module 6: Building Powerful Visualizations

Estimated time: 10 hours

• Design reports using charts, KPIs, maps, and tables
• Customize visuals with conditional formatting and themes
• Use slicers and tooltips to enhance interactivity

Module 7: Advanced Reporting Techniques

Estimated time: 10 hours

• Implement drill-through, bookmarks, and report navigation
• Use Q&A visuals and report-level filters
• Optimize for user experience and storytelling

Module 8: Using the Power BI Service

Estimated time: 10 hours

• Publish reports and create dashboards in Power BI Service
• Manage workspaces and collaborate with teams
• Automate refresh and monitor report usage metrics

Module 9: Row-Level Security and Data Governance

Estimated time: 2 hours

• Apply row-level security (RLS) to control data access
• Manage user roles and permissions
• Understand compliance and governance best practices

Module 10: Exam Preparation for Microsoft 70-778

Estimated time: 2 hours

• Review key exam concepts and domains
• Practice with sample questions and mock tests
• Learn strategies for managing time and analyzing questions

Prerequisites

• Basic understanding of data concepts and databases
• Familiarity with Microsoft Office applications
• No prior Power BI experience required

What You'll Be Able to Do After

• Master data visualization techniques using Power BI
• Understand how to model and transform data effectively
• Create dynamic dashboards and interactive reports
• Gain familiarity with DAX (Data Analysis Expressions) for calculations
• Prepare for the Microsoft 70-778 certification exam