48 小时从小白变高级数据分析师 ——

从零基础到高级数据分析师，8 天让你完成蜕变，一个课程，让你完转所有四大，咨询，投 行，基金公司等数据分析师岗位。

Excel 基本功能 —— Excel 高阶功能 —— Excel Modelling——Data Visualisation ( Tableau)

Corelogict PR Data丨量化数据分析师

CBA Sydney丨数据分析师

Deloitte Sydney丨数据分析师

Tableau丨软件工程师

课程设置

● Data Manipulation

● Lookups Functions

● Scenario Functions

● The IF Function

● Arithmetic & Logical Functions

● Text & Formatting Functions

● Conditional Formatting

● Data Validation

● Worksheet Protection

● Charts

● Data Handling Techniques

● PivotT ables

● Macros

● 高级 Excel 功能及 VBA

● 咨询公司及投行案例练习

● Manipulate and cleanse raw data sets to produce a meaningful analysis to allow for modeling and forecasting

● Learn the basic structure of an excel/financial model from inputs to calculations to final output result

● Learn professional model standards and see examples of actual models and data sets in practice

● Build a financial model with the ability to flex various assumptions

● Build various scenarios in the model to examine various possibilities and outcomes

● Develop financial and commercial literacy to analyze model outputs and data

● Create simple excel charts to summarise model output data

● Work through case studies where students utilize learned data analysis and financial

modeling skills to solve business issues

● What is Data (Definition of Data and Data Process Flow)

● Tools Available (Market Overview, Tableau Introduction)

● Tableau in Business (Examples and Case Studies)

● Career Prospects (Tableau in Finance, Job Advertised)

● Questions & Answers (Previous Experience, Real Life Career Pathways)

● Day 1 - Understanding Tableau

● Tableau Overview (Products Line, Application Terminology) 

● Setting Up Connections (Data Sources, Live Connections, Extracts)

● Filtering and Sorting Data (Date Filters, Top N Fields, Sorting Data)

● Organizing Data (Excluding Outliers, Grouping Data, Creating Hierarchies)

● Creating Calculations (Mathematical Operations, If Statements, Case Statements)

● Each topic is paired with questions and exercises for students to learn

● The day will finish with a case study where Tableau is used for data analysis instead of using Excel formulas or Pivot Tables

● Creating Graphs Basic (Bar Graph, Line Chart, Scatter Graph)

● Creating Graphs Intermediate (Heat Maps, Scatter Chart, Maps)

● Creating Graphs Advanced (Combined Charts, Dual Axis Charts, Donut Charts)

● Explanation of Charts (When to Use Which Charts)

● Customizing Tableau (Customised Icons, Labels, Chart within a Chart)

● Creating Calculations (String Formulas, Date Formulas)

● The day will finish with a case study where a data source is provided along with requirements for reporting. A simple dashboard will be constructed.

● Defining Key Metrics and Stakeholders

● Customer Segmentation (How to Create Different Layers of Reporting)

● Normalizing Data (Periodic comparison, Annualising Data, Run Rate)

● Creating a User Experience (URL Links, Action Filters, Legends)

● General Rules for Formatting (Red/Green colors, dashboard resolution, containers)

●The day will finish with a case study where a data source is provided with no requirements. A full suite dashboard for Executive, Manager, and Analyst will be created.