1 / 10

Teaching Data Warehousing and Business Intelligence at a Graduate Business Program

Teaching Data Warehousing and Business Intelligence at a Graduate Business Program. Nenad Jukic, Ph.D. Loyola University Chicago. Business Intelligence.

augustus-moser
Télécharger la présentation

Teaching Data Warehousing and Business Intelligence at a Graduate Business Program

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Teaching Data Warehousing and Business Intelligence at a Graduate Business Program Nenad Jukic, Ph.D. Loyola University Chicago

  2. Business Intelligence • Business Intelligence is the process of transforming data into information and through discovery transforming that information into knowledge” - Gartner Group • Business Intelligence is a discipline of developing information that is conclusive, fact-based and actionable. Business Intelligence gives companies ability to discover and utilize information they already own, and turn it into the knowledge that directly impacts corporate performance” - IBM

  3. Business Intelligence STEPS • Gathering Data • Organizing and Storing Data • Analysis • Dissemination of Results • Decision Making and Action

  4. Business Intelligence • Tactical vs. Strategic: The difference between operational systems (supporting day-to-day operations) and business intelligence systems. • TWO EXAMPLE SCENARIOS • A local bank branch manager views a report generated by a database application at the end of a workday and decides to order more cash from the central vault, due to the low cash level in the local branch shown in the report. The data about cash was gathered and organized in a database, analyzed into a report that was disseminated to the manager who then made a decision based on it. • A CEO of a large bank views a comprehensive analysis report describing the performance of each branch for the past five years and makes a decision to close a particular bank branch. The data about branches was gathered and organized in a database, analyzed into a report that was disseminated to the CEO who then made a decision based on it.

  5. Data Warehousing • Need for Data Warehousing • Integrated, company-wide view of high-quality information. • Separation of operational and analytical systems and data. • Data Warehouse • A foundation of a comprehensive business intelligence system • In general, data warehouse is designed and implemented to answer these TWO fundamental questions: • Who is buying what? • When and where are they doing so? • More specific • Who [which customer] is buying [buying / using / delivering / shipping / ordering / returning] what [products / services] from where [outlet / store / clinic / branch] on what occasion [when], how [creditcard / cash / check / exchange / debit] and why [causation]?

  6. Data Mining • Data Mining is the process of discovering meaningful new correlations, patterns and trend by sifting through large amounts of data stored in repositories, using pattern recognition technologies as well as statistical and mathematical techniques” - Gartner Group

  7. Business Intelligence Tools • Software that enables business users to see and use (analyze) large amounts of complex data. • Database Related • Data Storage Software (DBMS) • Query and Reporting Tools • Data Warehousing Related • Data Warehouse/ Data Mart Creation Tools • OLAP Tools • Data Mining Related • Data Mining Tools • Other Special Purpose Tools

  8. Motivation for the Program • The hardware and software needed to build and maintain data warehouses, as well as to undertake other business initiatives is now accessible to businesses of all sizes. • There is a great need for managers who understand how to design data warehouses and apply business intelligence techniques to extract information that can be used to understand business trends and market behavior.

  9. DWBI Graduate Certificate Program at Loyola University Chicago • A five course program of study • Graduate credit earned in the Certificate Program can be transferred to the MBA, the MSISM (Master of Science in Information Systems Management), or the MSIMC (Master of Science in Integrated Marketing Communications) degree programs in the Graduate School of Business. • Each course is one quarter long and follows the Graduate School of Business academic calendar.  • Corporate Partners: Oracle & SPSS. • http://www.cimt.luc.edu/certificate/dwcert1.html

  10. DWBI Graduate Certificate Program at Loyola University Chicago: Courses • Prerequisite: MARK 460 Marketing Management(may be waived) • Required: ISOM 492 Database Management(may be waived)  ISOM 796 Data Warehousing(Prereq:  ISOM 492 or equivalent)  • Electives: ISOM 494 Data Mining(Prereq:  ISOM 492)ISOM 497 Intelligent Systems for BusinessMARK 562 Database Marketing StrategyMARK 567 CRM: Models And Analytical TechniquesMARK 462 Business to Business Marketing(Prereq:  MARK 460)MARK 464 Integrated Marketing Communications(Prereq: MARK 460)MARK 468 Internet Marketing(Prereq:  MARK 460)MARK 568 Internet Marketing Strategy(Prereq:  MARK 468)

More Related