microsoft business intelligence bi n.
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Business Intelligence (BI) PowerPoint Presentation
Download Presentation
Microsoft Business Intelligence (BI)

Loading in 2 Seconds...

play fullscreen
1 / 25

Microsoft Business Intelligence (BI) - PowerPoint PPT Presentation

  • Uploaded on

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

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Microsoft Business Intelligence (BI)' - vinaya

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
about me
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:
  • Family:
types of solutions i work
Types of solutions I work

Also, we have created BI solutions in the Manufacturing, Insurance, Financial, Government,

Supply-Chain, and other industries.

  • 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
what is self service business intelligence ssbi
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.
visualizations ms bi history types
Visualizations - MS BI History & Types

Excel Pivot Table



SharePoint Required

1993, 2007 with SSAS

2007 w/SharePoint

2004 w/SQL Server 2000



Excel 2013, Office 365, Power BI

SQL Server 2012 Tabular & SharePoint 2010,

Excel 2013,

SQL Server 2012 SP1 CU4 SSAS Multidimensional

models microsoft bi history types
Models - Microsoft BI History & Types

Multidimensional Analysis Services

Tabular Analysis



SQL Server 2008R2, Excel 2010, SharePoint 2010



OLAP released SQL Server 7 in 1998

SQL Server 2012



Tools from


MS BI Decision Frameworks - Models



Start with a sound foundation – The Model

Star Schema






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

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
important links
Important Links

Extensive Blog for many aspects on PowerPivot

The First PowerPivot Formulas (DAX) Book Written Specifically for Excel Users

A blog concerning of thoughts on PowerPivot and SharePoint BI

Information, tips, news and announcements about SQL Server Analysis Services and PowerPivot directly from the product team. videos, examples, and other resources straight from Microsoft

Excellent blog on the limitations of the Tabular Model

what is powerbi
What is PowerBI?
  • Office 365
  • Excel 2013
  • PowerQuery Deep Dive on SQL Saturday
  • PowerPivot
  • PowerMap
  • PowerView

Thank You