The Leader in Global Product Development
Fact Sheet: Business Intelligence & Analytics GlobalLogic Quick Facts Founded in 2000 and backed bySequoia, NEA and New Atlantic
Ventures Headquartered in Vienna, Virginia,with European headquarters in the
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
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%.
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
Contact Us
• A solution that enables users to perform their own queries and generate ADHOC reports
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
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
BUSINESS INTELLIGENCE TOOL (BIRT) • Build GRID reports • Build GRAPH reports
• Lookups are supported
• Build GRID/GRAPH reports
• Tool supports creation of dimensions
• Build DASHBOARDS reports
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
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