PowerBI MasterClass (All in 1 hour)

PowerBI MasterClass (All in 1 hour), available at Free, has an average rating of 4.09, with 54 lectures, based on 95 reviews, and has 2842 subscribers.

You will learn about PowerBI Business Intelligence Beginner Business Analyst PowerQuery DAX This course is ideal for individuals who are Beginner in BI or IT Fresh Graduate or Data Engineer or Data Specialist or Data Analyst It is particularly useful for Beginner in BI or IT Fresh Graduate or Data Engineer or Data Specialist or Data Analyst.

Enroll now: PowerBI MasterClass (All in 1 hour)

Summary

Title: PowerBI MasterClass (All in 1 hour)

Price: Free

Average Rating: 4.09

Number of Lectures: 54

Number of Published Lectures: 34

Number of Curriculum Items: 54

Number of Published Curriculum Objects: 34

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

PowerBI
Business Intelligence Beginner
Business Analyst
PowerQuery
DAX

Who Should Attend

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

Target Audiences

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

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 formatting

2. 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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Table of Content

Lecture 3: Introduction to PowerBI

Lecture 4: Installing PowerBI Desktop

Lecture 5: Analysity: Your University towards Analytics

Lecture 6: Loading Data into PowerBI

Lecture 7: Dashboard Design

Lecture 8: Creating Our First Dashboard_Demo (Slicer, Card, Donut)

Lecture 9: Creating Measure

Lecture 10: Data Types

Lecture 11: Creating Measures in PowerBI

Lecture 12: Sorting

Lecture 13: Sorting_Demo

Lecture 14: Calendar

Lecture 15: DAX

Lecture 16: Chart Interaction

Lecture 17: Drill Up/Down

Lecture 18: Creating Buttons

Lecture 19: Creating Bookmarks

Lecture 20: Subscribe Now!

Chapter 2: PowerQuery

Lecture 1: Introduction to PowerQuery

Lecture 2: Connecting Data from Web

Lecture 3: Changing Data Type

Lecture 4: Splitting Columns

Lecture 5: Formatting

Lecture 6: Extract

Lecture 7: Statistical Information from PowerQuery

Lecture 8: Alternative to transform Column

Lecture 9: Custom Column

Lecture 10: Conditional Column

Lecture 11: Index & Duplicated Columns

Lecture 12: Add Column: Format & Extract

Lecture 13: Challenge 2

Lecture 14: Solution_2

Instructors

Arthur Fong
BI Developer

Rating Distribution

1 stars: 2 votes
2 stars: 8 votes
3 stars: 15 votes
4 stars: 39 votes
5 stars: 31 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu