Business Intelligence

Editor's Notes

• #3 Emphasis:1)The opportunity that organization faces Leaders were not given sufficient information to make decision. Without BI, there were given stacks of paper based reports at the end of quarter and usually, the leaders have NO TIME to analyze the details of these reportsThey are also overwhelmed with too much reports as ever detail were given, without much conclusion or summary as to whet the leaders wanted to see. Sometimes the reports bear conflicting numbers as they were extracted from different systems … This is confusing to the leaders and make it impossible for them to act accuratelyThus, 75% of companies fail to execute their strategies due to the basis flaw of information unavailability
• #4 Emphasis:1) DataMicron offer the `Next Generation Business Intelligence’, under the product family Performa.2) In Performa, our focus were on the following:BI Reports- where we have the web-based Pivot Table for drag-n-drop, ad-hoc query, analysis. Users create and save reportsBI Tools – This is an advanced visualization design tool to create dashboards, and without any programmingCorporate Performance Management (CPM) where users utilizes Dashboards to drive business and process performanceAll these functionalities are offered in ONE SINGLE application – PERFORMA BI SUITE
• #5 Emphasis:1)Phase 1: A long time ago, organization store their data and information on paper and some achieve this in tape drives2) This process is very manual and time consuming
• #6 Emphasis:1)Phase 2: Probably in the 80’s where computerization become popular and many applications were introduced to the business and organization2)This is where organization move quickly and adopt different systems and platforms and even operating systems3)Data were collected in an isolated manner across different systems4)Information were extracted in a Relational Manner (mainly using spread sheets) and then combining these spread sheets for analysis of data5) This is very manual and cumbersome6)There were NO Multidimensional analysis capabilities. Thus, limited analysis of business operations and strategies7) Note : Even until today, there are many organization and businesses using this method to extract data and for analysis
• #7 Emphasis:1)Phase 3: In the early 90’s Datawarehouse and Datamining become a requirement as organization strive to automate the process of data extraction from various systems and platforms2)Some companies went for the `Big Bang’ method where they believe that it is possible to extract all the relevant data for the whole organization into a single warehouse and then perform analysis using OLAP. This concept were mainly initiated by hardware and database vendors which wanted to make money by selling big boxes and highly priced Datawarehouses. But the fact is that such ideal situation is NOT practical as it may take years to extract all organization data, build relationships between tables and dimensions …. Casualties were high and companies end up with `White Elephants’3)Smarter companies resort to building Datamarts with OLAPs Cubes, and virtually connecting the OLAP cubes – Cheaper and better chance of success
• #8 Emphasis:1)Stage 4: The Internet become so popular and broadband is attainable at an affordable cost. Companies began to share information via the internet. This include web-based reports , emails etc.
• #10 Emphasis:1)DataMicron’s Performa BI Suite is ONE SINGLE product with the following (basically, it is value for money) - BI Tools : Advanced Visualization Tools (to design Dashboards, KPI’s, Business Performance Management) - BI Reports : Complete and Comprehensive BI Front-end for OLAP analysis 2)Note : We have studied the market and found that in terms of BI Analytics for OLAP, Cognos is the best. Now, with Performa: BI Reports, we have at least 90% of what Cognos has for BI Analytics . In additional, our Performa: BI Tools definitely is better in Dashboard designs. So far, we can confidently say that we offer the BEST Advanded Visualization Tools for Dashboards, with our patent pending technology3)It is 100% .Net compliance and tested and qualifiued in the USA by Veritest and Win Qual Microsoft Web-based browser (100% thin client)4)Performance : We have tested our application against Cognos using Load Runner, and it is faster than Cognos.5)Pricing: We are much lower in cost compared to Cognos or Business Objects, yet we have equivalent or even morre features
• #11 Emphasis:1)This list some benefits of Performa for organizations.2) In additional, there is a very good `Value For Money’ when organization uses Performa to improve the organization’s decision making process and drive performance to achieve its goals
• #12 Emphasis:BI Tools : Probably the ONLY one in the market that allows such flexibility and comprehensiveness in designing Dashboards. Currently , we have filed a patent (USA) in regards to the method of navigation of the Dashboard 2) Designing is by simply drag-n-drop of the controls from the available library. 3)Controls available –Charts, gauges, commentary box, alert buttons, buttons, labels, numeric indicators etc.4)Step-by-step design tools, without any programming5)Excellent to design KPI monitoring, and Business Performance Management
• #13 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #14 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #15 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #16 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #17 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #18 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #19 Emphasis:1)Example of Business Dashboard for FoodMark.2)You can see the blinking alert buttons overlaying a world map. 3)You can mouse over the controls to see the values versus targets set.4)You can also drill down on charts, and export to Word, Excel and Power Point5)Dashboards offer a high level view, and you can drill to lower level details.6)One of the important features of the BI Tools is users may drill to any of the pre-defines reports in BI Reports and then perform in-depth analysis. So far, to our knowledge, we are the ONLY company that has this feature
• #20 Emphasis:1)This shows a manufacturing process flow for ManuTech.2)This design is very impressive as the user can see the whole flow of the process by sliding the scroll bar.3)Any company with a process flow can use this design and view the process in a very user friendly manner.4)One of our manufacturing customer design the whole manufacturing flow based on this concept. They even have the different testers map in the visualization.5)They used this during meetings to see how well the daily production is going versus the targets. They also use the dashboard to see any issues and who is working on it.
• #21 Emphasis:1)This is a high level stock monitoring (Inventory Management) for a company called goMedia.2)Notice in this design, we use the orange/light brown color theme. Users are able to design any color theme that suits them
• #22 Emphasis:1)Sales Monitoring dashboard for NuVision.2)You can use the BI Tools to design KPI’s for high level sales monitoring3)Controls can be colour coded eg. The shape control and alert buttons
• #23 Emphasis:1)Service quality dashboard for NuVision.2)You can use the BI Tools to design KPI’s for service level monitoring3)Controls can be colour coded eg. The shape control and alert buttons
• #24 Emphasis:BI Reports – This shows the to features and capabilities of the product. Main point to emphasis is that the product is very robust and high-performance, and we have managed to ETL 6-8 million records per day, build OLAP cubes and users are able to view the reports and perform drag-n-drop within seconds (Project : DHL Asia Pacific)Performance Test were done using the Load Runner to simulate the loading (multiple users concurrently, bandwidth, CPU and RAM utilization, response time in browsing). Also testes were the drill-through to atomic dataVery few BI products in the market can deliver the type of performance that BI Reports provides
• #25 Emphasis:1)Drag-N-Drop capabilities Note: Some competitor products can’t even drag and drop. When drag-n-drop, you can drag-n-drop the whole Dimension (eg . Countries) or part of a Dimension (or member) eg. USA, Canada Most products ONLY allow you to drag and drop the whole dimension, but not the member of the dimension2)We can do Data-Schrolling (Other than Cognos, most other vendors cannot do this)3)Business Rules and calculations- Full and complete : Sort, Ranking, Percentage (3 types) , Average, Median, Summation, Customized Calculations
• #26 Emphasis:You can add symbols or indicators (which is also colour coded) based on the actual value versus targets. This allows the users to see the performance of the measures or data betterCognos DOES NOT have this feature
• #27 Emphasis:You can add symbols or indicators (which is also colour coded) based on the actual value versus targets. This allows the users to see the performance of the measures or data betterCognos DOES NOT have this feature
• #28 Emphasis:You can add color codes (which is a gradient from red –yellow-green) based on traffic light concepts. This allows the users to see the performance of the measures or data versus the targetCognos DOES NOT have this feature
• #29 Emphasis:You can apply HISTOBARS to the tables. Histobars are grat when you wanted to see the relative amount of each data cells versus the total.Cognos DOES NOT have this feature
• #30 Emphasis:1) Some high level Design Features of DataMicron Performa Suite
• #31 Emphasis:1) An illustration of the DataMicron Performa - BI Technology
• #32 EmphasisDataMicronPerfroma runs on the MS SQL 2000 and 2005It uses the Microsoft tools for the ETL (Extract, Transform and Load) to build the Datawarehouse. Most important, these tools is very high scalable and high performance …. And it is FREE compared to other BI vendors which may charge seperately for the ETL ToolsDataMicronPerfroma is the ultimate front-end BI tools for the MS SQL 2000 and 2005
• #33 Emphasis:Chart shows the different vendors in OLAP market shareDataMicron Performa is part of the Microsoft Ecosystem. It shows the highest improvement in market share over the yearsOne of the reasons for the increase in market share for Microsoft Ecosystem is because of the MSSQL 2000 and MSSQL 2005 has made tremendous improvements in Data Warehouse and OLAP technology
• #34 Emphasis:1)This is a very important Competitive Analysis of BI Suites 2)Basically, in the market we classify two (2) different class of vendors- Enterprise Vs. Non-Enterprise3)Enterprise vendors are such as Cognos (now acquired by IBM), Business Objects (now acquired by SAP), Hyperion (now acquired by Oracle), Microstrategy. 4)Non Enterprise vendors are not worth mentioning as their applications is very limited in features, and NOT scalable5)We compare the features by classifying % of vendors has such features.6)Features are broken down by : A) User Experience, B) Analysis and Data Exploration C) Technology, performance and scalability D) Pricing 7)Basically, with this competitive analysis, you will realize that DataMicron’s Performa is truly an Enterprise BI Suite, and offers the BEST Value
• #35 Emphasis1) Comparisons in Commercial, Technical and Professional Services.2) Basically, DataMicron’s Performa is Enterprise BI Suite, but we are offering it at `non-Enterprise’ pricing.3) It definitely is the BEST VALUE BI Suite in the market at the moment.4) We provide the BEST BI Solution … We can deliver 100% successfully. This is proven –refer to the customer satisfaction letters5) Performa can handle large scale data as evident in DHL Asia Pacific6) Our team is dependable and has excellent experience in both Business Intelligence and Data Warehouse7) Lastly, we offer the best ROI … and can guarantee successful implementations
• #36 Emphasis:1)Drag-N-Drop capabilities Note: Some competitor products can’t even drag and drop. When drag-n-drop, you can drag-n-drop the whole Dimension (eg . Countries) or part of a Dimension (or member) eg. USA, Canada Most products ONLY allow you to drag and drop the whole dimension, but not the member of the dimension2)We can do Data-Schrolling (Other than Cognos, most other vendors cannot do this)3)Business Rules and calculations- Full and complete : Sort, Ranking, Percentage (3 types) , Average, Median, Summation, Customized Calculations
• #37 End Of Presentation1)This material is ONLY meant for DataMicron’s potential Customers, Partners, Resellers and Alliances.2)Please DO NOT distribute this material without permission from DataMicron.
• #45 Emphasis:1)DataMicron’s list of BI implementations
• #46 Emphasis:1)DataMicron Customer Satisfaction Letters – Extracts of letters received from customers
• #48 End Of Presentation1)This material is ONLY meant for DataMicron’s potential Customers, Partners, Resellers and Alliances.2)Please DO NOT distribute this material without permission from DataMicron.