Develop your skills in data visualization and reporting. Learn how to use common industry reporting and visualization tools such as Excel and Tableau. You will also learn how to evaluate strengths and weaknesses of various data visualization techniques and the fundamentals of dashboard design for various types of reporting.
By the end of this course, you should be able to:
Recognize the difference in purpose between real-time reporting, scheduled reporting and on-demand reporting
Evaluate different strengths and weaknesses of various data visualization techniques and demonstrate how these visualizations assist with decision making
Apply heuristics to ‘report design’ based on need
Apply BI fundamentals of goals, objectives, measures, metrics, KPIs and performance statistics
Apply judgement to data visualization regarding ethical concerns and practices
Perform the following basic tasks in Excel and Tableau:
Import cleaned and compiled data
Perform conditional formatting functions
Present data in usable charts, graphs and tables to enable effective interpretation
Create dashboards and reports to meet specific user needs
The practical components of the course are predominantly taught using Excel and Tableau, while the application of these concepts is briefly shown in Microsoft Power BI, Shiny and Python.
It is recommended that students have completed either:
If your first language is not English, you will be asked to provide evidence of fluency through the submission of an IELTS (Academic) score of minimum 6.0 (with no component less than 5.5), TOEFL score of 550 (79 Internet Based TOEFL), completion of the UVic English Language Centre's ELPI 570 level, or equivalent level through one of our English pathway partners.
Required equipment and software
This course uses a virtual classroom and will present the course material live during the scheduled class times. As this is an online course, you will need your own laptop/PC as well as a decent internet connection. A headset-microphone is needed for visual and audio link-up, or participants may choose to participate in the tutorials by audio link-up only. You will also need access to the Microsoft Office suite (predominantly Excel and Word), however a licence for the Analytics tool you’ll be using will be provided for the duration of the course.
Online learning is when course delivery, and all associated learning activities, take place via the internet. For online learning tips, system requirements and differences between delivery styles, please visit our online learning webpages.
Using mobile devices in online courses
If you are planning on accessing your online courses using a mobile device such as a tablet or a smartphone, please note that not all required course features will be accessible with these devices. To fully function in your online courses, you will need to have access to a computer running Windows or MacOS.
Any requests to withdraw received more than a week prior to the course start date will be issued a full tuition refund. A refund—less an administrative fee ($60)—will be issued if you request to withdraw or transfer courses within the week prior to the course start date. No refunds will be issued after the course start date. Requests to transfer from one course section to another, or to withdraw from one course to another, are considered course withdrawals and will adhere to withdrawal deadlines noted above.
Continuing Studies statement on use of educational technology
This course will require the use of Zoom and may use other education technology such as internet-based applications, cloud services, or social media. In order to complete this course you will be required to either consent to the disclosure of your personal information outside of Canada to enable use of these technologies, or work with the Division of Continuing Studies to explore other privacy protective options (such as using an alias or nickname).