business intelligence solution n.
Skip this Video
Loading SlideShow in 5 Seconds..
Business Intelligence Solution PowerPoint Presentation
Download Presentation
Business Intelligence Solution

Loading in 2 Seconds...

play fullscreen
1 / 29

Business Intelligence Solution - PowerPoint PPT Presentation

Download Presentation
Business Intelligence Solution
An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Business Intelligence Solution for Actionable Information

  2. Agenda • Offer • Business Intelligence Solution • Why C-BIA

  3. Offer

  4. Customized BI Solution • Customized BI Platform for every managerial position • Software • BI Tool for generating and rendering Information and Analytics • ETL Tool for pulling data from transaction and other operational systems on daily basis • Data Warehouse • System Administration Tools for information security and system maintenance

  5. Our Offer Actionable Information • Study business needs • Design solution using innovative ways of measuring, informing and analyzing performance • Business Intelligence (BI) Solution implementation • Support services On-time-zero-defect Delivery

  6. To Benefit You • Organization wide ‘Single-truth’ Information • Online Information up-to Previous Day closing • Interactive information Views, Graphs and Reports • Users can generate their own Views, Graphs and Reports • Analytics functions work on the fly – drill down to details, slice / dice, Top x, Rank Order • Saves thousands of hours of effort in developing information reports – Excel generated, Programmed reports by IT, etc.

  7. What is Different from other BI Solutions • Excel front-end, the most easy to use platform • Target Setting Tool • Advanced Analytics • Trends • Pareto • Statistical Analysis • Data Mining

  8. How Do We Enable Superior Performance? • Key Performance Indicators (KPI) aligned to Managerial Key Result Areas (KRAs) • Use of innovative measures of performance • Managers to assess their own performance on day-to-day basis, without time lag • Alerts to highlight concerns • Enable analysis for better quality of decisions

  9. Business Intelligence Solution

  10. Key Features of BI Solution • Actionable Information • Summary information to assess performance v/s target and benchmark • Discover low performing and high performing areas • Discover causes of low / high performance • BI Design • BI Portal • User Defined Graphical Dash Board • Key Performance Indicators (KPI) • OLAP Views • Reports • Leverage Technology • Dash Board – Display of Favorite Graphs, Dials and Alerts • Drill-down, Slice and Dice information • Reports – filter / sort information • Information access control • Ability to Use Management Framework like Balanced Score Card • Deploy analytical techniques – clustering, correlation, pareto analysis, trend analysis, distribution analysis

  11. Illustrative Business Processes for Hotel Industry • Rooms • Food & Beverages • Banquets • Other Services • Customer Acquisition, Retention and Attrition • Customer Satisfaction • Financial Performance • Inventory Management • Procurement • Maintenance & House Keeping • HR

  12. XLDashBoard Functionality for Actionable Information

  13. Look at all reports and views available subject-wiseSelect information from chosen subject

  14. Key Performance Indicators and their performance trends…Average Room Rate

  15. Graphical Dash Board for your Favorite Performance Charts….

  16. Study ….find Room Type-wise Occupancy & Revenue for a Year…

  17. Drill down study Low and High Performing Room Type-wise Occupancy & Revenue for a Month

  18. Look at user-friendly graphsRoom Revenue and % of Total Revenue by Market Segment

  19. Analyse ….Pareto ChartChannel wise contribution to revenue…

  20. Generate Trend chart…Gross Hotel Revenue.. By Customer Segments

  21. Generate a Report…Listing Daily Collection

  22. Technology and Architecture XLDashBoard tools and applications are built on Microsoft platform using tools:

  23. Why XLDashBoard? • Key Benefits • Enterprise wide application providing ‘single version of truth’ • Corporate and Departmental Managers can Analyze their Own Performance…and….save a lot of energy in constructing Excel based Reports and Charts • How delivered • Data stored in dedicated Data Warehouse and Information Cubes • Protected data • No voluminous queries run on transaction systems • Instantaneous response to users with summary information, drill-downs, slice and dice functions • BI delivered on Excel, a most familiar platform • Ability to build ad-hoc reports, new Query and Analysis Views • BI functionality comparable to any world class BI Application…. Plus, statistical analysis and data mining…. • Access control mechanisms • Cost Effective

  24. Why Syscon & C-BIA?

  25. Combining Management, Analytics and Technology Domains • We understand the language of business… • Experts at designing KPIs given Business Strategy and Critical Success Factors • Right methods for generating actionable information • Experts at Analytics … approaches for improving business performance • Leverage technology to its best potential

  26. History C-BIA, a division of TechKnit was founded in 2004 Cyrus Mehta, Ph.D. Founder and President Cytel Inc. Nitin Patel, Ph.D. Founder and Chairman Cytel Inc. Statistical Software, Consulting and Services for Clinical Trials BI Solutions and Analytics Services e-Tutoring and Educational Content

  27. Team of 40 people in Pune, consisting of: Business Analysis and Solution Design (Ph.D. and MBAs) Application Development Statisticians (Masters in Statistics) Web Interface Data Managers (MCAs) Tools Development (Masters in Statistics and Computer Science) Information Technology (Engineers and MCAs) Platforms SAS Microsoft Oracle Cognos Business Objects People Capabilities

  28. ProfitLogic, US B harat Petroleum, India Mastek, India Dainik Jagran, India Trumac, India TAM Media Research, India Savita Chemicals, Ind ia KPIT Cummins Infosystems Ltd. , India Tata Motors Ltd., India HDFC Standard Life Insurance KR Choksey, India Selected Customers

  29. Thank You Any Questions?