Grow Data Skills

Power BI Crash Course With
Quality Industry Level Projects (Self Paced)

LanguageEnglish
Validity 1 Year
Mode Recorded

Demo Class Video

INR 2000

Buy Now

This course includes

30+ hours content
3 industry level real world projects & 1 bonus project
Learn while solving real life examples in lectures
Projects will be covered from scratch
Hands on exercises & quizzes after each module
Career & Interview Preparation guidance (Recorded)
Resume preparation (Recorded)
Linkedin profile making (Recorded)
Certificate of completion

Tools you'll learn

Course Content

Welcome to Power BI
How Learning Power BI can help you in career?
Power BI Installation
Power BI:Tool Introduction
Introduction to Power Query
Power Query:Cleaning and Transformations
Power Query:Merging and Appending
Introduction to DAX
Introduction to Data Modelling
Introduction to Dashboarding

Load and connect Data from different sources
Direct Query Vs Import
Data Warehouse, OLTP vs OLAP , Data Catalogue
Star Schema Vs Snowflake Schema
Fact Vs Dimension Table
Creating Relationships between various datasets
Types of relationships: one-to-one, one-to-many, and many-to-many

Tranform data in Power Query Editor
Create calculated columns using Power Query
Power query best practices
Putting Power BI to Work: Real-World Case Study for Practical Mastery

Basic Syntax and Operators in DAX
DAX Behaviour: Filter Context
ALL and ALLEXCEPT
Direct Filters and FILTER functions
DAX Calculated Columns
Measures in Power BI
DAX Functions
Smooth Sailing: Navigating Errors and Exceptions in Power BI

Preparation of list of Key Metrics, KPI(Key Performance Indicators)
Basic visualization : bar charts, column charts, line charts, pie charts, and scatter plots
Interactive Visualizations: Slicers, filters, buttons and bookmarks
Custom Visualizations
Conditional Formatting to visuals
Map Visualizations
Drill through and Drill down
Build your first Interactive Financial Dashboard with Power BI

Requirement Gathering
Learn how a Project Charter is used in companies
Steps followed for Data Analysis
Dashboard Vs Report
Design Rules for an effective dashboard

Create a User Acceptance Test Report
Create a Power BI account
Create a workspace in Power BI
Create a live Excel Report from Power BI

- 📍 Project 1: Build Financial Dashboard - Tracking Financial Fortunes: Analyzing Savings and Expenses Over Time and Categories with Power BI. 💰📊 Delve into the evolution of your financial landscape, charting the journey of savings and expenses across various categories. Unlock actionable insights to optimize your financial strategies and secure a prosperous future.
  
  Deploying The Solution In Power BI Service:
  - 📍 Power BI service Overview, Report sharing and Apps
  - 📍 How to setup Automatic Data Refresh
  - 📍 Documentation and Maintenance
  - 📍 Optimization of Reports
- 📍 Project 2: Food Delivery Data Analysis and Visualization using power BI - Unveiling the Flavorful Insights: Exploring the Dynamics of Food Delivery through Power BI. 🍔 Build an advanced Power BI Dashboard for analysing performace of food delivery company and generate meaningfull insights from it
- 📍 Project 3: E-Commerce Sales Dashboard - Unveiling E-commerce Excellence: Navigating Sales, Trends, and Customer Insights with Power BI. 🛒📊 Dive deep into the data-driven world of online retail, where every click tells a story. From sales performance to customer behavior, our Power BI dashboard illuminates the path to e-commerce success.
📍 Bonus Project - Supply Chain Analysis Dashboard Using Power BI

Attention Seeking Resume Preparation and Interview Strategies
Strategies To Crack Tech Interviews
Linkedin Profile Making
How To Expand Your Professional Network On Linkedin
How To Use Various Job Portals
How To Approach For Referrals

Course Schedule

Total Session:

Class Duration:

2 Hours Teaching

Mode of the Course:

Recorded Mode

Class Recording Provided:

Yes

Course Validity:

1 year

Any Prerequisite? :

Passion And Willingness To Learn

⚠️ Important Notice :

The video may not work on Linux due to DRM restrictions. It is only accessible on Chrome when using Windows or macOS.

Workaround: To access the video on Linux, you can create a Windows virtual machine (VM) and watch the video through the VM. Alternatively, you can use our Android or iOS application to view the video on your mobile device.

Instructor

Shailja Mishra

Shailja Mishra is a Data and Applied Scientist at Microsoft , mentored over 750+ Students around Data Engineering, Data Analysis and Data science Domain.