Power Bi – Master Power Bi with 40+ hours of Premium Content

Power Bi – Master Power Bi with 40+ hours of Premium Content, available at $69.99, has an average rating of 4.41, with 178 lectures, based on 263 reviews, and has 1763 subscribers.

You will learn about We have covered real life 151 data modelling scenarios using Power Query, DAX and Data Visualization You will learn to create 5 interactive multipage dashboards. Create and transform raw data into beautiful interactive dashboards using Power Query, DAX. Master Data Analysis Expressions (DAX) and Power Query (M Language) for Power BI Desktop Learn how to analyze data from multiple sources, create your individual datasets based on these sources and transform your results into interactive reports Understand Power BI Desktop and its components. Understand the end to end business intelligence workflow How to Create, Transform and build Relationships between different tables How to Build and Refine Data Models using Custom Formulas and How to work in the different views of the Data Model How to create a report with different interactive visualization types Showcase your skills with two full scale course projects At the end of this course students will be able to analyze data from different data sources and create their own datasets Learn the required knowledge to dive deeper into Power BI applications How to access your results from multiple devices using Power BI Mobile Hands On Experience using a Business Intelligence tool like Power BI Content gets updated each time a new versions of Power BI is released This course is ideal for individuals who are There is no One Stop Solutions to learn everything. In this course, we've focused on providing you with the fundamentals you need to work with Power BI effectively or Anyone who is interested to learn Data Analysis & Data Visualizations using Business Intelligence tool like Power BI or Interested to build visualizations, reports & interactive dashboards with Power BI Desktop or Learn how to convert raw data Into compelling data visualizations using Power BI or If you are interested in Story Telling based on any available Data It is particularly useful for There is no One Stop Solutions to learn everything. In this course, we've focused on providing you with the fundamentals you need to work with Power BI effectively or Anyone who is interested to learn Data Analysis & Data Visualizations using Business Intelligence tool like Power BI or Interested to build visualizations, reports & interactive dashboards with Power BI Desktop or Learn how to convert raw data Into compelling data visualizations using Power BI or If you are interested in Story Telling based on any available Data.

Enroll now: Power Bi – Master Power Bi with 40+ hours of Premium Content

Summary

Title: Power Bi – Master Power Bi with 40+ hours of Premium Content

Price: $69.99

Average Rating: 4.41

Number of Lectures: 178

Number of Published Lectures: 178

Number of Curriculum Items: 178

Number of Published Curriculum Objects: 178

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

We have covered real life 151 data modelling scenarios using Power Query, DAX and Data Visualization
You will learn to create 5 interactive multipage dashboards. Create and transform raw data into beautiful interactive dashboards using Power Query, DAX.
Master Data Analysis Expressions (DAX) and Power Query (M Language) for Power BI Desktop
Learn how to analyze data from multiple sources, create your individual datasets based on these sources and transform your results into interactive reports
Understand Power BI Desktop and its components. Understand the end to end business intelligence workflow
How to Create, Transform and build Relationships between different tables
How to Build and Refine Data Models using Custom Formulas and How to work in the different views of the Data Model
How to create a report with different interactive visualization types
Showcase your skills with two full scale course projects
At the end of this course students will be able to analyze data from different data sources and create their own datasets
Learn the required knowledge to dive deeper into Power BI applications
How to access your results from multiple devices using Power BI Mobile
Hands On Experience using a Business Intelligence tool like Power BI
Content gets updated each time a new versions of Power BI is released

Who Should Attend

There is no One Stop Solutions to learn everything. In this course, we've focused on providing you with the fundamentals you need to work with Power BI effectively
Anyone who is interested to learn Data Analysis & Data Visualizations using Business Intelligence tool like Power BI
Interested to build visualizations, reports & interactive dashboards with Power BI Desktop
Learn how to convert raw data Into compelling data visualizations using Power BI
If you are interested in Story Telling based on any available Data

Target Audiences

There is no One Stop Solutions to learn everything. In this course, we've focused on providing you with the fundamentals you need to work with Power BI effectively
Anyone who is interested to learn Data Analysis & Data Visualizations using Business Intelligence tool like Power BI
Interested to build visualizations, reports & interactive dashboards with Power BI Desktop
Learn how to convert raw data Into compelling data visualizations using Power BI
If you are interested in Story Telling based on any available Data

Master Power BI Desktop & learn advanced Power BI analysis & data visualization

This course will provide you the skillset you need to create Dynamic Reports and Interactive Dashboards to analyze and interpret meaningful insights from your any data using a Business Intelligence tool like Microsoft Power BI.We have created content with relevance to real world scenarios

From this course, you will learn how to analyze data based on relevance using Power BI.

Power BI is a business analytics and business intelligence service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. Power BI is part of the Microsoft Power Platform.

Power BI is a collection of software services, apps, and connectors that work together to turn your data from different sources into visually immersive and insightful reports.

Using Power BI Desktop, you can create rich, interactive reports with visual analytics at your fingertips for free. It can connect to more than 65 on-premises and cloud data sources to turn information into interactive visuals. Data scientists and developers work with Power BI Desktop to produce reports and make them available to the Power BI service.

