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

Autor/in	King, Michael A.
Titel	A Realistic Data Warehouse Project: An Integration of Microsoft Access[R] and Microsoft Excel[R] Advanced Features and Skills
Quelle	In: Journal of Information Technology Education, 8 (2009), S.91- (14 Seiten) PDF als Volltext Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	1547-9714
Schlagwörter	Strategic Planning; Problem Sets; Corporations; Statistics; Data; Management Information Systems; Case Method (Teaching Technique); Business Administration Education; Programming Languages; Computer Science Education; Computer Software; Information Technology; Computer System Design; Computer Assisted Instruction; College Curriculum; College Students; Instructional Effectiveness; College Instruction; Information Storage; Databases; Database Design; Database Management Systems; Virginia + Suchen Sie Ihr Suchwort? Strategy; Planning; Strategie; Planung; Problemstellung; Unternehmen; Statistik; Daten; Managementinformationssystem; Case method; Fallmethode; Computer science lessons; Informatikunterricht; Informationstechnologie; Computer based training; Computerunterstützter Unterricht; Collegestudent; Unterrichtserfolg; Hochschullehre; Informationsspeicherung; Datenbank; Datenbanksystem
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. Large fact table creation is demonstrated, which subsequently allows for the development of meaningful queries and cross tab analysis utilizing pivot tables. Fact table sizes of one million records can be iteratively developed and quickly imported into databases such as Microsoft Access or MySQL. A short discussion on the benefits of using Microsoft Access Query by Example and completely bypassing the complexities of advanced SQL is included. With the resulting fact table, students can experiment with several indexing techniques, usually only conceptually discussed in textbooks, and measure a series of index effectiveness. This paper includes a brief discussion of enterprise-level data requirements, the differences between dimensional and relational modeling, data warehouse schemas, and enterprise data flow concepts, along with a demonstration of business modeling concepts, such as random variable generation and probability distributions. As a case example, this data warehouse project utilizes a public retail corporation with an excellent online presence to provide the student with a real data extract, transform and load hands on experience. General financial data and colorful background information about the corporation is provided. (Contains 3 tables and 10 figures.) (As Provided).
Anmerkungen	Informing Science Institute. 131 Brookhill Court, Santa Rosa, CA 95409. Tel: 707-537-2211; Fax: 480-247-5724; Web site: http://JITE.org
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2017/4/10