Overview
Class Central Tips
This program combines Microsoft Power BI for business intelligence and Microsoft Power Platform for business automation, providing essential skills for data-driven decision-making and building custom business software solutions with minimal coding skills.
In the Power BI portion of the program, you'll master business intelligence and learn the data analysis process. You'll discover how to extract, transform, and load (ETL) data from multiple sources, create data models, write DAX calculations, and optimize Power BI performance. You'll also learn to create compelling visualizations, design accessible dashboards, and perform advanced analytics for deeper insights using Power BI. Lastly, you’ll learn to use Copilot to improve your Power BI productivity.
Additionally, this program explores the full potential of Power Platform. Discover how to boost productivity by automating business processes with Power Automate, creating simple apps with Power Apps, and building chatbots with Power Virtual Agents. By connecting these tools with Microsoft Dataverse and Power BI, you'll gain a holistic understanding of the Power Platform ecosystem. By completing this specialization, you'll be equipped to leverage both Power BI for comprehensive business intelligence and Power Platform for streamlined business automation as well as how to analyze data effectively
Syllabus
Course 1: Data for Analysis with Microsoft Excel
- Offered by Microsoft. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how ... Enroll for free.
Course 2: Unlock the Power of Data with Power BI
- Offered by Microsoft. You’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus ... Enroll for free.
Course 3: Data Extract, Transform, and Load in Power BI
- Offered by Microsoft. In this course, you will learn the process of Extract, Transform and Load or ETL. You will identify how to collect ... Enroll for free.
Course 4: Modeling Data in Power BI
- Offered by Microsoft. In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model ... Enroll for free.
Course 5: Analysis and Visualization of Data with Power BI
- Offered by Microsoft. In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for ... Enroll for free.
Course 6: Creative Designing in Power BI
- Offered by Microsoft. This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate ... Enroll for free.
Course 7: Copilot for Power BI
- Offered by Microsoft. This course portrays how Copilot can be leveraged in conjunction with Power BI to streamline process and enhance work ... Enroll for free.
Course 8: Introduction to Microsoft Power Platform
- Offered by Microsoft. Welcome to course 1 on Microsoft Power Platform Fundamentals! This course provides an overview of modules within the ... Enroll for free.
Course 9: Use Power Platform for Custom & Automated Solutions
- Offered by Microsoft. This course will teach you the Microsoft Power Platform to create applications that can solve real-world business ... Enroll for free.
Course 10: Power Virtual Agents
- Offered by Microsoft. This course will teach you the ease of creating chatbots with Power Virtual Agents. This no-code platform will allow ... Enroll for free.
- Offered by Microsoft. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how ... Enroll for free.
Course 2: Unlock the Power of Data with Power BI
- Offered by Microsoft. You’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus ... Enroll for free.
Course 3: Data Extract, Transform, and Load in Power BI
- Offered by Microsoft. In this course, you will learn the process of Extract, Transform and Load or ETL. You will identify how to collect ... Enroll for free.
Course 4: Modeling Data in Power BI
- Offered by Microsoft. In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model ... Enroll for free.
Course 5: Analysis and Visualization of Data with Power BI
- Offered by Microsoft. In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for ... Enroll for free.
Course 6: Creative Designing in Power BI
- Offered by Microsoft. This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate ... Enroll for free.
Course 7: Copilot for Power BI
- Offered by Microsoft. This course portrays how Copilot can be leveraged in conjunction with Power BI to streamline process and enhance work ... Enroll for free.
Course 8: Introduction to Microsoft Power Platform
- Offered by Microsoft. Welcome to course 1 on Microsoft Power Platform Fundamentals! This course provides an overview of modules within the ... Enroll for free.
Course 9: Use Power Platform for Custom & Automated Solutions
- Offered by Microsoft. This course will teach you the Microsoft Power Platform to create applications that can solve real-world business ... Enroll for free.
Course 10: Power Virtual Agents
- Offered by Microsoft. This course will teach you the ease of creating chatbots with Power Virtual Agents. This no-code platform will allow ... Enroll for free.
Courses
-
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 will learn how to creatively design dashboards, reports and charts that are easier for the audience to use. You will learn how to create cohesive business intelligence reports and dashboards, as well as what common problems to avoid. The insights that you will gain will help you to tell compelling stories using specialist chart visualizations and visual elements such as videos, streaming data and QR Codes. After completing this course, you'll be able to: ● Create compelling and cohesive reports and dashboards ● Recognize common problems in design in Power BI Reports and Dashboards ● Produce audience focused reports and dashboards ● Work in detail with specialist chart visualizations ● Use visualizations in reports ● Add elements such as videos, streaming data and QR codes to dashboards 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.
-
Welcome to course 1 on Microsoft Power Platform Fundamentals! This course provides an overview of modules within the Power Platform ecosystem. You will gain a solid understanding of its capabilities & potential for building powerful business solutions, get insights into data connectors & their role in integrating, interacting with different data sources. You will delve into Microsoft Dataverse, a secure scalable data platform at the core of Power Platform, understand how it allows you to define relationships between tables & entities, enabling efficient management & organization of your data, learn about its environments, which play a crucial role in separating & managing data & apps within Power Platform. You will also discover how Power Apps empowers you to create applications tailored to your business needs, enhancing productivity & efficiency. Real-world examples, such as the Heathrow Airport customer case study, provide practical insights into successful Power Platform implementations. Finally, you will also be introduced to the Exam PL-900. By the end of the course, you will be able to: 1. Describe the components of Microsoft Power Platform, the business value for customers, & security of the technology. 2. Define the basic concepts of the Dataverse and ways you can connect and customize data connections to Microsoft Power Platform applications. 3. Recognize the value and capabilities of Power Apps & ways other organizations have leveraged this technology to build simple applications for their business.
-
This course will teach you the Microsoft Power Platform to create applications that can solve real-world business problems. Starting with Power Apps, you'll learn to build simple canvas applications with user-friendly interface and customization options even if you don’t have a programming background. As the course progresses, you'll explore model-driven apps, where you can enhance and streamline the app development without the need for coding. You'll then learn to use PowerApps Portals, which will allow users external to your organizations to login and interact with your application. The course will also cover using Microsoft Power Automate to automate common business workflows and reduce the time spent on repetitive, time-consuming tasks. By the end of this course, you'll be equipped with the skill to create applications that can automate business processes and improve business efficiency.
-
This course portrays how Copilot can be leveraged in conjunction with Power BI to streamline process and enhance work outputs. It provides a general overview as well as detailed use case demonstrations for Power BI practitioners who want to augment their skills with Generative AI.
-
In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for building reports and dashboards. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI. You will explore how to get a statistical summary for your data and how to create and export reports in Power BI. You will also perform advanced analytics in Power BI to get deeper and more meaningful data insights. After completing this course, you'll be able to: ● Recognize the different types of visualizations in Power BI ● Add visualizations to reports and dashboards ● Apply formatting choices to visuals ● Add useful navigation techniques to the Power BI report ● Design accessible reports and dashboards ● Use visualizations to perform data analysis
-
In this course, you will learn the process of Extract, Transform and Load or ETL. You will identify how to collect data from and configure multiple sources in Power BI and prepare and clean data using Power Query. You’ll also have the opportunity to inspect and analyze ingested data to ensure data integrity. After completing this course, you’ll be able to: • Identify, explain and configure multiple data sources in Power BI • Clean and transform data using Power Query • Inspect and analyze ingested data to ensure data integrity
-
In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis. Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel.
-
In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas. You'll explore the basics of DAX, Power BI's expression language, and add calculations to your model to create elements and analysis in Power BI. You'll discover how to configure the model to support Power BI features for insightful visualizations, analysis, and optimization. After completing this course you'll be able to: ● Create and maintain relationships in a data model. ● Form a model using a Star Schema ● Write calculations DAX to create elements and analysis in Power BI ● Create calculated columns and measures in a model ● Perform useful time intelligence calculations in DAX ● Optimize performance in a Power BI model
-
This course will teach you the ease of creating chatbots with Power Virtual Agents. This no-code platform will allow you to build intelligent bots that can talk to your customers and employees and enhance their overall user experience. You'll learn how to define conversation topics, design interactive dialogues, and publish your chatbot across various platforms like Microsoft Teams, Facebook, and etc. The course concludes by demonstrating how to analyze your chatbot's performance, allowing you to continuously refine and improve its effectiveness.
-
You’ll learn about the role of a data analyst and the main stages involved in the data analysis process with a focus on applying them using Microsoft Power BI. After completing this course, you’ll be able to: • Describe how data is produced and gathered in businesses and organizations. • Outline the role of data in creating data-driven decisions and successful business outcomes. • Classify key stages in the data analysis process. • Recognize the skills needed by a Power BI analyst and the tools they use. • List the tasks performed by a Power BI Data Analyst. • Recognize the components of Power BI.
Taught by
Microsoft