CodingGirls - Data Analytics Bootcamp - Session 1 - Excel
Notice: Both men and women are welcomed.
Links to individual session ticket and Series ticket: (You are strongly to buy series tickets)
Session 1-6 Sessions (S$150) - codinggirlsdatabootcamp.peatix.com
Session 2 SQL (S$50) - codinggirlssession2sql.peatix.com
Session 3 Data Visualization (S$50) - codinggirlssession3dv.peatix.com
Session 4 R (Part1) (S$50) - codinggirlssession4r1.peatix.com
Session 5 R (Part1) (S$50) - codinggirlssession5r2.peatix.com
Session 6 Students Final Presentation Visitor Tickets (Free) - codinggirlssession6visitor.peatix.com
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.
(1). Previous programming experience not required.
(2). You are strongly recommended to attend all sessions to benefit from the course. .
Date and Time: Start from 19th June, Every Sunday. (Lunch time and break)
Venue: IDA #03-04 (July 24th will be at Skyscanner Singapore Office.39 Robinson Road #08-01 Robinson Point)
Session 01 - Data in Excel (19 Jun 16, IDA #03-04)
Introduction to Data Analytics [1 hr]
Excel basics: Workbook structure, formulae, inbuilt functions (eg. Pivot Tables) [1 hr]
Basic VBA [0.5 hr]
Project: Simple inventory management for CRUD and basic analytics requirements [3 hr]
Session 02 - Data Warehouse (26 Jun 16)
Session 03 - Data Visualisation (10 Jul 16)
- Motivation for creating visualisations
-Examples of good and bad visualisations
- Data types, visual encoding & visual perception
2. Installation of Tableau (0.5hrs)
3. Hands on Part 1: Create an interactive Tableau Dashboard (2hrs)
4. Hands on Part 1: Create a storyboard in Tableau (1hrs)
Session 04 - Statistics with R (Part 1) (17 Jul 16)
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)
Session 05 - Statistics with R (Part 2) (24 Jul 16)
Session 06 - Final Presentation & Graduation (31 Jul 16)
Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 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. We provide hand-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: email@example.com
- The event description was updated. Diff 2016-06-14 01:48:58