addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Everything about Data Analytics Bootcamp 5-Part Series

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.


Book your tickets for the Bootcamp here: http://peatix.com/event/210748

Links to individual session ticket (You are strongly recommended to buy series tickets):

Session 1 Excel (S$50) :cg-excel.peatix.com

Session 2 Data Visualization ($50):cg-dv.peatix.com

Session 3 Statistics with R (Part1 ($50)): cg-r1.peatix.com

Session 3 Statistics with R (Part2) ($50): cg-r2.peatix.com

Session 4 Data Warehouse ($50): cg-dw.peatix.com

Session 5 Students Final Presentation Visitor Tickets (Free) - cg-final.peatix.com


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)

Introduction to Data Analytics

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

Basic VBA

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.

Intro of data visulizationShowcase of good&bad data visualizationHands-on: create a storyboard in Tableau

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

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

Introduction to R (installation of R and RStudio)

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

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

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

Advanced R visualisation (grid, ggplot)

Hands-on practice

Part 2: (1:30 - 5:00 pm)

Basic statistics

Regression Models

Data Cleaning

R hands-on


Session 04 - Data Warehouse (Nov 27th, 2016, 1:30pm - 5:00 pm)

Introduction to DBMS

Setting up and installing MySQL

Relational DB and ER diagrams

Structured Query Language

Hands-on Exercise

Session 05 - Final Presentation & Graduation (Dec 4th, 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


Cancellation Policy

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 5 days before the scheduled event date. No refunds will be given after this timeframe.

CodingGirls is a Singapore-registered NGO, which aims to empower more girls to code to achieve their ambitions in tech world. All revenue will be used to cover the cost of each project.

We provide hands-on workshops, tech sharing talks and female leaders talk. Both men and women are welcomed !

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

Join or login to comment.

4 went

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy