Business Intelligence Meet Current Market Challenges With Business Insight

1. Business IntelligenceMeet Current Market Challenges With Business Insight

2. Company Overview • Established: • Based in Illinois (USA), serving multiple industries including many Fortune 500 companies since 1997 by experienced IT professionals. • To offer cutting edge IT services globally • help organizations both in Public and Private sector to improve and modernize their services • supplementing organization’s skill set with team augmentation • On-site resource deployment • Improved Return-on-Investment (ROI) by taking projects offshore Achievements: To date, Royal Cyber Inc. has grown into a reputable IT firm not only in USA but also in European, Middle Eastern and South Asian Markets.

3. Agenda • Right Decision at Right Time • How Technology (BI) can help? • Meet Current Market Challenges with Business Insight • Solution Showcase • Microsoft Business Intelligence Solution Suite • IBM Cognos® Business Intelligence Solution Suite • Few samples • Technical/Business Q/A Session

4. Royal Cyber Inc. World Wide Offices • Royal Cyber Inc. was established in 1997 by accomplished Business Consultants and IT Professionals with the objective to offer quality IT services to US based companies with focus on Chicago based companies. Since then Royal Cyber has grown into a well established and reputable IT company not just in Chicago – Illinois but around the globe. Regional Office South Asia Dubai Office UAE Regional Office Australia Head Office Chicago – Illinois London Office United Kingdom Riyadh Office Saudi Arabia Regional Office Canada

5. Partners • IBM Premier Business Partner • IBM Authorized Trainer

6. Right Decision at Right Time (Overview) Microsoft Survey data - Oct08 What is Business Intelligence? Business Intelligence refers to application and technology, which is used to: • Gather, understand and analyze data • Prepare trends to help predict future goals and achieve them • Prepare dashboards for top level management Microsoft believes SMB will continue to have interest in BI with 39% anticipated increase 23% polled in Oct 08 to invest in BI technology solutions to make users more productive 20% are looking toimprove data management.

7. Right Decision at Right Time (The Five Questions)

8. How Technology (BI) can help? (The Five Answers)

9. How Technology (BI) can help? (Overview)

10. Meet Current Market Challenges with Business Insight Why do you need better reporting, analysis, and scorecards? • Track holistic business performance (bank accounts, sales activity, operational efficiency) • Identify user trends to more easily find and retain customers • Respond to new customer opportunities faster We can provide technology to help you: • Make better-informed decisions that save you time and money and stay productive • Keep your business focused on effective, profitable activities that attract customers

11. Solution Showcase (at a Glance) • Microsoft Business Intelligence Solution Suite • Microsoft BI Solution provides complete business intelligence (BI) capabilities that deliver the right • information, at the right time, and in the right format for: • Performance Management with Rich Scorecard Functionality • Reporting & Analysis with Advanced Visualization • Data Warehousing with Powerful Integration Services • IBM Cognos ® Business Intelligence Solution Suite • IBM Cognos ® BI delivers the complete range of BI capabilities i.e. Reporting, Analysis, Dashboards, Scorecards and Event Management on a single service-oriented architecture

12. Microsoft Business Intelligence Solution Suite (Overview) Microsoft SQL Server Integration Services (SSIS) – SSIS offers a redesigned and highly scalable enterprise extract, transformation and load (ETL) platform for building high-performance data integration solutions. It offers –Rich development environment, Visual debugging tools, Data quality tools, Extensible architecture, Out-of-the-box high performance transformations. Microsoft SQL Server Analysis Services Microsoft SQL Server Analysis Services (SSAS) data mining and OLAP capabilities help you build complex analytical models that you can integrate with your business operations. It offers –Unified Dimensional Model, Data mining algorithms, Proactive caching, Advanced BI capabilities Microsoft SQL Server Reporting Services Microsoft SQL Server Reporting Services (SSRS) offers a complete and comprehensive reporting solution for creating, managing, and delivering traditional managed reports, interactive end-user reports, and embedded reports which can easily integrate with SharePoint, Office applications, Emails, Calendar, PDF and many more.

13. IBM Cognos® Business Intelligence Solution Suite (Overview) Report Studio – Professional report authoring tool formatted for the web Query Studio – Ad-hoc report authoring tool with instant data preview Analysis Studio – Multi-dimensional cube data to answer business questions Metric Studio – Monitor, analyze, and report on KPIs Metric Designer – Define, load, and maintain metrics to be available in Studio Event Studio – Action based agents to notify decision makers as event happen Framework Manager – Semantic metadata layer tool which creates models

14. Few Sample Solutions - KPI Dashboards: Trends graphs: Draws a trend for future reading past and current data. Helps proactively resolve problems More of a top-level management dashboard which summarizes all important data points with alerts, if any

15. Few Sample Solutions - Tracking information in detail: Thermal graphs: Used for critical data points to compare current value with target to achieve Get important data points in one view and co-relate them

16. Few Sample Solutions - Drilldowns: Detail report with data and comparisons to previous defined period (quarterly, mid-yearly, yearly, etc.)

17. Few advantages of Microsoft BI over COGNOS - Licensing – COGNOS is a suite of separate applications that need to be licensed separately, as opposed to SQL Server which is a single product UI less intuitive – COGNOS user interface is not as intuitive as Microsoft user interface. It requires additional end user training. Less data mining and predictive analysis – They have less data mining and predictive analysis capabilities then SQL Server 2005. Existing SQL Assets – Many times companies have SQL Server licenses for their databases and want to extract more value from those licenses. Performance – Many COGNOS users report unsatisfactory performance from deployments Skills availability – There are simply more Microsoft BI developers out there, and generally they cost less to employ and are cheaper to train Application Integration and black box – Microsoft applications are quite open in terms of connectivity, customization and integration with other applications. COGNOS is a closed box.

18. Contact Us For IBM Products: http://bi.royalcyber.com • Shabbir H Mala • Head of Business Intelligence and SharepointSolutions • Call: +1 312 363 9851 PAK : Caesers Tower ( National IT Park ), Office No: 1101 , 1102 , 1103 , 1104, Shahrah-e-Faisal Call : +92-21-32803061 • USA : Royal Cyber 55 ShumanBlvd, Suite 1025, Naperville, IL 60563 • Call: 1-630-355-6292