Introduction:
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:
Power BI
What is Power BI?
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Updates
Power BI Desktop
Installing Power BI Desktop
Exploring the Power BI Desktop Interface
Utilizing File Types; PBIX vs PBIT
Examining Data Sources
Discussing Data Refresh
Understanding Data Types
Working With CSV, TXT and Excel Worksheets
Importing, Transforming, and Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables
Connecting to Databases
Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular
Merging, Grouping, Summarizing, And Calculating Data
Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating
Reporting
Creating Reports
Utilizing the Matrix Visualization
Utilizing the Map Visualization
Utilizing the Card Visualization
Utilizing the Chart Visualization
Utilizing Slicers
Publishing to Power BI Online
Power BI Online
Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile
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. The software is free.
IITD Sr. Expert Faculty:
Highly experienced faculty from Indian Institute of Training & Development will conduct this training program. The training sessions will provide participants an opportunity to discuss specific problems with the expert faculty.
Medium: English/ Hindi/ Marathi
Fees & Registration Details:
Rs. 3,400 + GST 18% per person.
Rs. 3,200 + GST 18% per person for a group of Three to Four participants.
Rs. 3,000 + GST 18% per person for a group of Five or More participants.
Kindly provide the below given details of registration on email: iitdpune@gmail.com &/or rajiv@iitdworld.com
Name of the program:
Name of the participant(s):
Participants email id for sending venue details:
Name of the company:
GST number:
Certification: Participation certificate will be provided to all the participants.