Hands-On Power BI for Data Visualization
Raj Uchhana NetCom Learning www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Agenda
• • • • • •
What is Power BI and what’s all the hype all? What’s in the Cloud? Which Power BI Version is right? Power BI Interface Power BI Desktop Demo Power BI Service Demo
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Microsoft Power BI
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
What is Power BI and what’s all the hype all
• Brings together all of the previous MS tools o Power Pivot o Power Query o Power View o Power Map
• Self-Service for Business Intelligence • It adds the Cloud-based reporting Capabilities
• It allows for Sharing Reports across the Organization
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
What is Power BI?
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Simple & Powerful • • •
• •
Power BI may not be Silver Bullet Power BI is a very Powerful Bullet Out of the Box: Power BI can quickly handle 50%-75% requirements for most Power Users And some complex scenarios may be achievable using DAX functions Additional requirements can be addressed by using downloading & using Custom Visuals
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Breakdown
•
Power BI Desktop
•
Power BI Service
•
Power BI Embedded (Power BI visuals in your websites/apps)
•
Power BI Mobile (Power BI App on mobile device)
•
Power BI Gateways
•
Power BI Report Server
•
Power BI Visuals Marketplace
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Desktop
• Power BI Desktop •
Application download & install on local computer
•
Report Authoring Tool •
Create Reports
•
Edit Reports
•
Publish Reports
•
Updated Monthly by Microsoft
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Service
• Power BI Service •
Cloud-Only Service
•
Report Authoring Tool
•
•
•
Create Reports
•
Edit Reports
Used to Share Reports via •
Workspace Apps (Other Users)
•
Published Apps (Organization)
Updated Weekly by Microsoft
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Embedded
• Power BI Embedded •
Bring your visuals anywhere
•
Link your Power BI visuals
•
Embed reports in company website
•
Embed reports in your applications
•
Reports come to you
•
Websites & Apps do not go back to PowerBI.com
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Mobile
• Power BI Mobile •
Download Power BI App from any mobile device from: •
Apple App Store
•
Google Play Store
•
Log on to your Power BI account
•
See your reports while you’re on the move
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Gateway
• Power BI Gateway •
Connects to On-Premises data
•
Keeps your data under your control
•
No need to import data into Power BI
•
No need to publish data into cloud
•
Refreshes data on-demand via the Power BI Gateway connector
•
Ideal for large data sources •
Databases (SQL, Oracle)
•
Analysis Services (SSAS) www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Report Server
• Power BI Report Server •
Render reports locally using SSRS •
SQL Server Reporting Services
•
Keeps Power BI On-Premises
•
Keep data under your realm
•
No publishing data into the cloud
•
Ideal in scenarios where •
Data cannot leave company premises
•
Do not have authorization for putting data into the cloud www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Marketplace
• Power BI Marketplace • • • •
•
This is the App Store for Power BI Download to Power BI Desktop Most are Free to Download & use Find new visuals created by • Microsoft • 3rd party vendors Security Notice: Verify with your organization about using 3rd party visuals in your organization. They may need to approve usage. www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
What’s in the Cloud?
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Which Power BI Version is right for me?
Shared Cloud Capacity • Power BI Free • Power BI Pro
Dedicated Cloud Capacity • Power BI Premium
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Free Version
• Power BI Free o o o o o
Free to download, install and use personally Connect to data sources Publish to Power BI Service (cloud) View published reports on PowerBI.com View published reports on mobile device in Power BI app ▪ iOS ▪ Android ▪ Windows 10 o In the mobile apps, connect and interact with cloud and on-premises data o No Sharing with other users
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Pro Version • Power BI Pro ($10/month per user) o Use all features of Power BI Free version o Allows Sharing Reports with other users o Allows Sharing Workspaces with other users o Enterprise distribution ▪ Publish Apps ▪ Email subscriptions ▪ Embed APIs and controls
o Collaboration ▪ Share App workspaces ▪ Analyze in Excel, analyze in Power BI Desktop www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Premium Version • Power BI Premium Capacity • Minimum $5,000/month for dedicated capacity • Provides dedicated resources to run Power BI Service for your organization • Suitable for organizations with high number of report consumers • Also need Power BI Pro licenses for report content creators ($10/mo/user) • All Non-Premium accounts will share capacity with other organizations
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Get Data
• Data from your organization o o o o
Access Databases SQL Server databases Analysis Services Salesforce
• Data from files o Import data from Text, CSV, Excel www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Visualizing your DATA
• Visualize data in a variety of ways • Growing number of visualization types
Prepare
Explore
o Donuts, basic area, waterfall, filled maps, tree maps, funnel, gauges combo charts and
• Now preset Themes are available
Visualize
• Download Custom visuals Share & collaborate
• Drill down, Edit Interactions, Filter Contexts()
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Interface
• This refers to the Visualization pane in Power BI (see diagram below) • This unusual term “well” refers to where field names are dragged-dropped into
• It is analogous to a “well” for storage, like a water well www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Get Fresh Data
• Power BI Data Refresh • Refresh from Power BI Desktop • Refresh from Power BI Service
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
Power BI Desktop Demo
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Create Report, Share, Repeat Access
Share
Clean
Visualize
Mash-up
Explore www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Power BI Service Demo
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Recorded Webinar Video
To watch the recorded webinar video for live demos, please access the link: https://bit.ly/2OK4cSE
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
About NetCom Learning
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Recommended Courses
» 20778: Analyzing Data with Power BI - Class scheduled on Oct 08 » OD20778A: Analyzing Data with Power BI MOD » EDX11004: Analyzing and Visualizing Data with Power BI - DAT207x
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning
ASP.NET Functions on Microsoft Azure Autodesk Inventor Essentials: Visual Styles, Visualization, and Graphics Business Acumen for Project Managers DevOps Foundations: Lean and Agile CISSP Certification Prep: Security and Risk Management Cross Team Collaboration: Increasing Productivity with Office 365 Groups SharePoint 2019 "Wow" | First Look at new SharePoint 2019 Adobe InDesign CC: Down and Dirty Tips and Tricks Architecting for Security on AWS Big Data for Enterprise: Managing Data and Values Top Reasons to Master Agile Scrum and its Benefits Clean Architecture: Patterns, Practices, and Principles CEH: Understanding Ethical Hacking SQL Server 2017: Application Development Best Practices www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Promotions
From Cloud to Security, to Data and AI, to Networking, to Application Development, to Design, to Business Process & Application; all classes delivered by top-notch instructors in in-person Instructor-led Classroom or Live Online. And after you train, treat yourself with Gift Card rewards. Learn More www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
Follow Us On:
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
Š1998-2018 NetCom Learning
THANK YOU !!!
www.netcomlearning.com | info@netcomlearning.com | (888) 563 8266
©1998-2018 NetCom Learning