Powerbi Masterclass (Introduction, Powerquery And Dax)

Learning PowerBI starting from zero

What you'll learn
PowerBI
Business Intelligence Beginner
Business Analyst
PowerQuery
DAX
Requirements
No
Description
Today, we are all surrounded with full of data.Data can be in the form of structured data(eg: Tables, worksheets), or unstructured data (free text fields or comments from social media). In the current modern world of Business Modelling, many organizations have leveraged the importance of having Business Intelligence(BI) to surface the business problems that could be found in their underlying transactional data. BI tools have helped a lot of organizations, either in preventing some dreadful losses in the business or helping in adding growth towards revenue.BI has now emerged as a Marketing & Strategizing component to help organizations in monitoring the performance of a promotional event, either the promotional event has attracted a lot of attention, or the promotional event did not benefit the organization.Data is everywhere but if we do not transform the data into useful insight, we are not able to make the correct decision on a certain matter.In this course, we are going to learn more on PowerQuery transformation steps:1.  How to transform our columns to extract values or change column formatting2. How to add new columns, eg: Custom columns, conditional columns, index columns, etc.For the report table, we are going to explore more on DAX to help us with some of the common expressions that we used in reporting, eg: MTD/YTD DAX expressions.Hope you enjoy the course and let's roll!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Table of Content

Lecture 3 Introduction to PowerBI

Lecture 4 Installing PowerBI Desktop

Lecture 5 Loading Data into PowerBI

Lecture 6 Creating Our First Dashboard_Demo (Slicer, Card, Donut)

Lecture 7 Creating Our First Dashboard(Table and Bar)

Lecture 8 Challenge

Lecture 9 Solution

Lecture 10 Creating Measure

Lecture 11 Creating Measure Logic in Excel

Lecture 12 Data Types

Lecture 13 Creating Measures in PowerBI

Lecture 14 Sorting

Lecture 15 Sorting_Demo

Lecture 16 Calendar

Lecture 17 DAX

Lecture 18 Chart Interaction

Lecture 19 Creating Buttons

Lecture 20 Creating Bookmarks

Section 2: PowerQuery

Lecture 21 Introduction to PowerQuery

Lecture 22 Connecting Data from Web

Lecture 23 Changing Data Type

Lecture 24 Splitting Columns

Lecture 25 Formatting

Lecture 26 Extract

Lecture 27 Statistical Information from PowerQuery

Lecture 28 Alternative to transform Column

Lecture 29 Custom Column

Lecture 30 Conditional Column

Lecture 31 Index & Duplicated Columns

Lecture 32 Add Column: Format & Extract

Lecture 33 Challenge 2

Lecture 34 Solution_2

Section 3: PowerBI Report: Visual, Measure, and DAX

Lecture 35 Master Calendar

Lecture 36 Table Matrix

Lecture 37 Variable

Lecture 38 MTD Logic

Lecture 39 MTD Logic_2(Added Filter)

Lecture 40 Challenge 3

Lecture 41 Solution_3

Lecture 42 Prior Month & Prior Year

Lecture 43 Buttons

Lecture 44 Color Codes

Lecture 45 Conclusion

Beginner in BI,IT Fresh Graduate,Data Engineer,Data Specialist,Data Analyst