Python项目实践白天班
免费公开课:周六 12:30 pm

                                                                           

 

Python项目实践白天班


课程固定在 :

 周一至周四 9:30 am--2:30 pm,共三周

 


 
 
 
 
 
 
 
 
 
 
       
 
Business Analyst已经成为大多商科大学生毕业后的最佳就业方向
 
众所周知,Python目前是打开这一类BA就业大门的必备钥匙

维多利亚隆重推出初级分析师Python项目实践白天班
 
大师级的数据分析就业专家DQ曲达雍老师亲自授课
他将毫无保留分享20年的BA资深行业经验,无阻的北美 
BA就业之路从见到DQ老师开始!

应届毕业生Business Analyst 求职要点
 
很多商科方向的大学生毕业后想找Business Analyst的工作。个人认为找BA工作的想法起码比找CSR工作的想法靠谱的多(实在无法理解辛苦学习4年后去找一份高中必业就可以胜任的工作)。那么成功找到BA工作的CASE有多少?很低!究其原因,有两点
不知道,不了解Business Analyst的工作性质及日常工作职责,盲目的认为商科方向毕业后BA是对口就业方向
缺乏对Business Analyst工作中必要工具的了解及使用经验
 
Business Analysis的范围覆盖面很广,一两篇文章无法阐述清楚,要求从业人员对有Domain knowledge及Technology有比较深入的了解, 同时具备较强的Communication能力。可以说,BA是对综合素质要求最高的工作。在这里我们谈谈适合商科应届毕业生的Junior Business Analyst工作。
 
1. What does Business Analystdo?                                                                  
BA的工作集中于Mid Office, 处理公司的核心业务。由于各个行业业务的多样性导致了工作的多样性。总体来讲有两种Business Analyst - 业务分析员和系统分析员( 这两个其实区别很大 ), 其工作从业务分析,系统验收,提供报表,到需求收集.....零零总总,不一而同。
业务分析员,主要关注于公司某项业务,某项产品,某个业务,各个KPI指标是否达到预期,是否赚钱,和其他同类业务比较的Benchmark. 这工作对于刚毕业的学生有一定挑战 - 需要补充业务知识及掌握一些分析工具来开展工作。
 
系统分析员,OPENING很多,但能申请的人却不多。其工作需要和IT团队打交道,这一点成为许多人的软肋,这也是我们中国背景的大学生比较容易打开的就业大门(很可惜,大部分商科毕业并不知道这一点,不知道可以申请系统分析员)。开门你需要钥匙  - 打开这一类BA就业大门的钥匙是IT知识
 
2. How is the Career Future for being a Business Analyst?
由于现在已经没有那个行业不需要IT的系统支持,对于既了解业务,又有IT背景,并有较强沟通能力的从业人员的需求居高不下。
See details below from IT World Canada
http://www.itworldcanada.com/article/the-rise-of-the-it-business-analyst/46611
"IT business analyst” was also rated one of the country’s top 12 jobs to pursue last year by Money Magazine, which listed median pay for that position at $83,100. Computerworld’s Salary Survey 2012 listed an average total compensation for IT technology/business system analysts at $84,376, up 1.4 per cent from 2011.
 
3. "Wow, IT, I CANNOT do IT!" - What Skills BA need to have?
大部分同学咨询的问题是相类似的,我这里总结一下
问:各方面听起来都不错,一个问题,BA需要编程吗?
答:日常工作不用编程,但要了解IT及编程的基础知识,在这一基础上进行系统方案评估
问:我学了4年商科,看起来白学了,申请Business Analyst工作没有任何优势?
答:BUSINESS Analyst, 重点在商务逻辑,IT 是敲门砖,是药引子,主菜还是BUSINESS
问:我不想再学什么了,已经学了4年了!想尽快找到一份BA工做如何做?
答:很难,找其他工作还有可能,找BA希望很小。BA的沟通有其自己的一套流程,不培训,基本不可能无师自通。至少要看见过别人写的文档,你才有可能写出差不多的吧!
 
4. What should I do to be a BA?
根据我的经验为你提供一个关于Jr. Business Analyst 的Road Map 供你参考(不适用于Sr的职位),在紧紧抓住Business Analyst 相关知识以及简历面试的同时,对于不同类型的BA有如下建议
Business Analyst紧密相关的知识,包括
IIBA Certificate  / UML - 了解BA沟通的流程
Programming Basic  - 了解IT 相关知识
Web Application - 大部分程序是网上的程序,是否应该学,你懂的
UAT Testing - BA的一个主要工作职责是主持验收测试
 
对于业务分析员 - 学习Business Major 工作相关的一些SKILLS和工具( EXCEL, VBA, ACCESS, SQL,  DATABASE, SEO, SEM, CRM, CMS......), 同时REVIEW上学时学的ACCOUNTING / FINANCE的知识,没有准确就业定位的同学请考虑定位Marketing  方向,分析类工作。
对于系统分析员 - 补充Software Testing 工作相关的一些SKILLS和工具( ISTQB Certificate, Web Services, SQL Server, Automation Test........) 同时进一步加强IT方面的知识,做到能够和软件测试人员有效沟通
 
课程独特优势:
 
1)    短平快的课程, 白天集中强化, 着重技术实战
 
2)    培训所对应的数据分析师职位工作稳定,年薪4万以上,职位符合留学生办移民要求。
 
3)    课程时间灵活,随时入学训练,每个季度一期,全年大约四次。
 
4)    课上包含配套projects,真实项目活学活用, 文档正规背景完善, 应对面试游刃有余。
 
Python Basics for Business Analyst  

Objective: As one of the most important programming language in Data Analysis paradigm, Python becomes to a necessary tool for data analyzing, presentation, and integration given its abundance algorithms, libraries, and supported packages.  “Petite de petite, la soeur fait son ne” – let us start from the fundamentals – from Programming basics, Object Oriented Programming to GUI; eventually, we will have 3 labs to implement the concepts covered above.

 Instructor: Dayong Qu, who has 20-year extensive practice in Project Management, Business Intelligence, and Software outsourcing with companies from government agencies, financial institutions and public firms, currently takes a role of senior Director of Resource Manager in the company that provides sourcing solution for major financial institutions.

 Course Outline:

Session 1(5 hours):

·        1.1 - Why use Python and where is the best fit for it?

o   - How does it compare to SAS

o   - How does it compare to R

o   - How does it compare to SQL

·         1.2 Prepare your Python Development Environment

o   - Interpreted vs Compiled languages

o   - Which version should I use?

o   - Prepare multiple development envs.

·         1.3 The lifecycle for Analytical project

·         1.4 Quick Demos with basic Data types

 

Session 2(5 hours):

·         Various Data Type

o   List

§  Multi-Dimensional List

o   Tuple

o   Set

o   Dictionary

o   Class

·         Functions

o   Call By Value

o   Call By Ref

·         Conditionals

·         Loop

o   For loop / While loop

o   Continue and Exit

·         String Functions and Formatting

·         Lambda

 

Session 3(5 hours):

·         Object Oriented Programming

o   Inheritance

§  Function Overload

§  Function Override

o   Abstract

o   Encapsulation

o   Polymorphism

·         Lab 1 – Victoria Student Mgt. System

 

Session 4(5 hours):

·         GUI with  TK

o   How GUI works

§  Event Driven

§  Layout

o   GUI Components

§  Button

§  Label

§  Input box

§  Radio Buttons

o   Demo – Loan Calculator

·         Lab 2 -  Color Picker

o   Passing inline parameters

o   Using different data structures

·         Lab 3 -  Bubble Sort

o   Create a standalone library

o   Configuration with GUI

 

Session 5(5 hours):

·         Python Ecosystem for Data Analysis

·         Numpy Data Structure

o   Quickly review Python List

o   Demo on numpy

o   Structured array

·         Vectorization

o   zeros | ones

o   zeros_like | ones_like

o   transpose

·         Regular Expression

o   Search

o   Match

o   Substitut

 

Session 6(5 hours):

·         Data Visualization

·         Python plot packages

o   Matplotlib package

o   Basic components

§  Multi axis’s plotting

§  Multi plot areaas

·         2D Plotting

o   Line chart

o   Bar chart

o   Boxplot chart

o   Scatter chart

o   Histogram chart

·         Plot real-time data

·         3D Plotting

 

Session 7(5 hours):

·         Handling Time Series Data

·         Introduction to DataFrame

o   Basics of DataFrame

o   Construct time series with DataFrame

o   DataFrame supports directly plot

·         Structure Financial Data with DataFrame

o   Retrieve real time financial data

o   Calculate returns and moving average and Moving Historical Volatility

·         Regression Analysis with Financial Data

·         Data Resampling  for  High frequency data

 

Session 8(4.5 hours):

·         Input / Output for variables Sources

·         Basic I/O

o   Data Serialization

o   With txt files

o   With csv files

·         I/O with Pandas

o   With csv

o   With excel

o   With XML

·         I/O with PyTables

·         Working with Database

 

Python Real Project for Business Analyst

Objective: Only knowing basic business analysis knowledge as well as a programming language may give you the opportunity to step into the area of Business Analysis.  To further strengthen your professional portfolio, you need more knowledge of experience, process, and real practice. In the following sections, we will cover 2 certificates (IIBA and ISTQB) and implementation – the practice drilling down from requirement design, solution design, coding to testing.

 Instructor: Dayong Qu, who has 20-year extensive practice in Project Management, Business Intelligence, and Software outsourcing with companies from government agencies, financial institutions and public firms, currently takes a role of senior Director of Resource Manager in the company that provides sourcing solution for major financial institutions.

Duration: 39.5 Hours

Course Outline:

Session 1(5 hours):

·         Introduction

o   What is Business Analysis?

o   Who is a Business Analyst?

·         Business Analysis Key Concepts

o   The Business Analysis Core Concept

o   Key Terms

o   Requirements Classification Schema

o   Requirements and Designs

·         Business Analysis Planning and Monitoring

o   Plan Business Analysis Approach

o   Plan Stakeholder Engagement

o   Plan Business Analysis Governance

 

Session 2(5 hours):

·         Elicitation and  Collaboration

o   Conduct / Confirm Elicitation

o   Communicate Business Analysis Information

·         Requirement Life Cycle Management

o   Trace Requirements

o   Maintain Requirements

o   Prioritize Requirements

·         Strategy Analysis

o   Analyze Current State

o   Define Future State

o   Assess Risks

o   Define Change Strategy

 

Session 3(5 hours):

·         Requirement Analysis and Design Definition

o   Specify and Modeling

o   Requirements structuring

o   Requirements packaging

·         Solution Evaluation

o   Upfront Criteria /KPI / Metric

o   Testing and Evaluation

·         Use Case

·         UML

o   Static Diagram

o   Dynamic Diagram

·         ER Diagram

 

Session 4(5 hours):

·         Hands-on Practice in Requirement Analysis

o   Interview Business User

o   Operate requirement Workshop to establish requirement basis

·         Document business requirements

·         Review meetings

o   Walkthrough

o   Inspection

o   Checklist

·         Requirement management

o   Version

o   Update

Session 5(5 hours):

·         Implement Use Case of Login

o   UI Specification

§  Html Page

§  Field validation

o   Business logic implementation

o   Database design

·         Unit Test on Use Case Login

 

Session 6(5 hours):

·         Implement a selected Use Case

o   UI Specification

§  Html Page

§  Field validation

o   Business logic implementation

o   Database design

·         Unit Test on a selected Use Case

Session 7(5 hours):

·         Static Testing

o   Review Process

o   Walkthrough vs Inspection

·         Dynamic Testing

o   BVA/EP

o   Decision Table

o   State Transition Testing

o   Use case testing

 

Session 8(4.5 hours):

·         Hands-on Practice in UAT / BAT

o   Development Test Plan

o   Generate Test scenarios

o   Develop Test cases

o   Prepare Test data

o   Execute test cases

 

o   Report test outcomes

 



 

 

 

学员成功就业故事

Crystal我于20136月毕业于多伦多大学,主修数学与经济,副修统计。当初选择这个专业,是觉得就业面比较广,找工作会容易一些。但是毕业后却发现自己处于一个很尴尬的位置,既没有commerce同学accountingfinance的背景,也没有computer science同学programming的知识。大学四年,作为一名数学专业的同学,学的知识太过于理论化,多数时间都用于证明各种定理及题目,而当毕业了开始找工作的时候,却发现自己无法将所学的知识用于实践,为企业服务。因此,由于缺乏相关技能和工作经验,投了很多份简历都石沉大海,杳无音讯。Read More...

 
Helen四的时候,对于找工作,面试我都相当怀疑自己的能力,所以一直打算毕业后找一家移民中介,让他们给找份administration的工作,然后熬一年办移民。可是没想到去年11月份的移民政策突然砍掉了六个职位,当时一下子不知道该怎么办。对于简历我都不知道写什么,统计毕业的我知道,假如不是研究生肯定很难找到关于统计的工作,所以对于找什么样的,往哪里找工作自己都很纠结。那段时间的我像个无头苍蝇,找了家写简历的公司写了份简历,然后在网上乱投,都没有音讯。每天都过的比较痛苦。Read More...
 
Mary我是Mary – 多大金融专业本科毕业的留学生,毕业后好几个月找不到工作,心理很焦虑,有时候真想买张机票回国算了,省得在这里经受煎熬。听相同背景的朋友说他参加了 FA/BA培就业培训班后很快就找到了工作,抱着试试看的态度,报了FA/BA就业培训班,心想就算是找不到工作,学点实用的东西再回国也行啊。Read More...
 

【更多大学生就业故事】请点击:   http://www.vicmiss.com/category/?id=257


Reporting & Analysis with Excel
The course is designed for individual, who processes a basic understanding on how business case is created and operated, and knowledge in Accounting, Financial Planning and Investment Decision. Technically, student will use MS Excel to realize profitability studies, financial planning and various analysis by changing different drivers. The course materials are organized with several hands-on case studies to realize the concepts terms mentioned above. After taking the course, the student is expected to handle creating and maintaining daily business related reports and analysis.
VBA & Access / Databasefor Data Modeling
Data and Database; MS ACCESS,MS VBA; MS VBA with Sales & Marketing; MS VBA Projects
CRM / CMS / SEO for Business Processing
Digital Marketing can be defined as promoting of brands or products and services using all forms of digital advertising. The core is online marketing and all web related technologies; and Digital marketing uses Internet, mobile and any form of digital media to reach customers in a timely, relevant, personal and cost-effective manner.
Resume & Interview Workshop
Job Hunting in a systematical way; How the hiring process goes?; Stratagy on preparation.; Resume preparation; Working with agencies; Promote yourself to the market; Phone interview; Interview Anatomy –Prequel; Interview Anatomy –Non Technical Session; Interview Anatomy –Technical Session;Interview Anatomy –Yose
 

 

 

 想要得到更多的信息请点击旁边的图标:

本页最后更新: | -- | 网站设计和虚拟主机服务 WECAN.ca CMS