Skip to main content

Data Warehousing

Data Warehouse “Provides information on techniques to design, build, maintain and retrieve information from data. a. AB initio – is a database module. b. Business Intelligence – BI is a process of enhancing data into information and then into knowledge. Gather, store, analyze and provide access to data. c. Informatica – database module. d. ETL - Extract, transform, and load (ETL) is a process in data warehousing that involves, extracting data from outside sources, transforming it to fit business needs, and ultimately ,loading it into the data warehouse. ETL is important, as it is the way data actually gets loaded into the warehouse e. Cognos – is an Ottawa, Ontario based company which makes business intelligence (BI) and performance planning software. f. Data Stage – Is used for data extraction, transformation and loading (ETL) solution for information intensive companies, Offers end to end Meta data Management and data integration Applications such as CRM (Customer Relation Management), ERP (Enterprise Resource Planning), and SCM (Supply Chain Management). g. OLAP - Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining. h. Report Net - Cognos Report Net. Cognos Report Net improves your performance, reduced costs—complete reporting coverage and zero-footprint environment reduce maintenance. Quicker results—seamless integration and adaptive authoring shorten reporting times. Improved decision-making—reports and dashboards present critical data in easy-to-understand formats. Increased agility—create one version of data truth across divisions, departments, countries, and more.

Comments

Popular posts from this blog

DO and DON'T on a call

Don't Ask-- Only with the individual's consent: --School, college records Yes: --Social Security number --Performance at prior workplace --Credit report (but with notice to the applicant in California, Minnesota, Rhode Island, Vermont). (Under federal regulations, credit inquiries that tend to have a disparate impact on minority applicants, disabled persons or women may be closely scrutinized.) Generally Yes: --Smoke at home (The question could lead to a lawsuit; 31 states ban policies prohibiting off-duty smoking.) --Political affiliation (Some states ban discrimination on this basis and political affiliation may not be used for discriminatory purposes in federal-government employment.) Yes: --Ability to perform certain functions **The Americans with Disabilities Act governs these inquiries. Only after a job offer and only if all are treated the same: --Medical examination --Medical conditions --Urine test for drug use (13 states have further restrict...

Project SDLC

For a general understanding of the Project SDLC and we would also like to add that there can be changes to the user or roles and responsibility of the different participants mentioned in the SDLC. Most of the times recruiters are confused as to what is SDLC and wonder about the different roles and responsibilities carried out by the participants mentioned below. Explanation provided below will actually help you understand different user with in the different phases of SDLC and where they come into picture to actually be in a better position to question a consultant against the requirement on hand. It is important to understand the needs, goals, and challenges of the project .The Customer objectives can be defined by the business requirements which are used to determine the scope of the system. When start by defining the business requirements, it is important that the team look at all type...

Reference Checking & Presenting to the Client

Reference Checking: It a process of checking the Employment History of an individual against the reference He/She has furnished. The type of checking will be as per the requirement from the Hiring manager/ HR Manager. 1. Explore methods of communicating with referees to encourage open and frank discussion. 2. Utilise Competency Based / Behavioural Description questioning to gain deeper insight into competencies and avoid personal bias. 3. Turning the reference check into a marketing opportunity. 4. Consider a structured, systematic short-listing method. Presenting to the Client: 1. Develop the ability to confidently present the short-list to the client, including coaching the client on interview etiquette, where necessary. 2. Investigate how to prepare the candidate for success in the client interview, including constructive counselling on areas for improvement. 3. Follow a guide for post-interview debriefs with candidate and client to uncover and address issues, and manage t...