Data Warehousing Career Guide and Counseling

Question: Which of the following best describes the relationship between Data Warehousing and Data Mining? Which of the following best describes the relationship between Data Warehousing and Data Mining? a. Data Warehousing makes use of Data Mining by applying intelligent software. b. Data Mining makes use of Data Warehousing by applying intelligent software. c. Data Mining supplies the data for the Data Warehouse. d. Data Warehousing supplies the data for the Data

Answer: Answer: D. Is this for a class of some sort?

Question: What project i can do in data warehousing and data mining? i hav to do my final year project... i am willing to do it in data warehousing and mining... can anyone tell me about what kind of project i can select and do? and from where can i get resources to do the project.... Plz answer me

Answer: Could be problematic unless you're designing a purely theoretical application. These sorts of processes normally act upon huge amounts of data (often in the terabyte range), so getting your database together for a practical project is probably not an easy task. For a theoretical application, just think of something useful. For example, an analysis of purchasing patterns for a credit card company to identify anomalies that might indicate possible fraud.

Question: What does Data Warehousing experience mean? from a job desc ... Bachelor’s degree and six (6) years of professional work experience in Data Warehouse including systems analysis and programming work, design, development and implementation of large, complex data processing systems..... what does Data Warehouse mean.

Answer: I would imagine that if you have to ask, this is not the job for you. A ware house is a place to store large amounts of things, and a Data Warehouse would then be a way of housing or storing large amounts of data. The job is requiring experience in such management of data.

Question: Where can I get voluminous data for data warehousing or data mining practical? i am searching for voluminous data which i can use for my data mining project. Can anyone please help me in finding it on net?

Answer: u need to visit an midsize organisation at least to collect the data of their employees and also the transaction they do and all the data about the processes they run for....

Question: How do you measure productivity for data warehousing projects? What is the unit of measure..FP? or no. of ETL scripts or data warehouse size or any other?

Answer: You can put together a spreadsheet estimator based on the number of source tables and the number of target tables. I typicaly estimate from one to five days per ETL job where one is a simple load of a reference table and five days for a fact table load. This covers design, build and unit testing. A count of source and target tables gives you a rough estimate of the number of ETL jobs.

Question: what is the difference between Data Mining and Data WareHousing? further, what is the difference between database and data warehouse?

Answer: Data warehousing is the storage of data, typically summarized and prepared for analytical purposes, in contrast to "operational" databases, which are used in the real-time operation of a business or other organization. Data mining is a sophisticated statistical analysis of data, most often predictive modeling. As an example, consider a bank: operational databases record transactions and other changes to accounts in real-time. One or more data warehouses may be constructed which contain specialized summaries of the data in the operational database. For instance, one data warehouse might be used for the marketing department, another for fraud detection, and yet another to assess credit risk. Although data mining doesn't have to use a data warehouse as its source, in this case, data mining might be used, for instance, to analyze the credit risk of customers.

Question: How does data- warehousing work, what processes does it facilitate and its main concepts and technologies?

Answer: Abbreviated DW, a collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time. Development of a data warehouse includes development of systems to extract data from operating systems plus installation of a warehouse database system that provides managers flexible access to the data. The term data warehousing generally refers to the combination of many different databases across an entire enterprise. Contrast with data mart.

Question: Can you advise us on the data warehousing project? We have involved in doing a project in data warehousing...Please tell about the platform to be used,language to be used,software and hardware requirements, and other necessities....... and also resources to learn them..... Can you please help??......

Answer: A data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis. This classic definition of the data warehouse focuses on data storage. However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the dictionary data are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata. I hope this resources can be helpful: http://en.wikipedia.org/wiki/Data_warehouse http://www.dmreview.com/channels/dw_basics.html http://www.dwinfocenter.org/ http://datawarehouse.ittoolbox.com/

Question: How is the field of Data warehousing in the IT industry ? Is it good to pursue the career in future? I am currently working in the datawarehousing tool called as Webfocus and i am working in the 10g version of Oracle. Is this worth to pursue in this technology.......?

