Chat on WhatsApp

Business Analytics using MS Power BI


Price: 1,500 INR

About Course

Business Intelligence is the buzzword nowadays. Power BI is a product developed by Microsoft and widely used for business analytics and business intelligence.

Our training sessions are meticulously planned by our trainer and are designed in a manner geared toward the maximization of efficiency. Your time is valuable, so our goal is to best prepare you while taking up the least amount of your time possible.

Training sessions will be comprised of both exercises and lectures that will touch upon the topics mentioned in the Course Curriculum.

All our videos are recordings of our live training. We have intentionally kept discussions with participants in the videos to give you a feeling of the live training session.

What will You Learn?

 Understand Business Analytics

 Need of Business Analytics

 Importance of Visualization

 Get familiar with Power BI Interface

 Import data from various sources from CSV, Excel, Website etc.

 Data Cleaning

 Data Modelling

 Power BI Charts

 Adding Slicers and Filters

 Power BI Dashboard

Material Includes

  •   7+ Hours of High-quality Videos
  •   Exercise Files
  •  Handouts
  •  Unlimited Watch Time for 1 Year
  •  Verifiable e-Certificate

Requirements

 Anyone can Join

 Computer with Power BI Desktop Version installed

 Devote time to perform tasks given during the sessions

Audience

 Business Analyst/ Data Analyst/ Data Scientist Aspirants

 MIS professionals

 Excel Users

 Anyone who deals with data

Meet your Instructor

Hiren Kakkad

CEO & Founder

Stat Modeller

  •  More than 10 years of industrial experience
  •  Awardee of the Training Quality Excellence Award by IQAC and ISTD
  •  Certified Trainer by NSDC & Skill India
  •  Certified by Google Analytics Academy for Data Studio
  •  Certified Lean Six Sigma Black Belt
  •  Trained 11000+ participants
  •  Guided 150+ Improvement projects
  •  Assisted 50+ Research Projects
  •  Trainer for in Data Analysis, R, Python, SPSS, Minitab, Power BI, Excel, Advanced Excel, Six Sigma, TPM, Kaizen, 5-S, Kanban etc.

Get your Verifiable Certificate

Strengthen Your Professional Profile with a Verifiable Certificate

Course Curriculum

Introduction to Business Analytics
  • Welcome Note and Course and Material
  • Download Material
  • Faculty Introduction
  • Course Content
  • What is Business Analytics
  • Understanding UBER Case
  • Big Data and BI
  • Need of Business Analytics Part 1
  • Need of Business Analytics Part 2
  • Need of Business Analytics Part 3
  • BI as a Process
  • Importance of Visualization in BI
  • Bollywood Movie Game
  • Various tools for BI and Why Power BI
  • Excel Vs. Power BI
  • Versions of Power BI
  • Career Opportunities in Power BI
  • Building Blocks of Power BI
  • BONUS - E-Book
  • Q & A with Participants
Set up of Power BI Desktop
User Interface of Power BI
  • User Interface of Power BI Part 1
  • User Interface of Power BI Part 2
Import Data from Various Sources
  • Recap
  • Import Data from Excel
  • Import Data from CSV
  • Import Data from Web
Data Cleaning
  • Identify Cleaning to be done
  • Tour to the Power Query Editor Part 1
  • Tour to the Power Query Editor Part 2
  • Cleaning the Data Part 1
  • Cleaning the Data Part 2
  • Cleaning the Data Part 3
  • Recap and Saving the File
  • Adding Slicer of Country
  • Q & A Participants
Homework
  • Homework
Superstore Dashboard
  • Recap
  • Understanding Superstore Data
  • Cleaning of Text Data
  • Split Columns
  • Merge Columns
  • Adding Custom Columns
Building Data Model
  • Data Modelling in Power BI
  • Concept of Star Schema in Data Modelling
Power BI Charts
  • Creating Bar Chart
  • Chart Formatting Part 1
  • Chart Formatting Part 2
  • Q & A with Participants
Homework
  • Homework
Hierarchy and Drill Down options
  • Recap
  • Hierarchy and Drill Down option using Line Chart
Other Charts
  • Area Chart, Pie Chart, Donut Chart
  • Combo Chart
  • Funnel Chart
  • Scatter Plot
  • Treemap
  • Geo Map
  • Gauge and Cards
  • Q & A with Participants
Table and Matrix in Power BI
  • Making Table in Power BI
  • Formatting of Table
  • Matrix in Power BI
Slicers and Filters in Power BI Report
  • Adding Slicer in the Report
  • Adding Timeline Slicer in the Report
  • Working with Filters
Adding Visuals from AppSource
  • Visual from the AppSource
Power BI Dashboard
  • Initiate your Dashboard in Power BI
  • Export Power BI Report
  • Way Forward in Power BI
  • Q & A With Participants
Feedback
  • Feedback - Rohit Mathur
  • Feedback - Dr. Minal
  • Feedback - Emmah Morgia
  • Feedback - Rushikesh
  • Feedback - Shivang Rana
Qualitative Analysis in Power BI
  • How to Make Word Cloud in Power BI
Feedback
  • Your Feedback
FINAL EXAM
  • Exam Instructions
  • Final Exam
Chat on WhatsApp