Tutorial Series

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.

Tutorial Series Logos.jpgCombined - Img2Combined - Img2

Slide1(1).JPGSlide1Slide3(1).JPG

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.

Slide1.JPG

01 - VBA for Internships

This 3 part tutorial series will cover the basic & intermediate levels of VBA.

Slide7Slide8Slide9Slide10


02 - Zero to Web Scraping

This 5 part tutorial series will guide a non-programmer from setup to scraping data from Carousell Motors.

Slide1Slide2Slide3Slide5Slide6

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.

Slide3.JPG

Slide6.jpg

Tableau is free for students. You can download it here:
https://www.tableau.com/academic/students

Slide3

Connecting Data
Basic Charts
Filters & Colors
Building a map view with geographic data
Level of Details
Dashboard & Interactivity
Present a Story
Uploading your Work

Slide4

Visual Best Practices
Types of Calculations in Tableau
Top 15 LOD Expressions
Sankey Diagram (Advance – Only for those who like a challenge)

Slide5

Tableau Viz of the Day
Tableau Viz Gallery
Tableau Desktop Documentation

Slide2

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.

Slide4

Slide7

download

Click to download the Excel Tutorial Series – Working File

Slide8.jpg

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!01 - Landing Page

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
02 - How to use Workbook.png

Comments
Comments on each Sheet will share with you each Exercise’s objective and instructions.
03 - Comments by the Side.png

Comments under the Sheet “Pivot Table”
Follow the instructions line by line to learn how to use the Pivot Table Feature!04 - Large Comments

* 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.

Slide2

Slide1

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

Slide2

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.

Slide2

Slide1

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

Slide2

We have prepared 1 assignment covering all the tutorials above.

Python Assignment Challenge

 

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