Answer: As long as there are computers, there will be a need for Data warehousing. This offers companies a back-up for disaster recovery plans. It will grow as more companies develop these disaster recovery plans. I believe that ISO 9001 requires a plan in order to be certified. Another promising field is electronic archiving of hard copies. So many companies have to hold onto old documents, but would like to have those stored electronically. The problem is the time involved in scanning and recording all these documents.

Question: how is the feauture for data warehousing? i am mca holder.i wish to do my project in chennai.is any institutes offering live projects.i am in confusion that live or dummy is better. can we get job as a fresher on data warehousing platform.which tools are better to learn. somebody said that calls for warehousing people are reduced.

Answer: 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... Bill Inmon, an early and influential practitioner, has formally defined a data warehouse in the following terms; Subject-oriented The data in the database is organized so that all the data elements relating to the same real-world event or object are linked together; Time-variant The changes to the data in the database are tracked and recorded so that reports can be produced showing changes over time; Non-volatile Data in the database is never over-written or deleted - once committed, the data is static, read-only, but retained for future reporting; and Integrated The database contains data from most or all of an organization's operational applications, and that this data is made consistent. A data warehouse might be used to find the day of the week on which a company sold the most widgets in May 1992, or how employee sick leave the week before the winter break differed between California and New York from 2001–2005. While operational systems are optimized for simplicity and speed of modification (see OLTP) through heavy use of database normalization and an entity-relationship model, the data warehouse is optimized for reporting and analysis (online analytical processing, or OLAP). Frequently data in data warehouses are heavily denormalised, summarised or stored in a dimension-based model. However, this is not always required to achieve acceptable query response times. *********************************************************************************************************************************************************** Data Warehouses are a distinct type of computer database that were first developed during the late 1980s and early 1990s. They were developed to meet a growing demand for management information and analysis that could not be met by operational systems. Operational systems were unable to meet this need for a range of reasons: * The processing load of reporting reduced the response time of the operational systems, * The database designs of operational systems were not optimized for information analysis and reporting, * Most organizations had more than one operational system, so company-wide reporting could not be supported from a single system * Development of reports in operational systems often required writing specific computer programs which was slow and expensive As a result, separate computer databases began to be built that were specifically designed to support management information and analysis purposes. These data warehouses were able to bring in data from a range of different data sources, such as mainframe computers, minicomputers, as well as personal computers and office automation software such as spreadsheet, and integrate this information in a single place. This capability, coupled with user-friendly reporting tools and freedom from operational impacts, has led to a growth of this type of computer system. As technology improved (lower cost for more performance) and user requirements increased (faster data load cycle times and more features), data warehouses have evolved through several fundamental stages: Off line Operational Databases Data warehouses in this initial stage are developed by simply copying the database of an operational system to an off-line server where the processing load of reporting does not impact on the operational system's performance. Off line Data Warehouse Data warehouses in this stage of evolution are updated on a regular time cycle (usually daily, weekly or monthly) from the operational systems and the data is stored in an integrated reporting-oriented data structure. Real Time Data Warehouse Data warehouses at this stage are updated on a transaction or event basis, every time an operational system performs a transaction (e.g. an order or a delivery or a booking etc.) Integrated Data Warehouse Data warehouses at this stage are used to generate activity or transactions that are passed back into the operational systems for use in the daily activity of the organization. *********************************************************************************************************************************************************** Advantages There are many advantages to using a data warehouse, some of them are: * Data warehouses enhance end-user access to a wide variety of data. * Decision support system users can obtain specified trend reports, e.g. the item with the most sales in a particular area within the last two years. * Data warehouses can be a significant enabler of commercial business applications, particularly customer relationship management (CRM) systems.

Question: What exactly is data warehousing? I am an MBA grad, specialised in Human resourse and marketing. what is the kind of job that i will land in if i do a course in data warehousing?

Answer: Here's the link thta i found online http://en.wikipedia.org/wiki/Data_warehousing based on that article try to figure out what the job scopes are. Good luck with ur career.

