Data Analysis With Microsoft Power Bi For Beginners

Knowledge Required to Put You Up to Speed in Power BI.

What you'll learn

Learn Power BI Data Analysis from Scratch

Microsoft Power BI Business Intelligence made Simple

Help Businesses make Informed Decisions with Power BI Dashboard

Practice Questions for PL-300 Certification Exam -Becoming Microsoft Power BI Data Analyst Certified

Requirements

No data analysis prior experience need.

Description

This is a beginner and intermediate course for Data Analysis using Microsoft Power BI. Beginners would not need to wait for days or months of learning before they could acquire data analysis skills using Microsoft Power BI. The students would be able to get the general overview of Data Analysis, the roles in Data and specifically what Data Analysts do. Hence, they would be able to relate how Power BI is a very resourceful business intelligence tool to employ in Data Analysis. Students do not need any prior knowledge or technical skills to really jump into Data Analysis career or start using Power BI. This course could would really bridge that gap of no prior knowledge or experience. This would also help those aspiring or preparing for PL-300 Microsoft Data Analysis certification have access over reliable 200 practice questions for the exam (certification).Students can also follow through a simulated scenario of building reports for organization and the various steps to follow to achieve that. Students will learn how they can publish and share their reports so that report consumers can access the reports, gain insights and make informed decisions. An assignment is also shared at the end of the course for student to have some private hands on practice.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course Outline

Section 2: Discover Data Analysis

Lecture 3 Introduction

Lecture 4 Overview of Data Analysis

Lecture 5 Tasks of a Data Analyst

Lecture 6 Roles in Data

Section 3: Getting Started with Power BI

Lecture 7 Parts of Power BI

Lecture 8 Power BI Basic Process Flow

Lecture 9 Power BI Building Blocks

Lecture 10 Tour Power BI Service

Section 4: Get Data in Power BI

Lecture 11 Get Data in Power BI

Section 5: Clean, Transform and Load Data in Power BI

Lecture 12 Introduction to Power Query Editor and Some Basic Data Transformations

Lecture 13 Power BI Data Type

Lecture 14 Combining Tables in Power Query Editor

Lecture 15 Rename Query in Power Query Editor

Lecture 16 Profiling Data and Writing M Code in Power Query Editor

Section 6: Data Modelling in Power BI

Lecture 17 Introduction

Lecture 18 Relationships and Cardinality

Lecture 19 Working with Tables

Lecture 20 Hierarchy

Lecture 21 Create Date Table

Section 7: Report Design and Filtering

Lecture 22 Designing and Setting up Filtering in Power BI

Section 8: Measures and Calculated Columns

Lecture 23 Creating Calculated Column

Lecture 24 Measure in Power BI Part 1

Lecture 25 Measure in Power BI Part 2

Lecture 26 Measure in Power - Quick Measure

Lecture 27 Calculated Columns vs Measure

Section 9: Getting Started with DAX

Lecture 28 Introduction to DAX

Lecture 29 Common DAXFunctions Part 1

Lecture 30 Common DAX Functions Part 2

Lecture 31 Evaluation Context in DAX

Section 10: Project - Building Sales Report and Assignment

Lecture 32 Building a Sales Report

Section 11: Course Materials

Lecture 33 Course materials

Section 12: Assignment

Lecture 34 Assignment

Section 13: PL-300 Microsoft Power BI Data Analyst Certification Practice Questions

Lecture 35 PL-300 Microsoft Power BI Analyst Practice Questions

Beginner and Intermediate Data Analyst intending to help business derive maximum insight from their data using Power BI,Beginner data analyst who needs to get up to speed with Power BI tool,Solid foundational course for DAX (Data Analysis eXpression) in Power BI