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
Show info about module content
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
8 readings•Total 85 minutes
Course syllabus•10 minutes
Setting up your Power BI environment•20 minutes
Setting up Power BI Service•20 minutes
New name for Power BI datasets•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
Deploying assets
Module 2•7 hours to complete
Module details
In this module, you will deploy Power BI assets and explore deployment pipelines and their importance in data integrity
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
Capstone project
Module 4•9 hours to complete
Module details
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.
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more.
In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
● If you want to switch or start a career in the field of data analytics.
● If you are interested in the field of data analytics, just beginning to work with business intelligence and data analysis solutions and services, or new to Microsoft Power BI.
What background knowledge is necessary?
You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.
How long does it take to complete the Professional Certificate?
How long does it take to complete the Professional Certificate?
What is the main benefit of a Professional Certificate?
Whether you’re looking to start a new career or change your current one, Professional Certificates help you become job ready. Apply your new skills on hands-on projects that showcase your expertise to potential employers and earn a career credential to kickstart your new career.
What will I be able to do upon completing the Professional Certificate?
Once you have completed this Professional Certificate, you’ll have built a foundational knowledge of the key concepts and tools in Power BI and how they apply to a business environment including:
• The ability to implement best practices when conducting Data Analysis.
• The skills to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.
• The ability to provide valuable data insights that help to inform business decisions.
What does a Power BI analyst do?
Power BI Data Analysts design, develop, and deploy business analytics dashboards using Microsoft Power BI. Data analysts are essential in helping organizations gain valuable insights into the expanse of data that they have, and they work closely with others in the organization to help reveal valuable information.
Data Analyst, Business Intelligence Analyst and Power BI Analyst: What’s the Difference?
Data analysts and business intelligence analysts both help drive data-driven decision-making in their organizations. Data analysts tend to work more closely with the data itself, while business intelligence analysts tend to be more involved in using the results of data analysis to address business needs and recommend solutions. The Power BI data analyst is a combination of both of these roles. They work closely with business stakeholders to identify business requirements and collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI. These are all highly sort after roles.
What jobs can I get with Power BI data analytics skills?
Prepare for a career as a data analyst using Power BI. The Power BI skills you learn in this program prepare you for an entry-level role as a data analyst. An entry-level role as a data analyst is a great starting point and can be the first step towards building a career as a business intelligence analyst, data scientist or data engineer.
Will I be able to complete this course online?
This course is completely online. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.
Do I need to take the courses in specific order?
We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses. The final course contains a practice exam that assesses your knowledge of the content covered in the previous courses. As such, it makes the most sense to take the courses in the order they are presented.
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 Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, 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.