1 / 18

Andrew Fryer Technical Evangelist Microsoft UK

Business Intelligence Whats Next?. Andrew Fryer Technical Evangelist Microsoft UK. Andrew.fryer@microsoft.com. . Consumerisation. Technology. Economy. Compliance. BI. Business Intelligence. . Uncertainty. Priorities. £ 0. Patchy. IT Budget. Economy. . Audit. Data Quality.

adeline
Download Presentation

Andrew Fryer Technical Evangelist Microsoft UK

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. Business Intelligence Whats Next? Andrew Fryer Technical Evangelist Microsoft UK Andrew.fryer@microsoft.com

  2. Consumerisation Technology Economy Compliance BI Business Intelligence

  3. Uncertainty Priorities £0 Patchy IT Budget Economy

  4. Audit Data Quality Standards Compliance Governance Risk & Compliance

  5. P R N D-S Social Media Ease of Use Expertise Agility Consumerisation

  6. Smart Devices Cloud Spatial Memory Technology

  7. BISM Microsoft BI

  8. BI Semantic Model 3rd Party applications Reporting Services Excel PowerPivot SharePoint Insights BI Semantic Model Multi- dimensional Data model Tabular Business logic and queries MDX DAX Direct Query Data access ROLAP VertiPaq MOLAP Databases LOB Applications Files OData Feeds Cloud Services

  9. BISM Self Service Microsoft BI

  10. Crescent

  11. Self-Service Alerting

  12. Data Quality BISM Self Service Microsoft BI

  13. Data Quality Services • Reference Data Services • DQS Server New Records SSIS Data Flow Values/Rules Data correction Component Source + Mapping Corrections & Suggestions Destination ReferenceData Definition Correct Records SSIS Package Knowledge Base Invalid Records Microsoft Confidential—Preliminary Information Subject to Change

  14. Data Quality Services

  15. Data Quality Column Indexes BISM Self Service Microsoft BI

  16. Column based indexes Row store: … C1 C2 C3 C4 C5 C6 Column store: Pages Uses VertiPaq compression

  17. © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related