Business Intelligence in Tableau 2400-SP-SQL-BIT
The goal of this course is to familiarize students with Tableau software and to discuss various visualization methods depending on the type of analytical and business problem.
Course topics:
✓ Database Connections
Connecting to Tableau Server, connecting to various data types (.xlsx, .csv, .json), joining tables from one or more databases, preparing data for analysis (blending, editing metadata, pivoting, union, data interpreter), connection types (Live/Extract), splitting data.
✓ Data organization
Filtering, sorting, grouping, hierarchies, sets.
✓ Creating charts and fields
Tableau Terminology – Measure and Dimension, discrete and continuous fields, fields automatically generated by Tableau, charts (histogram, heat map, tree map, bullet graph, combo chart, shared axis, scatter plot, cross-tab, bar-in-bar chart, box plot), using titles, labels, and tooltips, editing axes, using labels.
✓ Performing calculations
Manipulating text and dates, creating Quick Table Calculations, level of detail (LOD) expressions, working with aggregation, logical expressions, totals and subtotals, calculations for joining tables.
Course coordinators
Type of course
Mode
Learning outcomes
Participants are able to navigate the Tableau software with ease and create visualizations. They learned not only how to create charts, but also when it’s best to use them. They became familiar with best practices for data visualization and the most common mistakes in this area. They also received tips on data visualization, such as using appropriate colors and making charts more readable.
Assessment criteria
An independent assessment task to be completed by the participant upon course completion. A minimum score of 50% is required to pass.
Bibliography
Materials prepared by the lecturer and made available to participants on e-learning platform