Tableau

I.                   Objectives

This course is focused on the analysis part of the Tableau tool.

It provides the necessary knowledge to use the data access and analysis tools.

At the end of the course, the student will have sufficient knowledge to:

Access data that resides in different sources.

Create analysis using Tableau.

II. Requirements

No specific requirements are needed beyond having used other simple analysis tools (Microsoft Excel, for example).

Knowledge of SQL and the use of plain text files can facilitate understanding of the subject.

III. Duration

20 hours.

IV. Methodology

The course is developed through theoretical presentation accompanied by practical demonstrations and explanations of the results obtained.

The student carries out practical exercises in which he/she models different data sources to test the characteristics of the product, in addition to using the data analysis functions.

Resolution of doubts about the concepts presented.

V.               Content

Introduction to Business Intelligence, Data Warehouse and Tableau. Basic concepts of B.I. Data models. Main characteristics of Tableau.

Data access and preparation.

Use of plain text files.

Pivoting dataset.Fixed length plain text files.Plain text files with field separator character.Using Microsoft Excel as a data source.Joining data using Microsoft Excel.Using Google Sheets.Basic use of geographic information.Complementing data using extractions.LEFT / RIGHT / FULL data joins.CROSS data joins.BLENDING data joins.Data analytics:Data tables.Context filters.Sorting and hierarchical sorting.Charts:Basic.Bullet Chart.Bar in bar.Heat map.Other charts.Calculated elements:Row level calculations.Grouped calculations.Null values ​​in grouped calculations.Dimensional level calculations.Parameters.Trend lines.Clustering.Forecast.Dashboard.Creating the dashboard. control.Using visualizations.Inserting images.

Story.Creating a story.Adding elements to each sheet.

Adding comments to each sheet.