Loading Events

This course is designed for anyone who works with a large set of data and is facing problem in excel and wants to create a dashboard and share it with your team members – regardless of technical or analytical background. Get trained in data visualization techniques, work with interactive dashboards, generate reports, charts and graphs.

Key Benefits of Power BI:
Create data dashboards and visualizations in minutes
Quick and easy access to your data
Data search and exploration
Insight into data from all types of devices
Ability to work across the company
Live, real time, analytics and dashboard monitoring
A consolidated clear overview & Informed business decision making
Integration to well-known products including Excel

Contents:
Getting Started
Introducing Power BI
Using Power BI
The building blocks of Power BI
A quick look at the Power BI service

Getting Data
Overview of Power BI Desktop
Getting started with Power BI Desktop
Connect to data sources in Power BI Desktop
Clean and transform your data with the Query Editor
Cleaning irregularly formatted data

Connect To Data
Data Sources in Power BI Desktop
Connect to web data
Import Excel Workbooks
Analysis Services Tabular Data

Modelling
Introduction to modelling your data
How to manage your data relationships
Create calculated columns
Optimizing data models
Create calculated measures
Create calculated tables
Explore your time-based data

Data Fundamentals
Data Type in Power BI Desktop
Measures in Power BI Desktop
Calculated columns
DAX Basics and Calculated tables

Working On DAX
YTD – ENDOFQUARTER
QTD – ENDOFMONTH
MTD Calculations with DAX – FIRSTDATE
DAX Calculations and Measures – LASTDATE
RANKX – DATESBETWEEN
ISERROR – CLOSINGBALANCEYEAR
ISTEXT, DATEFORMAT – CLOSINGBALANCEQTR
TIMEFORMAT – SAMEPERIOD
Time Intelligence Functions with – PREVIOUSMONTH DAX – QUARTER
Data Analysis Expressions and – IF..ELSEIF. Conditions with DAX Functions – Slicing and Dicing Options with
DATESYTD Columns, Measures, Calculated
DATESQTD Columns and Calculated
DATESMTD Measures with DAX
ENDOFYEAR

Working With Reports
KPI’s Using Measures.
Report View
Sort by column
Tips and tricks for creating reports
Import and display KPIs (Preview)

Sharing Your Work
Publish from Power BI Desktop
Dashboards in Power BI
Share a dashboard from Power BI

Who should attend?
Business Analysts who want to derive information from data
Business Development Managers who want to measure performance using BI
Statisticians aiming to implement their statistics skills
Marketing, Finance, Sales and other domain professionals who need extensive BI

Download: Go to https://powerbi.microsoft.com/en-us/downloads/
Select Microsoft Power BI Desktop, Download and install, this software is free.

Medium: English/ Hindi

Fees and Registration:
Rs. 5,800 + GST 18% per person.
Rs. 5,600 + GST 18% per person for a group of Three to Four participants.
Rs. 5,400 + GST 18% per person for a group of Five to Nine participants.
Rs. 5,000 + GST 18% per person for a group of Ten or more participants.
Kindly provide details for registration to Email: iitdpune@gmail.com & rajiv@iitdworld.com; Name of the Program, name of the participants, company name, GST no., contact details.

Certification:
Digital Certificate of Participation will be provided to all the participants.