The “Tutorial Series” is an initiative by NUS Business Analytics Consulting Team. We want to help University Students learn Excel, VBA, R, Python & SQL & Tableau at their own pace with comprehensive and streamlined learning resources.
VBA Tutorial Series
The VBA Tutorial Series is a new initiative by NUS Business Analytics Consulting Team. We want to help University Students learn VBA at their own pace with comprehensive and streamlined learning resources.
The series is designed such that it will benefit those who are learning VBA for Internships and those who would like to scrape data from the web.
This tutorial series was written by Goh Jun Hui. He is actively adding additional parts to the series.
This 3 part tutorial series will cover the basic & intermediate levels of VBA.
This 5 part tutorial series will guide a non-programmer from setup to scraping data from Carousell Motors.
Tableau Tutorial Guide
The Tableau Tutorial Guide is a new initiative by NUS Business Analytics Consulting Team. We want to help University Students learn Tableau at their own pace with comprehensive and streamlined learning resources.
This guide was put together by Simon Hung.
Tableau is free for students. You can download it here:
https://www.tableau.com/academic/students
Connecting Data
Basic Charts
Filters & Colors
Building a map view with geographic data
Level of Details
Dashboard & Interactivity
Present a Story
Uploading your Work
Visual Best Practices
Types of Calculations in Tableau
Top 15 LOD Expressions
Sankey Diagram (Advance – Only for those who like a challenge)
Tableau Viz of the Day
Tableau Viz Gallery
Tableau Desktop Documentation
UFO Sightings by National UFO Reporting Centre
Data Source: https://www.kaggle.com/NUFORC/ufo-sightings/data
Discover interesting insights with this data set: It can be anything, ranging from ‘average duration of UFO sightings across different countries’ to ‘types of UFO sightings over the years’.
If you’d like take ‘Year’ as a data point, you will need to extract the year from the ‘datetime’ data point. This can be done through string manipulation, column-to-text function or other methods within Microsoft Excel or Tableau. It is an additional challenge of this exercise. You are free to complete this exercise without using year as a data point.
Sample Answers will be released soon!
Excel Tutorial Series
The Excel Tutorial Series is an initiative by NUS Business Analytics Consulting Team. We want to help University Students learn fundamental Excel Skills at their own pace with a comprehensive and streamlined learning resource.
The guide is designed such that it will benefit those who are learning Excel for Internships. This tutorial file has been used in the society’s Excel Workshops conducted in NUS.
This tutorial was put together by Alexander Leong.
Click to download the Excel Tutorial Series – Working File
Landing Page
This will be the first screen that you will see upon opening the Working File. Don’t forget to like our Facebook page if you haven’t!
Using the Workbook
Click the “Answer” button to view the answers for each exercise
Click the “Reset” button to clear all answers so that you can try it again
Click the “Shortcuts” button to navigate between exercises in the same sheet
Comments
Comments on each Sheet will share with you each Exercise’s objective and instructions.
Comments under the Sheet “Pivot Table”
Follow the instructions line by line to learn how to use the Pivot Table Feature!
* Happy Learning! *
R Tutorial Series
The R Tutorial Series is a new initiative by NUS Business Analytics Consulting Team. We want to help University Students learn R at their own pace with comprehensive and streamlined learning resources.
This tutorial series was written by Fan Ting Wei.
This 8 part tutorial series will guide a non-programmer over the following topics:
R Tutorial 1: Introduction & Setup of R
R Tutorial 2: Working Environment
R Tutorial 3: Basic Programming
R Tutorial 4: Data Structures
R Tutorial 5: Basic Programming (Continued)
R Tutorial 6: Data Manipulation
R Tutorial 7: Data Manipulation (Continued)
R Tutorial 8: Data Visualisation
We have prepared 2 assignments covering all the Tutorials above.
R Assignment Challenge 1
R Assignment Challenge 2
Python Tutorial Series
The Python Tutorial Series is a new initiative by NUS Business Analytics Consulting Team. We want to help University Students learn Python technicalities at their own pace before using it for advanced analytics purposes.
This tutorial series was written by Leong Zeng Hui, Alexander, Nelson Lim Jun Kang and Fan Ting Wei.
This 7 part tutorial series will guide a non-programmer over the following topics:
Python Tutorial 1: Installation and Working Environment
Python Tutorial 2: Data Types – Integers, Strings, Floats, Boolean
Python Tutorial 3: Basic Operations
Python Tutorial 4: Data Structures
Python Tutorial 5: Basic Flow Control
Python Tutorial 6: Functions
Python Tutorial 7: Libraries
We have prepared 1 assignment covering all the tutorials above.
SQL Tutorial Series
The SQL Tutorial Series is an initiative by NUS Business Analytics Consulting Team. We want to help University Students learn SQL at their own pace with comprehensive and streamlined learning resources.
This tutorial series was written by Ng Wei Xuan.
Welcome to BACT’s SQL Tutorial Series! In our previous tutorial publications, we have learnt many concepts from R, Python and VBA that deals with analysing and manipulating data to create insights. However, have you ever wondered, how do we even get all these data to analyse in the first place? Many companies store these data in their databases and we require a certain tool to get these data out before we can even carry out data analysis. The tool to do so is Structured Query Language (SQL).
The idea behind SQL is to write code, known as queries, to get the datasets we need. This is important considering that these databases are extremely huge in size and it is very inefficient to extract all available data from these databases without filtering those that you would really need. In this tutorial series, we aim to cover some of the key concepts in writing SQL queries.
This 7 part tutorial series will guide a non-programmer over the following topics:
SQL Tutorial 1 : “SELECT FROM WHERE” Framework
SQL Tutorial 2 : Additional criterias with the use of OR/IN/AND Functions
SQL Tutorial 3 : Aggregation Functions
SQL Tutorial 4 : “GROUP BY” & “ORDER BY” Functions
SQL Tutorial 5 : “HAVING” Function
SQL Tutorial 6 : “JOIN” Function
SQL Tutorial 7 : Summary & Cheatsheet
NUS BACT 