Event is FINISHED

Data Analytics Bootcamp (Rerun) - Session 5 - Final Presentation

Description

Note: change of date- 3 Dec,2016 1:30pm- 5pm

Sorry for the inconvenice cause.

Our Everything About Analytics Bootcamp is coming back!

Amidst an increasingly competitive business landscape in an increasingly data-driven world, companies across various industries are making data analytics a top priority to stay ahead of the competition. Hence, it comes as no surprise that data analysis has become one of the hottest skills with demand outstripping supply.

Register for our Data Analytics Bootcamp and learn how to analyse datasets through hands on experience with powerful tools such as Excel, Tableau, SQL and R within 5 sessions.

The Bootcamp will be conducted by industry experts who will impart knowledge on how to apply these skills can be applied in the real world. Learn how to ask the right questions about data, derive insights using data and perform basic exploration of large complex datasets.

At the end of the course, you will gain an understanding of how insights from data can help you make strategic decisions confidently.

The Bootcamp will culminate with a final project where all participants will apply what they have learnt and present their findings in the final 6th session of the Data Analytics Bootcamp. Outstanding presentations will be published on CodingGirls official website, slideshare platforms and promoted through various social media channels.


Syllabus:

Session 01 - Data in Excel (Nov 6th, 2016, 1:30pm - 5:00pm)

  1. Introduction to Data Analytics

  2. Excel basics: Workbook structure, formulae, inbuilt functions (eg. Pivot Tables)

  3. Basic VBA

  4. Project: Simple inventory management for CRUD and basic analytics requirements

Session 02 - Data Visualization (Nov 13th, 2016, 1:30 pm - 5:00 pm)

Learn how to create stunning data visualization examples with Tableau.

  1. Intro of data visulization
  2. Showcase of good&bad data visualization
  3. Hands-on: create a storyboard in Tableau


Session 03 - Statistics with R (Nov 20th, 2016, 10am-5pm)

Part 1: (10 am - 12:30 pm)

  1. Introduction to R (installation of R and RStudio)

  2. Basic R syntax/grammar (for, if, while, which, write, read etc…)

  3. Basic R statistics function (mean, min, max, as.numeric, data.frame etc…)

  4. Basic R visualisation function (plot, hist, barplot, etc…)

  5. Advanced R visualisation (grid, ggplot)

  6. Hands-on practice

Part 2: (1:30 - 5:00 pm)
  1. Basic statistics

  2. Regression Models

  3. Data Cleaning

  4. R hands-on


Session 04 - Database and SQL Fundamentals(Nov 27th, 2016, 1:30pm - 5:00 pm)

  1. Introduction to DBMS

  2. Setting up and installing MySQL

  3. Relational DB and ER diagrams

  4. Structured Query Language

  5. Hands-on Exercise


Session 05 - Final Presentation & Graduation (Dec 3th, 2016, 1:30 pm - 5:00 pm)


Add to calendar: https://calendar.google.com/calendar/embed?src=codingirls.org_g8744rsa27lbg0qjv7h8ctos88%40group.calendar.google.com&ctz=Asia/Singapore


Check out our website (www.codingirls.org) and follow our FB for more info: CodingGirls SG. Or you may send email to: hello@codingirls.org

Event Timeline
Updates
  • Venue was changed to "21 Heng Mui Keng Terrace, National University of Singapore, Singapore 119613". Diff 2016-11-30 08:38:40
More updates
Sun Dec 4, 2016
1:30 PM - 5:00 PM SGT
Add to Calendar
Venue
21 Heng Mui Keng Terrace, National University of Singapore, Singapore 119613
Tickets
Visitor Ticket
Venue Address
The Hangar Singapore
Organizer
CodingGirls Singapore
566 Followers