【数据科学】求职实战精品课

主讲老师:James老师

导师介绍

 

James老师现就职于普华永道TMT(Technology, Media, Telecom)行业,曾斩获无数面试和offer,包括PwC CSI,EY consulting,DTT & KPMG FA,济邦咨询,指数资本,花旗银行及京东金融等,对四大校招和数据相关职位面试颇具心得

课程亮点

 
4+ Toolbox

全面增强实力

课程涵盖成为数据科学家所需的所有toolbox,Python编程、大数据云计算、商业实例分析项目,帮助同学快速积累

实战经验,全面提升简历。

 

30+ Python课程

夯实编程基础

基于数据科学岗位工作需求,为您定制编程课程及case study,帮助您快速入门,建立算法和编程知识体系,自信

应对面试。

 

个性化简历修改

模拟面试

来自一线科技/咨询公司的资深导师为您量身修改简历,并就行为面试和技能面试两块面试大头进行面试能力提升。

同时,本课程还包括了模拟面试,帮助您抓住面试机会。

 

强大内推网络

助力求职

BRC求职与世界500强企业及Tier1的顶尖优质企业保持良好的合作关系,拥有遍布各大一线投行、咨询、IT公司的强大的导师师资力量,为您提供强有力的内推支持。

课程介绍

助你通往数据科学家之路的必备精品数据科学课程,本课程旨在提供无论未来在什么工作环境中都用得到的SQL, Python, Tableau和Google Cloud课程,包括:建立个人SQL数据库,Python数据并行处理,Tableau数据可视化,熟悉理解Google Cloud大数据平台,将数据科学的技能应用到实际商务案例中,用对数据科学领域的深刻理解给面试官留下好印象,编辑专业简历,提升行为和技能面试等等。

课程大纲

阶段Ⅰ 基础数据理论+SQL基础编程

理解基础数据库概念、数据关系(一对一、一对多、多对多),理解数据处理语言、数据定义语言等。

  • Install Microsoft SQL database

  • Critical SQL database concepts

    • Understand Data Relationships

      • One to One

      • One to Many

      • Many to Many

    • Understand Data Normalization

    • Understand SQL Data Type

    • Data Manipulation Language (Update, Insert, Delete)

    • Data Definition Language 

阶段Ⅱ SQL高阶+实际应用

 

通过跨多表格编写高级SQL进行数据分析,使用内设程序和处理器工作,与Excel和Tableau建立数据联系管理等。

  • Write complex SQL queries across multiple tables to do data analysis

  • Work with Stored Procedures and Triggers (must learn skills in the workplace)

  • Schedule SQL Jobs and introduction to SQL Extraction, Transformation, and Load (ETL) packages (must learn skills in the workplace)

  • Create data connection manager with Excel and Tableau

 

阶段Ⅲ Python基础编程+ Python ETL
(extract,transform,load)

 

Python数据结构基础,多任务处理,Python ETL是什么?利用Python实现自动化等。

•  Install Python with Anaconda

•  Programming with Python

    •  Python object and data structure

    •  Python comparison operators, statements, and  functions

    •  Use pandas Data Frames to solve complex tasks

•  ETL with Python

    •  Importance of ETL in a real world (must learn skills in the workplace)

    •  What is Python ETL? a short for extract, transform, load, three database functions that are combined into one tool to pull data out of one data source and place it into another data source.

    •  Extract: reading/writing tables from files, databases, web service and other sources

    •  Transform: transforming tables

    •  Load: writing tables from files, databases, web service and other sources

    •  Setup Database Credentials and Variables and work with some examples

•  Automation with Python

    •  Importance of automation in a real world (must learn skills in the workplace)

    •  Setup Python task scheduler and run Python job  automatically

阶段Ⅳ Python API & Python parallel processing

 

Python API(Application Programming Interface),用Python实现并行处理等。

  • Working with Python API (Application Programming Interface)

    • What is an API:  are commonly used to retrieve data from remote websites

    • API Terminology:

      • HTTP (Hypertext Transfer Protocol) 

      • URL (Uniform Resource Locator) 

      • JSON (JavaScript Object Notation)

      • REST (RE presentational State Transfer) 

    • Using the YouTube API in Python

  • Parallel processing with Python

    • Parallel processing allows you to carry out many calculations at the same time, thus reducing the amount of time it takes to run your program to completion (must learn skills in the workplace)

    • Multi-process vs Multi-thread

      • When to use threads vs processes?

    • Parallel processing examples with API calls

阶段Ⅴ Tableau实战编程

Tableau基础介绍,在Tableau中建立与SQL, Excel, Google Cloud的数据联系,Tableau实际运用等。

  • Intro to Tableau (must learn skills in the workplace)

  • Create data connection in Tableau to SQL, Execl, Google Cloud

    • Live and Extract

  • Work with Tableau

    • Create various types of chart

    • Create Maps

      • Assigning Geographical Roles to Data Elements

    • Create Dual Axis Charts

    • Understand Types of Joins and how they work

    • Work with Parameters

    • Create Calculated Fields

    • Create highly interactive dashboards

      • Adding Actions to Dashboards (filters & highlighting)

    • Create storylines

    • Export Results from Tableau into PowerPoint, Word, and other software

 

阶段Ⅵ 大数据平台——Google Cloud

 

理解云计算,Google Cloud核心概念,Google Cloud企业数据仓库实战运用等。

  • Understand cloud computing

  • Google Cloud critical concepts:

    • Columnar database vs relational database

    • Datasets vs Projects

    • Storing data

    • Access control

  • Work with Google Cloud BigQuery: an enterprise data warehouse (must learn skills in the workplace)

    • BigQuery data type

    • Working with Datasets

    • Working with Objects

    • Query BigQuery data

    • Load data into BigQuery

  • Machine Learning on Goolge Cloud

    • use BigQuery ML to predict basketball outcomes

    • Visualize BigQuery data using Google Data Studio

阶段Ⅶ 简历辅导+面试技能提升

 

个性化简历修改,关键词战略,提升简历设计感;行为面试提升:攻破5大经典行为面试题,技能面试:SQL和Python编程,案例分析,技术评估;模拟面试等。

  • Resume

    • Personalized approach to suit you

    • Keywords(data science) strategy for catching attention

    • Writing from a sketch or doing edits

    • Good design for a good impression

  • Interview

    • behavioral interview

      • Prepare 5 classic behavioral interview questions

    • Technical interview

      • Programming (SQL and Python)

      • Case study

      • Technical assessment (statistics, possibility, machine learning)

    • Mock interview

Contact Us

Address: New York 

85 Broad St 29FL, New York, NY, 10004

Tel:  +1 646-847-2107

Email: info@beyondremarkable.com
 

Address: Boston

200 Portland St, Boston, MA, 02114 

WeChat: BRCBOSTON

Email:

info@beyondremarkable.com

VIP Coaching & Mentorship Program
For Coaching & Program Inquiry

Address: San Francisco 

555 California St, San Francisco, CA 94104

Tel:  +1 650-439-9209

Email: info@beyondremarkable.com
 

Mentorship &

Business Partnership

Address: Shanghai

上海市黄浦区黄陂南路838

​中海国际中心

Tel:  135-6495-6893

Wechat: Beyondremarkable1
 

  • Facebook - Grey Circle
  • Twitter - Grey Circle
  • Instagram - Grey Circle

Copyright © Beyond Remarkable LLC 2014-2017 All rights reserved.