1 / 0

Do It Strategically with Microsoft Business Intelligence!

Do It Strategically with Microsoft Business Intelligence!. Bojan Ciric Strategic Consultant bojan.ciric@asseco-see.rs . Introduction Quiz. Domain of Business intelligence?.

duard
Download Presentation

Do It Strategically with Microsoft Business Intelligence!

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. Do It Strategically with Microsoft Business Intelligence!

    Bojan Ciric Strategic Consultant bojan.ciric@asseco-see.rs
  2. Introduction Quiz
  3. Domain of Business intelligence? … is the processing of data about customers and their relationship with the enterprise in order to improve the enterprise's future sales and service and lower cost. A …is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. B
  4. Who is the owner of the organizational data? Business Users IT department
  5. DW is a mandatory part of BI? TRUE FALSE
  6. Platform/Technology is most important factor of BI project success? TRUE FALSE
  7. BI Project team is consist of? A Mostly IT people with low Business people involved B Mixture of Business and IT people C Mostly Business people with low IT people involved
  8. Introduction
  9. Top reasons to use BI in the organization
  10. Tactical versus Strategically
  11. Organization presumptions for BI deployment It is an evolutionary process, as such it needs time to evolve BI as a technology is borderline worthless. As a religion, it can save an organization. However, without enlightened management, dedicated analysts, and a culture of data-driven decision making, there's very little utility in the technology. I would estimate, even in this technology ready age, that about 10% of organizations have management ready for these apps. That adds up to a lot of failed projects when this is prescribed as a cure-all.
  12. APOLLO 13:”HOUSTON, WE HAVE A PROBLEM!” There is a lot of data warehouse projects clamed as “success” upon implementation. However, a revisit after a few months with the business sponsors of the projects shows the utter failure. A majority of these failures are due to data quality issues. Moreover, various researches show that more than a half of data warehouse projects will result with failure in terms of: -Costs overruns -Time overruns -Project not delivered with required functionality Therefore, the right question is: how to be proactive in order to avoid to becoming ”failure” part of this statistic? Let’s find the answer.
  13. BI Architecture – Strategic Approach
  14. Critical Success Factors
  15. Implementation PrerequisitesTechnical Platform
  16. What users are looking for? Dashboards Visualization Predefined reports Easy to Access Ordinary Users Executives Easy to use Aggregated data Detail data Predictive Analysis Scenario Analysis Free form reports Can we use the same foundation for all types of users? Analysts
  17. User Adoption
  18. The Dreams Comes True?
  19. Agenda PART 1 Business Intelligence and Business Problem - Tactical or strategic approach? Do it on Strategic way! Establishing a BICC, Implementation methodology, Project Management Methodology, Platform and Tools Selection, Data Governance and Data Quality Policies, Standardization/Corporate Data Dictionary Project prerequisites (in details) Business Case Definition, Project Organization (roles and responsibilities), Designing Architecture, Project Plan, Mentor, Business Owner Project Implementation(in details) Business Requirements Analysis, Data Model definition, Data Source Analysis, Mapping Data Sources to the Data model, OLAP & UI modeling, Data Integration, OLAP & Front end development, Technical Deployment, Stabilization, Project Acceptance, Project Risk Mitigation (Risk Matrix, Issue Log) ------------------------------------------------------------------------------------------------------------------------------ PART 2 Using Microsoft BI platform for STRATEGIC implementations Data Integration - Microsoft SQL Server Integration services OLAP & data Mining – Microsoft SQL Server Analysis Services (Cube, Hierarchies, KPI, prediction) User experience Microsoft Office Excel as powerful BI Client (predefined and free form reports, pivoting, data visualization) Microsoft SQL Server Reporting Services Integration Microsoft Share Point Portal Server (dashboards) Miscellaneous Improve platform with Metamodel and custom developed components The new wave – Office 2010, SQL Server 2008 R2 Hands On – Solution Outline
  20. Goals COURSE LEVEL Terms and Conditions for Strategically Deployment Solution Architecture Design Deep down technical details Technical Platform understanding (Microsoft)
More Related