Learn Power BI for Data Science

  1245 Ratings      6128 Learners

Business Analytics with Power BI course provides a complete overview of Business Analytics tools and techniques using Power BI. Learning Power BI is a crucial skill for many Data Science roles.

INR 10000  INR 15000

Why should you take this Power BI Course?

In this course you will work on 5 industry projects from HR, Finance, Retail and Manufacturing. End of this course, you will be able to create interactive dahsboards.

 

Learn Advanced DAX functions using business scenarios, Custom Charts Designing, running Python scripts for Data Manipulation and Visualization, and many more.

 

You will get life-time 24/7 course access with 1:1 instaructor support.

 

Upcoming [LIVE] Online Batch:

19th JUL'20SAT & SUN (Weekend Classes)Timings: SAT & SUN at 10 am - 2 pmEnroll Now

Course Curriculum (100 hrs.)

Module 1
Statistics (20 hrs.)

Introduction

Sample or population data?

The fundamentals of regression analysis

Measures of central tendency, asymmetry, and variability

Practical example: descriptive statistics

Distributions

Estimators and estimates

Confidence intervals: advanced topics

Practical example: inferential statistics

Hypothesis testing: Introduction

Hypothesis testing: Let’s start testing!

Practical example: hypothesis testing

The fundamentals of regression analysis

Subtleties of regression analysis

Assumptions for linear regression analysis

Dealing with categorical data

Practical example: regression analysis

Bonus lecture

Module 2
Power BI (40 hrs.)

Overview of Power BI

Power BI Cloud Service

Power BI Desktop

Importing and Transforming Data

Data Transformations

Using a Dynamic Fiscal Calendar Table

Data Modelling

Report Building

Commonly Used DAX Functions

Optimizing Measures for Self-Service BI

Using Quick Measures

Report Functionality

Report Visualisation

Optimizing the Design

Shapes and Borders

Governance & Distribution

Data Refreshing

Module 3
Python (40 hrs.)

Overview of Python

Core Programming Principles

Fundamentals of Python

Matrices

Data Frames

Advanced Visualization

Data Science

Data Pre-processing

Regression

Classification

Clustering

Association Rule

Reinforcement Learning

Natural Language Processing

Deep Learning

Artificial Neural Network

Projects you will Cover in this Course

Project 1

Income Statement is an organization's core financial statement that reports the company's performance over a specific accounting period. It is a means of communicating the income and expenses, and thus profitability of the organization's operations across time.

Power BI Training Understanding of Income Statement
Power BI Training Custom Bullet Graph Creation
Power BI Training Percentage Calculations and Custom Tooltip
Power BI Training Monthly Line Chart and Custom Tooltip
Power BI Training Discount, Net Sales and Cost of Goods Calculations
Power BI Training Gross Profit and Expenses Calculations
Power BI Training Taxes and Net Profit Calculations
Power BI Training Header and Footer Designing


Income Statement Dashboard EC Analytics Consulting in Power BI

Project 2

Sales Dashboard displays the sales key performance indicators (KPI’s), like Sales, Profit, etc., which enables the sales managers to make better sales decisions.

Power BI Training MTD Sales Dashboard Introduction
Power BI Training Data Understanding, Data Load and Data Modeling
Power BI Training Monthly Sales Calculations
Power BI Training Previous Year Sales and Percentage Growth calculations
Power BI Training Profit and Number of Orders Calculations
Power BI Training State-wise Map Chart

Power BI Training Returns by Month
Power BI Training Top 5 Customers and Products

Sales Dashboard EC Analytics Consulting

Project 3

An HR Dashboard that displays import HR metrics using interactive data visualization. In this dashboard you will learn how to calculation Headcount, Rolling Headcount, Attrition, Rolling Attrition, and Attrition Percentage USing DAX.

Power BI Training HR Dashboard Understanding
Power BI Training HeadCount and Rolling Head Count Calculations
Power BI Training Attrition and Rolling Attrion Calculations
Power BI Training Attrition Percentage Calculation
Power BI Training Tenure and Department wise Calculations
Power BI Training Gross Profit and Expenses Calculations


HR Analytics Dashboard EC Analytics Consulting

Project 4

Sales Dashboard displays the sales key performance indicators (KPI's), like Sales, Profit, etc., which enables the sales managers to make better sales decisions.

Power BI Training YTD Sales Dashboard Introduction
Power BI Training Previous Year Same Period of Previous Year Calculations
Power BI Training Controls to Compare KPI's with Previous Period and Same Period of Last Year
Power BI Training Subcategory wise Sales and Profit as per Category
Power BI Training Shape Map Visual with Color Variance


Monthly Sales Dashboard EC Analytics Consulting

Project 5

Product Dashboard which helps you to find an association between products using Market Basket and showing the share of the top 20% using Pareto Analysis.

Power BI Training Product Category wise Sales
Power BI Training Sub Category wise Sales
Power BI Training Dynamic Pareto Chart to Show share of top 20% products
Power BI Training Product-wise Sales, Profit, Quantity and Profit Ration with Conditional Formatting
Power BI TrainingMarket Basket Analysis to show association between products

Product Dashboard EC Analytics Consulting

Power BI Certification

EC Analytic Consulting's Business Analyst using Power BI Certificate Holders work at 1000s of companies

 

GET IN TOUCH

Selected Clients

Michelin EC AnalyticsTaiki_Sha EC AnalyticsNestle EC AnalyticsCheors EC AnalyticsWNS EC Analytics

     

Techsurge EC AnalyticsTalent Catalyst EC AnalyticsAtkearney EC AnalyticsQuicqo EC AnalyticsGazelle EC Analytics

Testimonials

Social Media

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

Address:

NM 23, SECTOR 14, OLD DLF COLONY,
GURGAON (HARYANA)
0124- 4601426

ABOUT EC ANALYTICS CONSULTING

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