- Entry Requirement
- Company Sponsored
- Self Sponsored
Course Fees
$866.00 (Before funding*)
Description
TPGateway Course Code
TGS-2024042143
Claim your SFC here !
Funding
UTAP : Available for all NTUC Members
Format
VILT takes the fundamentals of face-to-face (F2F) training and replicates the experience online and live.
Duration
2 days or 16 hours
Prerequisites
- Basic Knowledge of Excel
- Computer with Excel Installed
Certification
On successful completion of the course, you will receive a Certificate of Course Competition Certificate from TÜV NORD.
Who should attend this course?
- Aspiring Data Analysts
- Research Professionals
- BusinessProfessionals
- Marketing Specialists
- Healthcare Professionals
- Public Sector Employees
- IT and Tech Enthusiasts
- Educators and Trainers
Description
Dive into the world of data visualization and analytics with our comprehensiveTableau course. Over two days, this course offers a hands-on approach tomastering Tableau, one of the leading data visualization tools in the industry.You will learn how to transform raw data into compelling, interactivevisualizations that provide insights and drive decision-making. The course coversthe fundamentals of data storytelling, the analytics workflow, and variousfunctionalities of Tableau to build charts, graphs, and dashboards
Module 1: Data Collection, Ingestion and Preparation
Prior to visualization and analytics, it is imperative to make sure that the datayou use is clean and ready for visual analysis. This module takes you throughthe concepts of various data sources, how data is collected and how youprepare and make the data ready.
- Introduction to Data
- Data Collection Mechanisms–How should you collect data?
- Data Cleaning Methods
- Creating a data model
Module 2: Data Normalization and Tables
One of the important parts of data analytics is making sure data is in the mostoptimized form. Non optimized data tends to slow down visualizations andmakes the process messy. This module will recap a few concepts of datanormalization and the basic normal forms of data along with the main types oftables that should exist in a dataset.
- What is Data Normalization?
- Normalizing a dataset
- Understanding Fact and Dimension Tables
Module 3: Understanding Data Storytelling
The aim of using data is to present actionable insights using the rightdashboards, charts, metrics, and story. It is important to convey the rightmessage to the right people.
- Key elements of data storytelling
- Formulating business questions relevant to the data
- Introduction to KPIs and key KPIs
- Visualizations and their implications
- What differentiates good and bad visualizations?
Module 4: Tableau Overview, Data Sources, Worksheet and View
In this module participants will get a high-level understanding of thecapabilities of Tableau and will start working with the Tableau interface. Aspart of analytics and visualization, getting your data ready is the first step. Thisalso covers the basicsof working with the data to prepare it for furthervisualization and analytics
- Exploring Tableau and its Interface
- Connecting to different data sources
- Create relationships between tables
- Create data extracts and filters at data source
- Understanding Dimensions and Measures
- Basics of worksheets and views
Module 5: Charts, Graphs and Formatting
The next step towards analytics and visualizations is to summarize the dataand create the right charts and graphs to present data in the most precisemanner.
- Create different charts for different scenarios
- Formatting size, colours, and other elements of charts
- Gathering insights from charts
Module 6: Module 6: Organize and Transform Data
In many cases, you would require organizing, transforming, or creating newdata fields to makedata visualization more effective. This refinement helps analysts to find betterinsights within data.
- Create Filter from measures and dimensions
- Apply Filters to Charts
- Organize Data by groups and sets
- Create calculated fields and parameters
- Apply logical functions
- Top N Analysis
Module 7: Advanced Analytic
Many a time, you would want to employ analytics to get quick insights fromyour data. Tableau presents such advanced analytics features which can bedirectly applied to charts and graphs.
- Create trend and average lines to make charts more insightful
- Forecast future values using built in methodologies
- Create clusters in the data and visualize them
- Create and fit regression lines
Module 8: Creating Maps and Analytical Dashboards
Map services are used to show geographical insights in a visually appealingmanner. This module covers the basics of how maps can be used and thedifferent kinds of maps that can be added to Tableau to provide moredetailing. Creating insightful dashboardsare critical to all sectors. Dashboardsand reports are designed to help managers, executive draw insights andconclusions by viewing interpretable data, understand the cause and effectand implement further plans accordingly
- Maps Basics and Adding Markers
- Creating dashboards from charts and graphs
- Formatting dashboards to make them interpretable
- Creating filters for dashboard visualizations
- Adding images and annotations to dashboards
- Publishing a dashboard to Tableau public
Why Choose Avanta Academy?
Avanta Academy, a member of the TÜV Nord Group in Germany,offers a practical and interactive approach to learning Excel for dataanalytics. Our experienced instructors provide hands-on training, ensuring that participants not only understand theoretical aspects but alsoacquire practical skills applicable in their professional life
Company Sponsored
Important Note:
1. [Company Sponsored]: Company shall ensure there is employer-employee relationship and CPF contribution for employer-sponsored trainees. Should SDF grant disbursement be rejected due to wrong company / UEN provided to Avanta, the company shall be liable to pay the full course fees with out grant.
2. Registration is valid only if, each participant Mobile Number & Email address is provided (Shouldn’t provide same contact details of Person in charge)
Self Sponsored
Important Note:
1. [Company Sponsored]: Company shall ensure there is employer-employee relationship and CPF contribution for employer-sponsored trainees. Should SDF grant disbursement be rejected due to wrong company / UEN provided to Avanta, the company shall be liable to pay the full course fees with out grant.
2. Registration is valid only if, each participant Mobile Number & Email address is provided (Shouldn’t provide same contact details of Person in charge)
