Deploy and Maintain Power BI Assets and Capstone project

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

Instructor: Microsoft

Access provided by Interbank

46,499 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

297 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

90%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

297 reviews

Beginner level

Recommended experience

Flexible schedule

3 weeks at 10 hours a week

Learn at your own pace

90%

Most learners liked this course

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 videos11 readings3 assignments2 discussion prompts

12 videos Total 61 minutes

Course introduction 8 minutes
How data flows through business 6 minutes
Data-driven enterprise 5 minutes
The important role of a data analyst 4 minutes
SQL in enterprise 4 minutes
Connecting to a SQL database 6 minutes
What are dynamic reports? 4 minutes
Creating a dynamic report 4 minutes
Creating a multi-value dynamic report 4 minutes
What-if parameters 5 minutes
Vignette: The world of data 5 minutes
Module summary: Power BI in enterprise 6 minutes

11 readings Total 95 minutes

Course syllabus 10 minutes
How to be successful in this course 10 minutes
How to open an image in a new tab 10 minutes
Setting up your Power BI environment 10 minutes
Setting up Power BI Service 10 minutes
New name for Power BI datasets 10 minutes
How to locate your downloaded files 10 minutes
Additional resources: Key concepts 5 minutes
Additional resources: Data in enterprise 5 minutes
SQL cheatsheet 10 minutes
Additional resources: SQL data sources 5 minutes

3 assignments Total 60 minutes

Module quiz: Power BI in enterprise 30 minutes
Knowledge check: Data in enterprise 15 minutes
Knowledge check: SQL data sources 15 minutes

2 discussion prompts Total 20 minutes

Discussion prompt: What do you hope to learn 10 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 videos Total 78 minutes

What is a workspace? 6 minutes
Creating a workspace 3 minutes
Assign workspace roles 5 minutes
Creating workspace apps 5 minutes
Monitoring workspace usage 5 minutes
Creating a usage report 5 minutes
Datasets in Power BI Service 5 minutes
Power BI gateways 6 minutes
Configure a dataset refresh 4 minutes
Endorsing datasets 4 minutes
Electric car manufacturing 3 minutes
Development lifecycles 4 minutes
Deployment pipeline 3 minutes
Impact analysis and lineage 5 minutes
Improving performance with caching 4 minutes
Troubleshoot service connectivity 5 minutes
Module summary: Deploying assets 6 minutes

17 readings Total 190 minutes

Workspace settings 10 minutes
Roles cheatsheet 10 minutes
Exercise: Creating a shared workspace 30 minutes
Exemplar: Creating a shared workspace 10 minutes
Managing audiences in workspace apps 10 minutes
Additional resources: Deploying assets 5 minutes
Metric report cheatsheet 10 minutes
Usage metrics report credentials 10 minutes
Additional resources: Monitoring workspaces 5 minutes
Installing a personal gateway 10 minutes
Promote versus certify 10 minutes
Exercise: Configuring a dataset 30 minutes
Exemplar: Configuring a dataset 10 minutes
Additional resources: Datasets and gateways 5 minutes
Deployment pipelines best practices 10 minutes
Troubleshooting refresh scenarios 10 minutes
Additional resources: Maintaining workspaces and datasets 5 minutes

7 assignments Total 110 minutes

Module quiz: Deploying assets 30 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 videos Total 66 minutes

Safely sharing information 5 minutes
Sharing via links 6 minutes
Data sensitivity labels 5 minutes
Leaking of sensitive data 4 minutes
Dataset permissions 5 minutes
Configuring dataset permissions 4 minutes
Sharing outside your organization 4 minutes
What is row-level security? 5 minutes
Configuring static row-level security 4 minutes
Dynamic row-level security with DAX 4 minutes
Subscribing to reports and dashboards 4 minutes
Configuring data alerts 6 minutes
How data alerts prevented trading losses 4 minutes
Module summary: Security and monitoring 6 minutes

10 readings Total 125 minutes

Exercise: Applying sensitivity labels 30 minutes
Exemplar: Applying sensitivity labels 10 minutes
Additional resources: Sharing information in Power BI 5 minutes
Permissions cheatsheet 10 minutes
Additional resources: Organizations and permissions 10 minutes
Static versus dynamic row-level security 10 minutes
Additional resources: Row-level security 5 minutes
Exercise: Configuring a data alert 30 minutes
Exemplar: Configuring a data alert 10 minutes
Additional resources: Subscriptions and alerts 5 minutes

7 assignments Total 110 minutes

Module quiz: Security and monitoring 30 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 prompts Total 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.