What is Power BI?

Power BI is Microsoft’s latest business intelligence (BI) and data visualization tool that enables you to quickly develop stunning interactive dashboards that bring your data to life and enable you to monitor your business on every device.
In this course master data visualization through Microsoft Power BI, which will help you or key decision-makers to discover data patterns such as customer purchase behavior, sales trends, or production trends. In this course, you will learn all of the features in Power BI using

  1. Power BI Desktop
  2. Power BI Services/ Power BI Report Server
  3. Power BI Mobile App
  4. Power BI Gateway

Classroom Power BIClassroom & Online Training
24*7 Power BI Content Access24*7 Content Access

Classroom Trainer SupportOnline and Classroom Trainer Support
Real_time_Power_BI_Projects20+ Case Studies


Case Studies

In this course, you’ll be playing the role of Lead Business Intelligence Analyst for AXJ Companies, a global retail store. Your mission? To design and deliver a professional-quality, end-to-end business intelligence solution, armed only with Power BI.

Monthly Sales Dashboard in Power BI

Retail Dashboard in Power BI

Income Statement in Power BI
HR Dashboard in Power BI

Course Curriculum

Introduction to Power BI 00:10:00
In this lesson, you will get an understanding of Business Intelligence, Power BI, Prower BI products and Power BI architecture.
Power BI Desktop 00:07:00
Data Load in Power BI 00:08:00
Power Query Editor
Power Query Editor 00:11:00
Text Transformation 00:12:00
Date Transformation in Power BI 00:09:00
Number Transformation 00:10:00
Group By in Power Query Editor 00:04:00
Replace, Fill and Data Type 00:09:00
Pivot and Unpivot in Power BIFREE 00:06:00
Merge Query in Power Query Editor 00:12:00
Append Queries in Power Query Editor 00:06:00
Data Modeling in Power BI
What is Data Modeling? 00:21:00
Data Modeling Demo 00:07:00
Date Dimension Table 00:05:00
Data Visualization in Power BI
Matrix Visual 00:11:00
Conditional Formatting 00:19:00
Funnel Chart 00:09:00
Percentage Calculations 00:14:00
Treemap Chart 00:07:00
Ribbon Chart 00:04:00
Waterfall Chart 00:06:00
Slicers 00:05:00
Map Charts 00:08:00
Specific Location Map Chart 00:07:00
Edit Interactions in Power BI 00:00:00
DAX (Data Analysis Expressions) in Power BI
Difference between Calculated Columns and Measures 00:08:00
Difference between Implicit and Explicit Measures 00:05:00
IF Logical Function 00:12:00
Switch and Iferror 00:06:00
Text Functions in Power BI
Text Functions 00:11:00
Format Function 00:15:00
Filter Functions
ALL Function 00:11:00
Related Function 00:04:00
Filter Function 00:08:00
UseRelationship Function 00:09:00
Calculate Function 00:11:00
Iterator Functions
Iterators 00:07:00
Time Intelligence Functions
DatesMTD, DatesQTD, and DatesYTD 00:12:00
Previous Day, Previous Month, Previous Quarter, and Previous Year 00:12:00
Same Period Last Year Function DAX 00:11:00
Dates in Period (Moving Average Calculations) 00:11:00
Dates Between 00:05:00
Advanced Charts
Scatter plot Chart 00:11:00
Time Series Forecasting Chart in Power BI 00:05:00
Q and A – AI Visual 00:04:00
AI Visuals Key Influencer in Power BI 00:03:00
Histogram Chart 00:06:00
Pareto Chart in Power BI 00:00:00
Financial Statement Case Study
Introduction to Financial Statement Dashboard in Power BI 00:05:00
Section 1 Income Statement – Gross Sales Calculations – Bullet Graph 00:24:00
Section 2 Income Statement – Percentage Change Calculation and Custom Tool tip 00:27:00
Section 3 Income Statement – Discount Calculations 00:14:00
Section 4 – Net Sales Calculations 00:16:00
Section 5 – Cost of Goods Calculations 00:13:00
Section 6 – Gross Profit and Expense Calculations 00:22:00
Section 7 – Taxes Calculations 00:10:00
Section 8 – Net Profit Calculations 00:07:00
Section 9 – Header and Footer Designing 00:14:00
Power BI Services
Introduction to Power BI Services 00:02:00
How to publish report and workspace creation 00:08:00
How to Edit Report and Prepare Mobile View 00:08:00
Share, Subscribe, Comment and Set Favourites 00:06:00
Scheduling Refresh 00:11:00
Dashboard Creation and Setting Alerts 00:07:00
Power Apps Creation 00:05:00
MTD Report Case Study
HR Analytics Case Study
HR Dashboard Introduction 00:14:00
Head Count Calculations 00:16:00
Attrition Calculations 00:09:00
HR Dashboard – Attrition Percentage 00:10:00
Tenure wise Calculations and Mobile View Dashboard 00:24:00
Sales Dashboard Case Study
Monthly Sales Dashboard Introduction 00:03:00
Data Understanding, Load and Modeling 00:09:00
Monthly sales Dashboard (Final) 00:12:00
Previous Year Sales and Change Percentage 00:13:00
Profit Calculations 00:11:00
Number of Orders 00:06:00
Map Chart 00:05:00
Returns by Months 00:04:00
Top 5 Customers and Products 00:09:00

Course Reviews


6 ratings
  • 5 stars5
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Ashmir Singh


    I first connected with Lokesh through his online course on Advanced Excel.
    After completing the excel course, I signed up for Power BI course with Lokesh as I was really pleased with the training and the ease at which the information is delivered. The training has been thorough, and he has been able to understand my requirements and is able to guide me and explain in a fairly simple manner and solve all issues that I have as I go through building my model dashboard.
    The quality and caliber of both Excel and Power BI training far exceeded all of the others I sampled.
    Lokesh takes his work seriously and is very dedicated. He absolutely nails the brief and his online courses are a great way to connect. He has set a high bar for himself. It is a privilege having him as my teacher and trainer.

  2. Karan Jeena


    The experience has been great! I was only halfway through my Full Stack Data Analyst program when I bagged an opportunity at one of the leading MNC.

  3. Kartika Saraswat


    I’d received very good feedback about Lokesh even before I signed up for his course. Few of my last organisation colleague have done “Data Analytics for Essentials” program from him and are now working with leading MNC’s. So, I decided to join and now working with WNS as Report Analyst.

  4. Pooja


    Hi, my experience with Lokesh Paliwal about Data Analysis course is that I am very much impressed with the quality of the training material and the Trainer as well. You get access to previously recorded sessions just after your signup. You have access to course and materials forever, which is really helpful. I got the opportunity just after the course. Now working with one of the leading MNC as BI Analyst.

  5. Aishwarya


    After spending over 2 years in the field of market research, I realized that my career was stuck. So, I decided to join Lokesh Paliwal’s Power Bi program. Now I am working with one of the MNC as Analyst.

    I would not hesitate to recommend this course to anyone interested in Power BI.

  6. prakhar bansal


    This course power bi is extremely good. The explanation is clear and comprehensive. I like that he makes every thought and every decision verbal so you understand how he is thinking. I would suggest that he have a final project using different data such as a financial industry example.

Social Media

facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


0124- 4601426


EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED