6 Educators providing Courses delivered Live Online

Microsoft Power BI Training Course Overview: The Microsoft Power BI Training course is designed to equip learners with the knowledge and skills to use Power BI effectively for data analysis and reporting. This course covers the core features of Power BI, from data import and transformation to the creation of reports and visualizations. Learners will explore how to analyse data, generate insights, and create dynamic dashboards for reporting purposes. Whether you are looking to improve your analytical skills or advance your career, this course provides the foundation needed to become proficient in using Power BI for various data analysis tasks. By the end of the course, learners will be able to handle large data sets, create compelling visual reports, and make data-driven decisions. Course Description: This comprehensive Microsoft Power BI course delves into the essential components of the Power BI platform. Learners will start by exploring how to import and work with data, before progressing to designing reports and visualizations. The course includes an in-depth look at the various types of visualizations available, enabling learners to display data in an intuitive, easy-to-understand format. Additionally, learners will explore the Power BI Web App to access and share their reports online. As they move through the course, participants will gain valuable skills in data transformation, reporting, and visualization, all of which are applicable to industries requiring data-driven decision-making. By completing this course, learners will have a solid understanding of Power BI and the ability to create impactful reports and dashboards for business or personal use. Microsoft Power BI Training Curriculum: Module 01: Getting Started Module 02: Working with Data Module 03: Working with Reports and Visualizations Module 04: A Closer Look at Visualizations Module 05: Introduction to the Power BI Web App (See full curriculum) Who is this course for? Individuals seeking to understand Power BI and data analysis. Professionals aiming to enhance their data reporting skills. Beginners with an interest in business intelligence and data analytics. Anyone looking to improve their ability to visualise data for better decision-making. Career Path: Data Analyst Business Intelligence Analyst Reporting Specialist Data Visualisation Specialist Business Analyst

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security