MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.98 GB | Duration: 6h 16m
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
