logging in or signing up prak arasu011 dineashkumar1 Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 34 Category: Education License: All Rights Reserved Like it (0) Dislike it (0) Added: September 19, 2009 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... By: justinlong (10 month(s) ago) H@! guys i liked ur ppt can u please mail me !! this is my mail address justinlong522@yahoo.com Saving..... Post Reply Close Saving..... Edit Comment Close Premium member Presentation Transcript BUSINESS INTELLIGENCE : BUSINESS INTELLIGENCE BY PRAKASH.P THANIGAIARASU.R BUSINESS INTELLIGENCE : BUSINESS INTELLIGENCE Business intelligence (BI) is a broad category of applications and technologies for Gathering Storing Analyzing Providing access to data to help enterprise users make better business decisions. WHY BUSINESS INTELLIGENCE? : WHY BUSINESS INTELLIGENCE? BI allows organizations to get a more accurate and detailed picture of what is going on in terms of business and customers. WHY BUSINESS INTELLIGENCE? Cont…. : WHY BUSINESS INTELLIGENCE? Cont…. It can do this in different ways viz. accurate view of cost Liabilities Risks customer buying patterns supplier cost-effectiveness SQL Server 2005 We Need More Than Just Database Engine : Data acquisition and integration from multiple sources Data transformation and synthesis Knowledge and pattern detection through Data Mining Data enrichment with logic rules and hierarchical views Data presentation and distribution Data publishing for mass recipients SQL Server 2005 We Need More Than Just Database Engine Slide 6: Why….. Microsoft SQL Server 2005 delivers robust application programming interfaces (APIs) to extend product components on each tier….. Business intelligence must meet current requirements and provide for growth and future needs What’s New in SQL 2005 for BI? : What’s New in SQL 2005 for BI? Integrated platform. Improved decision making. Security and availability. Enterprise-wide analytical capabilities. TOP FEATURES : TOP FEATURES Data Integration Data Analysis Data Reporting Data Mining Slide 10: DATA INTEGRATION Data integration involves combining data residing in different sources and providing users with a unified view of these data. Slide 11: The ability to transform corporate data into meaningful and actionable information is the single most important source of competitive advantage in today’s business world. There are three broad categories of issues associated with data integration: DATA INTEGRATION(cont..) INTEGRATION SERVICES : INTEGRATION SERVICES A platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing. A new Microsoft SQL Server Business Intelligence Application. The successor to Data Transformation Services (DTS). The next generation high performance data integration Platform. INTEGRATION SERVICES ARCHITECTURE : INTEGRATION SERVICES ARCHITECTURE •Package Containers Tasks Precedence Constraints Connection Managers Data Flow Source Adapters Transformations Destination Adapters Paths Slide 17: TECHNOLOGY CHALLENGES ORGANIZATIONAL ISSUES ECONOMIC CHALLENGES CHALLENGES IN DATA INTEGRATION Slide 18: DATA ANALYSIS Data analysis is a process of gathering, modeling, and transforming data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making REQUIREMENTS Why? : Why? Analysis Services combines the flexibility and richness of the traditional relational reporting model with the user-friendly powerful analytics and the superb performance of the classic OLAP model. Major enhancements in enterprise capabilities including scalability, manageability, and productivity, soundly position Analysis Services Unified Dimensional Model : Unified Dimensional Model By combining the best aspects of traditional OLAP analysis and relational reporting, Analysis Services 2005 provides a metadata model that covers both sets of needs The UDM is a central metadata repository defining business entities, business logic, calculations, and metrics that serves as the source for all reports. The UDM provides a bridge between end users and their data : The UDM provides a bridge between end users and their data Proactive Caching : Proactive Caching Enables the combination of real-time updates with MOLAP class performance Analysis Services 2005 . Maintains a highly compressed and optimized data Advanced Business Intelligence in analysis : Advanced Business Intelligence in analysis Slide 24: Key Performance Indicator(KPI) Translations. MDX Scripts Semi-Additive Measures. Data mining : Data mining Data mining is a key member in the Business Intelligence (BI) “The process of extracting valid, authentic, and actionable information from large databases.” Mining Process : Mining Process With predictions Data Mining ProcessCRISP-DM : “Putting Data Mining to Work” “Doing Data Mining” Data Data Mining ProcessCRISP-DM www.crisp-dm.org TOOLS : TOOLS Data mining can be used to solve a several problems such as: Classification Clustering Regression Sequence Analysis Deviation Analysis Life cycle : Life cycle Business understanding Data understanding Data preparation Modeling Evaluation Deployment and maintenance DATA MINING ALGORITHM : DATA MINING ALGORITHM The data mining algorithm is the mechanism that creates a data mining model. To create a model, an algorithm first analyzes a set of data and looks for specific patterns and trends. Slide 31: Classification algorithms Regression algorithms Segmentation algorithms Association algorithms Sequence analysis algorithms Challenges of Data Mining : Challenges of Data Mining Scalability Dimensionality Complex and Heterogeneous Data Data Quality Data Ownership and Distribution Privacy Preservation Streaming Data Data reporting : Data reporting SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. Slide 35: It is administered via a web interface. Reports can be delivered in multiple formats interactively. He reports can be built together or separately. REPORTING SERVICES PROVIDES : REPORTING SERVICES PROVIDES • A high performance engine for processing and formatting reports • A complete set of tools for creating, managing, and viewing reports. • An extensible architecture and open interfaces for embedding reports or integrating reporting solutions in diverse IT environments • End-to-End Reporting 2005 Features : 2005 Features • Rich Client Printing • Multi-valued parameters • Interactive sort • Analysis Services support (i.e. MDX support) • SharePoint web parts • Report Builder REPORT BUILDER vs REPORT DESIGNER : REPORT BUILDER vs REPORT DESIGNER Slide 39: MAIN OBJECTIVE Core Product Improvements Better Integration Rich Developer Experience Empowering End Users Slide 40: ARCHITECTURE Reporting Life Cycle : Reporting Life Cycle REPORT AUTHORING REPORT MANAGEMENT REPORT DELIVERY REPORT SECURITY Slide 42: SQL Server 2000 Reporting Services delivered on the promise of cost-effective, enterprise reporting for the entire organization. SQL Server 2005 Reporting Services (SSRS) takes this promise to the next level Ssrs Contacts and Resources : Contacts and Resources Resources & reference: SQL Server 2005 Editions and Features: http://www.microsoft.com/sql/2005/productinfo Microsoft SQL Server 2005: http://www.microsoft.com/sql Microsoft SQL Server 2005 Business Intelligence: http://www.microsoft.com/sql/solutions/bi/default.mspx Prakash.P -prakvinoth@gmail.com Thanigai arasu.R -arasu008@gmail.com You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
prak arasu011 dineashkumar1 Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINT lite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 34 Category: Education License: All Rights Reserved Like it (0) Dislike it (0) Added: September 19, 2009 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... By: justinlong (10 month(s) ago) H@! guys i liked ur ppt can u please mail me !! this is my mail address justinlong522@yahoo.com Saving..... Post Reply Close Saving..... Edit Comment Close Premium member Presentation Transcript BUSINESS INTELLIGENCE : BUSINESS INTELLIGENCE BY PRAKASH.P THANIGAIARASU.R BUSINESS INTELLIGENCE : BUSINESS INTELLIGENCE Business intelligence (BI) is a broad category of applications and technologies for Gathering Storing Analyzing Providing access to data to help enterprise users make better business decisions. WHY BUSINESS INTELLIGENCE? : WHY BUSINESS INTELLIGENCE? BI allows organizations to get a more accurate and detailed picture of what is going on in terms of business and customers. WHY BUSINESS INTELLIGENCE? Cont…. : WHY BUSINESS INTELLIGENCE? Cont…. It can do this in different ways viz. accurate view of cost Liabilities Risks customer buying patterns supplier cost-effectiveness SQL Server 2005 We Need More Than Just Database Engine : Data acquisition and integration from multiple sources Data transformation and synthesis Knowledge and pattern detection through Data Mining Data enrichment with logic rules and hierarchical views Data presentation and distribution Data publishing for mass recipients SQL Server 2005 We Need More Than Just Database Engine Slide 6: Why….. Microsoft SQL Server 2005 delivers robust application programming interfaces (APIs) to extend product components on each tier….. Business intelligence must meet current requirements and provide for growth and future needs What’s New in SQL 2005 for BI? : What’s New in SQL 2005 for BI? Integrated platform. Improved decision making. Security and availability. Enterprise-wide analytical capabilities. TOP FEATURES : TOP FEATURES Data Integration Data Analysis Data Reporting Data Mining Slide 10: DATA INTEGRATION Data integration involves combining data residing in different sources and providing users with a unified view of these data. Slide 11: The ability to transform corporate data into meaningful and actionable information is the single most important source of competitive advantage in today’s business world. There are three broad categories of issues associated with data integration: DATA INTEGRATION(cont..) INTEGRATION SERVICES : INTEGRATION SERVICES A platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing. A new Microsoft SQL Server Business Intelligence Application. The successor to Data Transformation Services (DTS). The next generation high performance data integration Platform. INTEGRATION SERVICES ARCHITECTURE : INTEGRATION SERVICES ARCHITECTURE •Package Containers Tasks Precedence Constraints Connection Managers Data Flow Source Adapters Transformations Destination Adapters Paths Slide 17: TECHNOLOGY CHALLENGES ORGANIZATIONAL ISSUES ECONOMIC CHALLENGES CHALLENGES IN DATA INTEGRATION Slide 18: DATA ANALYSIS Data analysis is a process of gathering, modeling, and transforming data with the goal of highlighting useful information, suggesting conclusions, and supporting decision making REQUIREMENTS Why? : Why? Analysis Services combines the flexibility and richness of the traditional relational reporting model with the user-friendly powerful analytics and the superb performance of the classic OLAP model. Major enhancements in enterprise capabilities including scalability, manageability, and productivity, soundly position Analysis Services Unified Dimensional Model : Unified Dimensional Model By combining the best aspects of traditional OLAP analysis and relational reporting, Analysis Services 2005 provides a metadata model that covers both sets of needs The UDM is a central metadata repository defining business entities, business logic, calculations, and metrics that serves as the source for all reports. The UDM provides a bridge between end users and their data : The UDM provides a bridge between end users and their data Proactive Caching : Proactive Caching Enables the combination of real-time updates with MOLAP class performance Analysis Services 2005 . Maintains a highly compressed and optimized data Advanced Business Intelligence in analysis : Advanced Business Intelligence in analysis Slide 24: Key Performance Indicator(KPI) Translations. MDX Scripts Semi-Additive Measures. Data mining : Data mining Data mining is a key member in the Business Intelligence (BI) “The process of extracting valid, authentic, and actionable information from large databases.” Mining Process : Mining Process With predictions Data Mining ProcessCRISP-DM : “Putting Data Mining to Work” “Doing Data Mining” Data Data Mining ProcessCRISP-DM www.crisp-dm.org TOOLS : TOOLS Data mining can be used to solve a several problems such as: Classification Clustering Regression Sequence Analysis Deviation Analysis Life cycle : Life cycle Business understanding Data understanding Data preparation Modeling Evaluation Deployment and maintenance DATA MINING ALGORITHM : DATA MINING ALGORITHM The data mining algorithm is the mechanism that creates a data mining model. To create a model, an algorithm first analyzes a set of data and looks for specific patterns and trends. Slide 31: Classification algorithms Regression algorithms Segmentation algorithms Association algorithms Sequence analysis algorithms Challenges of Data Mining : Challenges of Data Mining Scalability Dimensionality Complex and Heterogeneous Data Data Quality Data Ownership and Distribution Privacy Preservation Streaming Data Data reporting : Data reporting SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. Slide 35: It is administered via a web interface. Reports can be delivered in multiple formats interactively. He reports can be built together or separately. REPORTING SERVICES PROVIDES : REPORTING SERVICES PROVIDES • A high performance engine for processing and formatting reports • A complete set of tools for creating, managing, and viewing reports. • An extensible architecture and open interfaces for embedding reports or integrating reporting solutions in diverse IT environments • End-to-End Reporting 2005 Features : 2005 Features • Rich Client Printing • Multi-valued parameters • Interactive sort • Analysis Services support (i.e. MDX support) • SharePoint web parts • Report Builder REPORT BUILDER vs REPORT DESIGNER : REPORT BUILDER vs REPORT DESIGNER Slide 39: MAIN OBJECTIVE Core Product Improvements Better Integration Rich Developer Experience Empowering End Users Slide 40: ARCHITECTURE Reporting Life Cycle : Reporting Life Cycle REPORT AUTHORING REPORT MANAGEMENT REPORT DELIVERY REPORT SECURITY Slide 42: SQL Server 2000 Reporting Services delivered on the promise of cost-effective, enterprise reporting for the entire organization. SQL Server 2005 Reporting Services (SSRS) takes this promise to the next level Ssrs Contacts and Resources : Contacts and Resources Resources & reference: SQL Server 2005 Editions and Features: http://www.microsoft.com/sql/2005/productinfo Microsoft SQL Server 2005: http://www.microsoft.com/sql Microsoft SQL Server 2005 Business Intelligence: http://www.microsoft.com/sql/solutions/bi/default.mspx Prakash.P -prakvinoth@gmail.com Thanigai arasu.R -arasu008@gmail.com