Scribd
Upload
68 views3 pages

ICENTRIC Professonal Services PVT LTD.: Introduction To Power BI

The document provides an overview of Power BI, including getting and transforming data with Power BI Desktop, modeling with Power BI, using DAX, visualizing data with reports, and sharing and collaboration tools in Power BI Service. It discusses topics such as connecting to different data sources, shaping and transforming data with Power Query, building relational models and relationships, creating calculated columns and measures with DAX, creating various visualizations, publishing reports, and setting up gateways for data refresh.

Uploaded by

Rick V
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
68 views3 pages

ICENTRIC Professonal Services PVT LTD.: Introduction To Power BI

The document provides an overview of Power BI, including getting and transforming data with Power BI Desktop, modeling with Power BI, using DAX, visualizing data with reports, and sharing and collaboration tools in Power BI Service. It discusses topics such as connecting to different data sources, shaping and transforming data with Power Query, building relational models and relationships, creating calculated columns and measures with DAX, creating various visualizations, publishing reports, and setting up gateways for data refresh.

Uploaded by

Rick V
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

 Introduction to Power BI

o What is Power BI and Why Power BI


o Installing Power BI Desktop
o Exploring the Power BI Workflow
o Adjusting the settings of the Power BI Desktop
o Comparison of Power BI vs Other Reporting Tools
 Getting and Transforming Data with Power BI Desktop
o Connecting to different sources
o Different connecting Options(DirectQuery vs Import Data Vs Live Connection)
o Shaping and transforming data with Power Query
o Editing,Merging,Appending queries etc
 Modeling with Power BI
o Introduction to Modeling
o Building Relational Models(Setup and Manage Relationships)
o Creating table relationships
o Understanding the filter flow
o Cardinality and Cross filtering
 DAX
o Understanding Dax Syntax
o Calculated Columns vs Measures
o Common Dax functions and formulae
o Understanding the evaluation context in DAX

 Visualising Data with Reports


o Creating Visualisations
o Color & Conditional Formatting
o Setting Sort Order
o Scatter & Bubble Charts & Play Axis
o Tooltips
o Slicers, Timeline Slicers & Sync Slicers
o Cross Filtering and Highlighting

ICENTRIC Professonal Services Pvt Ltd.


MIG 74, Guguru & Ganduri Complex Dharma Reddy Colony, opp.jntu Main GateKPHB PHASE-1,
KUKATPALLY, HYDERABAD, TELANGANA 500085.
Phone : 965 252 7024, 801 985 7188 Email : info@icentricservices.com
hr@icentricservices.com
o Visual, Page and Report Level Filters
o Drill Down/Up
o Hierarchies
o Constant Lines
o Tables, Matrices & Table Conditional Formatting
o KPI's, Cards & Gauges
o Map Visualisations
o Custom Visuals
o Managing and Arranging
o Drillthrough
o Custom Report Themes
o Grouping and Binning
o Bookmarks & Buttons

 Introduction to Power BI Service


o Introduction to the Power BI Service
o Quick Tour of Power BI Service
o Connecting to Data from Power BI service
o Building Blocks of Power BI Service
 Sharing and Collaboration Tools in Power BI Service
o Sharing and Collaboration Options Overview
o Publish from Power BI Desktop
o Publish Reports to Web
o Printing and Exporting from Power BI Service
o Sharing Reports & Dashboards
o Workspaces (My Workspace vs App Workspace)
o Publishing Apps in Power BI Service
o Row Level Security in Power BI Desktop and Service
 Power BI Gateway and Refreshing Datasets
o Understanding Gateways in Power BI
o Difference between Personal and On-Premise Gateway

ICENTRIC Professonal Services Pvt Ltd.


MIG 74, Guguru & Ganduri Complex Dharma Reddy Colony, opp.jntu Main GateKPHB PHASE-1,
KUKATPALLY, HYDERABAD, TELANGANA 500085.
Phone : 965 252 7024, 801 985 7188 Email : info@icentricservices.com
hr@icentricservices.com
o Installation of Personal Gateway
o Installation of On Premise Enterprise Gateway
o Setting Up a Gateway in Power BI Service
o Understanding Data Refresh(Manual vs Scheduled Refresh)
o Troubleshooting Refreshing scenarios
 Case Study

ICENTRIC Professonal Services Pvt Ltd.


MIG 74, Guguru & Ganduri Complex Dharma Reddy Colony, opp.jntu Main GateKPHB PHASE-1,
KUKATPALLY, HYDERABAD, TELANGANA 500085.
Phone : 965 252 7024, 801 985 7188 Email : info@icentricservices.com
hr@icentricservices.com

You might also like