When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Power BI: Data Secure, Governance, and Workspace Management

This course is part of Exam Prep PL-300: Microsoft Power BI Data Analyst Associate Specialization

Instructor: Whizlabs Instructor

Included with

Learn more

2 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

2 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

7 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

91%

of learners achieved a positive career outcome

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Exam Prep PL-300: Microsoft Power BI Data Analyst Associate Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 2 modules in this course

This course is designed to provide a comprehensive foundation in Power Query and Power BI, equipping learners with the skills to transform, analyze, and visualize data efficiently. Participants will begin by exploring Power Query text and number functions, understanding key transformations such as formatting, merging, extracting, and statistical operations to structure raw data effectively.

The course progresses to advanced data modeling in Power BI, covering essential techniques like fact and dimension tables, index columns, and custom column creation to optimize data relationships and queries. Learners will gain expertise in conditional column logic, row-level security, and workspace role management, ensuring controlled access and governance in Power BI environments. Additionally, this course covers dashboard and report creation, enabling participants to craft insightful visualizations with interactive elements. Features like Quick Insights, Semantic Model Modes, and configuration settings are explored to enhance analytical capabilities. This course is structured into multiple modules, each featuring lessons and video lectures that provide both theoretical understanding and hands-on practice. Participants will engage with approximately 3:00–4:00 hours of instructional content, reinforcing learning through graded and ungraded assignments, ensuring real-world applicability. Module 1 - Power BI: Power Query Editor with Functions and Columns Module 2 - Power BI: Governance and Semantic Model Management Whether you're preparing for Power BI certification or seeking to optimize business intelligence workflows, this course equips you with the essential skills to master Power Query and Power BI for effective data analysis and visualization. The course is for Power BI Security Analysts, Power BI Data Associates, Data Security Associates and Workspace Managers

Module details

This module provides a practical foundation in Power Query transformations and column management, empowering learners to clean, shape, and enrich data effectively before visualization. Participants will explore essential text functions such as formatting, merging, and extracting, as well as number functions for standard, scientific, and statistical operations. The module also introduces custom and conditional columns, which allow for tailored logic to be applied directly in the data preparation layer. Additional techniques such as indexing and duplicating columns will help optimize data structure for downstream reporting. By the end of this module, learners will gain hands-on expertise in preparing high-quality, analysis-ready datasets that integrate seamlessly into Power BI reports.

What's included

11 videos2 readings2 assignments

11 videosTotal 57 minutes

Text Functions in Power Query (Format)5 minutes
Text Functions in Power Query (Merge Columns)2 minutes
Text Functions in Power Query (Extract)6 minutes
Number functions in Power Query (Standard)-edited9 minutes
Number functions in Power Query (Scientific)4 minutes
Number Functions in Power Query (Statistics)5 minutes
Custom Column in Power Query4 minutes
Conditional Column in PowerBI5 minutes
Index Columns in Power Query4 minutes
Duplicating Columns in Power Query4 minutes
Exam Tips8 minutes

2 readingsTotal 60 minutes

Welcome to Course30 minutes
Power BI: Power Query Editor with Functions and Columns - Overview30 minutes

2 assignmentsTotal 60 minutes

Advanced Data Transformation in Power Query - Practice Assignment30 minutes
Power BI: Power Query Editor with Functions and Columns - Graded Assignment30 minutes

This module equips learners with the knowledge and skills to build secure, structured, and insightful Power BI solutions. Starting with transforming semi-structured data into tables using Power Query, learners will create normalized data models with fact and dimension tables. The module then focuses on data governance, including configuring item-level access, workspace roles, row-level security, and sensitivity labels to ensure secure report sharing. Participants will learn to design impactful dashboards and reports, understand the difference between the two, and explore Power BI’s Quick Insights feature for automated analysis. Additionally, learners will explore semantic model modes and how to check and optimize them for performance. This comprehensive module concludes with exam tips and a course wrap-up to reinforce key concepts and best practices.

What's included

13 videos2 readings3 assignments1 discussion prompt

13 videosTotal 84 minutes

Convert semi-structured data to a table using PowerQuery7 minutes
Create fact tables and dimension tables in power bi8 minutes
Configure item-level access in Power BI6 minutes
Assign workspace roles and sensitivity labels7 minutes
Configure row-level security group membership7 minutes
Creating Dashboards in PowerBI6 minutes
Creating Reports in PowerBI6 minutes
Difference between Dashboard and a Report7 minutes
Quick Insights Feature in Power BI6 minutes
Semantic Model Modes in PowerBI10 minutes
Checking Semantic Model Mode in PowerBI3 minutes
Exam Tips7 minutes
Course Conclusion5 minutes

2 readingsTotal 50 minutes

Power BI: Governance and Semantic Model Management - Overview30 minutes
Best Practices and Key Takeaways20 minutes

3 assignmentsTotal 90 minutes

Advanced Reporting and Visual Design in Power BI - Practice Assignment30 minutes
Power BI: Insights and Semantic Models - Practice Assignment30 minutes
Power BI: Governance and Semantic Model Management - Graded Assignment30 minutes