Download - SPS-Power BI Introduction
![Page 1: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/1.jpg)
4/9/2016SharePoint Saturday Omaha
Kerry Dirks MCP, MCSDManager Consultant, SogetiSharePoint Solution Architect
![Page 2: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/2.jpg)
![Page 3: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/3.jpg)
Use #SPSOmaha in your tweets to thank them!
Thank You Sponsors !
![Page 4: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/4.jpg)
GET TO KNOW SOGETILOCAL TOUCH—GLOBAL REACH™ AT YOUR SERVICE
![Page 5: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/5.jpg)
Power BI
Agenda
• Introduction
• Demos
• Resources
• Q & A
![Page 6: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/6.jpg)
Introduction
![Page 7: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/7.jpg)
PBI transforms your company's data into rich visuals [for you to collect and organize] so you can …
Power BI (PBI)
Focus on what matters [to you]
By clearing the clutter
Stay in the know
With real-time data
Spot trends as they happen
With insights
Push your business further
Competitive advantage
![Page 8: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/8.jpg)
What if … Instead of viewing your data like this ?
![Page 9: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/9.jpg)
Which is often like viewing your data like this !
![Page 10: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/10.jpg)
You could view your data like this …
“actionable insights”
![Page 11: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/11.jpg)
Excel on Steroids …
![Page 12: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/12.jpg)
Feature
Power BI is a cloud-based business analytics service that enables.
• fast and easy access to your data• a live 360º view of your business• data discovery and exploration• insights from any device• collaboration across your organization• anyone to visualize and analyze data
Experience Your Data. Any Data, Any Way, Anywhere.
Power BI
![Page 13: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/13.jpg)
Power BI REST APIsPower BI Desktop
Prepare Explore ShareReport
0110
001
0001
0110
Data sourcesSaaS solutionse.g. Marketo, Salesforce, GitHub, Google analytics
On-premises datae.g. Analysis Services
Organizational content packsCorporate data sources or external data services
Azure servicesAzure SQL, Stream Analytics…
Excel filesWorkbook data / data models
Power BI Desktop filesData from files, databases, Azure, and other sources
Power BI
Power BI service
Data refresh
Visualizations
Live dashboards
Content packs Sharing & collaborationNatural language query
Reports
Datasets0100110101
Power BI
![Page 14: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/14.jpg)
Power BI - Licensing
![Page 15: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/15.jpg)
Power BI - Licensing
![Page 16: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/16.jpg)
Power BI – Sign up &/or Sign in
![Page 17: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/17.jpg)
Power BI – Settings
![Page 18: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/18.jpg)
PBI DesktopPower BI Desktop makes discovering data easy. You can import data from a wide variety of data sources. After you connect to a data source, you can shape the data before importing to build your analysis, reporting and dashboard experience.
PBI GatewaysPersonal Version: acts as a bridge, providing quick and secure data transfer between the Power BI service and on-premises data sources that support refresh.
Enterprise Version: enables IT departments to deploy and manage central gateways to serve a large group of users.
Power BI Downloads – Available After Signup
![Page 19: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/19.jpg)
Power BI Downloads – Available After Signup PBI Mobile
Stay connected to your data from anywhere, anytime on any device: iOS (iPad or iPhone), Apple Watch, Android phone, or Windows 10 device.
PBI Publisher for ExcelTake snapshots of your most important insights in Excel, like PivotTables, Charts, and ranges and pin them to dashboards in Power BI.
Analyze in Excel UpdatesHave a great dataset in Power BI, but just have to see it in Excel? With the Analyze in Excel feature, you get all the great PivotTable, Chart, and Slicer features in Excel your used to, all while connected to your data in Power BI.
![Page 20: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/20.jpg)
Power BI – Mobile Experience
![Page 21: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/21.jpg)
Power BI – Get Data
![Page 22: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/22.jpg)
Content Packs
![Page 23: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/23.jpg)
Content Pack – My Organization
![Page 24: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/24.jpg)
Power BI – Create Content Pack
![Page 25: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/25.jpg)
Content Pack – Services
![Page 26: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/26.jpg)
Power BI – Content Pack Samples (Online Services)
![Page 27: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/27.jpg)
Power BI – Content Pack Samples (Online Services)
![Page 28: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/28.jpg)
Power BI – Content Pack - Bing (NCAA Final Four)
![Page 29: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/29.jpg)
Power BI – Content Pack - Bing (Blue Origin Launch)
![Page 30: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/30.jpg)
Power BI – Get Data
![Page 31: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/31.jpg)
Power BI – Content Pack Samples
![Page 32: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/32.jpg)
Power BI – Content Pack Samples (IT Spend Analysis)
![Page 33: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/33.jpg)
Demo Prep
![Page 34: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/34.jpg)
Demos
Topics• Connections• Databases• Reports• Dashboards• Publish to Web (SharePoint Integration)• Power BI Desktop
![Page 35: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/35.jpg)
Demos
![Page 36: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/36.jpg)
Demos
![Page 37: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/37.jpg)
Demos – Connect ODB Excel File w/PBI (Connect)
1.2.3.
![Page 38: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/38.jpg)
Demos – Connect ODB Excel File w/PBI (Connect)
May pin the Chart to a Dashboard
![Page 39: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/39.jpg)
Demos – Connect ODB Excel File w/PBI (Import)
1.2.3.
![Page 40: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/40.jpg)
Demos – Build Reports
![Page 41: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/41.jpg)
Demos – Build Dashboard
![Page 42: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/42.jpg)
Demos – Pin New Chart to Dashboard via Search
![Page 43: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/43.jpg)
Demos – Pin New Chart to Dashboard via Search
![Page 44: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/44.jpg)
Demos – Publish to Web (SharePoint)
![Page 45: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/45.jpg)
Demos – Publish to Web (SharePoint)
![Page 46: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/46.jpg)
Demos – Publish to Web (SharePoint)
![Page 47: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/47.jpg)
Demos – Publish to Web (SharePoint)
![Page 48: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/48.jpg)
Demos – Publish to Web (SharePoint)
![Page 49: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/49.jpg)
Demos – Publish to Web (SharePoint)
![Page 50: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/50.jpg)
Demo Walk-ThruODB > PBI > SPO
Questions
![Page 51: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/51.jpg)
Demos – Power BI Desktop
![Page 52: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/52.jpg)
Demos – Power BI Desktop (Existing File)
![Page 53: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/53.jpg)
Demos – Power BI Desktop
Import Prompt
![Page 54: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/54.jpg)
Demos – Power BI Desktop (Get Data – Excel)
Click to view the Raw Data
Click to view the Data Model / Relationships
![Page 55: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/55.jpg)
Demos – Power BI Desktop (Get Data – Excel)
![Page 56: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/56.jpg)
Demos – Power BI Desktop (Publish)
![Page 57: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/57.jpg)
Demos – Power BI Desktop (Quick Insights)
![Page 58: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/58.jpg)
Demos – Power BI Desktop (Publish)
![Page 59: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/59.jpg)
Demos – Power BI Desktop (PBI DB and Reports)
![Page 60: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/60.jpg)
Demo Walk-ThruPBI Desktop
![Page 61: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/61.jpg)
Resources
![Page 62: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/62.jpg)
![Page 63: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/63.jpg)
Get Power BI (Free) http://tinyurl.com/hj5hdg6
Power BI Jump Start http://bit.ly/1ktON16
Power BI Getting Started http://bit.ly/1FF88KA
Power BI Team Blog http://bit.ly/1vwbTLG
Power BI Channel 9 http://bit.ly/1a9Q0gv
Power BI https://powerbi.microsoft.com
Resources
Kerry Dirks MS, MCSD, CSPManager Consultant, Sogeti USA
@kerdirks
kerdirks.wordpress.com
![Page 64: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/64.jpg)
Thank You For Attending !
Sign up for Power BI today at
PowerBI.com
Q & A
![Page 65: SPS-Power BI Introduction](https://reader035.vdocuments.us/reader035/viewer/2022062306/5881a1f01a28ab1a398b5791/html5/thumbnails/65.jpg)
Kerry Dirks MS, MCSDManager Consultant, Sogeti USA
@kerdirks
kerdirks.wordpress.com
SPS Omaha Session #