1 / 32

Power BI and You

Power BI and You. Brent Tenney. Agenda. What is Power BI? Power Query Power Pivot Power View Power Map Power BI App How To Get Started. Brent Tenney. SharePoint consultant with since 2004 B.A. in Information Systems from the University of Utah

marla
Download Presentation

Power BI and You

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. 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

More Related