Exploring Data Analytics

Tableau is a business intelligence tool that is widely used and rated one of the top 2 in the Gartner 2020 Magic Quadrant.  In this basic level course, learner will learn how visualization can be done on Tableau.

1. Introduction
   1. Overview of Data Analytics
   2. Understanding Big Data
   3. Impact of Big Data to organizations
2. Introducing Visual Analytics
   1. Importance of Visualization
   2. Learn the Visual Language
   3. What is a Dashboard?
   4. The Art of Storytelling
3. Visual Analytics with Tableau
   1. Getting started with Tableau
   2. Exploring basic Tableau
      1. Creating the first workbook
      2. Connecting to Excel workbook
      3. Connecting to various data sources in Tableau
      4. Understanding joins
      5. Understand concept of dashboards
4. Deep Dive into Tableau
   1. Understanding difference between Live vs Extracts
   2. Dragging and dropping data
   3. Using Tabular vs Graphs
   4. Changing tableau metadata
      1. Renaming columns
      2. Creating hierarchy
      3. Creating folders
      4. Changing aggregation
      5. Creating calculated columns
5. Create Distribution Charts and Blending Data
   1. Joining different data sources and connections
   2. Create basic tabular reports and graphs
   3. Create basic calculations
6. Massaging data inputs
   1. Understand techniques to transform and clean input data
   2. Data interpreter
   3. Custom splits
7. Exploring Graphs and Grouping Concepts
8. Explore Advanced Filtering Techniques
9. Using Tableau Maps
10. Advanced Tableau Visualization (Pareto)
11. Advanced Tableau Visualization (Waterfall chart)
12. Calculated fields in Tableau

Who Should Attend
Learners with Advanced Excel skills and would like use Tableau to create business intelligence reports with data visualization and storytelling

Duration: 09.00AM-5PM (2 days)

Full Course Fees: $500.00

This course is suitable for learners who are new to data analytics and data visualization.  During the 2 days session, learners will be exposed to how data analytics is used for businesses using Power Pivot.

1. An Introduction to Data Analytics
   1. What is Data Science vs Big Data vs Data Analytics?
   2. How it is applied and skills required
   3. The role of a Data Analyst
   4. The 5 ways to make sense of data
   5. How data analytics can support business decisions
2. An Introduction to Data Visualization
   1. What is Data Visualization?
   2. The Value of Data Visualization
   3. Story Telling in Data Visualization
   4. Data visualization tools
   5. Data visualization techniques
3. Using Excel as Data Visualization Tool
   1. What is a Dashboard?
      1. Concepts of a Dashboard
      2. Define information needs
      3. Acquiring and arranging data
      4. Dashboard design considerations
   2. Using Excel Tables
      1. Importing data from source
      2. Types of data sources
   3. Using Excel Functions to prepare Data
      1. Name Range and Advance Filter
      2. Logical functions IF, Nested IF, IF(And), IF(OR)
      3. Lookup functions VLOOKUP, HLOOKUP, INDEX MATCH
   4. Using Excel for Data Validation
      1. Using basic data validation
      2. Applying Name Range in data validation
      3. Applying logical function into data validation
   5. Using Database Functions
   6. Using Conditional Formatting
   7. Text and Mathematical Functions
4. Using Power Pivot
   1. Build Data Model & Relationships
   2. Creating and filtering Pivot Tables
   3. Grouping and Ungrouping data
   4. Applying calculations in Pivot Table
5. Creating Pivot Charts
   1. Types of Charts
   2. Using Chart Elements and Formats
   3. Using Combo Charts
   4. Introduction to Slicers
   5. Slicer Setting and Formatting
6. Building a Dashboard
   1. Linking Slicers to Dashboard Charts
   2. Create interactivity elements in dashboards
   3. Introduction to Sparklines
7. Using Dashboard for Analysis
   1. How to read data visualizations in the dashboard to get insight?
   2. How to use slicers to refine your dimension to drill down or drill up
   3. Communicating your insight as a data analyst using the dashboard

Who Should Attend
Learners seeking to better understand data analytics and how to visualize the data they have.

Duration: 09.00AM-5PM (2 days)

Full Course Fees: $450.00

Before you start creating our visualizations to present the information, you need to know what is the story.  In this course, you will learn how you can tell that story to your stakeholders that will keep them engaged.

1. Understand the importance of context
   1. Who are the audience?
   2. Understanding what your audience need to know
   3. Awareness of situational context and the mechanics of audience communication
2. Choosing an effective visual
   1. Identifying the best way to show the data you want to communicate
   2. Common types of visuals like different data visualization, KPIs and infographics
3. Avoid Clutter
   1. Identifying and eliminating elements that is considered clutter
   2. Understand the principles of visual perception
   3. How to apply visual displays of information
4. Helping your audience focus
   1. Understand how to take advantage of how people see to craft visuals
   2. Importance of pre-attentive attributes like size, colour and position on page
   3. Using pre-attentive attributes to strategically help direct audience attention
5. Thinking like a designer
   1. Understanding what we want the audience to do with the data
6. Dissect the Model Visuals
   1. Review exemplary visuals and the thought process and design choices
7. Lessons in storytelling
   1. Understand concepts of storytelling for effective communication
   2. The beginning, middle and close framework

Who Should Attend
This course is for those who are required to make presentations to an audience with data visualization and learn keys to engage the audience

Duration: 09.00AM-5PM (1 day)

Full Course Fees: $300.00