Tableau Certified Data Analyst Training

Topic 1: Connect to and Transform Data

• Connect to Data Sources

  • Choose an appropriate data source
  • Choose between live connection or extract
  • Connect to extracts
  • Connect to spreadsheets
  • Connect to .hyper files (or .tde files)
  • Connect to relational databases
  • Pull data from relational databases by using custom SQL queries
  • Connect to a data source on Tableau Server
  • Replace the connected data source with another data source for an existing chart or sheet

• Prepare data for analysis

  • Assess data quality (completeness, consistency, accuracy)
  • Perform cleaning operations
  • Organize data into folders
  • Use multiple data sources (establish relationships, create joins, union tables, blend data)
  • Prepare data by using Data Interpreter, pivot, and split
  • Create extract filters

• Perform data transformation in Tableau Prep

  • Choose which data transformation to perform based on a business scenario
  • Combine data by using unions
  • Combine data by using joins
  • Shape data by using aggregations
  • Perform filtering
  • Shape data by using pivots

• Customize fields

  • Change default field properties (types, sorting, etc.)
  • Rename columns
  • Choose when to convert between discrete and continuous
  • Choose when to convert between dimension and measure
  • Create aliases

Topic 3: Explore and Analyze Data

• Create calculated fields

  • Write date calculations (DATEPARSE, DATENAME…)
  • Write string functions
  • Write logical and Boolean expressions (If, case, nested, etc.)
  • Write number functions
  • Write type conversion functions
  • Write aggregate functions
  • Write FIXED LOD calculations

• Create quick table calculations

  • Moving average
  • Percent of total
  • Running total
  • Difference and percent of difference
  • Percentile
  • Compound growth rate

• Create custom table calculations

  • Year to date
  • Month to date
  • Year over year
  • Index
  • Ranking
  • First-last

• Create and use filters

  • Apply filters to dimensions and measures
  • Configure filter settings including Top N, Bottom N, include, exclude, wildcard, and conditional
  • Add filters to context
  • Apply filters to multiple sheets and data sources

• Create parameters to enable interactivity

  • In calculations
  • With filters
  • With reference lines

• Structure the data

  • Sets
  • Bins
  • Hierarchies
  • Groups

• Map data geographically

  • Create symbol maps
  • Create heat maps
  • Create density maps
  • Create choropleth maps (filled maps)

• Summarize, model, and customize data by using the Analytics feature

  • Totals and subtotals
  • Reference lines
  • Reference bands
  • Average lines
  • Trend lines
  • Distribution bands
  • Forecast by using default settings
  • Customize a data forecasting model
  • Create a predictive model

Topic 3: Create Content

• Create charts

  • Create basic charts from scratch (bar, line, pie, highlight table, scatter plot, histogram, tree map, bubbles, data tables, Gantt, box plots, area, dual axis, combo)
  • Sort data (including custom sort)

• Create dashboards and stories

  • Combine sheets into a dashboard by using containers and layout options
  • Add objects
  • Create stories

• Add interactivity to dashboards

  • Apply a filter to a view
  • Add filter, URL, and highlight actions
  • Swap sheets by using parameters or sheet selector
  • Add navigation buttons
  • Implement user guiding sentences (click…, hover…, menu options)

• Format dashboards

  • Apply color, font, shapes, styling
  • Add custom shapes and color palettes
  • Add annotations
  • Add tooltips
  • Apply padding
  • Remove gridlines, row-level and column-level bands, and shading
  • Apply responsive design for specific device layouts

Topic 4: Publish and Manage Content on Tableau Server and Tableau Cloud

• Publish Content

  • Publish a workbook
  • Publish a data source
  • Print content
  • Export content

• Schedule data updates

  • Schedule data extract refreshes
  • Schedule a Tableau Prep workflow

• Manage Published workbooks

  • Create alerts
  • Create subscriptions
  • Create user-specific views
  • Troubleshoot user permissions
  • Customize and distribute a published workbook

Prerequisite:

HRDF Funding

Please refer to this video https://youtu.be/Kzpd-V1F9Xs

