1 / 25

Microsoft Business Intelligence (BI)

Microsoft Business Intelligence (BI) . About Me. Creating solutions for 20 years Traveling c onsultant at Glenture. Principal Consultant in Microsoft BI Practice. Graduated from . Also, have MCP and PMP . My Email: aholowaty@yahoo.com Family:.

vinaya
Download Presentation

Microsoft Business Intelligence (BI)

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. Microsoft Business Intelligence (BI)

  2. About Me • Creating solutions for 20 years • Traveling consultant at Glenture. Principal Consultant in Microsoft BI Practice. • Graduated from . Also, have MCP and PMP. • My Email: aholowaty@yahoo.com • Family:

  3. Types of solutions I work Also, we have created BI solutions in the Manufacturing, Insurance, Financial, Government, Supply-Chain, and other industries.

  4. Agenda • What is Self-Service Business Intelligence (SSBI) • How is oneusing Governance w/SSBI • Visualizations - MS BI History & Types • Models - MS BI History & Types • MS BI Decision Frameworks – Which one to pick • Start with a sound foundation – The Model • Tips/Takeaways for success • Important Links • What is PowerBI? • Demo • Questions and Comments

  5. What is Self-Service Business Intelligence (SSBI) • Enables business users to access and work with corporate information without the IT department’s involvement (except, of course, to set up the data warehouse and data marts underpinning the business intelligence (BI) system and deploy the self-service query and reporting tools). • The self-service approach enables end users create personalized reports and analytical queries while freeing up IT staffers to focus on other tasks – potentially benefiting both groups. • Because self-service BI software is used by people who may not be tech-savvy, however, it is imperative that the user interfacemust be intuitive and easy to use. Ideally, the IT department should help users understand what data is available for BI uses by providing a metadata dictionaryat the business layer level. This will help end users to focus on the meaning of the data in the BI system, not the technology itself. • Self-service BI capabilities should be built with a business focus from the start. Training, on both the data and the self-service applications, is critical for getting business workers up-to-speed on how they can use the information in the BI system. While self-service BI encourages users to base decisions on data instead of intuition, it creates the risk of chaotic reporting within an organization. To mitigate that risk, IT should work with business units to determine key metrics and an agreed-upon vocabulary,  processes for creating reports and publishing, what privileges are necessary for access to confidential data and how to define and implement data security policies and privacy policies.

  6. What is Self-Service Business Intelligence (SSBI)

  7. What is Self-Service Business Intelligence (SSBI)

  8. How is one company using Governance w/SSBI

  9. Visualizations - MS BI History & Types Excel Pivot Table SSRS PerformancePoint SharePoint Required 1993, 2007 with SSAS 2007 w/SharePoint 2004 w/SQL Server 2000 PowerView PowerMap Excel 2013, Office 365, Power BI SQL Server 2012 Tabular & SharePoint 2010, Excel 2013, SQL Server 2012 SP1 CU4 SSAS Multidimensional

  10. Models - Microsoft BI History & Types Multidimensional Analysis Services Tabular Analysis Services PowerPivot SQL Server 2008R2, Excel 2010, SharePoint 2010 with Vertipaq/xVelocity OLAP released SQL Server 7 in 1998 SQL Server 2012 with Vertipaq/xVelocity Tools from CodePlex.com

  11. MS BI Decision Frameworks - User Types

  12. MS BI Decision Frameworks - Data Size

  13. MS BI Decision Frameworks - Visualizations

  14. MS BI Decision Frameworks - Visualizations

  15. MS BI Decision Frameworks - Visualizations

  16. MS BI Decision Frameworks - Visualizations

  17. MS BI Decision Frameworks - Visualizations

  18. MS BI Decision Frameworks - Models

  19. MS BI Decision Frameworks - Models Source: http://download.microsoft.com/download/F/F/6/FF62CAE0-CE38-4228-9025-FBF729312698/Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012_PDF.pdf

  20. Start with a sound foundation – The Model Star Schema (Dimension) (Dimension) (Measures) (Dimension) (Dimension) • MSBI is geared toward Star Schemas – a Ralph Kimball world; Natively support snowflake in Multidimensional model and limited support in Tabular with unidirectional relationships or complex DAX • Build your hierarchies, calculations, KPIs in the model so it can be reused from many visualizations. • Build similar and consistent (conformed) dimensions in models when possible so that analysis from different models can be integrated in the future. • Use terms for tables and columns that are easy to understand and consistent across the organization. • Have a governing body to manage how models are created and deployed.

  21. Tips/Takeaways for Success • Gather BI Requirements • Map Requirements to the MS BI Decision Frameworks(User Types, Size, Visualization, Model) • Model your data if needed or leverage an existing model • Start with a small/simple POC in Excel • Build out POC to the full scale system • Get feedback often

  22. Important Links http://powerpivotgeek.com/ Extensive Blog for many aspects on PowerPivothttp://www.powerpivotpro.com/the-book/ The First PowerPivot Formulas (DAX) Book Written Specifically for Excel Usershttp://www.powerpivotpro.com/ A blog concerning of thoughts on PowerPivot and SharePoint BI http://blogs.msdn.com/b/analysisservices/ Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team. http://www.microsoft.com/en-us/bi/powerpivot.aspxTraining videos, examples, and other resources straight from Microsoft http://www.jamesserra.com/archive/2013/11/tabular-model-not-ready-for-prime-time/ Excellent blog on the limitations of the Tabular Model

  23. What is PowerBI? • Office 365 • Excel 2013 • PowerQuery Deep Dive on SQL Saturday • PowerPivot • PowerMap • PowerView • http://www.microsoft.com/en-us/powerbi/ • http://blogs.msdn.com/b/powerbi/

  24. Demo

  25. Thank You and Questions

More Related