Business Intelligence: Dashboard Design

COURSE

Course description

In the second course of the Business Intelligence and Data Analytics Certificate program, you will gain a comprehensive introduction to the Monitor, Analyze and Detail (MAD) design strategy, and design and build a business intelligence dashboard. Using standard industry informatics tools, you will identify and extract data to use in the design and creation of suitable Tables, Charts, Metrics, and Key Performance Indicators (KPIs) for use in a business intelligence dashboard project in support of a case study.

Upon completion of this course, you will be able to:

  • design and build a Business Intelligence dashboard using R shiny techniques as part of a business solution for a case study problem;
  • use the Monitor, Analyze and Detail (MAD) design strategy for business intelligence development that promotes re-use of modules;
  • create Table, Chart, Metric and KPI components using modules for a dashboard solution using R, and create alerts based on sound business practice; and
  • use R at an intermediate level to extract, merge and aggregate data sets and create toolkits for re-use of universal code.

How to register

This course is part of the Business Intelligence and Data Analytics program.

To register in the courses, you must apply to and be accepted into the program.

Please contact Loraine Ferreira, Program Assistant at bida@uvic.ca or (250) 472-5442 for further information.

Additional course details

Blended delivery

In-Class Requirement

The blended delivery model incorporates online learning with two days of on-campus classes. These classes at the beginning of the course allow students to become acquainted with UVic, faculty and fellow students.

While on campus, students will:

• begin to engage in core elements of the program;
• develop skills essential for success in the related field of data science;
• consolidate learning acquired during the program; and
• benefit from interaction with the instructor and other learners.

Online learning

The online learning portion of this course expands upon the conceptual introductions offered during the on-campus classes, allowing participants to practice skills and expand their knowledge base. The online portion delivers much of the theoretical and information-based material in the program. This material is applied to case study exercises undertaken by teams of students within each course.

The online portion of the program takes place over the internet, using a learning management system known as Moodle. The Moodle site for this course will contain discussion forums and readings. At their convenience, students work through the requirements of the course (although there are ‘real time’ deadlines for assignments, etc).

Students will study online for approximately four weeks, and will be required to spend approximately 15 hours per week on coursework. This may vary at times throughout the course and from student to student. During the first course, the amount of time required may be higher, as students familiarize themselves with our online learning technologies.

Required equipment/software

Hardware and Operating Systems

  • Internet connection (DSL, LAN, or cable connection desirable)
  • Course Moodle site, URL will be provided
  • Laptop with administrator privileges, and power cable
    • ​CPU: i5/i7 or equivalent
    • 16GB/32GB RAM
    • 300MB/20GB free hard disk space
    • Wi-Fi capable
    • 32 bit/64bit OS
    • Dedicated GPU with on-board RAM (the more the better, but there is no heavy graphics usage)

Software

  • R - free unlimited use under open source agreements
  • RStudio – free unlimited use under open source agreements
  • MS Office (Word, Excel) or equivalent - for example Open Office (free unlimited use under open source agreements); PowerPoint or equivalent would be useful, but is not necessary
  • Web Browser (Chrome recommended)
  • DIA or Visual Paradigm CE or suitable diagramming software (consult instructor)
  • Anti-virus scanner

Course text

  • No textbook required

RELATED TOPICS: Computing and Technology