1-     HRD Corp Grant Helper

How to submit grant applications for HRD Corp Claimable Courses

2-     Employers are required to apply for the grant at least one week before training commences.

Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.

3-     First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my

Second, Click Application

4-     Click Grant on the left side under Applications

5-     Click Apply Grant on the left side under Applications

6-     Click Apply

7-     Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply

8-     Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:

9-     Select your Immediate Officer and click Next

10-  Select a Training Provider, then click Next

11-  Please select a training programme from the list, then key in all the required details and click Next

Select your desired training programme.

Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.

Explain the background and objective of this training.

Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.

12-  If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next

Insert MiCAS Application number

13-  Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:

14-  Please select a Course Title and Type of Training

15-  Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:

16-  Please key in the Training Location and click Next

17-  Please select the Level of Certification and click Next

18-  Please follow the instructions and key in trainee details

19-  Click Add Batch, then click Save

20-  Click Add Trainee Details

21-  Please key in all the required details, then click Add

22-  Click Add if there are more participants. Once done, click Save

23-  Click Next

24-  Please key in the course fees and allowance details, then click Save

25-  Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.

26-  Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next

27-  Complete the declaration form and select a desired officer

28-  Add all the required documents, then click Add Attachment. Then, click Save and Submit Application

29-  Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.

The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.

• Data Analyst
• Business Intelligence Analyst
• Data Visualization Specialist
• Tableau Developer
• Reporting Analyst
• Analytics Consultant
• Data Scientist
• Information Analyst
• Data Management Specialist
• Business Analyst
• Decision Support Analyst
• Data Quality Analyst
• Data Governance Specialist
• Database Analyst
• Data Architect
• ETL Developer
• Data Operations Analyst
• Data Strategy Analyst
• Data Compliance Analyst
• Data Security Analyst

Saeid: Saeid is co-founder of Skymics sdn bhd, he has 8 years experience in field of IOT (Internet of things) and Information Technology. He is a certified IBM IoT Practitioner and instructor and Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventors of 3 inventions during the last 4 years. He has worked across wide domains such as, data analytics, IoT, social media analytics, smart cities energy management, smart plantations. In addition, 5+ years of experience in data processing, visualization, and analytics. He is expert in Power BI, Qlikview, and Tableau.

Lee Cheong Loong: Lee Cheong LoongManager with 23 years working experience in multiple role and department, He completed HRD Corp Train the Trainer programme, HRD Corp Accredited Trainer, Microsoft Certified Trainer and CPFA Citizen Data scientist Trainer programme. with Professional certificate in Big Data & Analytics, Microsoft Office Specialist -Excel 2016 and Tableau Desktop Specialist. He also deliver training for R & Python programming, Excel Dashboard for Business analysis, Data Visualization with Tableau, and Microsoft PowerBI, and Citizen Data Scientist (OpenCertHub).

Milad: Milad is a Microsoft certified in SQL and currently working as Senior Software Engineer in Xchanging Malaysia, a DXC-YTL Joint Venture. He has 8+ years of comprehensive experience in software development using ASP.NET MVC, SQL, JavaScript and JQuery. In addition, 3+ years of experience in data processing, visualization, and analytics. He is expert in Power BI, Qlikview, Relational databases like SQL and MYSQL, SQL Server Integration Service (SSIS), Machine Learning and prediction using Python and Anaconda, Python, ASP.NET and JavaScript.

Ghazaleh Babanejad: Ghazaleh Babanejad has received her Ph.D from University Putra Malaysia in Faculty of Computer ‎Science and Information Technology. She is working on recommender systems in the ‎field of skyline queries over Dynamic and Incomplete databases for her PhD thesis. She is also working ‎on Data Science field as a trainer and Data Scientist. She worked on Machine Learning and Process ‎Mining projects. She also has several international certificates in Practical Machine Learning (John ‎Hopkins University) Mining Massive Datasets (Stanford University), Process Mining (Eindhoven ‎University), Hadoop (University of San Diego), MongoDB for DBAs (MongoDB Inc) and some other ‎certificates. She has more than 5 years of experience as a lecturer and database administrator.