Data Analysis Bootcamp 

• Excel layout introduction, basic operations, useful shortcuts

• Excel functions, Vlookup, IF, Sumif, Sumifs, Countif, Countifs, data processing functions, pivot table

• VBA introductions, Sub and Function, procedures, range objects

• VBA Programming theories and worksheet functions, loops and decisions

• Applications in Capital Markets, Financial Analysis

• Real-world automation project

• Introduction: database concepts, table, data type, primary key

• Retrieve data: select from, distinct, top

• Sort data: order by, desc. Filter data: where, where clause operators part 1

• Filter data: where, where clause operators part 2

• Wildcard filtering. Calculated fields

• Data manipulation functions and Summarize and group data

• Advanced SQL: Windows functions

• Combine data (inner join, outer join, self join, subqueries, derived tables)

• Project: Financial Product Report

• Tableau introduction, download and install

• Tableau data connection and data bending

• Filter, aggregation; Simple table, bar; line; pie and different graphs introduction

• Calculation field: String, date function

• Advanced calculation: LOD and window function

• Basic dashboard and Advanced dashboard. Dynamic online dashboard

• Series of Story

• Project: New York Uber Report

• Data import and storage

• Understand the data, basic explorations • Data manipulations

• Packages Description: Pandas, Pandsql, Numpy, Seaborn, Sklearn

• Data Modelling (Linear Regression, Logistic Regression)

• Project: Biking Share Prediction Project