Grow Data SKills | Most Affordable Courses | Become Top Data Professional

Light
Dark

Power BI Crash Course

By Shailja In Grow Data Skills

Self Paced
English
Completion Certificate

Demo Class Video

1 Year

Validity (From the date of Enrollment)

30 Hours

Duration

12

Sessions

4

Projects

INR 2200

Buy Now

This course includes

Content Duration30 Hours
Total Video Sessions12
Total Industry Projects4
Quality Assignments & quizzes after each module
Interview preparation guide
Dedicated placement assistance
Resume & Linkedin profile making
Doubt support on private discord community
Certificate of completion

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

Mode of the Course:

Recorded

Course Duration:

30 Hours

Total Sessions:

Total Projects:

Validity:

1 Year (From the date of enrollment)

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.