Business Intelligence & Analytics
Content
The Leader in Global Product Development
Fact Sheet: Business Intelligence & Analytics
GlobalLogic Quick Facts
Founded in 2000 and backed bySequoia, NEA and New Atlantic
Overview
To stay competitive in the data mining and business intelligence (BI) space, complex data transformation and analytical reporting must keep pace with everchanging consumer needs and an increasing number of competitors. GlobalLogic partners with technology companies to deliver high quality BI and analytical reporting solutions that easily integrate with existing product offerings via a plug-in based framework. By leveraging our world-class engineers and proven GlobalLogic Velocity™ distributed Agile methodology and open source platform, clients realize both increased quality and dramatically reduced timelines – often by up to 30%.
Ventures
Headquartered in Vienna, Virginia,with European headquarters in the
Our Offerings
GlobalLogic has extensive expertise building end-to-end BI/Analytics solutions using open source technologies. Our offerings include: • A solution that provides interactive and professional business intelligence information • Low-cost plug-in framework that supports quality analytical reporting solutions • Customized platform with ready-made components that easily integrate with business information lying in disparate systems • Distributed Agile development methodology that reduces time-to-market and provides shorter release cycles • Expertise in multiple domains (Finance, Enterprise, Mobile and Telecom) • Conversion of data to user-required formats for framing a robust Decision Support System (DSS) • Analysis of data in disparate systems for generating consolidated reports or MIS reports such as financial analysis, sales comparison, top selling products and prime customers focus • Dimensional analysis of data • Architecture and capacity that is scalable both horizontally and vertically • Support for multiple databases and systems
UK and global delivery centers throughout the US, India, Ukraine and China Inc. 500 company with thousands of professionals worldwide Partnerships with more than 150 technology companies in markets that include Mobile, Telecom, Consumer, Healthcare and Enterprise Thousands of successful major product releases, including 300 in the last twelve months with a better than 95% on-time delivery rate InfoWorld award-winning distributed Agile method and platform (GlobalLogic Velocity™) Ranked a top employer in both India and Ukraine by IDC and Hewitt Associates
Contact Us
US: (+1) 703.847.5900 UK: (+44) 870.734.8602 India: (+91) 120.406.2000 Ukraine: (+38) 044.492.9693 China: (+86) 105.900.2309 Israel: (+972) 3.755.1300
• A solution that enables users to perform their own queries and generate ADHOC reports
www.globallogic.com
The Leader in Global Product Development
Fact Sheet: Business Intelligence & Analytics
Our Expertise
The figure below showcases GlobalLogic’s approach to developing end-to-end solutions for data transformation and analytics. The solution is designed to use best of open source technologies for data transformation (using KETTLE as an ETL tool) and analytical reporting (using BIRT as a BI tool). This solution is capable of handling any source/target databases available in today’s market.
S O U R C E
Data Model Tool • Tool identifies all kinds of source data structures • Users have option to define warehouse table structures on the fly • Lookups are supported • Tool supports creation of dimensions Data Transformation • Powerful metadata-driven ETL tool designed to bridge the gap between business and IT • Data warehouse population with built-in support for slowly changing dimensions, junk dimensions, etc. • Export of database(s) to text file(s) or other databases • Import of data into databases, ranging from text files to Excel spreadsheets • Data cleaning via application of complex conditions in data transformations
BUSINESS INTELLIGENCE TOOL (BIRT)
• Build GRID reports • Build GRAPH reports • Build GRID/GRAPH reports • Build DASHBOARDS reports
WAREHOUSE
• Denormalized structure (follow either star or snowflake schema) • Will store aggregated data • Will by default have data and currency-related dimension tables; user does not have flexibility to create/update/ delete these lookup tables using GlobalLogic data model tool • During first phase will not follow complete concept of a warehouse, but will have some presence of a warehouse
Data Loading • Loading of data through job scheduler
Our Technology Stack
ETL: KETTLE BI: BIRT Operating Systems: Windows, Linux, Solaris Databases: Oracle, SQL Server, MySQL, Text Files (fixed, csv), XML, EDI Files Other Technical Competencies: ETL: Informatica,Oracle Materialized Views BI: Microstrategy, Jasper Reports, Crystal Reports, Business Objects
www.globallogic.com
Fact Sheet: Business Intelligence & Analytics
GlobalLogic Quick Facts
Founded in 2000 and backed bySequoia, NEA and New Atlantic
Overview
To stay competitive in the data mining and business intelligence (BI) space, complex data transformation and analytical reporting must keep pace with everchanging consumer needs and an increasing number of competitors. GlobalLogic partners with technology companies to deliver high quality BI and analytical reporting solutions that easily integrate with existing product offerings via a plug-in based framework. By leveraging our world-class engineers and proven GlobalLogic Velocity™ distributed Agile methodology and open source platform, clients realize both increased quality and dramatically reduced timelines – often by up to 30%.
Ventures
Headquartered in Vienna, Virginia,with European headquarters in the
Our Offerings
GlobalLogic has extensive expertise building end-to-end BI/Analytics solutions using open source technologies. Our offerings include: • A solution that provides interactive and professional business intelligence information • Low-cost plug-in framework that supports quality analytical reporting solutions • Customized platform with ready-made components that easily integrate with business information lying in disparate systems • Distributed Agile development methodology that reduces time-to-market and provides shorter release cycles • Expertise in multiple domains (Finance, Enterprise, Mobile and Telecom) • Conversion of data to user-required formats for framing a robust Decision Support System (DSS) • Analysis of data in disparate systems for generating consolidated reports or MIS reports such as financial analysis, sales comparison, top selling products and prime customers focus • Dimensional analysis of data • Architecture and capacity that is scalable both horizontally and vertically • Support for multiple databases and systems
UK and global delivery centers throughout the US, India, Ukraine and China Inc. 500 company with thousands of professionals worldwide Partnerships with more than 150 technology companies in markets that include Mobile, Telecom, Consumer, Healthcare and Enterprise Thousands of successful major product releases, including 300 in the last twelve months with a better than 95% on-time delivery rate InfoWorld award-winning distributed Agile method and platform (GlobalLogic Velocity™) Ranked a top employer in both India and Ukraine by IDC and Hewitt Associates
Contact Us
US: (+1) 703.847.5900 UK: (+44) 870.734.8602 India: (+91) 120.406.2000 Ukraine: (+38) 044.492.9693 China: (+86) 105.900.2309 Israel: (+972) 3.755.1300
• A solution that enables users to perform their own queries and generate ADHOC reports
www.globallogic.com
The Leader in Global Product Development
Fact Sheet: Business Intelligence & Analytics
Our Expertise
The figure below showcases GlobalLogic’s approach to developing end-to-end solutions for data transformation and analytics. The solution is designed to use best of open source technologies for data transformation (using KETTLE as an ETL tool) and analytical reporting (using BIRT as a BI tool). This solution is capable of handling any source/target databases available in today’s market.
S O U R C E
Data Model Tool • Tool identifies all kinds of source data structures • Users have option to define warehouse table structures on the fly • Lookups are supported • Tool supports creation of dimensions Data Transformation • Powerful metadata-driven ETL tool designed to bridge the gap between business and IT • Data warehouse population with built-in support for slowly changing dimensions, junk dimensions, etc. • Export of database(s) to text file(s) or other databases • Import of data into databases, ranging from text files to Excel spreadsheets • Data cleaning via application of complex conditions in data transformations
BUSINESS INTELLIGENCE TOOL (BIRT)
• Build GRID reports • Build GRAPH reports • Build GRID/GRAPH reports • Build DASHBOARDS reports
WAREHOUSE
• Denormalized structure (follow either star or snowflake schema) • Will store aggregated data • Will by default have data and currency-related dimension tables; user does not have flexibility to create/update/ delete these lookup tables using GlobalLogic data model tool • During first phase will not follow complete concept of a warehouse, but will have some presence of a warehouse
Data Loading • Loading of data through job scheduler
Our Technology Stack
ETL: KETTLE BI: BIRT Operating Systems: Windows, Linux, Solaris Databases: Oracle, SQL Server, MySQL, Text Files (fixed, csv), XML, EDI Files Other Technical Competencies: ETL: Informatica,Oracle Materialized Views BI: Microstrategy, Jasper Reports, Crystal Reports, Business Objects
www.globallogic.com
