Duration : 30 days | 1hr theory/day 1hr Practical

 

Introduction to Power BI

 

Learning Objective: This module will introduce you to Power BI, its Building Blocks
and the various fundamental concepts of Power BI.

 

Topics:

 

Overview of BI concepts
Why we need BI ?
Introduction to SSBI
SSBI Tools
Why Power BI?
What is Power BI?
Building Blocks of Power BI
Getting started with Power BI Desktop

 

Hands-On:
Explore Power BI Desktop
First Report on Power BI Desktop

 

Power BI Desktop

Learning Objective: This module will introduce you to Power BI Desktop, extract data from various  sources and establish connections with Power BI Desktop, perform Transformation operations on  data and know the Role of Query Editor in Power BI.

Topics:

 

Power BI Desktop
Extracting data from various sources
Workspaces in Power BI
Data Transformation
Measures and Calculated Columns
Query Editor

 

Hands-On:

Install Power BI Desktop | Data Transformation | Using Query Editor

 

Data Analysis Expressions (DAX)


Learning Objective: This module will help you understand the relationships between data tables, and you will learn the following - DAX Calculation Types, DAX Functions for Advanced Calculations, Time Intelligence Functions, Variables in DAX expressions and Table Relationships in DAX

 

Topics:

 

Modelling Data
Manage Data Relationship
Optimize Data Models
What is DAX?
Data Types in DAX
Calculation Types
DAX Functions: Date and Time, Time Intelligence,
Information, Logical, Mathematical, Statistical, Text and Aggregate
Measures in DAX

 

Hands-On:


Create relationships | Data Types in DAX | Calculated Columns
Explore DAX Functions such as Aggregation, Counting, Logical, Information, Text
Time Intelligence Functions | Creating Calculated Measure


 

Data Visualization

 

Learning Objective: This module will help you understand the benefits of Data Visualization, Best Practices of Data Visualization, Power BI Desktop Visualization, Custom Visuals in Power BI, Formatting Visuals and create Charts, Score Cards and other Visualization items in Power View

 

Topics:

 

How to use Visual in Power BI ?
Charts in Power BI
Matrixes and tables
Slicers
Map Visualizations
Gauges and Single Number Cards
R Visuals in Power BI
What Are Custom Visuals ?
KPI Visuals
Data Binding
Power BI report server

 

Introduction to Power BI Q&A and Data Insights


Learning Objectives: This module covers Power BI Q&A which is currently available as part of the Power BI for Office 365 Preview. You will also learn about Dashboards, Reports, Tiles Quick Insights and Power BI Publisher.

 

Topics:

 

Why Dashboard?
Dashboard vs Reports
Creating Dashboards
Configuring a Dashboard: Dashboard Tiles, Pinning Tiles
Power BI Q&A
Quick Insights in Power BI
Power BI embedded
REST API

 

Hands-On:


Explore Power BI Q&A | Creating a Dashboard | Run Quick Insights on a Dataset
Connect to Power BI Data in Excel
Pinning a Tile to a Dashboard | Pin a range to a Dashboard
Monitor Real-time Data with REST API


Direct Connectivity


Learning Objectives: In this module, you will be connecting directly to Azure, HD Spark, My SQL, and create interactive dashboards.

Topics:

Custom Data Gateways
Exploring live connections to data with Power BI
Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services/ My SQL
Introduction to Power BI Development API
Excel with Power BI: Connect Excel to
Power BI, Power BI Publisher for Excel
Content packs
Update content packs

Hands-On:
Connecting Power BI with Azure, HD Spark, SSAS
Connecting Excel to Power BI
Use the developer API to create custom visuals
Creating content packs

 

Integrating Power BI and Azure ML


Learning Objectives: In this module, you will learn to integrate Azure Machine Learning model inside Power BI. Using Azure ML, Power BI regularly brings in the latest output of business model for analysis.

 

Topics:

 

Extracting data out of Azure SQL using R
Using R, call the Azure ML web service and send it the unscored data
Writing the output of the Azure ML model back into SQL
read scored data into Power BI using R
Publishing the Power BI file to the Power BI service
Scheduling a refresh of the data using the Personal Gateway

 

Hands-On:

 

Extracting data from Azure SQL using R
Writing the Output of the Azure ML back to SQL
Publishing the file to Power BI service | Calling Azure ML web service using R
Reading scored data into Power BI | Scheduling a refresh of the data

 

Project

 


Contact US


A : :PHILLOS,

#257, (BIIT Building),9th A Main, Near Upahaara Darshini,

 3rd Block, Jayanagar, Bangalore - 560011

 

E : : nishu.phillos@gmail.

 

Ph : : 984488 5059 / 96208 90035 / 903588 5059

 

Whatsapp : 984488 5059 / 96208 90035

 

Facebook | Linked in | Google + | Google Web


 



ANIMATION & MULTIMEDIA

 

Adobe photoshop Course


 

Adobe illustrator Course



Corel draw Course



Graphic designing Course



Infographics



DTP Course



Web designing Course



Video editing Course



Audio editing Course



2D Animation Course



3D Animation Course



 



BUSINESS ANALYTICS & REPORTING TOOLS



 

Microsoft Advanced Excel Course


 

VBA & Macros Course


 

Microsoft Access Course


 

SAS Base & Advanced Course



Clinical sas Course



Statistical SAS Course



MSBI SSIS SSRS SSAS Course



Tableau Course



Business Analytics


 

 



SAP ERP Course



 

 

SAP fico Course


 

SAP ABAP Course


 

SAP WM Course



SAP PP Course



SAP SD Course



SAP MM Course



SAP HANA Course



SAP BI BO Course


 

 



.net Course



java / J2EE Course



Android Course



Oracle Sql & Plsql Course



Sql Server Course



PHP and MYSQL Course



Sql Course



Vmware Course



Tally ERP Course



Basic Excel


 

 



Why Phillos.....?


 

In Depth technical Knowledge

 

Live Project guidence

 

Real Time Working Environment

 

100% Placement Support

 

One On One Sessions availablity

 

Fast track & Super fast track classes

 



 

 

 

 

Related Links