This plan combines Microsoft Power BI for business intelligence and Microsoft Power Platform for business automation.
Provides essential skills for data-driven decision-making
Build custom business software solutions with minimal coding skills
In the program’s Power BI cluster
Master business intelligence and learn the data analysis process.
Discover how to extract, transform, and load (ETL) data from a variety of sources
Create data models
Write calculations in DAX
Optimize Power BI performance
Create interesting visions
Design accessible dashboards
Perform advanced analytics for deep insights using Power BI
Learn to use Copilot to upgrade your Power BI productivity
Additionally, this program explores the full potential of Power Platform
Discover how to increase productivity by automating business processes with Power Automate
Create simple apps with Power Apps
Building chatbots with Power Virtual Agents
Connecting these tools with Microsoft Dataverse and Power BI
Upon completion of this specialization
You can leverage Power BI for comprehensive business intelligence
Power Platform for seamless business automation
Analyze data effectively
Hands-on Learning Project
During the program
Learners will work on a variety of practical projects that simulate real-life business scenarios.
These projects will range from data analysis and visualization tasks in Power BI to process automation and app development in Power Platform, including:
Data preparation and analysis in Excel
Configuring and cleaning data from various sources using Power Query
Creating a data model and writing calculations in DAX
Design and layout of interactive reports and illustrations in Power BI
Developing simple apps in Power Apps and connecting them to Microsoft Dataverse
Automate a business process with Power Automate
Building a functional chatbot with Power Virtual Agents
Details of the courses that make up the specialization
Data for analysis using Microsoft Excel
Course 1 • 19 hours
Course Details
What you’ll learn
Create data in Microsoft Excel and prepare it for data analysis.
Use common formulas and functions in a worksheet.
Prepare Excel data for analysis in Power BI using functions.
Skills you will acquire
Category: Data Platform
Category: Microsoft Power Platform
Category: Microsoft Datawars
Unlock the power of data with Power BI
Course 2 • 14 hours
Course Details
What you’ll learn
How to identify and use the key components of data analysis in Microsoft Power BI.
Understand the skills, tasks, and tools of a data analyst in Power BI.
Describe the different steps in the data analysis process that lead to data-based decisions.
Skills you will acquire
Category: Report Building
Category: Data Analysis
Category: Data Presentation
Category: Power BI
Category: Creating Dashboards
Import, transform, and upload data in Power BI
Course 3 • 20 hours
Course Details
What you’ll learn
How to define a data source, explain and configure storage modes in Power BI.
How to prepare for data modeling by cleaning and transforming data.
How to use profiling tools to identify anomalies in data.
How to handle queries and data flows and use the advanced editor to modify code.
Skills you will acquire
Category: Data Analysis
Category: Data-driven decision making
Category: Power BI
Data models in Power BI
Course 4 • 23 hours
Course Details
What you’ll learn
How to create a model using a star pattern.
How to write DAX calculations to create components and analyses in Power BI.
How to optimize performance in a Power BI model.
Analyze and visualize data with Power BI
Course 5 • 29 hours
Course Details
What you’ll learn
How to add forecasts to reports and dashboards.
How to design accessible reports and dashboards.
How to use predictions to perform data analysis.
Skills you will acquire
Category: Data Analysis
Category: Data Presentation
Category: Power BI
Category: Report Design
Category: Dashboard Design
Creative design in Power BI
Course 6 • 20 hours • 4.5 (188 ratings)
Course Details
What you’ll learn
How to create interesting and well-designed reports and dashboards.
How to work with special graphic projections in detail.
How to add elements like videos, live data, and QR codes to dashboards.
Skills you will acquire
Category: Data Analysis
Category: Power BI
Copilot for Power BI
Course 7 • 1 hour
Course Details
What you’ll learn
This course shows how to use Copilot together with Power BI to streamline processes and increase work productivity.
It provides an overview as well as detailed usage demonstrations for Power BI users interested in upgrading their skills with generative AI.
Skills you will acquire
Category: Virtual Power Agents
Category: Chatbot
Introduction to Microsoft Power Platform
Course 8 • 3 hours • 4.7 (37 ratings)
Course Details
What you’ll learn
Describe the components of the Microsoft Power Platform, the business value for customers, and the security of the technology.
Define the basic terms of DataWare and what methods can be used to connect and tune data connections to Microsoft Power Platform applications.
Discover how Power Zero allows you to create applications tailored to your business needs, improving productivity and efficiency.
Identify the value and capabilities of Power Zero and how organizations are leveraging this technology to build simple applications for their business.
Skills you will acquire
Category: Microsoft Excel
Category: Data Analysis
Category: Excel formulas and functions
Category: Data Preparation
Use the Power platform for customized and automated solutions
Course 9 • 9 hours • 3.6 (16 ratings)
Course Details
What you’ll learn
Build and customize dynamic canvas apps to address specific business process challenges.
Design model-driven applications using component-based architecture.
Configure and accelerate PowerApps portals for external users.
Develop and implement automated workflows for applications using Microsoft Power Automate.
Skills you will acquire
Category: Power Apps Portals
Category: Microsoft Power Automate/Flow
Power Virtual Agents
Course 10 • 4 hours
Course Details
What you’ll learn
Explain the value and capabilities of Power Virtual Agents for building chatbot solutions.
Design and deploy chatbots without code using Power Virtual Agents.
