Data Warehousing Course
by Reliance Global ServicesHyderabad, Bangalore, Chennai |
Request Info |
Category: Data Warehouse | Data Integration, BI & Analytics
| Medium of instruction: | English |
A Data Warehouse is the main repository of an organization's historical data, its corporate memory. It contains the raw material for management's decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems.
Data Warehouse applications are designed primarily to support executives, senior managers, and business analysts in making complex business decisions. Data Warehouse applications provide the business community with access to accurate, consolidated information from various internal and external sources.
Topics Covered of Data Warehousing
Informatica
Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation and supporting all the steps of Extraction, Transformation and Load process. Informatica is an easy to use tool. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases. Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can effectively join data from two distinct data. In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
Cogonos
Cognos 8 Business Intelligence (BI) offers a single, strong BI reporting and analysis product for support of analytic and enterprise reporting. The product is strong in all three areas — analytic functionality, application development, and usability with comprehensive support for unification, internationalization, and open APIs, and strong support for OLAP, query, metadata, dashboards, and scorecards. Cognos is one of a growing number of vendors — including Actuate, Business Objects, Hyperion, Microsoft, and MicroStrategy — that offer both analytic and enterprise reporting capabilities. However, Cognos 8 BI is a completely new, Web-based product that incorporates much of the functionality from Cognos legacy BI products such as PowerPlay, Metrics Manager, Impromptu, ReportNet, and others. Cognos is a leader in both analytic and enterprise reporting.
Data Stage
The Cognos Banking Risk Performance application provides a simplified risk performance process to detect, control, and optimize risks. It is an agile packaged solution that includes predefined warehouse and target models mapped to the IBM Banking Data Warehouse, best practice analytic reports, and dashboards. The application is designed to provide banks with an efficient way to identify credit risk. It enables the bank to ensure that it is:
-
Originating loans that are in line with planned diversification
-
Maintaining delinquencies at or below the planned level
-
Managing past due funds as efficiently as possible
-
Maintaining capital and reporting according to Basel II requirements
| Classroom - Regular | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified | Not Specified | All Venues | Not Specified | Price On Request |
Bangalore, Jaya Nagar (Branch):- D.No: 362/7 , 3rd Floor, Above Ample Market, 16 th Main, 4th T Block Jaya Nagar, Bangalore - 560041, Karnataka, India
Chennai, Triplicane (Branch):- 107(New#203) Triplicane High Road, Triplicane, Chennai - 600005, Tamil Nadu, India
Reliance Global Services
Reliance Global Services Pvt Ltd is one of the fast growing IT solutions and services provider delivering best-in-class services to help clients reduce costs, enhance organizational flexibility, and improve business and IT performance. We have proven capabilities across various industry verticals. Our wide spectrum of solutions and services encompass ERP specialized in SAP Custom application development, Application maintenance and support. We offer Management-consulting services through Contract staffing enabled with in-house Competency development through- Strategic Innovation in Training
Reliance Global is a specialist outsourced software services company with a keen accent on ERP , specialized in SAP Consulting Services, Project Implementations (onsite and offshore), Remote Maintenance, Support Services . We also offer services in the areas of PeopleSoft, Oracle Applications, Data Warehousing Solutions and Web Services along with IBM and other prime technologies. We are preferred partner for several leading global companies. Relentless exploration of technology horizons, a unique Delivery Model, committed approach to quality and a judicious combination of onsite and offshore development, offer our clients a complete range of high-ROI business solutions spanning across the Business consulting, technology, operations and process outsourcing value chain.
Reliance Global management team comprises of ace professionals, each with years of managerial experience, rich industry knowledge and multidimensional skills. They form a formidable think tank with their industry knowledge, understanding of client requirements, processes and key client backgrounds.
