Course: PBIESS

Duration: 1 Day

Overview

During this 1-day course, you will learn how to develop and share reports and dashboards using Microsoft Power BI. During the course, students will use excel data sets as examples to explore various features and functionalities of MS Power BI and learn the underlying concepts that make Power BI Desktop such a powerful Business Intelligence tool. Upon completion of this course, students will gain a solid foundational and practical knowledge of the tool which will prepare you for more advanced courses.

Audience

This course is suitable for excel users who wants to implement BI to create reports and dashboard or SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

This Power Bi Beginner course is suitable for the people who have no or very little understanding of Microsoft Power BI tool. To get the most out of this course, some expertise in using Microsoft Excel is necessary especially with VLOOKUP and Pivot table. An understanding of key business constructs such as revenue, profitability, and financial reporting is desirable but not necessary.

Module List

* Module 1: Understanding Business Intelligence

* Module 2: Understanding Power BI

* Module 3: Getting Started with Power BI

* Module 4: Getting Data in Power BI

* Module 5: Data Transformation

* Module 6: Introduction to Power Query (M Formula Language)

* Module 7: Data Modelling

* Module 8: Introduction to DAX

* Module 9: Data Visualization

* Module 10: Creating Custom Visuals

* Module 11: Visual Interaction

* Module 12: Exploring Filters

* Module 13: Creating Custom Slicers

* Module 14: Exploring Power BI Desktop Features

* Module 15: Power Bi service Features

* Module 16: Dashboard

* Module 17: Natural Language Query

* Module 18: Power Bi Publisher for Microsoft Excel

* Module 19: Quick Insights

* Module 20: Sample Reports and Dashboard

* Module 21: The Power Bi Mobile App

Click here for the full 'Power BI Essentials' course outline