In Power BI Desktop, users can:

Connect to raw data from different sources
Extract, Profile, Clean, Transform and model the data. Build a Relational Data Model using Power Query and DAX
Build and optimize data models and DAX measures
Create charts and graphs using different visualization techniques
Design and create reports and interactive dashboards to get meaningful insights
Analyze hidden trends and patterns
Create and manage datasets
Share reports with others using the Power BI service within or outside the organization

In this course,

You will learn data analysis and data visualization using Power Query, M Language, Dax and Visualizations in Power BI. You will learn about Power BI Desktop and its components. Learn how to use the Power Query Editor to connect Power BI to various data sources, learn how to work on the Data Models to get meaningful insights.

You will learn how to work with hierarchies and timeseries to find trends in your dataand make accurate forecasts.

We will go from basic to advanced in a step by step process. Each section provides a new data set and exercises that will challenge you so you can learn by immediately applying what you’re learning.

Topics you will Learn

We will cover 151 Power BI Data Modelling Real Life examples
We will cover 5 Multipage Interactive Dashboard projects

You will learn Power BI in a Step by Step Process

Learn how to use Power BI Desktop and Power BI Query Editor
Learn how to create relationships between related data sources in Power BI
Learn to create Power BI Data Models using the Power Query, M Language and DAX Formula language to create powerful calculations
Learn Power BI DAXand how to use it to build custom Measures
Use the built in Power BI Q&A featureto easily ask questions regarding your data to get new meaningful insight
Learn to create Power BI reports with various types of aggregations and filters
Learn to create Powerful Interactive reports and dashboardswith drill throughs and relative date filters in Microsoft Power BI
Create a wide range of Power BI Charts, Graphsand Visualizationsusing drag and drop methods from Data Visualization Tools
Learn how to use themes and custom visualizations in enhance your reports

By the time you complete this course, you’ll be a highly proficient Power BI user.

So what are you waiting for?

Let’s get started.

Course Curriculum

Chapter 1: Introduction to Microsoft Power BI Course

Lecture 1: Introduction to Microsoft Power BI Course

Lecture 2: Download & Install – Microsoft Power BI Desktop

Lecture 3: Download – Microsoft Power BI supporting files (Practice files used)

Chapter 2: Learn Data Analysis & Data Visualization using Power Query, DAX & Visualizations

Lecture 1: Overview of Microsoft Power BI Desktop Interface

Lecture 2: Microsoft Power BI data sources and how to connect them.

Lecture 3: Power BI – Connect to data sources like Excel, CSV and Website

Lecture 4: Power BI – Connecting to other data sources in Microsoft Power BI

Lecture 5: Combine data from multiple excel files – Use Query Editor to reduce data set

Lecture 6: Power BI – Power Query Editor – An overview

Lecture 7: Power BI – M Query Language – An Overview

Lecture 8: Renaming, Editing and Error handling in Power Query advanced editor

Lecture 9: Consolidate and add custom data types in Power BI using M formula language

Lecture 10: Change data types, replace values, group data, transpose and unpivot

Lecture 11: Text column functions (split , format, merge and extract columns)

Lecture 12: Append data to a query, Insert custom columns and index column

Lecture 13: Build relation between tables, merge data, show and hide queries

Lecture 14: How to Lookup tables in a data set using Microsoft Power BI

Lecture 15: Adding Text Formulas in Custom Columns and Conditional Formulas

Lecture 16: Power BI – Power Query List function

Lecture 17: Group by aggregation and find sum by unique column values in Power Query

Lecture 18: Power BI – Date Function in Power Query

Lecture 19: Power BI – Number Functions in Power Query

Lecture 20: Percentage, Percent of, Fill Up and Fill Down in Power Query

Lecture 21: Power BI – Add Prefix and Suffix to a Text in Power Query

Lecture 22: Power BI – Dynamically Merge Related Data Spilled Out in Different Columns

Lecture 23: Power BI – How to GroupBy All Rows in Power Query

Lecture 24: 3 Ways to Extract Text and Numbers from a string using Power Query

Lecture 25: Power BI – How to Reduce row data with Power Query

Lecture 26: Power BI – Get Top N records using List .Range function in Power Query

Lecture 27: Power BI – IF Error function in Power Query

Lecture 28: Power BI – Merge tables based on conditions

Lecture 29: Power Query Let and Nested Let statement

Lecture 30: Power BI – Create Functions in Power Query – Part 1

Lecture 31: Power BI – Create Functions in Power Query – Part 2

Lecture 32: Power BI – How to Add Parameters in a Data Table using Power Query

Lecture 33: Power BI – Group By Maximum Value in a table using Power Query

Lecture 34: How to use Fill Up or Fill Down in your data based on conditions

Lecture 35: Power BI – How to Index columns in Power Query to get value of previous row

Lecture 36: Power BI – How to do conditional join or conditional merge using Power Query

