A Presentation on Business Intelligence
اسلاید 1: A Presentation on Business Intelligence June 10th 2003byPaul Balacky & Richard Fayers
اسلاید 2: TopicsIntroductionsCharacteristics of a Business Intelligence ApplicationDemonstrationDesign Issues
اسلاید 3: Introductions – Thorogood Associates LtdEstablished 1987 as Independent Business Intelligence Specialists45 peopleWe are located in London, High Wycombe, Manchester and Princeton USAMicrosoft Gold Certified Partner for Business Intelligence15 years experience in the application of Business Intelligence/OLAP technologiesWe partner with key players in the marketwww.thorogood.com
اسلاید 4: Characteristics of BI
اسلاید 5: Business IntelligenceThe term Business Intelligence (BI) is relatively new but the it is synonymous with a range of applications that have been around for years;Decision support systemsExecutive Information SystemsOn-line Analytical Processing (E.F Codd early 90’s) or multi-dimensional modellingIt is the conversion of data into information in such a way that the business is able to analyse the information to gain insight and take action
اسلاید 6: The BI CycleSource: Business Intelligence, Elizabeth Vitt
اسلاید 7: BI QuestionsWhat happened?What were our total sales this month?What’s happening? Are our sales going up or down, trend analysisWhy?Why have sales gone down? What will happen?Forecasting & What If AnalysisWhat do I want to happen?Planning & TargetsSource: Bill Baker, Microsoft
اسلاید 8: Where is Business Intelligence applied?ERP ReportingKPI Tracking Product ProfitabilityRisk ManagementBalanced ScorecardActivity Based CostingGlobal SourcingLogisticsSales AnalysisSales ForecastingSegmentationCross-sellingCRM AnalyticsCampaign PlanningCustomer ProfitabilityOperational EfficiencyCustomer Interaction
اسلاید 9: OLTP v OLAPOLTP systems model processesOLAP focuses on output and user reporting and analysis requirementsData warehouses support business decisions by collecting, consolidating, and organizing data for reporting and analysis with tools such as online analytical processing (OLAP) and data mining. (Microsoft)OLAP still requires a very formal approach
اسلاید 10: Business Intelligence SoftwareIntegration ofOLAP multi-dimensional technologyRelational database technologyWeb technologyScalability for warehousingFlexibility, performance and business viewsWeb deployment
اسلاید 11: Major BIOLAP VendorsOracle 9i OLAPSAP BWMicrosoft SQL Server 2000 & Analysis ServicesHyperion EssbaseIBMMicrostrategyCognosBusiness Objects
اسلاید 12: State of BI at the present timeRobust, scaleable, web deployable BI technologies are availableProblems are likely to lie in data complexity, process and peopleSuccessful implementation demands very close working between the business and the system providersChoosing products is as hard as everThere’s no such thing as a green field site (OLAP, Query & Reporting, RDBMS, ETL, Data Mining)ERP vendors are offering BI
اسلاید 13: The BI market has been turned upside down in the last 4 yearsMicrosoft has entered the market with dramatic impactOracle has lost momentumThe products best able to work with Microsoft’s platform were unknown 4 years ago
اسلاید 14: BI in Action
اسلاید 15: How Many Matches?
اسلاید 16: How Many Matches Now?
اسلاید 17: Concept of a Cube or Pivot TableDateProductRegionProduct – ChocolateDate – May 2003Region – South EastMeasure – SalesHow much Chocolate did we sell in the South East in May 2003?
اسلاید 18: SQL Server 2000Analysis ServicesRelational DatabaseDTSMDXInformixTextExcelOracleAccessSybaseSQL ServerFront-End ToolsClient ServerWebSQLClient ServerWeb
اسلاید 19: Design Considerations
اسلاید 20: Things to get right at design stageScope of projectBetter to phase project than big bangBusiness unit buy-inOwnership within the BU and clear goalsUser FocusManagement of user expectations becomes very important
اسلاید 21: Things to get right at design stageSource dataDo we have access?Often data in disparate sources and not always accessibleIs it at the same levelBudget data may be formulated at a higher summary level than actual data is sourced atProcessHow and when does the data get into the Warehouse?What level of data cleansing & transformation will be requiredWho is responsible?
اسلاید 22: Things to get right at design stageSource dataAre we able to match outputs to inputsMerging and matching of data sources Requirement for company wide data standards and definitionsAre there common keys?Hierarchy movements over time the need to restate or retain historic view?Timeliness of dataData volumesHandling of missing values and relationships
اسلاید 23: Things to get right at design stageCan you deliver the user/business requirements with the tools/skills availableSome things that look easy are sometimes notDimension changesThings that do not seem important to the developer are important to the business userFormatPerformanceSome things will be slow because they are slowManage expectationsProduct limitations
اسلاید 24: Things to get right at design stageReporting vs AnalysisThey may seem the same but they are notDifferent toolsDifferent approachDifferent audience
اسلاید 25: BI Design ParametersCubesNumber of cubes – possibly defined by business functions or securityNumber of dimensions per cube, shared or privatePartitions relating to data volumes and update speeds (cube processing times)Virtual cubes – cross functional analysisData storage options
اسلاید 26: DimensionsTypes of hierarchies - multiple, ragged, parentchild, balancedunbalancedSize, number of membersMember properties and how these could be used (attributes)Number of levels, children within each levelHierarchy changes over timeReporting views, scenariosBI Design Parameters
اسلاید 27: Time DimensionAlternative time hierarchies – calendar, financial13 period year – weeks to periodNumber of levelsBI Design Parameters
اسلاید 28: Timeliness of DataReal-timeNext dayWeekly reviews (possible weekend to process)Monthly reviews (month end processing)BI Design Parameters
اسلاید 29: MeasuresMethods of aggregationData entering cubes at differing levels required for comparisonsCustom rollupsNon additive dataPrecision, formatBI Design Parameters
اسلاید 30: Calculated MeasuresTime series calculationsSQL vs OLAP calculations (pre cube build vs post cube build)Calculated cellsNature of equations required to derive the calculated measuresCurrency exchange ratesDistributed processing opportunities (server calcs vs client side calcs)Application of MDXBI Design Parameters
اسلاید 31: Write-Back requirementsAllocationsbreak back requirements, level of data entryAudit logValidationBI Design Parameters
اسلاید 32: Output requirements User report definitions – format, layout, precisionTypes of adhoc analysisActionsRequirements for printed output Quantitative vs Qualitative data outputBrowserOffice deliveryOLAP database drill-through to SQL ServerNumber of usersReport maintainabilitySecurityBI Design Parameters
اسلاید 33: SecurityCubeDimensionCell levelBI Design Parameters
اسلاید 34: To consider when building BI applications..Users can fail to realise how much info they requested – leads to poor perceived performance Complexity due to a large number of dimensions – users don’t understand the model/numbersHard to test because they are conceptually complexPerformance vs storage – consider MOLAP/HOLAP/ROLAP, on-the fly versus pre-aggregated data
اسلاید 35: There is a strong case for a BI strategyBI can drive significant valueIt is an agile technologycrosses functional boundariescrosses organisational boundariesImplementation can involve many stakeholdersTactical BI applications may deliver significant value (and prove BI’s worth) …In a post boom business climate, BI offers a pragmatic way of delivering high return in the short term without major upheaval
نقد و بررسی ها
هیچ نظری برای این پاورپوینت نوشته نشده است.