Deploy and Maintain Power BI Assets and Capstone project

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

Instructor: Microsoft

51,209 already enrolled

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.

Skills you'll gain

Tools you'll learn

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

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

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

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 videos8 readings3 assignments

12 videosTotal 61 minutes

Course introduction8 minutes
How data flows through business6 minutes
Data-driven enterprise5 minutes
The important role of a data analyst4 minutes
SQL in enterprise4 minutes
Connecting to a SQL database6 minutes
What are dynamic reports?4 minutes
Creating a dynamic report4 minutes
Creating a multi-value dynamic report4 minutes
What-if parameters5 minutes
Vignette: The world of data5 minutes
Module summary: Power BI in enterprise6 minutes

8 readingsTotal 85 minutes

Course syllabus10 minutes
Setting up your Power BI environment20 minutes
Setting up Power BI Service20 minutes
New name for Power BI datasets10 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

Module quiz: Power BI in enterprise30 minutes
Knowledge check: Data in enterprise 15 minutes
Knowledge check: SQL data sources 15 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?6 minutes
Creating a workspace3 minutes
Assign workspace roles5 minutes
Creating workspace apps5 minutes
Monitoring workspace usage5 minutes
Creating a usage report5 minutes
Datasets in Power BI Service5 minutes
Power BI gateways6 minutes
Configure a dataset refresh4 minutes
Endorsing datasets4 minutes
Electric car manufacturing3 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 130 minutes

Module quiz: Deploying assets50 minutes
Self-review: Creating a shared workspace 10 minutes
Knowledge check: Deploying assets 15 minutes
Knowledge check: Monitoring workspaces 15 minutes
Self-review: Configuring a dataset 10 minutes
Knowledge check: Datasets and gateways 15 minutes
Knowledge check: Maintaining workspaces and datasets 15 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 minutes
Sharing via links6 minutes
Data sensitivity labels5 minutes
Leaking of sensitive data4 minutes
Dataset permissions5 minutes
Configuring dataset permissions4 minutes
Sharing outside your organization4 minutes
What is row-level security?5 minutes
Configuring static row-level security4 minutes
Dynamic row-level security with DAX4 minutes
Subscribing to reports and dashboards4 minutes
Configuring data alerts6 minutes
How data alerts prevented trading losses4 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

Module quiz: Security and monitoring30 minutes
Self-review: Applying sensitivity labels 10 minutes
Knowledge check: Sharing information in Power BI 15 minutes
Knowledge check: Organizations and permissions 15 minutes
Knowledge check: Row-level security 15 minutes
Self-review: Configuring a data alert 10 minutes
Knowledge check: Subscriptions and alerts 15 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.