1 / 24

Realizing Business Insights with PowerPivot

Realizing Business Insights with PowerPivot. About the Presenter. Chris Campbell Principal Consultant with BlueGranite Certified Professional in Microsoft BI Development Microsoft Virtual Technology Specialist

iden
Download Presentation

Realizing Business Insights with PowerPivot

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. Realizing Business Insights with PowerPivot

  2. About the Presenter • Chris Campbell • Principal Consultant with BlueGranite • Certified Professional in Microsoft BI Development • Microsoft Virtual Technology Specialist • Business Intelligence Technical Architect at the Microsoft Technology Center, Detroit ccampbell@blue-granite.com b-chcamp@microsoft.com http://www.blue-granite.com http://twitter.com/ckcampbell

  3. Agenda • Introduction • What is PowerPivot? • Data Modeling for Analysis • Demo • Resources • Questions

  4. What is PowerPivot?

  5. Trends in Business Intelligence • IT Owned & Managed • Slow to Respond • Monolithic • Not Interactive BI 1.0 BI 2.0 Silo Silo Structured & UnstructuredData UnstructuredData StructuredData • Business Owned, IT Managed • Agile • Flexible • Collaborative

  6. What is PowerPivot? A solution that re-defines the line between I.T. and end-user roles ... using familiar tools without requesting support … managing usage and resources involved

  7. Why Use PowerPivot? • Process massive amounts of data in seconds • Take advantage of familiar Excel tools and features • Load even the largest data sets from virtually any source • It is FREE!

  8. Download and Install PowerPivot Go to http://www.powerpivot.com and choose a version

  9. Download and Install PowerPivot Make sure to select the appropriate version for your version of office (32-bit or 64-bit)

  10. Finding out what version of Excel You Have In Excel, Click “File” then Help. The version of Excel is noted under “About Microsoft Excel”

  11. Data Modeling for Analysis

  12. OLAP Data Modeling • OLAP Data Models generally take the form of a “Star” Schema • Two kinds of tables • Dimension • Fact • Fact tables have a 1:M relationship to all Dimension tables.

  13. Data Modeling for Analysis • PowerPivot blurs the line between dimensions and facts. • Only requires that a user understand where the numbers are and how they want to slice them. • Can join together many disparate data sources. • DAX allows you to manipulate the data and build custom calculations.

  14. DEMO Building a Data Model and Dashboard with PowerPivot

  15. DAX Evaluation Context • Row Context • “The current row” • Determined by the content of the TABLE • Includes ALL columns • May include “RELATED()” columns from other tables • Query Context • What row(s) and column(s) are selected? • Determined by what are on rows/columns in your pivot table • Filter Context • What rows are left after the filter is applied?

  16. DAX Evaluation Context – Example Row Context Query Context Filter Context

  17. DEMO PowerPivot Management Dashboard

  18. PowerPivot Management Dashboard

  19. Management Dashboard – Server Activity

  20. Management Dashboard – Workbook Activity

  21. Management Dashboard – Workbook Details

  22. Resources

  23. PowerPivot Resources • Web sites • http://msbiacademy.com • http://powerpivotpro.com • http://www.powerpivot.com • http://powerpivotgeek.com • http://powerpivot-info.com • BOL • http://msdn.microsoft.com/en-us/library/ee210682(SQL.105).aspx

  24. Questions? ccampbell@blue-granite.com b-chcamp@microsoft.com http://www.blue-granite.com http://twitter.com/ckcampbell

More Related