1. Power BI and You Brent Tenney

2. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

3. Brent Tenney SharePoint consultant with since 2004 B.A. in Information Systems from the University of Utah Microsoft Certified Solutions Master: SharePoint R15

4. Expertise: • SharePoint • Dynamics CRM • Dynamics ERP - Great Plains (GP), Solomon (SL)

5. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

6. What is Power BI? • Excel Features • Power Query – easily discover and connect to data from public and corporate data sources • Power Pivot – create a sophisticated Data Model directly in Excel • Power View – create reports and analytical views with interactive data visualizations • Power Map – explore and navigate geospatial data on a 3D map experience in Excel • Power BI for Office 365 • Power BI Sites – share, view, and interact with reports in these collaborative Power BI sites • Power BI Q&A – use natural language queries to find, explore, and report over your data • Query and Data Management – share and manage queries and data sources, and view query usage analytics • Power BI Windows Store App – view reports on the go, with the Power BI app • IT Infrastructure Services for Power BI • Provision Power BI for Office 365 – create a tenant, and get Power BI for your organization • Power BI Admin Center – manage your organization’s Power BI infrastructure from a site • Data Management Gateway – connect on-premises data to the cloud, seamlessly and securely

7. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

8. Power Query … for discovering, combining, and refining data across a wide variety of sources ...

9. with Power Query, you can … • Find and connectdata across a wide variety of sources. • Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and PowerView. • Create custom views over data. • Use the JSON parser to create data visualizations over Big Data and Azure HDInsight. • Perform data cleansing operations. • Import data from multiple log files. • Perform Online Search for data from a large collection of public data sources including Wikipedia tables, a subset of Windows Azure Marketplace, and a subset of Data.gov. • Create a query from your Facebook likes that render an Excel chart. • Pull data into Power Pivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections. • With the Power BI Preview edition, you can share and manage queries as well as search data within your organization.

10. Power Query Data Sources • Web page • Excel or CSV file • XML file • Text file • Folder • SQL Server database • Windows Azure SQL Database • Access database • Oracle database • IBM DB2 database • MySQL database • SharePoint List • OData feed • Hadoop Distributed File System (HDFS • Windows Azure Marketplace • Active Directory • Facebook

11. Demo • Wikipedia: list of countries by gun ownership • Census: population by state • SharePoint: BradyScores • FBI: Total NICS Firearm Background Checks • FBI: NICS Firearm Background Checks by Year

12. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

13. Power Pivot … an add-in that enables you to perform powerful data analysis in Excel 2013 …

14. with Power Pivot you can … • get data using Power Pivot add-in • create relationships between tables (super VLOOKUP) • define hierarchies (e.g. city > state > country) • write advanced formulas with DAX • create KPIs based on calculated fields • create Perspectives (custom views)

15. Power Query vs Power Pivot

16. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

17. Power View … an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting ... … quickly create a variety of data visualizations, from tables and matrices to bar, column, and bubble charts, and sets of multiple charts …

18. Excel Services vs Excel Web App

19. Continued

20. Demo

21. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

22. Power Map … plot geographic and temporal data visually, analyze that data on a 3-D globe and over time, and create visual tours to share with others …

23. Geographic & Temporal Data • each row of data needs • geographic value: • latitude/longitude pair • city • country • zip code • state / province • address • date/time field

24. Demo

25. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

26. Power BI App … provides live mobile access to the important business information stored in your Office 365 account. View and interact with Excel and Power View content on any Windows 8 or Windows RT tablet or PC …

27. Demo

28. Agenda • What is Power BI? • Power Query • Power Pivot • Power View • Power Map • Power BI App • How To Get Started

29. How To Get Started with Power BI • install Excel 2013 Professional Plus • enable the Power View add-in • File > Options > Add-Ins > COM Add-Ins • install Silverlight • download the Excel add-ins: • Power Query • Power Map • sign up for the Power BI for Office 365 Preview • assign licenses to user(s) • provision team site • download the Power BI App from the Windows Store

30. Questions & Answers Contact Information: Brent.Tenney@JourneyTEAM.com

31. The user group for SharePoint End Users Come see us in the Community Lounge at SPS Utah • Topic: Tips and Tricks to Get More Out of SharePoint • When: February 11th, 8:00AM - 9:00AM • Where: WesTechEngineering, 3665 S W Temple, Salt Lake City, UT 84115 • Sponsor:

32. Special Thanks to our Platinum Sponsor …and our Gold Sponsor