StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Data Warehousing and Business Intelligence - Coursework Example

Cite this document
Summary
The paper "Data Warehousing and Business Intelligence" describes that data mining will be done by the open-source WEKA software. The two techniques used are clustering and association. In clustering, we examine an individual and group it to make up a structure…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.5% of users find it useful
Data Warehousing and Business Intelligence
Read Text Preview

Extract of sample "Data Warehousing and Business Intelligence"

Data Warehousing and Business Intelligence Data Warehousing and Business Intelligence Data Audit 1. Describe your data (give an overview summary of your data set) Data Set information The dataset is reasonable and easy to use because it can be easily analysed. for example, a histogram to represent the number of people against age can be drawn. The histogram can be divided like in 18-50 age group to represent normal working age. the distribution obtained reveals the data set is reasonable. Data extraction was made possible by Barry Becker in 1994 from a census database. The records were obtained by passing the following conditions to the database: ((AGE>16) && (AGI>100) && (AFNLWGT>1) && (HRSWK>0)) The data warehouse consists of elementary data of all of the of the citizens information from the census. This was done to predict if an individual earns more than fifty thousand per annum. The attribute information are as follows Attribute lists: Salary less than 50,000 (>50K) , greater than 50,000 (50K) , greater than 50,000 ( 7073.5 and the age>21, the attribute is classified as a >50K. On the other hand, if age50K (0.0) | | | | | | Occupation = Craft-repair: >50K (1.0) | | | | | | Occupation = Transport-moving: >50K (0.0) | | | | | | Occupation = Farming-fishing: >50K (0.0) | | | | | | Occupation = Machine-op-inspct: >50K (1.0) | | | | | | Occupation = Tech-support: >50K (0.0) | | | | | | Occupation = ?: 50K (0.0) | | | | | | Occupation = Armed-Forces: >50K (0.0) | | | | | | Occupation = Priv-house-serv: >50K (0.0) | | | | | Capital-loss > 653: >50K (11.0) | Marital status = Married-civ-spouse | | Capital-loss 50K (0.0) | | | | | | | | | | | | | | Education = 5th-6th: >50K (0.0) | | | | | | | | | | | | | | Education = 10th: >50K (0.0) | | | | | | | | | | | | | | Education = 1st-4th: >50K (0.0) | | | | | | | | | | | | | | Education = Preschool: >50K (0.0) | | | | | | | | | | | | | | Education = 12th: >50K (0.0) | | | | | | | | | | | | Hours per week > 53: >50K (8.0/1.0) | | | | | | | | | | | Sex = Female | | | | | | | | | | | | Education = Bachelors: >50K (0.0) | | | | | | | | | | | | Education = HS-grad | | | | | | | | | | | | | Hours per week 50: 52: 50K (0.0) | | | | | | | | | | | | Education = Masters: >50K (0.0) | | | | | | | | | | | | Education = 9th: >50K (0.0) | | | | | | | | | | | | Education = Some-college | | | | | | | | | | | | | Fnlwgt 50K (21.0/4.0) | | | | | | | | | | | | Education = Assoc-acdm: >50K (2.0) | | | | | | | | | | | | Education = Assoc-voc: >50K (3.0/1.0) | | | | | | | | | | | | Education = 7th-8th: >50K (0.0) | | | | | | | | | | | | Education = Doctorate: >50K (0.0) | | | | | | | | | | | | Education = Prof-school: >50K (0.0) | | | | | | | | | | | | Education = 5th-6th: >50K (0.0) | | | | | | | | | | | | Education = 10th: >50K (0.0) | | | | | | | | | | | | Education = 1st-4th: >50K (0.0) | | | | | | | | | | | | Education = Preschool: >50K (0.0) | | | | | | | | | | | | Education = 12th: >50K (0.0) | | | | | | | | | | Workclass = Federal-gov | | | | | | | | | | | Hours per week 50K (81.0/28.0) | | | | | | | | | | Workclass = Local-gov: 50K (98.0/35.0) | | | | | | | | | | | Workclass = Without-pay: >50K (0.0) | | | | | | | | | | | Workclass = Never-worked: >50K (0.0) | | | | | | | | | | Race = Black | | | | | | | | | | | Fnlwgt 50K (10.0) | | | | | | | | | | | Fnlwgt > 209236 | | | | | | | | | | | | Age 45: 47: 50K (0.0) | | | | | | | | | | | | Education = Prof-school: >50K (0.0) | | | | | | | | | | | | Education = 5th-6th: >50K (0.0) | | | | | | | | | | | | Education = 10th: >50K (0.0) | | | | | | | | | | | | Education = 1st-4th: >50K (0.0) | | | | | | | | | | | | Education = Preschool: >50K (0.0) | | | | | | | | | | | | Education = 12th: >50K (0.0) | | | | | | | | | | | Workclass = Federal-gov: >50K (14.0/2.0) | | | | | | | | | | | Workclass = Local-gov: 50K (0.0) | | | | | | | | | | | Workclass = Self-emp-inc | | | | | | | | | | | | Age 50K (5.0/2.0) | | | | | | | | | | | | Age > 53: 50K (0.0) | | | | | | | | | | | Workclass = Never-worked: >50K (0.0) | | | | | | | | | | Race = Black | | | | | | | | | | | Relationship = Not-in-family: 50K (5.0/1.0) | | | | | | | | | | | Relationship = Wife: 44: 50K (0.0) | | | | | | | | Education = 11th: >50K (0.0) | | | | | | | | Education = Masters: >50K (0.0) | | | | | | | | Education = 9th: >50K (0.0) | | | | | | | | Education = Some-college: >50K (0.0) | | | | | | | | Education = Assoc-acdm: >50K (0.0) | | | | | | | | Education = Assoc-voc: >50K (0.0) | | | | | | | | Education = 7th-8th: >50K (0.0) | | | | | | | | Education = Doctorate: >50K (0.0) | | | | | | | | Education = Prof-school: 50K (0.0) | | | | | | | | Education = 10th: >50K (0.0) | | | | | | | | Education = 1st-4th: >50K (0.0) | | | | | | | | Education = Preschool: >50K (0.0) | | | | | | | | Education = 12th: >50K (0.0) | | | | | | | Native Country = Italy: >50K (2.0) | | | | | | | Native Country = Poland: >50K (0.0) | | | | | | | Native Country = Columbia: >50K (0.0) | | | | | | | Native Country = Cambodia: >50K (0.0) | | | | | | | Native Country = Thailand: >50K (0.0) | | | | | | | Native Country = Ecuador: >50K (0.0) | | | | | | | Native Country = Laos: >50K (1.0) | | | | | | | Native Country = Taiwan: >50K (0.0) | | | | | | | Native Country = Haiti: >50K (0.0) | | | | | | | Native Country = Portugal: >50K (0.0) | | | | | | | Native Country = Dominican-Republic: >50K (0.0) | | | | | | | Native Country = El-Salvador: >50K (0.0) | | | | | | | Native Country = France: >50K (0.0) | | | | | | | Native Country = Guatemala: >50K (0.0) | | | | | | | Native Country = China: 50K (0.0) | | | | | | | Native Country = Yugoslavia: >50K (0.0) | | | | | | | Native Country = Peru: >50K (0.0) | | | | | | | Native Country = Outlying-US(Guam-USVI-etc): >50K (0.0) | | | | | | | Native Country = Scotland: >50K (0.0) | | | | | | | Native Country = Trinadad&Tobago: >50K (0.0) | | | | | | | Native Country = Greece: >50K (0.0) | | | | | | | Native Country = Nicaragua: >50K (0.0) | | | | | | | Native Country = Vietnam: 50K (0.0) | | | | | | | Native Country = Ireland: >50K (0.0) | | | | | | | Native Country = Hungary: >50K (0.0) | | | | | | | Native Country = Holand-Netherlands: >50K (0.0) | | | | | | Occupation = Exec-managerial: >50K (827.0/188.0) | | | | | | Occupation = Handlers-cleaners | | | | | | | Capital-gain 50K (2.0) | | | | | | Occupation = Prof-specialty | | | | | | | Relationship = Not-in-family: 50K (962.0/262.0) | | | | | | | Relationship = Wife: >50K (121.0/29.0) | | | | | | | Relationship = Own-child: 50K (0.0) | | | | | | | Relationship = Other-relative: 50K (0.0) | | | | | | | | Education = 11th: >50K (0.0) | | | | | | | | Education = Masters | | | | | | | | | Age 56: 50K (0.0) | | | | | | | | Education = Some-college: >50K (0.0) | | | | | | | | Education = Assoc-acdm: >50K (0.0) | | | | | | | | Education = Assoc-voc: >50K (0.0) | | | | | | | | Education = 7th-8th: >50K (0.0) | | | | | | | | Education = Doctorate: 50K (0.0) | | | | | | | | Education = 1st-4th: >50K (0.0) | | | | | | | | Education = Preschool: >50K (0.0) | | | | | | | | Education = 12th: >50K (0.0) | | | | | | | Workclass = Federal-gov: 50K (1.0) | | | | | | | Workclass = ?: >50K (0.0) | | | | | | | Workclass = Self-emp-inc: >50K (62.0/16.0) | | | | | | | Workclass = Without-pay: >50K (0.0) | | | | | | | Workclass = Never-worked: >50K (0.0) | | | | | | Occupation = Craft-repair | | | | | | | Workclass = State-gov: >50K (1.0) | | | | | | | Workclass = Self-emp-not-inc | | | | | | | | Education = Bachelors | | | | | | | | | Hours per week 50K (2.0) | | | | | | | | Education = HS-grad: 50K (0.0) | | | | | | | Native Country = Portugal: >50K (0.0) | | | | | | | Native Country = Dominican-Republic: >50K (0.0) | | | | | | | Native Country = El-Salvador: >50K (0.0) | | | | | | | Native Country = France: >50K (0.0) | | | | | | | Native Country = Guatemala: >50K (0.0) | | | | | | | Native Country = China: >50K (0.0) | | | | | | | Native Country = Japan: >50K (0.0) | | | | | | | Native Country = Yugoslavia: >50K (0.0) | | | | | | | Native Country = Peru: >50K (0.0) | | | | | | | Native Country = Outlying-US(Guam-USVI-etc): >50K (0.0) | | | | | | | Native Country = Scotland: >50K (0.0) | | | | | | | Native Country = Trinadad&Tobago: >50K (0.0) | | | | | | | Native Country = Greece: >50K (0.0) | | | | | | | Native Country = Nicaragua: >50K (0.0) | | | | | | | Native Country = Vietnam: >50K (0.0) | | | | | | | Native Country = Hong: >50K (0.0) | | | | | | | Native Country = Ireland: >50K (0.0) | | | | | | | Native Country = Hungary: >50K (0.0) | | | | | | | Native Country = Holand-Netherlands: >50K (0.0) | | | | | | Occupation = ? | | | | | | | Hours per week 38 | | | | | | | | | Fnlwgt 50K (3.0) | | | | | | | Hours per week > 43: >50K (19.0/7.0) | | | | | | Occupation = Protective-serv: >50K (47.0/12.0) | | | | | | Occupation = Armed-Forces: >50K (0.0) | | | | | | Occupation = Priv-house-serv: 1762 | | | Capital-loss 50K (585.0/14.0) | | | Capital-loss > 1980 | | | | Capital-loss 2415: 12: >50K (62.0/2.0) | Marital status = Divorced | | Education-num Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Data Warehousing and Business Intelligence Coursework Example | Topics and Well Written Essays - 1500 words, n.d.)
Data Warehousing and Business Intelligence Coursework Example | Topics and Well Written Essays - 1500 words. https://studentshare.org/information-technology/1870262-data-warehousing-and-business-intelligence
(Data Warehousing and Business Intelligence Coursework Example | Topics and Well Written Essays - 1500 Words)
Data Warehousing and Business Intelligence Coursework Example | Topics and Well Written Essays - 1500 Words. https://studentshare.org/information-technology/1870262-data-warehousing-and-business-intelligence.
“Data Warehousing and Business Intelligence Coursework Example | Topics and Well Written Essays - 1500 Words”. https://studentshare.org/information-technology/1870262-data-warehousing-and-business-intelligence.
  • Cited: 0 times

