1 / 19

Our Powers Combined: Query , Pivot, Map, and View

Our Powers Combined: Query , Pivot, Map, and View. A quick tour through the 4 pillars of Power BI February 11, 2014. Agenda. What is Power BI? Why is Power BI? The 4 pillars: Power Query Power Pivot Power Map Power View DEMO! -Election Data Office 365 integration capabilities.

guri
Download Presentation

Our Powers Combined: Query , Pivot, Map, and View

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Our Powers Combined:Query, Pivot, Map, and View A quick tour through the 4 pillars of Power BI February 11, 2014

  2. Agenda • What is Power BI? • Why is Power BI? • The 4 pillars: • Power Query • Power Pivot • Power Map • Power View • DEMO! -Election Data • Office 365 integration capabilities

  3. Who am I? • Jeff Mlakar, Enterprise Architect BI consultant from Bennett Adelson. • Mechanical Engineering and Computer Science degrees from the University of Michigan • (pause for “boo”s) • Bennett Adelson is a strategic managed partner with Microsoft. • bennettadelson.com • jeffmlakar.com • @JeffMlakar

  4. What is Power BI? • Suite of data tools within Excel and Office 365 to enable self-service Business Intelligence • Powerful data searching, combining, analyzing, and presenting

  5. Why is Power BI? • Your users know the data • Your users know Excel • Eliminate “Excel Hell”

  6. Power BI’s 4 pillars Power Query: Search and Share a world of data sources to discover the data you need. Power Pivot: Combine data from numerous types of data sources and perform powerful data analysis. Power View: Enable intuitive, ad-hoc reporting in an interactive data exploration, visualization, and presentation experience that can easily bring your reports to SharePoint and mobile devices. Power Map: Analyze Geographical data with powerful 3D visualizations.

  7. What we’re going to do on our tour • Follow one requirements use case (Election data) through each of the Power BI pillars • Along the way, take detours to examine each pillar a little more in depth

  8. YOUR REQUIREMENTS Power Query • Find data external to your company • Reference it to data internal to your company • Create a 3D map of geographical data • Produce a report with all dimensions filterable • Have the report touch-enabled on mobile devices Power Pivot Power Map Power View Power BI Mobile App

  9. Power BI High-Level Overview • Software as a Service Mobile App Visualizations Created with Excel 2013 Excel Services Excel 2013 Prof. Plus Natural Language Query Web Browser PowerMap Power Pivot PowerView PowerQuery Power Pivot Service Q&A Service

  10. Getting Started • Enable Power Pivot and Power View in Excel Addins • Download Power Query and Power Map Addins at powerbi.com -> Support -> Getting Started • Sign up for Free Trial • 25 licenses • 3 months

  11. Power Query • Formerly “Data Explorer” • Query many data sources • Query the Web • Wikipedia • Data.gov • OData feeds • Expose your data and allow users to share their own queries • JSON parser to query over Big Data / HDInsight

  12. Power Pivot • Formerly “PowerPivot” • Oldest of the Power BI Pillars (2012) • Data stored in local Analysis Services xVelocity (formerly Vertipaq) engine tabular model • Allows for sorting of large amounts of data • Data calculations via Data Analysis Expressions (DAX)

  13. Power Map • Formerly “GeoFlow” • Create 3D visualizations of geographic and temporal data • Build videos based on time dimensions • (currently no SQL Server spatial data type support)

  14. Power View • Formerly “Crescent” • Included in Excel Professional Plus 2013 • Build intuitive, interactive reports • Publish to Web • Interact with your reports through touch-enabled Windows App

  15. Demo: Election Data

  16. Power BI High-Level Overview • On Premises • Software as a Service Mobile App SQL Server Data Source(s) Natural Language Query Web Browser Excel Services Data Refresh Metadata Query Excel Pro Plus Power Pivot Service Data Discovery Q&A Service Data Management Gateway PowerMap Power Pivot PowerView PowerQuery

  17. Pricing

  18. Additional Resources • powerbi.com • Bing: “Power BI Demo Contest” • Microsoft and Pragmatic Works present:Atlanta Self Service Power BI Workshop: February 18th - 19th, 20148:30AM to 5:00PM Microsoft Office1125 Sanctuary Pkwy. Suite 300 Alpharetta, GA 30009

  19. Questions?

More Related