1 / 20

Building Business Intelligence capabilities with

Building Business Intelligence capabilities with. Isabelle Van Campenhoudt ICT7 http://blogs.codes-sources.com/thesqlgrrrl / ivc@icTè.com. Agenda. Gold mine. Years of activites are the treasure of an enterprise . YOU are the source of this treasure . BI Concepts. DECISION.

dutch
Download Presentation

Building Business Intelligence capabilities with

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. Building Business Intelligence capabilities with Isabelle Van Campenhoudt ICT7 http://blogs.codes-sources.com/thesqlgrrrl/ ivc@icTè.com

  2. Agenda

  3. Gold mine Years of activites are the treasure of an enterprise. YOU are the source of thistreasure.

  4. BI Concepts

  5. DECISION • what is the impact • of the colour of the shoes • in the quota of sale • in the region of Asia • after a spring campaign of advertising ?

  6. Dimensional Model • Fact Table contains: • Measure • Price • Quantity • Taxes • And FK to dimensions • Dimension Table contains description of fact • By customer • By supplier • In the time • By region • ….

  7. One Version of the Truth BI Process

  8. People & Tools

  9. Resistance • Cross the data ? • Makethings clean • @source : • Ooopsdirtyinconsistent data ? How couldthathappen • @reportinglevel: • Waw amazingresult but whyso…different ?

  10. Technical challenge

  11. BI SQLCommon Architecture

  12. Integration Services

  13. Demo

  14. Analysis Services?

  15. Demo

  16. Reporting Services

  17. SQL andSelf-Service BI?

  18. PowerPivot pour Excel 2010 Slicer

  19. Excel, (Word, PowerPoint) • Analysis • PowerPivot • Data exploration & analysis BUSINESS USER EXPERIENCE BUSINESS COLLABORATION PLATFORM • Dashboards & Scorecards • Excel Services • PowerPivotfor SharePoint • Visio Services DATA INFRASTRUCTURE & BUSINESS INTELLIGENCEPLATFORM • SGBD, • ETL, • OLAP, • Reporting, • MDM

  20. SQL 2008r2 BIKey Capabilities

More Related