CHECK THESE SAMPLES OF Data Warehousing and Business Intelligence

Data Warehouse, Data Mart and Business Intelligence

This discussion explores the differences between data warehouses and databases, data warehouse technologies, and the relationship between Data Warehousing and Business Intelligence.... hellip; Many organizations are increasingly adopting data warehousing to enhance reporting and decision making.... While databases are designed to record and store data, data warehouses are designed to respond to critical business queries.... Data bus mart with linked dimensional data marts architecture is designed to meet the needs of a specific business process....
4 Pages (1000 words) Essay

Business Intelligence Process

Therefore need for business intelligence to face the competitive environment and effectively cut the cost has become a significant part of every business.... business intelligence can be defined as the tools, technologies and processes require for converting data into information, information into knowledge and knowledge into plans that drive profitable business action (Loshin, 2012, p.... Conclusions drawn business intelligence is the process of gathering large quantity of data, assessing the data and offering a high end report set that compress the fundamental nature of the data into the foundation of the business activities, making the management able to make basic decisions related to the business....
5 Pages (1250 words) Essay

Factors Influencing Online Shopping Behavior of the Consumers of Thailand

‘Oracle Data Warehousing and Business Intelligence Solutions', Wiley Publishing, Inc: Indianapolis 10.... It can be recommended that for the purpose of establishing online shopping as a useful mode of shopping in Thailand the business houses can implement the business intelligence tools which help in restoring, preserving and processing the data.... business intelligence can be defined as the tools, technologies and processes require for transforming raw data into information, processed information into knowledge and readily available knowledge into framework that guide lucrative business acts (Loshin, 2012, p....
2 Pages (500 words) Dissertation

Enterprise system

Shedding Light on data Shadow Systems.... Enterprise System Name: Course: Tutor: Date: Q1: The purpose of the Enterprise System is to offer flawless information integration throughout the organization, in the different information areas of the organization.... These areas include the accounting and finances function, customer information, human resources and the supply chain management function (Davenport, 1998, p....
4 Pages (1000 words) Assignment

Impact of big data on data management functions

Data Warehousing and Business Intelligence Management7.... Thus, it has profound effect on scientific research, business intelligence, weather forecasting, etc.... In describing Big data, it is important to mention that worldwide data storage, management, and transaction rates have increased several times in the last 20 years.... Big data is a novel data… Big data can significantly rapidly capture, process, and manage enormous amounts of data having varied complexities and purposes (Snijders, Matzat, and Reips 2012)....
2 Pages (500 words) Essay

Master Data and Data Warehousing and Business Intelligence Management

The main focus of the paper "Master Data and Data Warehousing and Business Intelligence Management" is on explaining reference and master Data Integration Needs, on identifying reference Data Sources and contributors defining and maintaining the Data Integration Architecture.... This will contribute to confidence in matching and reducing data redundancy and there will be no conflict of individuals sharing names and similar or almost similar street addresses.... Reference data will include patient name, age, ethnicity, past medical records, body temperature, blood pressure and any other relevant individual data deemed necessary before a patient receives treatment....
6 Pages (1500 words) Essay

Business Intelligence

business intelligence is a concept that allows a business to gather and convert raw data related to both the internal and external operations of the business, into usable information for business decision-making purposes (Ranjan, 2009:65).... Thus, the basic relevance of the application of business intelligence within an enterprise draws from the ability of this raw Thus, business intelligence allows an enterprise to generate data related to the enterprise customers, competition and internal functions, to be able to predict and plan for the future performance of the business (Stackowiak, Rayman & Greenwald, 2007:27)....
4 Pages (1000 words) Essay

Real-time Business intelligence at Continental Airlines

Continental revolutionized its functioning by adopting strategies relevant to business intelligence.... Active data warehousing is a method used for implementing data warehouse which greatly supports the process of decision making in either near-real-time or near-time.... Active… data warehousing is characterized by actions that are event driven and provoked by a constant flow of queries raised by any application or people working in such an organization....
5 Pages (1250 words) Case Study
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us