Question: What is the different between business intelligence and data warehousing?

Answer: Business Intelligence consists of various data points utilized in the assessment of business operation and performance. These data points are actual numbers or derivatives representing numerous aspects of the company, and certainly may vary widely in composition, depending upon your intelligence needs. Figures on things such as revenue, operating margin, sales backlog, overhead costs, etc... may be considered as elements of business intelligence. Data warehousing is merely a repository for computerized records maintained for reference via queries and reports. Perhaps, in order to appreciate the distinction, you might consider this; Business Intelligence is likely to be current information utilized as input to decisions or actions affecting immediate or future business conduct, while the data warehouse might retain historical data leveraged to reveal trends which would then be used as a piece of business intelligence. In my current position, I deliver "Competitive Intelligence" to my clients by collecting Business Intelligence data points for their competitors, which are available in the public domain, combine this with historical information retrieved from our proprietary data warehouse, and conduct further analysis upon my findings to afford insight regarding competitors' relative business posture and strategy.

Question: How lucrative is a career in Business Intelligence and data warehousing?

Answer: Robert Half Technologies released a 2008 Salary Guide Recently. Here are some data intelligence salaries for 2008. DB Manager: $88,750-$122,750 DB Developer: $76,250-$107,500 DB Administrator: $74,250-$106,750 Data Analyst/Report Writer: $57,750-$78,500 Data Architect: $85,750-$119,000 Data Modeler: $74,250-$102,000 Data Warehouse Manager: $90,750-$120,750 Data Warehouse Analyst: $78,250-$104,250 Business Intelligence Analyst: $78,250-$108,250 Of course, falling anywhere along those ranges depends on experience, responsibility, and knowledge of tools like Hyperion, which is a good thing to know how to do since Hyperion experts and in short supply and heavily demanded. If you want any information on one of the above titles, add a detail and I will check back later. If you are starting a career in data warehousing, you will probably start as a Data Analyst/Report Writer. As you develop your skills and acquire experience, seek opportunities for development and promotion. IT Consulting companies like Protiviti are always looking for database and business intelligence saavy people. Good luck! Let me know if you need any more info.

Question: What is the estimated salary range for a data warehousing and business intelligence consultant in Vancover? Hello there, this is Hani, I am Canadian, I was living in Montreal for 7 years then I've moved to work in Kuwait and I am still there for about 12 years, now, I am plannig to move to Vancover(BC) and I really know nothing about it. I am an IT data warehousing and business intelligence specialist, will it be easy for me to find such related job in Vancover. what is the min-max salary wage for this particular job and what about the IT market need for a person with 15 years experience having solid banking and financial back ground? How about the life style there and living expenses for a family of 4 members(me, my wife and 2 kids less than 5 years old) Can we save and travel at least once a year? Thank you for your help

Answer: The salary/remuneration for a particular job is the market value for a particular profession and designation at the city/town where the office is located. Job postings at websites like Monster, Yahoo HotJobs and Careerbuilder carry information about salaries. The Govt Dept of Labor, (www.bls.gov) Bureau of statistics has information about median salaries for different professions and details of additional compensation offered. Other online resources are salary.com and payscale. Your salary will also depend on your educational qualification and how you handle your career. More details and links to relevant websites available at http://tinyurl.com/rndxq

Question: How is the market for Data Warehousing in US? What is the average salary/annum in US? My experience is 3.2 years... Please let me know if you any idea in this regard... I know very well Datawarehousing..

Answer: Market and salary depends on type of experience you have what type of degree you have what field you worked in where in the US you will work You can find jobs at:

Question: Data warehousing training in Chennai? I have 2 yrs experience with SQL and PL/SQL. I'm planning to do Data warehousing course. Is choosing data warehousing right for me(with the experience that I have)? Or is it better to do Oracle application developer course? 1) Can anybody suggest me good training centers in Chennai? 2) Does anybody know about infitech in chennai and Sqlstar in chennai? Thanks.

Answer: Sorry, haven't heard of it.