Developing an Introductory Class in Business Intelligence (BI) Using MS Excel PowerPivot [Konferenzbericht] Paper presented at the Annual Meeting of the Association Supporting Computer Users in Education (ASCUE) (51st, Myrtle Beach, SC, Jun 10-14, 2018).

Autor/inn/en	Hiljazi, Sam; Curtis, Trevor
Titel	Developing an Introductory Class in Business Intelligence (BI) Using MS Excel PowerPivot [Konferenzbericht] Paper presented at the Annual Meeting of the Association Supporting Computer Users in Education (ASCUE) (51st, Myrtle Beach, SC, Jun 10-14, 2018).
Quelle	(2018), (18 Seiten) PDF als Volltext kostenfreie Datei Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Monographie
Schlagwörter	Introductory Courses; Business Administration Education; Business Skills; Spreadsheets; Computer Software; College Students; Instructional Design; Data Analysis + Suchen Sie Ihr Suchwort? Einführungskurs; Spread sheet; Spredsheets; Spreadsheet; Tabellenkalkulation; Collegestudent; Lesson concept; Lessonplan; Unterrichtsentwurf; Auswertung
Abstract	Asking questions about your data is a constant application of all business organizations. To facilitate decision making and improve business performance, a business intelligence application must be an integral part of everyday management practices. Microsoft Excel added PowerPivot and PowerPivot officially to facilitate this process with minimum cost, knowing that many business people are already familiar with MS Excel. This paper will design an introductory class to business intelligence (BI) using Excel PowerPivot. If an educator decides to adopt this paper for teaching an introductory BI class, students should have previous familiarity with Excel's functions and formulas. This paper will focus on four significant phases all students need to complete in a three-credit class. First, students must understand the process of achieving small database normalization and how to bring these tables to Excel or develop them directly within Excel PowerPivot. This paper will walk the reader through these steps to complete the task of creating the normalization, along with the linking and bringing the tables and their relationships to excel. Second, an introduction to Data Analysis Expression (DAX) will be discussed. [For the full proceedings, see ED592847.] (As Provided).
Anmerkungen	Association Supporting Computer Users in Education (ASCUE). 1513 Magnolia Drive, Surfside Beach, SC 29575. Tel: 606-218-5308; Fax: 606-218-5184; e-mail: president@ascue.org; Web site: http://www.ascue.org
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2020/1/01