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

Recruitment:

Recruitment refers to the process of finding possible candidates for a job or function, undertaken by recruiters. It may be undertaken by an employment agency or a member of staff at the business or organization looking for recruits. Either way it may involve advertising, commonly in the recruitment section of a newspaper or in a newspaper dedicated to job adverts. Employment agencies will often advertise jobs in their windows. Posts can also be advertised at a job centre if they are targeting the unemployed. Suitability for a job is typically assessed by looking for skills, e.g. communication skills, typing skills, computer skills. Evidence for skills required for a job may be provided in the form of qualifications (educational or professional), experience in a job requiring the relevant skills or the testimony of references. Employment agencies may also give computerized tests to assess an individuals' off hand knowledge of software packages or their typing skills. At a more

Screening Resumes

When screening and evaluating resumes, recruiter must consider the following information: · Previous job responsibilities and past related work experience that may suggest future performance. · Special skills and qualifications. · Dates of employment. Staff will look for unaccounted gaps of time or conflicting dates, which may suggest instability or unsuccessful work experiences · Salary information. · Verifiable facts. Positions held, responsibilities, dates of employment, salary, etc. After the close date of the recruitment, the Job Expert for the hiring department and Human Resources will screen the application forms or resumes for minimum education and qualification requirements. A recruitment date may be extended if there are no qualified candidates. Recruitments can also be open until the position is filled; in this situation, applicants are reviewed and interviewed on a regular basis until an eligible candidate can be selected and appointed to the available position.

Phone Screening & Interviewing Techniques

Phone Screening: 1. Learn questioning techniques to minimise the time spent screening calls to eliminate unsuitable candidates, and identify and attract marketable ones. 2. Develop approaches for dealing effectively and diplomatically with unsuitable applicants. 3. Effectively prepare quality candidates for their interview with you, helping ensure their attendance. Interviewing Techniques: 1. Understand that the interview aims to balance efficient information exchange and effective relationship building. 2. Consider the importance of sound preparation for the interview, and what you can to do to maximise your professional credibility with the candidate. 3. Explore the utilisation of skill and psychometric testing, and understand the types of testing appropriate to specific candidates and situations. 4. Become aware of the importance of creating a positive first impression, and how to achieve this though the verbal, vocal and visual aspects of communication. 5. Follow a useful