Powerbi Masterclass (Introduction, Powerquery And Dax)

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
Homepage

https://www.udemy.com/course/powerbi-for-beginners-introduction-powerquery-and-dax