- Level Foundation
- Duration 4 hours
- Course by Microsoft
-
Offered by
About
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.Modules
Welcome to the Course
1
Discussions
- Discussion prompt: What do you hope to learn
1
Videos
- Course introduction
8
Readings
- Course syllabus
- How to be successful in this course
- How to open an image in a new tab
- Setting up your Power BI environment
- Setting up Power BI Service
- New name for Power BI datasets
- How to locate your downloaded files
- Additional resources: Key concepts
Data in Enterprise
1
Assignment
- Knowledge check: Data in enterprise
3
Videos
- How data flows through business
- Data-driven enterprise
- The important role of a data analyst
1
Readings
- Additional resources: Data in enterprise
SQL data sources
2
Assignment
- Knowledge check: SQL data sources
- Module quiz: Power BI in enterprise
1
Discussions
- How can SQL enhance business insights?
8
Videos
- SQL in enterprise
- Connecting to a SQL database
- What are dynamic reports?
- Creating a dynamic report
- Creating a multi-value dynamic report
- What-if parameters
- Vignette: The world of data
- Module summary: Power BI in enterprise
2
Readings
- SQL cheatsheet
- Additional resources: SQL data sources
Creating workspaces
2
Assignment
- Self-review: Creating a shared workspace
- Knowledge check: Deploying assets
4
Videos
- What is a workspace?
- Creating a workspace
- Assign workspace roles
- Creating workspace apps
6
Readings
- Workspace settings
- Roles cheatsheet
- Exercise: Creating a shared workspace
- Exemplar: Creating a shared workspace
- Managing audiences in workspace apps
- Additional resources: Deploying assets
Monitoring workspaces
1
Assignment
- Knowledge check: Monitoring workspaces
2
Videos
- Monitoring workspace usage
- Creating a usage report
3
Readings
- Metric report cheatsheet
- Usage metrics report credentials
- Additional resources: Monitoring workspaces
Datasets and gateways
2
Assignment
- Self-review: Configuring a dataset
- Knowledge check: Datasets and gateways
5
Videos
- Datasets in Power BI Service
- Power BI gateways
- Configure a dataset refresh
- Endorsing datasets
- Electric car manufacturing
5
Readings
- Installing a personal gateway
- Promote versus certify
- Exercise: Configuring a dataset
- Exemplar: Configuring a dataset
- Additional resources: Datasets and gateways
Maintaining workspaces and datasets
2
Assignment
- Knowledge check: Maintaining workspaces and datasets
- Module quiz: Deploying assets
6
Videos
- Development lifecycles
- Deployment pipeline
- Impact analysis and lineage
- Improving performance with caching
- Troubleshoot service connectivity
- Module summary: Deploying assets
3
Readings
- Deployment pipelines best practices
- Troubleshooting refresh scenarios
- Additional resources: Maintaining workspaces and datasets
Sharing information in Power BI
2
Assignment
- Self-review: Applying sensitivity labels
- Knowledge check: Sharing information in Power BI
4
Videos
- Safely sharing information
- Sharing via links
- Data sensitivity labels
- Leaking of sensitive data
3
Readings
- Exercise: Applying sensitivity labels
- Exemplar: Applying sensitivity labels
- Additional resources: Sharing information in Power BI
Organizations and permissions
1
Assignment
- Knowledge check: Organizations and permissions
1
Discussions
- How would dataset permissions impact different business departments?
3
Videos
- Dataset permissions
- Configuring dataset permissions
- Sharing outside your organization
2
Readings
- Permissions cheatsheet
- Additional resources: Organizations and permissions
Row-level security
1
Assignment
- Knowledge check: Row-level security
3
Videos
- What is row-level security?
- Configuring static row-level security
- Dynamic row-level security with DAX
2
Readings
- Static versus dynamic row-level security
- Additional resources: Row-level security
Subscriptions and alerts
3
Assignment
- Self-review: Configuring a data alert
- Knowledge check: Subscriptions and alerts
- Module quiz: Security and monitoring
1
Discussions
- How would security impact different stakeholders?
4
Videos
- Subscribing to reports and dashboards
- Configuring data alerts
- How data alerts prevented trading losses
- Module summary: Security and monitoring
3
Readings
- Exercise: Configuring a data alert
- Exemplar: Configuring a data alert
- Additional resources: Subscriptions and alerts
Setting up the Capstone project
3
Assignment
- Self-review: Prepare Sales Excel data
- Self-review: Configure data sources
- Self-review: Design and develop the data model
1
Videos
- Course recap and Capstone introduction
5
Readings
- About the final project and assessment
- Exercise: Prepare Sales Excel data
- Exercise: Configure data sources
- Exercise: Design and develop the data model
- Capstone project progress checklist
Finishing the Capstone project
6
Assignment
- Self-review: Configure aggregations using DAX
- Self-review: Create a Sales report
- Self-review: Create a Profit report
- Self-review: Create an executive dashboard
- Self-review: Configure alerts and subscriptions
- Course quiz: Deploy and maintain Power BI assets
2
Videos
- Capstone check-in
- Capstone project review
8
Readings
- Exercise: Configure aggregations using DAX
- Exercise: Create a Sales report
- Exercise: Create a Profit report
- Exercise: Create an executive dashboard
- Exercise: Configure alerts and subscriptions
- Exemplar: Capstone project - Part 1
- Exemplar: Capstone project - Part 2
- Exemplar: Capstone project - Part 3
Wrap-up: Deploy and maintain Power BI assets and Capstone project
1
Discussions
- Reflect on learning
1
Videos
- Congratulations
1
Readings
- Next steps
Auto Summary
Embark on a dynamic journey into data analysis with the "Deploy and Maintain Power BI Assets and Capstone Project" course. This foundational course is an integral part of the Microsoft Power BI Analyst Professional Certificate, tailored for those aspiring to excel in data science and AI using Power BI. Guided by expert instructors on Coursera, you will delve into deploying and maintaining Power BI assets through immersive, hands-on exercises. Learn to create, implement, and manage Power BI workspaces, while mastering security and monitoring practices to safeguard organizational data. Key skills you will acquire include: - Utilizing SQL for enterprise data analysis - Creating and publishing apps in Power BI - Auditing usage in reports and dashboards - Managing and refreshing datasets - Implementing dynamic reports - Establishing robust security measures and alerting - Setting up Row Level Security in Power BI models Culminate your learning experience with a comprehensive capstone project, designed to showcase your newly acquired skills and prepare you for the Microsoft PL-300 exam, leading to the Power BI Data Analyst certification. With a duration of 240 hours, this course offers a flexible learning path through Coursera's Starter subscription, making it accessible for beginners eager to build a strong foundation in data analysis. Perfect for aspiring data analysts, this course equips you with the essential tools and knowledge to launch or advance your career in the thriving field of data science. Join us and elevate your data analytical capabilities to new heights with Power BI!

Microsoft