DAT102: Data Analysis and Visualisation

Learn the fundamental concepts of data analysis and visualisation using Excel, SQL, and Tableau from experienced data analysts in Singapore.

✅  Hybrid instructor-led classes
✅  Basic and intermediate Excel, SQL, and Tableau concepts
✳️  Build your own data analytics projects on real-world datasets
⭐ Rated 4.8/5 on SwitchUp and Google

Data Analytics Nanodegree

Earners of this badge have demonstrated proficiency in analysing, visualising, and interpreting data, utilising Python, and implementing machine learning solutions.

 Earners have completed DAT101, AI101, and AI201
 Direct admission into Buidlnaut internship programme
 Increased employment chances
Data Analysis and Visualisation
⧖   18 instructional hours
△   Beginner level
ⓘ   No prior knowledge required
Data Analytics and AI with Python
⧖    18 instructional hours
△   Beginner level
ⓘ   No prior knowledge required
Machine Learning and Deep Learning
⧖    24 instructional hours
△   Intermediate level
ⓘ   AI101 or equivalent knowledge

Growing Demand For Data Professionals

Data analysis and visualisation stand at the core of today's data-centric environment. Business of all sizes harness data visualisations to drive decision-making, understand market dynamics, and enhance user experiences. As such, the demand for skilled data analysts is on the rise.

By mastering tools like Microsoft Excel, SQL, and Tableau in our course, participants will be equipped to transform raw data into compelling visuals, revealing patterns, and providing invaluable business insights.

Don't just hear it from us

"I had an incredible experience at this course. I never thought that after such a short amount of time I would be able to create a simple web server from scratch. One of the main pros for me have been the attentive instructors."

Senior UX Consultant

"Attending bootcamp gave me guidance and direction when I was trying to transition into a tech career. Metacamp has great instructors and their lectures were awesome. Coding challenges and projects helped reinforce the concepts. I would highly recommend Metacamp to aspiring software engineers."

Tech Presales

"I wanted to learn more about blockchain that I was already interested in but had no idea where to start. Metacamp was the perfect answer. Metacamp is an excellent platform for people to gather, learn, and share their experiences."

lim qi jie
Co-Founder, TableFi

Industry expert instructors from AWS, Microsoft, OKX, ...

Attend live classes online outside of working hours

Graduate with a blockchain-verified certificate

Build and pitch your capstone project during demo day

Dedicated career support and matching with partners

4.8 / 5 ⭐
5 / 5 ⭐

Data Analysis and Visualisation Course Details

Metacamp's Data Analysis and Visualisation course in Singapore is crafted to equip learners with the latest techniques and best practices in modern data visualisation and analysis. This course emphasises the utilisations of tools such as Microsoft Excel, SQL, and Tableau. Participants will utilise their understanding, undertake various projects designed to tackle specific real-world data challenges.

What to expect?

Learn new concepts and tools through expert-led lectures, discussions, assignments and projects

Complete all assignments and receive a certificate of completion in the form of an NFT at the end of the course

Receive individualised feedback and support from your instructional team with free 1-on-1 consultations

Be part of a community where members can leverage connections with alumni, instructors and experts

Data Analysis and Visualisation Course Schedule

The schedule for this course is currently unreleased on our website. We encourage you to join our waitlist so that you will be prioritised and notified once our schedule is out. Feel free to reach out to us via email at team@metacamp.so for any enquiries!

Data Analysis and Visualisation Course Curriculum

Module 1: Data Analysis and Microsoft Excel Primer
  • Data Analysis introduction
  • Microsoft Excel functions
  • Formatting on Microsoft Excel
  • Creating charts and graphs
  • Data cleaning and munging
  • Creating pivot tables and charts
Module 2: Advanced Microsoft Excel
  • Creating macros with recorder
  • Creating and modifying VBA Code
  • Using VBA to automate Excel formulas
  • Creating a form using VBA
  • Interact with text files using VBA
Module 3: SQL Fundamentals
  • Introduction To SQL
  • Creating SQL tables
  • Selecting and filtering data based on criterias
  • Showing unique values
  • Order values by columns
  • Counting number of instances
  • Group and aggregate data on columns
  • Merging tables
Module 4: Advanced SQL
  • String functions and operators
  • Mathematical functions and operators
  • Subqueries
  • Case statement
Module 5: Visualisation with Tableau
  • Importing data into tableau
  • Joining data from multiple sources
  • Combine tables with blending
  • Appending rows with SQL Unions
  • Measures and dimension
  • Discrete and continuous fields
  • Exploring different charts
Module 6: Tableau Calculations and Analysis
  • Filtering and sorting
  • Groups, Sets and Hierarchies
  • Calculating mathematical measurements
  • String functions
  • If statements
  • Totals and subtotals
  • Level of detail expressions
Module 7: Tableau Analysis and Dashboards
  • Plotting trend lines
  • Forecasting prediction
  • Creating a dynamic dashboard
  • Making dashboard interactive
  • Publish and share dashboard in Tableau
  Live Chat