Microsoft Power BI and Power Platform for Productivity

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.