Loading...

Course Description

In this course, students will learn to create useful analysis for the business within a functional reporting framework. Also, students will learn to gather the right requirements and ask the right business questions to create dashboards and reports for presenting the results of business analysis using the MAD framework.


Course Details

Business Intelligence is often misunderstood because it resides in-between the business and the technology departments of an organization. Both its challenges and its potential are borne from the dependence on collaboration to achieve the desired outcome. However, this collaboration requires that both groups understand the needs and capabilities that Business Intelligence solutions can provide.

The concepts in this course will be taught through a class-long mini-project where you will engage in the hands-on development of dashboards, scorecards and reports primarily using tools from the Microsoft suite.


Course Level Learning Outcomes

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

  • Model a MAD framework presentation
  • Use industry best practices to develop visual dashboard layouts
  • Develop monitor level dashboards using SQL Server Mobile Report Publisher
  • Develop analysis level dashboards using Power BI Desktop
  • Develop detail level reporting using SQL Server Reporting Services

Topics of Instruction

  • Identify business problems to solve through reporting and analysis
  • Translate requirements into information presentation designs
  • Develop a MAD framework for the information delivery solution
  • Use semantic layers to drive report development
  • Develop interactive operational reports
  • Enable drill, slice and filter capabilities within the reporting solution
  • Design user experiences that enable effective information consumption
  • Develop executive dashboards and scorecards
  • Explore advanced data visualization tools and techniques

Notes

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

Applies Towards the Following Certificate(s)

Loading...

Enrol Now - Select a section to enrol in

Type
Online Synchronous
Days
M, W
Time
6:00PM to 9:00PM
Dates
Oct 26, 2020 to Nov 30, 2020
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $975.00
Instructor(s)
Reading List / Textbook

Title: Microsoft SQL Server 2016 Reporting Services
Edition: 5th
Authors: Brian Larson
Publisher: McGraw-Hill Education
ISBN: 978-1259641503

Section Notes

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

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

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

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 who register on (or after) the start date will receive access within one day of registration.

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this 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.

The University is closed on holidays and no classes are run on these dates or their long-weekends:

  • Wednesday, November 11, 2020 (Remembrance Day)
     
Type
Online Synchronous
Days
W
Time
6:00PM to 9:00PM
Dates
Feb 17, 2021 to Mar 17, 2021
Type
Online Synchronous
Days
Sa
Time
9:00AM to 12:00PM
Dates
Feb 20, 2021 to Mar 20, 2021
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $975.00
Instructor(s)
Reading List / Textbook

Title: Microsoft SQL Server 2016 Reporting Services
Edition: 5th
Authors: Brian Larson
Publisher: McGraw-Hill Education
ISBN: 978-1259641503

Section Notes

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

You will require access to a computer with an 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. The instructor will post your course outline and other materials in D2L.
  • Zoom web conferencing software.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

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

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 who register on (or after) the start date will receive access within one day of registration.

Students who are unfamiliar with Desire2Learn or Zoom are recommended to take BMC 352 Learning Online prior to enrolling in this 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
Class
Days
M
Time
6:00PM to 9:00PM
Dates
Apr 12, 2021 to Jun 21, 2021
Schedule and Location
Hours
30.0
Delivery Options
Course Fees
Flat Fee non-credit $975.00
Instructor(s)
Reading List / Textbook

Title: Microsoft SQL Server 2016 Reporting Services
Edition: 5th
Authors: Brian Larson
Publisher: McGraw-Hill Education
ISBN: 978-1259641503

Section Notes

This course uses:

  • Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L.
  • A virtual lab with VMware Horizon, a platform that provides access to virtual applications including the latest software for the course. You will be provided with a VMware account and login information once the course starts.

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

For more information about D2L and Virtual Machines please visit our Online Learning Resources.

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.

The University is closed on holidays and no classes are run on these dates or their long-weekends:

  • Monday, May 24, 2021 (Victoria Day, Monday, May 24, 2021)
     
Required fields are indicated by .