You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
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
Course Info
Promotion Code
Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions
- Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)
Attitude
- Positive Learning Attitude
- Enthusiastic Learner
Experience
- Minimum of 1 year of working experience.
Target Age Group: 18-65 years old
Minimum Software/Hardware Requirement
Software:
TBD
Hardware: Window or Mac Laptops
Job Roles
Job Roles
- 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
Trainers
Trainers
is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies
Review
Customer Reviews (6)
- Well structured course Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 1/11/2026)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Clear and easy to follow Review by Course Participant/Trainee
-
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 10/17/2025)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Practical and relevant Review by Course Participant/Trainee
-
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 11/27/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Clear and easy to follow Review by Course Participant/Trainee
-
Good hands-on training with plenty of examples. I feel much more confident applying these skills now. (Posted on 10/11/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment - Great learning experience Review by Course Participant/Trainee
-
Well organised course with clear objectives. The step-by-step approach made it easy to follow. (Posted on 6/24/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
