Power BI for Data Analysis

Power BI for Data Analysis, available at $69.99, has an average rating of 4.63, with 41 lectures, based on 167 reviews, and has 436 subscribers.

You will learn about Able to analyze data with Power BI and gain insight Able to connect and extract data from the web, excel etc. Able to design interactive reports and dashboards Able to understand the logical steps in data models Able to write DAX expressions Data mash ups using the Power query editor Able to write your own DAX measures Able to design and interactive reports and dashboards Able to understand the concepts of facts and dimension table Able to create a Power BI mobile dashboard This course is ideal for individuals who are Data analysts or Students or Business oriented or Freelancers or Anyone curious about data science and what to have a change of career It is particularly useful for Data analysts or Students or Business oriented or Freelancers or Anyone curious about data science and what to have a change of career.

Enroll now: Power BI for Data Analysis

Summary

Title: Power BI for Data Analysis

Price: $69.99

Average Rating: 4.63

Number of Lectures: 41

Number of Published Lectures: 41

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Able to analyze data with Power BI and gain insight
Able to connect and extract data from the web, excel etc.
Able to design interactive reports and dashboards
Able to understand the logical steps in data models
Able to write DAX expressions
Data mash ups using the Power query editor
Able to write your own DAX measures
Able to design and interactive reports and dashboards
Able to understand the concepts of facts and dimension table
Able to create a Power BI mobile dashboard

Who Should Attend

Data analysts
Students
Business oriented
Freelancers
Anyone curious about data science and what to have a change of career

Target Audiences

Data analysts
Students
Business oriented
Freelancers
Anyone curious about data science and what to have a change of career

I have created this course with a very simplified approach and many students who have taken this course have found it clear and easy to understand. The Power BI course is designed to give the participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to extract from their data to gain great insights.

At the end of the course, you would have progressed from a zero level to an intermediate level at a very tailored pace.

This course covers the essentials of Power BI Desktop including:

1. Data Preparation

2. Data Modeling

3. Data Visualization

4. DAX

In the Data Preparation section, I explained the rules for clean data structure. I also show how to connect Power BI to a system Folder and the minimum transformation that you can do for data clean up.

In the Data Visualization section, I have explained thoroughly and included a guide you that will hep you in selecting the right kind of charts for your reporting.

The Data Modeling section, I have shown how to methodologically create a data model and how you can eliminate redundant data by separating a large data set by separating the tables into Fact and Dimension Tables. You will see how to do this from scratch using a methodical approach on excel, before transferring to using the power query editor

Although, I have not gone very deep on DAX, the DAX content here is excellent, and it is a super place to start.

I hope you enjoy the course!

Course Curriculum

Chapter 1: Introduction & General Overview

Lecture 1: Welcome

Lecture 2: Introduction

Lecture 3: Downloading Power BI Desktop App and Dataset

Lecture 4: Overview of Power BI User Interface

Lecture 5: Understanding the Case Study

Lecture 6: Importing Data into Power BI

Lecture 7: Power Query Overview

Lecture 8: Data Transformation with Power Query Editor

Chapter 2: Data Visualization Reports using Power BI

Lecture 1: Overview of Power BI Reporting

Lecture 2: Creating your First Visual – Line Chart

Lecture 3: Formatting Power BI Charts

Lecture 4: Creating a Top N Report with a Bar Chart

Lecture 5: Creating a Donut Chart

Lecture 6: Creating a Bottom N Report with a Bar Chart

Lecture 7: Using Filters Pane and Slicers

Lecture 8: Slicer 2

Lecture 9: Editing Interactions

Lecture 10: More on Formating

Lecture 11: Module Outro

Chapter 3: Data Modelling

Lecture 1: Quiz Solution

Lecture 2: Introduction to Data Modelling

Lecture 3: Workflow for Data Modelling

Lecture 4: Building the Data Model for our Data

Lecture 5: Building the Data Model for our Data 2

Lecture 6: Building the Data Model for our Data 3

Lecture 7: Building the Data Model for our Data 4

Lecture 8: Testing the Data Model Part 1

Lecture 9: Fixing the Data Model Part 1

Chapter 4: DAX Fundamentals

Lecture 1: Data Analysis Expressions – DAX

Lecture 2: Building a Calendar Table

Lecture 3: Adding Columns to our Calendar Table (Month, Year etc)

Lecture 4: Adding Columns to our Calendar Table (Quarter)

Lecture 5: Investigating the Date Table

Lecture 6: Measure – Revenue

Lecture 7: Measure – Previous Month

Lecture 8: Measure -Month on Month Variance

Lecture 9: Line Chart

Lecture 10: Water Fall Chart

Lecture 11: Matrix Table

Lecture 12: Analysis

Chapter 5: Forecasting

Lecture 1: Business Forecast

Instructors

Cleverson Esene PhD
Teacher at Udemy

Rating Distribution

1 stars: 1 votes
2 stars: 2 votes
3 stars: 12 votes
4 stars: 47 votes
5 stars: 105 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