Business Intelligence Improving business insight A broad category
Business Intelligence Improving business insight “A broad category of applications and technologies for gathering, storing, analyzing, sharing and providing access to data to help enterprise users make better business decisions. ” – Gartner
Business Intelligence Adoption Challenges Users lack necessary skills TCO is high Difficult to learn and use Sources: - Gartner: The Business Intelligence Market Trends and Directions, 2006
Business Productivity Infrastructure Streamline the way people do business with 2007 Office system Unified Communications And Collaboration Workflow Search Business Intelligence Enterprise Content Management Business Open Extensible Data XML File UI Catalog Formats Secured, Well-Managed Infrastructure Website And Security Framework
Microsoft Business Intelligence Improving business insight Performance Management Reporting and Analysis Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions Data Warehousing
Performance Management Integrated solution to align and measure the business Improve corporate performance Scorecards to orient measurement to corporate goals Single model to align planning and analysis to the business process Span the organization with planning and measurement capabilities Accelerate management decision making Office Performance Point Server to integrate scorecarding, analysis and planning Integrated workflow for simpler consolidation and reporting Common model for planning used in analysis Enable collaborative analysis Integration with Office Excel for broad deployment of analysis capabilities Personalized scorecards and KPIs for individual views Collaborative environment with context for analysis
Reporting and Analysis Broad reach tools for insight Analyze information with powerful and familiar tools New Office Excel Pivot Tables for analyzing information using business terms Tight integration between Office Excel and Microsoft SQL Server Analysis Services Pro. Clarity for additional advanced analysis and visualization capabilities Enabling end-users with ad hoc reporting capabilities Report Builder for ad hoc reporting of relational or OLAP data Microsoft SQL Server Reporting Services for personalized views of management data Pro. Clarity for personalization of reports and briefing books Share reports and analysis over the web Excel Services for web based viewing of analysis Scorecards and dashboards for quickly disseminating information Report Center for centralized report management and repository
Data Warehousing Centrally managed, integrated, single version of the truth Integrate information from disparate sources Access corporate data in a heterogeneous environment Cleanse and transform data with high performance Ensure high quality data Store and manage vast amounts of detail data Maintain high performance for multiple users with varying workloads Tap multiple terabytes of atomic data for analysis Access granular and aggregate data for reporting Analyze information with an integrated view of your business Proactive Caching for real time analysis A centrally managed KPI engine for usage across the business Data mining for predictive analytics to determine what “will” happen
Microsoft Business Intelligence Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions Drive pervasive business performance Implement a complete and integrated business intelligence solution Deliver widespread intelligence through Microsoft Office Meet enterprise needs with affordable economics
Microsoft Business Intelligence An end-to-end integrated offering Performance Management Applications Business Pro. Clarity Analytics Scorecard Performance. Point Server 2007 6 Manager 2005 Office Share. Point Server 2007 Office Excel 2007 SQL Server 2005 Analysis Integration Services BI Platform SQL Server 2005 Reporting Services
Map Your Infrastructure Journey Improve business insight with Business Intelligence Data silos, custom and IT dependent reporting, Limited automation of data management Disconnected scorecards and IT dependant reporting and analysis on subjectoriented data Automation of data loading IT is a cost center IT is a more efficient cost center Infrastructure for enterprise-wide centralized scorecards and self-service reporting Centralized data management Federated document and records mgmt within and outside enterprise. Single search across desktop, enterprise content and LOB IT is a business enabler IT is a strategic asset
Case studies @ Public Sector United States Department of Agriculture (USDA) Υπουργείο Εσωτερικών
Case Studies The 5, 000 employees of the Illinois Department of Transportation work to provide safe, cost-effective transportation to the residents of Illinois. Among the Illinois Department of Transportation’s guiding principles is a dedication to providing quality programs through innovation. The organization continually endeavours to “do it right the first time, every time. ” With Performance. Point as a key part of its BI platform, IDOT plans to implement several invaluable dashboards that will help save lives and money. For example, a fatalities dashboard will track fatal crashes and help to identify high-crash locations and root cause. This will optimize the development of effective crash mitigation programs. Another useful dashboard will monitor road-salt usage by location, essential to the effective management of a high cost item. And these dashboards are only the beginning. IDOT plans to build many more, all aiming to provide it’s employees with direct and easy access to the information and analytics they’ll need to make better and faster decisions, drive efficiencies, and improve safety.
Case Studies Westminster City Council is a Local Authority serving the heart of London. Its 60 elected councillors needed a Members Information Portal that would allow them to monitor critical services such as planning, street care, and licensing in their neighbourhoods in near real time. Westminster City Council is a unitary authority providing local government services to 232, 000 people and 47, 000 businesses in London. Rated “excellent—four stars” by the Audit Commission, Westminster is a pioneer in the provision of leading-edge solutions for local government. The council’s 60 elected members serve a community that is highly diverse with complex needs, and which generates 2 per cent of the United Kingdom’s gross domestic product. The council members wanted new tools that would help them better engage with the residents in their neighbourhoods by providing real-time street-based information from council officers.
Case Studies The Department of Fisheries, part of the Ministry of Agriculture in France, manages all maritime activities in the country, including the regulation of the fishing industry. In 2006, the European Union (EU) cited the department for its inability to collect inspection data and generate reports appropriately. In two months, the Department of Fisheries implemented • Microsoft® Office Share. Point® Server 2007, • Microsoft Office Info. Path® 2007, and • Info. Path Forms Services With this integrated solution, the department can gather information digitally during inspections and then easily supply reports to the EU. In addition, the Department of Fisheries can predict potential infractions, focusing its inspections and ensuring that one of France’s most important natural resources is well protected.
Case Studies Israel Police needed to unite data from more than 20 intelligence applications to give its officers a faster and more efficient tool for solving crime. They needed an enterprise grade extract, transform, and load (ETL) tool for performing complex transformations on feeds before adding information to its new online analytical processing (OLAP) intelligence system. After testing Informatica Power. Center against Microsoft® SQL Server™ 2005 Integration Services, Israeli Police decided to use Integration Services for the ETL component of its OLAP solution. The 2 terabyte intelligence system, running on a single instance of SQL Server, helps Israeli Police intelligence officers complete data searches in seconds that once took days to assemble from disparate systems. Integration Services has also proven easy to incorporate into custom applications created using Microsoft Visual Studio®. NET.
Case Studies Greek Ministry of Interior Web Site for Greek Elections Attracts over 150 Million Hits Υπουργείο Εσωτερικών The Ministry of Interior is responsible for organizing voting for some 10 million Greek citizens, spread across 24, 500 voting districts, in national, local and European elections. Business Situation: The government wanted to boost the popularity of its election results service by increasing the traffic to its Web site, to offer mobile phone customers polling data by SMS messages and provide a compete service to political parties and the media. Solution : Microsoft®. NET Framework as the backbone of an improved election results service that was secure, multi-media and capable of handling more than 150 million hits over two week-ends on its Web site. Benefits: • Over 150 million hits on Internet election site • Automated service in real time to political parties and the media • Citizens get uniform reporting service • Election results by SMS • Bespoke service to hand held computers • Secure from hackers Partner(s): Delta Singular – HP - Microsoft Services Software and Services: Notification Services, Microsoft. NET Framework Microsoft Application Center, Microsoft SQL Server, Microsoft Visual Studio
Summary The Microsoft foundation for ubiquitous Business Intelligence is now in place – AMR research, October 2005 ü Complete and integrated BI offering ü Widespread delivery of intelligence through Microsoft Office ü Enterprise grade and affordable
Next Steps View the Business Intelligence website http: //www. microsoft. com/bi Review the Business Intelligence Product Guide http: //www. microsoft. com/office/preview Download the SQL Server evaluation copy http: //www. microsoft. com/sql/downloads/trial-software. mspx Explore 2007 Office system – Online through Web & Download Trials http: //www. microsoft. com/office/preview Visit Microsoft’s BI Case Studies @ Public Sector http: //www. microsoft. com/casestudies/
© 2006 Microsoft Corporation. All rights reserved. Microsoft, 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
- Slides: 20
