Power BI - Zero to Dashboard in a day

Name: Power BI - Zero to Dashboard in a day
Rating: 4.4 (266 reviews)

Learn Power BI in just one day - a complete flow explained with case study (100% practical)

Created byNurture Tech Academy

Last updated 1/2021

English

English [Auto],

What you'll learn

Zero to Dashboard in a Day
Complete Power BI flow - from Brining Data to Publishing report
A Complete Introduction of Power BI
Real Time Project for Revision

Course content

1 section • 11 lectures • 1h 37m total length

Power BI Course Introduction3:15
Learn Power BI through a practical, project-based intro that guides you from connecting and cleaning data to modeling, data analysis expressions, and publishing an end-to-end report for McGarr Market.
What is Power BI10:51
Discover how Power BI supports the business intelligence cycle—collect, analyze, and visualize data to drive informed decisions, with desktop and service options.
3. Understanding Power BI Flow5:28
Master the eight-step Power BI flow from extract to share, using Power Query to extract, transform, load, model data, analyze with DAX, publish to Power BI service, and build dashboards.
How to Extract and Transform Data into Power BI12:53
Learn to extract and transform data in Power BI using Power Query, merge first and last names into full name, and build interactive dashboards from Excel datasets.
How to Connect to Data & Folder into Power BI Desktop13:59
connect to data in power bi desktop using excel sources and power query to build a calendar table and clean headers. then combine folder files and load into data model.
How to build Data Model in Power BI11:58
Build a Power BI data model by establishing one-to-many relationships among key tables using primary and foreign keys, and learn star versus snowflake schemas.
How to write DAX functions & perform calculation in Power BI10:51
Master DAX functions and calculations in Power BI, including calculated columns and measures. Compute age, discounted price, return rate, and revenue with explicit and implicit measures and related functions.
How to visualize data in Power BI12:53
Learn to build a Power BI report from a loaded data model, create slicers and visuals, and design a subcategory matrix showing units sold, returns, and return rate.
How to Build report in Power BI11:14
Create a Power BI report by adding visuals such as a tree map and map, configure zone, state, and units sold, adjust colors and labels, and set slicer interactions.
How to Publish Report to Power BI Service3:53
Publish your desktop report to the Power BI service from the home, log in with your official email, publish to your workspace, and share with collaborators using a pro license.
Practice Files With Real Time Project0:02

Requirements

Microsoft Power BI Desktop (free download)
This course is designed for PC/Windows users (currently not available for Mac)

Description

Hi Folks,

This side Lokesh Lalwani. I am the instructor of this course and would like to share a word about this course with you.

This course is for a beginner and someone who would like to brush up on the core concepts in Power BI. The best part is that you will learn all this in the shortest possible time i.e. just 1 day.

Its been over 10 years that I am into training and consulting and trained over 1000's of professionals from companies like EY, PWC, KPMG, Honda, Volvo, Amazon, etc. and my approach to sharing my knowledge is always practical. I only share knowledge on any feature or tool when I am 100% sure and understand its usage. Maybe that is the reason that since I have started my journey as a trainer, I always got a 5-star review from my participants. That is why I am sure that you will love the content of the course too. My course are already subscribed by 1000's of professionals around the globe on this amazing platform.

In this course first, I will start explaining some important concepts around Power BI through a presentation and then will understand our case study files. Then will start the flow by connecting to data, then transforming (cleaning) the data, and finally loading the same in the Power BI desktop application (ETL process).

Once the data is being loaded, we will understand how to build a data model (this module is specially designed for people who are from non-technical backgrounds... like me). In this module, we will understand how different concepts of Data modeling like Primary and foreign key, filter flow, relationship cardinality, star and snowflake schema, etc.

Once the model is in place we will be finding insights through Data Analysis Expressions (DAX). This is a formula language and in my view this the hardest part of Power BI flow. We will be understanding the most commonly used PBI DAX functions.

The moment we have DAX in place, we will jump in Report Building. Here we will be inserting some amazing visuals and building a report theme too.

And finally will be publishing the report on the Power BI service environment.

Hope you are already excited to be a part of this amazing journey. So don't wait just signup and I'll see you in the course :)

Who this course is for:

Anyone who wants to learn Power in just one day
Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Aspiring data professionals looking to master the #1 business intelligence tool on the market
Students who want a comprehensive, engaging, and highly interactive approach to training
Anyone looking to pursue a career in data analysis or business intelligence