Introduction to Power BI - Devin Knight | My thoughts on

download report

Transcript Introduction to Power BI - Devin Knight | My thoughts on

Introduction to Power BI
Devin Knight
[email protected]
@knight_devin
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
About Devin
•
•
•
•
•
Training Director
SQL Server MVP
Author of 5 books
Runs JSSUG User Group
Blogs at BIDN.com
Twitter: @knight_devin
[email protected]
INTELLIGENT DATA SOLUTIONS
• Popup books about
• Will Work for cupcakes
maintaining a healthy
relationship with your
miniature donkeys.
• And supporting cult being
investigated by the
government.
• Blogs mainly consist of a
collection of internet cat
pictures
WWW.PRAGMATICWORKS.COM
Agenda
What is Power BI
Tour of each of the Power BI tools
Power BI Pricing
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power Map BI Overview
Power Query
Power BI Sites
Allows you to extract and transform data from
extraneous data sources
Share, view and interact with reports in a
collaborative site
Power Pivot
Power BI Q&A
Creates data models using mash ups
Provides that ability to interrogate your data
using natural language queries
extraneous data sources
Power View
Data visualization tool that enables you to
quickly gain business insight into your data
Power BI App (Mobile BI)
Mobile app that allows you to view reports while
on the go
Power Map
3-D Mapping Data Visualization Tool
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Self-Service BI Lifecycle
Data
Extraction
INTELLIGENT DATA SOLUTIONS
Data
Modeling
Data
Presentation
WWW.PRAGMATICWORKS.COM
Databases
Tables
Flat Files
Charts
Reporting Services
Cloud
SharePoint Lists
Relationships
Apps For Office
Hierarchies
Calculations
Tables
Key Performance
Indicators
Charts
Internet
Maps
Active Directory
Exporting
Facebook
Hadoop
INTELLIGENT DATA SOLUTIONS
3-D Maps
WWW.PRAGMATICWORKS.COM
Power Query
Discover
INTELLIGENT DATA SOLUTIONS
Combine
Refine
WWW.PRAGMATICWORKS.COM
Demos
Discover -> Consume -> Visualize
Data Wrangling
Putting it all together
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power Pivot
Performance
Uses In-Memory Technologies Providing
Unmatched Analytical Performance
Short Development Cycles
Quick and Easy to Create and End to End
Solution
End User Capable
Familiar Tools with Enhanced Capabilities
Millions Excel Users Worldwide
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Demos
Creating a Data Model
Adding Relationships
Designing Hierarchies
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power View
Reporting Services
Report Builder
Power View
• Development in Visual
Studio
• Use by Developers
• Highly Customizable
• Intended for Power
Users
• Click-Once Application
• Office Look and Feel
• Designed for End Users
• Silverlight Based
• Data Exploration Tool
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Demos
Creating Charts in Power View
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power Map Overview
Power Map Features
3-D Data Visualization Tool for Excel 2013
Plots Geography Data Visually
Analyze Data on a 3-D globe Using Bing
Create Visual Tours to Share with Others
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Demos
Linking Geographical Data to Power Map
Mapping Data Across Time
Creating a Power Map Tour
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power BI Sites
Collaboration
Deploy Excel workbooks
to share with others
Power BI Q&A built in to
Power BI site
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power BI Q&A
User Experience
Uses Natural Query Language to return results
Making it Work
Works on Power Pivot models deployed to a
Power BI site
Use Synonyms in Power Pivot to tune Natural
Queries
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Demos
Deploying Reports to the Power BI site
Using Power BI Q&A on your Model
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power BI App (Mobile BI)
Mobile BI
Gives you Power BI on the go
Connects to your Power BI site
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Demos
Quick view of Power BI App
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Power BI Pricing
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM
Thanks!
Email:
[email protected]
Twitter:
@knight_devin
Blog:
www.devinknightsql.com
INTELLIGENT DATA SOLUTIONS
WWW.PRAGMATICWORKS.COM