Loading...

Course Description

Business Intelligence Introduction

This course introduces students to the concepts, practices and tools used to successfully deploy business intelligence projects. Emphasis will be placed on people and processes, with an introduction to the technologies involved.

 

Course Details

Business Intelligence (BI) is an umbrella term that includes the applications, infrastructure, tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance. It is both a business and a technology endeavour.

Its success depends largely on bringing business and technology together in the right ways around people, process, technology and data. For both business and IT managers, BI skills are some of the most in-demand skills in business today.

Basic skills on how to build and manage a data warehouse platform for business intelligence applications will be covered, but emphasis will be given to people and processes with an introduction to the technologies involved.

Course Level Learning Outcomes

By completion of this course, successful students will be able to:

  • Describe the four main components of a business intelligence system
  • Discuss the roles, processes, techniques, and technology related to business intelligence applications
  • Explain the role of data management in successful business intelligence systems
  • Apply dimensional modelling techniques
  • Recognize the roles, processes, techniques, and technology related to Extract-Transform-Load (ETL) systems

Topics of Instruction

  • Introduction to Business Intelligence
  • Program Requirements and Architecture of a Business Intelligence Solution
  • Launching and Managing a program
  • Requirements Gathering
  • Establishing the Technical Architecture
  • Product Selection
  • Designing a Business Intelligence Solution
  • Designing Dimensional Models
  • Designing the Physical Databases
  • Introduction to ETL
  • Designing Business Intelligence Applications
  • Deployment and Support
  • Growing and expanding the program

Notes

For the best experience, your computer and internet connection should meet certain requirements. See the recommended requirements...

Applies Towards the Following Program(s)

Loading...
Enrol Now - Select a section to enrol in
Type
Online Synchronous
Days
W
Time
6:00PM to 9:00PM
Dates
Apr 17, 2024 to Jun 19, 2024
Schedule and Location
View Details
Hours
30.0
Delivery Options
Online Synchronous  
Course Fees
Flat Fee non-credit $979.00
Instructor(s)
Required Software
VM required MS Visual Studio 2019, MS Visio 2016, MS Excel 2016 PowerBI Desktop
Reading List / Textbook

Title: The Data Warehouse Lifecycle Toolkit
Edition: 2nd
Authors: Kimball, Ross, Thornthwaite, Mundy, Becker
Publisher: Wiley
ISBN: 978-0-470-14977-5

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

Classes are held online in real time (Mountain Time) at the specified time and dates.

Students will require access to a computer with the required software, Internet connection, a headset with speakers and microphone, webcam, and a monitor large enough to display multiple applications (or the use of two monitors).

This course uses Desire2Learn (D2L), an online learning management system, and Zoom web conferencing software. The instructor will post the course outline and other materials in D2L. For more information, please visit our Online Learning Resources.

Unless notified, all online courses are available at 9 am MT the day before the start date. Students registered on (or after) the start date will receive access within one day of registration.

Students unfamiliar with online learning are encouraged to take our free Digital Skills for Learning Online course.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Type
Online Synchronous
Days
T, Th
Time
6:00PM to 9:00PM
Dates
Sep 03, 2024 to Oct 03, 2024
Schedule and Location
View Details
Hours
30.0
Delivery Options
Online Synchronous  
Course Fees
Flat Fee non-credit $979.00
Required Software
VM required MS Visual Studio 2019, MS Visio 2016, MS Excel 2016 PowerBI Desktop
Reading List / Textbook

Title: The Data Warehouse Lifecycle Toolkit
Edition: 2nd
Authors: Kimball, Ross, Thornthwaite, Mundy, Becker
Publisher: Wiley
ISBN: 978-0-470-14977-5

Please note: ICT textbooks are not available through the University of Calgary bookstore.

Section Notes

Due to the intensive nature of this course there may be pre-work assigned. If there is pre-work the instructor will post it to D2L one week (7 calendar days) before the course start date.

Assignments and group work will be required throughout the course duration and a final assignment may be due after the course has ended.

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L one week prior to the course start date. For more information about D2L, please visit our Online Learning Resources.

Students are expected to attend all sessions.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .