bi presentation - rishabh software
TRANSCRIPT
Business Intelligence Capabilities
EMPOWERING BUSINESSES
Presentation Agenda EMPOWERING BUSINESSES
2
• Business Intelligence Overview
• Business Intelligence Market Overview
– Key Market Issues (Pain Points)
– BI Market Analysis
• Business Intelligence @ Rishabh
– History with BI
– BI Service Overview
– BI Service Offerings
• Experience with BI Tools
• BI Projects Case Studies
EMPOWERING BUSINESSES
3
• Business Intelligence (BI) is about getting the right information, to the
right decision makers, at the right time.
• BI is an enterprise-wide platform that supports reporting, analysis and
decision making.
• BI leads to:
– fact-based decision making
– “single version of the truth”
• BI includes reporting and analytics.
Business Intelligence Overview
EMPOWERING BUSINESSES
4
• Data everywhere, information no where• Different users have different needs
– Excel versus PDF– Pull versus push– On demand – on schedule– Your format – my format
• Takes too long – wasted resources/efforts• Security • Technical “Jargon” … Why I just can’t get it to you when you want it. • The impact of IBM, SAP and Oracle’s entry into the BI market through their
recent BI pure play mega-acquisitions is propelling IT majors to position themselves further away from being fixated with a particular type of data format, towards enhanced understanding and capabilities of managing diverse data types and formats.
• Key drivers include increasing uptake of BI and business optimization, an overarching need for business transparency, better corporate governance and the need comply with stricter regulations.
Key Market Issues (Pain Points)
BI Market Analysis EMPOWERING BUSINESSES
5
Since we are re-inventing the Business Intelligence market, our market is essentially the Business Intelligence market plus the midmarket which traditional BI vendors were not able to address. Below is a graph of the BI market size.
Rishabh’s History with BI EMPOWERING BUSINESSES
6
BI Service Overview EMPOWERING BUSINESSES
7
BI Service Offerings EMPOWERING BUSINESSES
8
Rishabh’s BI
Offerings
•BI Competency Centre•Business Requirement definition•Study & Analysis of Database•Assessments•Proof of concept development•Infrastructure recommendations
•Enterprise Architecture design•Management reporting & dashboards•BI Planning & forecasting•Financial, Managerial & Technical Consolidations•BI Technical Design & Architecture•ETL•Enterprise Data Integration•Master Data Management (MDM)•Maintenance & Support of systems
IBM Cognos EMPOWERING BUSINESSES
9
• Capabilities to provide solutions for:– Metadata modeling– Pixel-perfect reporting– Ad-hoc analytics– OLAP– Data transformation– Dashboard and scorecard tools– ETL
• Tools & Technologies used– Cognos 8 Business Intelligence Server
• Report Studio • Query Studio • Analysis Studio (Analytics)
– Cognos 8 Framework Server • Metrics Studio
– Cognos 8 Framework Manager – Cognos 8 PowerPlay Transformer – Cognos 8 Data Manager
SQL Server 2008 EMPOWERING BUSINESSES
10
• Capabilities to provide solutions for:– Data warehousing– OLAP– Budgeting– Analytics– Dashboards– Enterprise Reporting
• Tools & Technologies used:– Microsoft Office SharePoint Server– Microsoft SQL Server – SQL Analysis Services – SQL Reporting Services – SQL Integration Services
Reporting Services EMPOWERING BUSINESSES
11
• Reporting Services Capabilities:– Relational, multidimensional and XML data sources.– Tabular, matrix, chart, and free-form report layouts.– Ad hoc reports.– Drill-through reports and interactivity– Parameterized reports.– Presentation formats.– Custom controls or report items.– Navigation.– Aggregations.– Graphical elements.– Custom .NET code
BI Project Case Study EMPOWERING BUSINESSES
12
Project Name: Consolidation of Regional Data Warehouses
Description: Consolidation of regional BI Solutions to a centralized BI Solution for effective management of changes, master data, reporting and Licensing
Technology: Cognos 7.3/7 .4, SQL Server 2005, Windows 2000
Solution:• To implement one Cognos server instead of multiple instances • Delete unnecessary Cubes and Reports• Distributed Cognos Architecture• SQL Server Optimization & Migrate Cognos to Qlikview • Separate Gateway Installation• Distributed Processing Installation• Multiple Upfront Servers Installation• Improve performance of rebuilding cube process• Infrastructure recommendations for improved performance and load balancing
Business Benefits• Significant reduction of efforts in deployment and change management• Significant reduction in maintenance of consolidated server platform• Significant cost benefits by reduction of Licenses• Significant reduction in cost of overall maintenance and support activities• Significant reduction in cost due to minimal points of management• Improved User experience with uniform UI and reporting features• Summarized reports with single click reduces reports consolidation efforts
BI Project Case Study EMPOWERING BUSINESSES
13
Project Name: Taxation Reports Project Description: To develop different types of reports for the different applications used by the client
Technology: MS SQL Server 20005, IIS 6.0, .NET Framework 3.5, Visual Studio .NET 2008, Report Builder 2.0
Solution• Migration of data from legacy DB to SQL Server 2005• Data analysis & modeling to new requirements • Report development
Business Benefits• Scheduled reports, snapshots• Simple and cost-effective way to expose select information to user• Partner- and customer-facing reports online• Admin-defined privilege-based access to specific data.• Personalization and interactivity • Ability to satisfy information needs on-demand with high performance.• Professional, clean designs that support (not obscure) the business need.
BI Project Case Study EMPOWERING BUSINESSES
14
Project Name: Shipment Warehouse Description:To provide analysis of price, shortest shipping path, details of shipping by shipment company
Technology: MS SQL Server 20005, IIS 6.0, .NET Framework 3.5, Visual Studio .NET 2008, Report Builder 2.0
Solution• Data migration using EDI interfaces & ETL • Report development using SSRS 2008• Pre-process reporting data using SQL jobs.
Business Benefits• Scheduled reports, snapshots• Online analysis of shipment information by region, by shipment company
Business Queries
306/311, 3rd Floor, Gajanan Complex, Old Padra Road, Vadodara 390 020, Gujarat, INDIA
Tel: +91-265-2326267, 2326268, 2313056 | Fax: +91-265-2334644US Ph: +1-201-484-7302 | UK Ph: +44-0207 993 8162
Web: www.rishabhsoft.com | Email: [email protected]
Thank You