Deploy and Maintain Power BI Assets and Capstone project

This course is part of Microsoft Power BI Data Analyst Professional Certificate

Instructor: Microsoft

What you'll learn

How to create and publish an app in Power BI.
How to implement dynamic reports in Power BI.
How to implement security measures and alerting in a Power BI report or dashboard.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

26 assignments

Taught in English

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

Learn more about Coursera for Business

Build your Data Analysis expertise

This course is part of the Microsoft Power BI Data Analyst Professional Certificate

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

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 from Microsoft

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI.

In this course, you’ll learn how to deploy and maintain assets in Power BI. Through hands-on exercises, you’ll explore the process of creating, implementing, and managing Power BI workspaces.You’ll also implement security and monitoring to protect data in organizations. At the end of the course, you will complete a capstone project to showcase all your new Power BI and data analytical skills. After completing this course, you'll be able to: ● Describe how SQL is used in enterprise data analysis. ● Create and publish an app in Power BI. ● Audit usage in Reports and Dashboard. ● Manage and refresh datasets. ● Implement dynamic reports in Power BI. ● Implement security measures and alerting in a Power BI report or dashboard. ● Establish Row Level Security in a Power BI model. This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.

In this module, you will gain a larger view of Power BI in enterprise scenarios and how deploying and maintaining assets plays an important role in data-driven businesses

What's included

12 videos11 readings3 assignments2 discussion prompts

12 videosTotal 60 minutes

Course introduction7 minutesPreview module
How data flows through business6 minutes
Data-driven enterprise5 minutes
The important role of a data analyst3 minutes
SQL in enterprise4 minutes
Connecting to a SQL database5 minutes
What are dynamic reports?3 minutes
Creating a dynamic report4 minutes
Creating a multi-value dynamic report3 minutes
What-if parameters5 minutes
Vignette: The world of data4 minutes
Module summary: Power BI in enterprise5 minutes

11 readingsTotal 95 minutes

Course syllabus10 minutes
How to be successful in this course10 minutes
How to open an image in a new tab10 minutes
Setting up your Power BI environment10 minutes
Setting up Power BI Service10 minutes
New name for Power BI datasets10 minutes
How to locate your downloaded files10 minutes
Additional resources: Key concepts5 minutes
Additional resources: Data in enterprise5 minutes
SQL cheatsheet10 minutes
Additional resources: SQL data sources5 minutes

3 assignmentsTotal 60 minutes

Knowledge check: Data in enterprise15 minutes
Knowledge check: SQL data sources15 minutes
Module quiz: Power BI in enterprise30 minutes

2 discussion promptsTotal 20 minutes

Discussion prompt: What do you hope to learn10 minutes
How can SQL enhance business insights?10 minutes

In this module, you will deploy Power BI assets and explore deployment pipelines and their importance in data integrity

What's included

17 videos17 readings7 assignments

17 videosTotal 78 minutes

What is a workspace?5 minutesPreview module
Creating a workspace3 minutes
Assign workspace roles4 minutes
Creating workspace apps5 minutes
Monitoring workspace usage4 minutes
Creating a usage report5 minutes
Datasets in Power BI Service4 minutes
Power BI gateways5 minutes
Configure a dataset refresh4 minutes
Endorsing datasets3 minutes
Electric car manufacturing2 minutes
Development lifecycles4 minutes
Deployment pipeline3 minutes
Impact analysis and lineage5 minutes
Improving performance with caching4 minutes
Troubleshoot service connectivity5 minutes
Module summary: Deploying assets6 minutes

17 readingsTotal 190 minutes

Workspace settings10 minutes
Roles cheatsheet10 minutes
Exercise: Creating a shared workspace30 minutes
Exemplar: Creating a shared workspace10 minutes
Managing audiences in workspace apps10 minutes
Additional resources: Deploying assets5 minutes
Metric report cheatsheet10 minutes
Usage metrics report credentials10 minutes
Additional resources: Monitoring workspaces5 minutes
Installing a personal gateway10 minutes
Promote versus certify10 minutes
Exercise: Configuring a dataset30 minutes
Exemplar: Configuring a dataset10 minutes
Additional resources: Datasets and gateways5 minutes
Deployment pipelines best practices10 minutes
Troubleshooting refresh scenarios10 minutes
Additional resources: Maintaining workspaces and datasets5 minutes

7 assignmentsTotal 110 minutes

Self-review: Creating a shared workspace10 minutes
Knowledge check: Deploying assets15 minutes
Knowledge check: Monitoring workspaces15 minutes
Self-review: Configuring a dataset10 minutes
Knowledge check: Datasets and gateways15 minutes
Knowledge check: Maintaining workspaces and datasets15 minutes
Module quiz: Deploying assets30 minutes

In this module, you will audit, secure and monitor Power BI assets

What's included

14 videos10 readings7 assignments2 discussion prompts

14 videosTotal 66 minutes

Safely sharing information5 minutesPreview module
Sharing via links6 minutes
Data sensitivity labels4 minutes
Leaking of sensitive data3 minutes
Dataset permissions4 minutes
Configuring dataset permissions4 minutes
Sharing outside your organization3 minutes
What is row-level security?4 minutes
Configuring static row-level security3 minutes
Dynamic row-level security with DAX3 minutes
Subscribing to reports and dashboards4 minutes
Configuring data alerts6 minutes
How data alerts prevented trading losses3 minutes
Module summary: Security and monitoring6 minutes

10 readingsTotal 125 minutes

Exercise: Applying sensitivity labels30 minutes
Exemplar: Applying sensitivity labels10 minutes
Additional resources: Sharing information in Power BI5 minutes
Permissions cheatsheet10 minutes
Additional resources: Organizations and permissions10 minutes
Static versus dynamic row-level security10 minutes
Additional resources: Row-level security5 minutes
Exercise: Configuring a data alert30 minutes
Exemplar: Configuring a data alert10 minutes
Additional resources: Subscriptions and alerts5 minutes

7 assignmentsTotal 110 minutes

Self-review: Applying sensitivity labels10 minutes
Knowledge check: Sharing information in Power BI15 minutes
Knowledge check: Organizations and permissions15 minutes
Knowledge check: Row-level security15 minutes
Self-review: Configuring a data alert10 minutes
Knowledge check: Subscriptions and alerts15 minutes
Module quiz: Security and monitoring30 minutes

2 discussion promptsTotal 20 minutes

How would dataset permissions impact different business departments?10 minutes
How would security impact different stakeholders?10 minutes

In this module, you will be assessed on the key skills covered throughout the courses. The module contains the capstone project which encapsulates the learning into a practical whole.