scispace - formally typeset
Open AccessJournal ArticleDOI

A Realistic Data Warehouse Project: An Integration of Microsoft Access[R] and Microsoft Excel[R] Advanced Features and Skills.

Michael A. King
- 01 Jan 2009 - 
- Vol. 8, Iss: 1, pp 091-104
Reads0
Chats0
TLDR
The purpose of this paper is to provide an overview of how to construct a realistic data warehouse using numerous advanced features available in Microsoft Access and Microsoft Excel.
Abstract
Business intelligence derived from data warehousing and data mining has become one of the most strategic management tools today, providing organizations with long-term competitive advantages. Business school curriculums and popular database textbooks cover data warehousing, but the examples and problem sets typically are small and unrealistic. The purpose of this paper is to provide an overview of how to construct a realistic data warehouse using numerous advanced features available in Microsoft Access and Microsoft Excel.

read more

Content maybe subject to copyright    Report

Citations
More filters
Journal ArticleDOI

Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool

TL;DR: A methodology for designing data warehousing applications from various sources based on ontologies, which reduces most important types of conflicts that may exist in sources and requirements and facilitates the sustainable urbanization of the target data warehouse.
Journal ArticleDOI

A Tools-Based Approach to Teaching Data Mining Methods

TL;DR: A data mining course in an Information Systems program has an analytical component, a tools-based, hands-on component, and a rich collection of data sets, and the application of mining models for decision support and prediction.

Building Data Warehousing and Data Mining from Course Management Systems: A Case Study of FUTA Course Management Information Systems

TL;DR: In this paper, the authors present the benefits of data warehouse and to sensitize companies in Nigeria to start building these facilities into their enterprise resource management systems with the aim of making effective business decisions that will promote the rapid growth of the companies.
Dissertation

Ensemble Learning Techniques for Structured and Unstructured Data

TL;DR: HONORS and AWARDS 2012: R. B. Pamplin Doctoral Fellowship from IBM Academic Initiative for IBM SPSS Modeler Premium software.
Journal ArticleDOI

Design and Delivery of Technical Module for the Business Intelligence Course.

TL;DR: The pedagogical design and the delivery method of a practicable technical module for a nontechnically oriented Business Intelligence course is presented and preliminary student feedback has indicated the usefulness of this technical module.
References
More filters
Book

Database systems : design, implementation, and management

Peter Rob, +1 more
TL;DR: This text provides the most comprehensive, detailed, and clear coverage of database basics, with ample exercises and problems at the end of each chapter to encourage hands-on learning.
Book

Modern Database Management

TL;DR: Reacting to the current business environment, Modern Database Management, 6/e addresses current issues in the market, such as Internet, data warehousing and object-orientation, to understand the role of database management within a business.
Book

Introduction to Business Data Mining

TL;DR: This paper presents a meta-modelling architecture for data mining that automates the very labor-intensive and therefore time-heavy and expensive process of designing and implementing data mining techniques.
Book

Intelligent Decision Support Methods: The Science of Knowledge Work

TL;DR: Information systems - past, present, and emerging the determinants of intelligence density data driven decision support evolving solutions - genetic algorithms simulating the brain to solve problems - neural networks putting expert reasoning in a box - rule-based systems dealing with linguistic ambiguity.