Lecture 37: Power BI – How to use IF Function in Power Query

Lecture 38: Power BI – Dynamically change column names using Power Query

Lecture 39: How to create a delimited list in Power Query

Lecture 40: Power BI – Create Dynamic Start date & End date for data tables in Power Query

Lecture 41: Power BI – Match data based on Approximate or Close Match in Power Query

Lecture 42: Power BI – How to Combine tables with Different Columns

Lecture 43: Power BI – How to work with Nulls or Blank values in Power Query

Lecture 44: Power BI – How to create a Dynamic Calendar table in Power Query

Lecture 45: Power BI – How to Pivot data in Power Query

Lecture 46: Power BI – How to Filter data based on Multiple Criteria using Power Query

Lecture 47: How to Summarize and Group data using Power Query

Lecture 48: Power BI – Dynamically Rank with Ties in Power Query

Lecture 49: Power BI – Find TopN rows in each group using Power Query

Lecture 50: Power BI – For Each Group create a Row Number using Power Query

Lecture 51: Power BI – Retain recent records and remove duplicate records

Lecture 52: Power BI – How to perform VLOOKUP in Power Query

Lecture 53: Power BI – Extract Min date & Max date for column category dynamically

Lecture 54: How to use SUMIF between two table using Power Query

Lecture 55: Power BI – How to add Zeros before Numbers in Power Query

Lecture 56: Power BI – Complete Hidden Function List in Power Query

Lecture 57: An overview of Power BI Report View (Filters, Visualizations, Fields)

Lecture 58: An overview of Visualizations (Text, chart, Cards, Table, Slicer, Filters)

Lecture 59: Q&A feature in Microsoft Power BI

Lecture 60: An overview of Data Analysis Expressions (DAX) – Data Modeling and Visualization

Lecture 61: Power BI – Import data and Create Relationships – Transform data using DAX

Lecture 62: DAX Lookup function – Add a calculated column & get details from a lookup field

Lecture 63: Create a DAX function with calculated column to find Product of two columns

Lecture 64: DAX function with calculated column to Divide & find difference of two columns

Lecture 65: DAX Aggregate Functions such as SUM & SUMX

Lecture 66: DAX Aggregate Functions such as MIN & MAX

Lecture 67: DAX Aggregate Functions AVERAGE

Lecture 68: Power BI Data Visualization – Create a Simple Dashboard

Lecture 69: DAX COUNT, COUNTA, COUNTAX, COUNTROWS, COUNTX, COUNTBLANK & DISTINCTCOUNT

Lecture 70: DAX Logical Functions – AND, OR, NOT, IF, NESTED IF, IFERROR, TRUE, False & SWIT

Lecture 71: DAX Text Functions such as COMBINEVALUES, SEARCH, FIND, EXACT and TRIM

Lecture 72: DAX Text Functions such as CONCATENATE, REPLACE, LEFT, RIGHT, MID and LEN

Lecture 73: DAX Text Functions such as SUBSTITUTE, FIXED and FORMAT

Lecture 74: DAX Date Functions such as MINUTE, HOUR, DAY, MONTH, QUARTER, Year

Lecture 75: DAX WEEKDAY, WEEKNUM, DATE, TODAY, NOW, CALENDAR and CALENDAR AUTO Functions

Lecture 76: DAX Advanced Date Functions – DATEDIFF, DATESBETWEEN and DATESINPERIOD

Lecture 77: DAX DATEADD Function

Lecture 78: DAX EDate and EOMonth Functions

Lecture 79: Calculate MTD, QTD, YTD (Cumulative Total in Power BI)

Lecture 80: DAX ISBLANK, ISNUMBER, ISTEXT, ISNONTEXT, ISERROR, ISODD, ISEVEN & ISLOGICAL

Lecture 81: DAX Contains Function – Basic and Advanced Function

Lecture 82: MONTH, OPENINGBALANCEQUARTER & OPENINGBALANCEYEAR

Lecture 83: CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER & CLOSINGBALANCEYEAR

Lecture 84: DAX such as Function MAX, MAXA, MAXX

Lecture 85: DAX Function such as FIRSTNONBLANKVALUE & LASTNONBLANKVALUE

Lecture 86: DAX Function such as FIRSTNONBLANK and LASTNONBLANK

Lecture 87: DAX Function GENERATESERIES

Lecture 88: DAX Function such as EXCEPT, All and ALLEXCEPT

Lecture 89: DAX Function such as ALLSELECTED and SELECTEDVALUE

Lecture 90: DAX Function such as VALUE, ERROR, IN

Lecture 91: DAX Function such as UPPER and LOWER

Lecture 92: DAX Function TREATAS

Lecture 93: DAX Function HASONEVALUE

Lecture 94: DAX Function such as UNION and CROSSJOIN

Lecture 95: DAX Function PARENT and CHILD

Instructors

Skills On Demand
Better Skills Better Learning

Rating Distribution

1 stars: 18 votes
2 stars: 10 votes
3 stars: 33 votes
4 stars: 90 votes
5 stars: 112 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