building a bi solution with power bi - · pdf filemay 2 –4, 2016 | san jose, ca building...
TRANSCRIPT
May 2 – 4, 2016 | San Jose, CA
Building a BI Solution with Power BI
Hands-On Micro Workshop
Paul TurleyMentor, BI Solution Architect
Intelligent Business LLC
SqlServerBiBlog.com
Get Connected
PASS BAC 2016
You’ll be running on battery for two hours(unless you’re sitting in the corner)
Please silence cell phones
DemoTHIS IS NOT A
WORKSHOPIT’S A
Foundational Substance
Visuals & New Features
Objective
MORE
LESS
Expectations
Power BI Desktop installed• Install from PowerBI.com
• Windows 7: may need to install .NET Framework 4.5
• Windows 8, 10: should just work
• Recommend Windows x64 with 4GB RAM (8 GB is better)https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-get-the-desktop
A Power BI subscription is not required but will be useful
WiFi Internet access
Workshop Files
OneDrive link from my blog: SqlServerBiBlog.com
Download files to a project folder
or
Copy files from USB drive
Agenda
The objective of this workshop is to get you started building a real solution and
to develop useful skills so you can work with your own data
• Quickly cover essentials
• Will move fast
• May not have time to
answer all questions
• You might not finish
the solution
• I will provide “starter”
& finished files
for each stage
2:30 4:453:15
Hands-on Workshop
Intro
Co
nce
pts
Q &
A
Queries Models Visuals
4:002:45
SQL Server
Analysis Services
Power Pivot/Excel
Power Query/Excel
Power
Pivot/SharePoint
Power BI/Office 365
Power BI.com/
Power BI Desktop
Power BI Technologies & Tools History
1998 2000 2005 2008 2012 2014 20152010 2013 2016
Power View
product
release
service releaseupdate
BI Solution StagesData Sourcing &
Transformation
Dimensional &
Semantic ModelingData Presentation &
Delivery
Self-
service
Enterprise
Power Query
Integration Services
Power Pivot
SQL Server /
Analysis Services
Power BI
Excel PivotTables & Charts
Reporting Services
Power BI
Excel PivotTables & Charts
PQ
Skills
Power BI
Desktop
Power BI
Service
Power Query
& Power Pivot
Excel
SSAS Tabular
Universal Data Problems
Trustworthiness
Maintenance
Data Quality
Ownership & Stewardship
Conformity
Completeness
Let’s Get Started
ObjectivesData: UFO sightings since 1900
Frequency and trends
Correlation with other data
Analyze for:
• # of sightings
• Duration
Analyze by:
• Date: Year, Month & Day
• Time of day
• Region: State & City
• UFO shapes & characteristics
Project Settings
Cleansing Data 2:45
Dirty Data Happensclean it up UFO Sightings 1 (queries completed).pbix
Transforming Data 3:00
Modelling Data 3:15
Relationships Matterand other important life lessons UFO Sightings 2 (model completed).pbix
Visualizing Data 4:00
Visuals and Insights
Explore US city population
Explore calculations
• Calculated columns
• Measures
• Cities with highest
per capita sightings
• Longest sighting
durations
• Distribution of shape
categories
• Current & prior period
UFO Sightings 4 (Offline with Population).pbix
DeploymentPowerBI.com
Datasets
Reports
Dashboards
Q&A
Quick Insights
Cortana desktop integration
Gateways & scheduled refresh…
Power BI: then, now and tomorrowso many options
Custom visuals
R integration
Analyze in Excel & SSRS report pinning
Embedding
Solution scenarios
Resources
Paul TurleyMentor, BI Solution Architect
SolidQ
SqlServerBiBlog.com
Community.PowerBI.com
SqlServerBiBlog.com
Your feedback
is important
and valuable.
Submit by
11:59 PM PT,
May 13, 2015 to
WIN prizes
Session Evaluations
Go to
passbaconference.com
/2016/evals
Download the PASS
EVENT App from
your App Store and
search: PASS BAC
2016
Follow the QR code
link displayed on
session signage and
in the program
guide
for attending this
session and the
PASS Business
Analytics
Conference 2016
ThankYou