维多利亚培训中心(Victoria Training Center (Toronro))

座电话：416-665-1888，Website：www.victoronto.com

地址：200 Consumers Road，Suite 108，M2J 4R4  (位于Consumers夹Sheppard东南角第三座楼，近地铁站，免费停车)

如果您是住在密市附近的朋友，请参考维多利亚密市培训中心网站：www.vicmiss.com；联系电话：905-361-8881

一年一度数据分析论坛交流会本周举行，欢迎数据分析/SAS入行，换工，提升人士参加

时间：7月28日(周六)2:30pm

7月28日（周六）2:30pm，应广大华人朋友的要求，本期数据分析论坛交流会将在维多利亚举行，此次我们邀请到两位主讲嘉宾，分别是在北美最大风险管理机构Euifax和TD Bank从事多年数据分析工作的Mr. Li和Mr. Chen分享热门行业技术。

讲座安排

Presentation by: Kelvin Li (from Equifax)

Topic 1: Business Analytics and Statistical Modeling

The Business Analytics and Statistical Modeling helps professionals gain a competitive advantage through utilizing data resources and analytical software. The lecture offers a generic procedure in applied statistical and data mining methods, focusing on the practice to build model with better performance. The topic includes

·         Variables selection

·         Model performance evaluation

·         Data exploration and automation

·         Feature engineering (feature selection, WOE, Binning, transformation, missing values treatment ,  standardization)

·         Various data mining methods (random forest, boost gradient, additive model)

·         Quantify statistical model by $ amount

Presentation by: Charles Chen (from TD Bank)

Topic 2: A Promising Model Technique -- Generalized Additive Model

Conventional Modeling Techniques have been widely used in database marketing for targeting models. Their advantages are easy to use and interpret, as well as low computing cost. However, they have some challenges as follows:

·         Generalized Linear Models is under the criticism of failure to model the nonlinear features of the predictor’s effect on the dependent variable

·         Decision Tree is under the criticism of not being robust enough

·         ANN is like a black-box, not easy to interpret, and easy to over fit

Therefore all of them might lead to unsatisfactory results! The purpose of generalized additive models is to maximize the quality of prediction of a dependent variable from various distributions, by estimating unspecific (non-parametric) functions of the predictor variables which are "connected" to the dependent variable via a link function.

适合众多背景华人的高薪求职方向——数据分析

相关职位包括SAS programmmer, Data  Analyst, Business Analyst, Marketing Analyst, Campaign  Analyst, Modeler 等职位近年来招聘众多，这些职位薪水高，一般起薪为６万左右，几年后可达到７－８万甚至１０万以上，而且工作稳定。例如某个大通讯公司在０９年底进行大规模重组，裁员30%左右，但从事数据分析的人员基本未裁。即使某些team整个撤销，而其中从事数据分析的人员并未被裁员，而是分配到其他几个 department内，继续从事数据分析工作。这充分说明数据分析在企业内许多部门都需要，从业人员需求量大，企业也尽量想留住他们。

“数据分析实战班”，助您打通高薪稳定数据分析就业之路！
高薪数据分析职位已经成为北美就业的香饽饽

【课程内容】This course introduces SAS programming, SAS GUI applications and common statistical methods used in data processing and analysis across all major industries (Banking, Health-Care Insurance, Telecom, Retail, etc). It attempts not only to provide an understanding of statistical techniques and guidance on the appropriate use of data analysis methodologies, but also to help students gain hands-on experience, practical skills and working process knowledge in the real world. This course is designed for people who desire to learn how to use SAS beyond the SAS programming knowledge. Moreover, students can build most required skills and confidence in data analysis and result interpretation through this course study.

【课程面向对象】
1. 对于正在寻找 Marketing Analyst, Business Analyst和Data analyst工作之人士；
2. 对于具有SAS证书或已经受过SAS培训的人士；
3. 对于会使用SAS技术，而无北美经验的人士；
4. 对于具有生物，医学及公共卫生专业背景的人士；
5. 对于具有金融，保险，商业管理，数学，统计学学位的人士。

名师Mr. Chen告诉您，如何学习并从事“数据挖掘”工作

公开课：7月28日(周六)2:30pm

第一次课：7月29日(周日)9am，以后固定在每周日9am-1pm

【课程内容】数据挖掘(Data Mining) 已成为企业保持竟争力的必要方法，它已广泛地应用在银行、保险、电讯、商品零售等行业的客户关系管理(CRM)，促销活动设计，信用风险预报等诸多方面并扮演着重要的角色。数据挖掘的发展得益于两个因素：信息的可用性与计算机功能的增加，特别像银行和一些大公司普遍建有数据仓库并用以存储客户及商业的各种数据，这就使得公司利用这些数据并辅以人口统计学及第三方数据去捕获它的客户消费行为模式及购买习惯成为可能。

很多朋友也会问“数据挖掘”与“ETL (Extract-Transform-Load)”和“数据库管理”有何不同？简单地说，“数据挖掘”是一个将数据提炼成知识的过程；“ETL”是数据准备的过程，而“数据库管理”是数据搜集，存取及管理的过程。如果我们把数据比作食才，则三者的不同可类比于日常生活中的烹调。“数据库管理”类似于食才的采买及保管者，“ETL”就是按照烹饪者的要求清洗整理食才的人，而“数据挖掘”才是烹饪这些食才的灶上大师傅。当然，这美味的菜肴就是基于“数据挖掘”技术从数据库的数据中获取的满足商业规则的CRM及市场的知识，而享受菜肴的人就是企业管理决策层。简而言之，基于客户数据的CRM知识发现就是由“数据挖掘”人员来完成的，所以“数据挖掘”人员在智能商业团队中占有十分重要的地位。
 
近来各大企业为了保持竟争力，都在加强和提高各自的智能商业团队。十年前或许一个大公司仅一名数据分析员，而今仅Customer Knowledge Department就有几十位数据分析人员。职位包括：Data Analyst, Predictive Modeler, Marketing Analyst, Campaign Management Analyst, Marketing consultant, Marketing assistant, Report analyst, Campaign analyst, Survey Analyst, Statistician, BI Analyst, and Treasury Analyst等。那什么样的人适合学习进而从事“数据挖掘”工作呢？如果你有SAS(或SPSS或其它)编程语言基础的；或者你有数据库知识的；或者受过MBA训练的，或者你有数学背景的，你就是合适的人选。

【课程面向对象】
1. 对于正在寻找 Marketing Analyst, Business Analyst和Data analyst工作之人士；
2. 对于具有SAS证书或已经受过SAS培训的人士；
3. 对于会使用SAS技术，而无北美经验的新移民；
4. 对于具有生物，医学及公共卫生专业背景的人士；
5. 对于具有金融，保险，商业管理，数学，统计学学位的人士。

【维多利亚数据分析系列其他课程推荐】

SAS证书经验班(Base & Advanced)

(Introduction to SAS Base Certificate/ Introduction to SAS Advanced Certificate)

 【课程特点】SAS证书班课程为广大华人定身制作，不仅帮助学员顺利考取SAS Base证书，而且帮助学员完全掌握数据处理与分析方面新的SAS就业状况和技术要求；同时，提供SAS面试常见问题及求职网站大全，加上认真、负责，具有多年经验的授课老师的细心讲解和赞不绝口的授课风格，完善的硬件设施，更能够以内至外全盘掌握SAS技能，成功扫清SAS求职路上的任何障碍，走向成功的殿堂，为寻求SAS职位的有志之士提供了就业保证.

【授课老师1】Janet Sun；

【授课老师2】Mr. Zhang；Waterloo大学统计学硕士。现任职于著名顾问公司的市场研究与发展部，主要负责Customer Level 数据分析，统计建模和Data Mining。

数据分析/SAS简历面试班

(Resume & Interview Workshop for SAS)

第一次课：7月25日(周三)7pm，以后固定在每周三7pm - 10pm

这门15 小时的超级Excel培训课程，其目的不是教你学软件而是帮助你在职场中有效地借助 Excel 快速有效解决复杂和高难的问题。因为Excel的基本功能是有限的，不需要太多的介绍。而真正的成长来源于如何把这些有限的功能不断排列组合以创新用法。学员在15小时内的上课过程中，丰富的实例和课堂练习使学员在迅速提高Excel使用水平，在老师的讲解和帮助下，将以往痛苦枯燥的工作，变成了轻松简单的几张表格，利用Excel强大的数据处理功能，迅速得到自己想要的结果。

【课程目标】
你可以在15 分钟内做出一个别人要用3个小时才能做出一个报表；
你可以在两小时内分析出一个别人要用一天时间才能找出问题根源；
你可以做出一个最优化的计划，而别人只能优化到 70％
你可以开发出一个复杂的Excel 决策支持工具而别人不知从何处着手；
你可以快捷有效地实施商务预测，而别人还茫然不知所措；
授课老师是在加拿大知名企业工作的资深分析员。六年职业生涯Excel运用精华总结。
你只需要用15小时掌握老师精选的最重要，最常用的Excel功能，就可以在老师的指导下，组合运用这些公式非常漂亮地解决繁琐，复杂，超难的商务问题。

【授课老师】Steven Huang；专业物流师(P. Log.)，毕业于瑞典Chalmers University of Technology，并获得运输管理硕士学位，在Seneca College获得全球物流供应链管理证书。曾在加拿大Wal-Mart担任Distribution Analyst一职长达三年，并曾在LCBO担任长达三年的Senior Supply Chain Analyst。拥有美国零售工业管理协会颁发的RSCC证书(Retail Supply Chain Certification)，也是Supply Chain Logistics Association Canada、Canadian Professional Logistics Institute、Council of Supply Chain Management Professionals (US)三大专业协会的成员。 

ACCESS & EXCEL VBA经验班

(Master of Access & Excel VBA)

Access虽然强大，但仍会有些功能是它没有提供的，为此Access为我们预备了VBA。配合VBA的使用，我们可以实现任何指定功能，提高工作自动化，增加工作效率。所以，VBA已成为Access工作人员必需掌握的有力工具。VBA（Visual Basic for Applications）是新一代标准宏语言，是基于Visual Basic for Windows 发展而来的。它与传统的宏语言不同，传统的宏语言不具有高级语言的特征，没有面向对象的程序设计概念和方法。而VBA 提供了面向对象的程序设计方法，提供了相当完整的程序设计语言。VBA 简单易懂，是最易学习和掌握的电脑语言之一，是学习程序设计最好的入门语言。

总之，Access 是一种易懂的关系型数据库，对数据库初学者属于最佳入口；VBA是众多语言中相对简单的一种，两者均可在短期内迅速掌握。“Access&VBA 实践班”全新设计，教授Access—VBA开发和使用环境的全面技术，更着重于Example 的演示和说明，使学员了解如何用 Access和VBA 去处理不同类型的 Data Input and Output，无论就业或提升都是帮助巨大！此课虽没有大做宣传，却美名远扬，课程口碑极好，就业形势和效果不同凡响。

【授课老师】Mr. Liu；计算机软件专业毕业，MCITP-DBA 2005/2008，拥有多年大型信息系统设计开发经验。曾经在中国主持设计开发超过1000个用户的大型政府部门办公自动化系统，AT&T全美联机系统的Senior Consultant，加拿大著名金融公司、银行及政府部门的Senior SQL Server DBA Consultant。擅长大型系统的设计，复杂数据结构的应用，企业级数据库系统的维护和开发。对于数据库系统理论及应用有精辟及独到的见解，所教授的SQL Server DBA及Access VBA 课程一直受到众多学员的好评。

SQL Server Developer 证书经验班

(Introduction to SQL Server Developer Certificate)

【授课老师】Deanna Wang，Senior Database Specialist；10年北美数据库经验，成功的带领数据库开发团队，完成从数据库设计，开发，实施，管理到后期的支持咨询工作；深入的了解软件开发流程，数据库开发管理流程，拥有丰富的，针对北美中型到企业级大型用户的实施经验；拥有MCSE，MCDBA，MCTS SQL 2005，MCITP SQL 2005 Developer，MCIPSQL 2005 Administrator 认证。

SQL BI证书项目班
(SQL Server BI Real Project)

--SSIS (integration services) enable us to build a high performance data integration solution. We can build extract, transform, and load (ETL) packages to update data warehouse, interact with external processes, clean and mine data, process analytic objects and perform administrative tasks.
 
--SSAS (Analysis Services) provides numerous online analytical processing (OLAP) features such as Key Performance Indicators (KPI), multidimensional expression (MDS) queries and scripts and Unified Dimensional Model (UDM) enable us to slice, dice and summarize information, so it can be presented a meaningful manner. Data mining permits us to find and present patterns and behavior predictors, which might not be found in the data.
 
--SSRS (Reporting Services) is a server based reporting platform that enable us to create and manage tabular, matrix, graphical and free form reports that contain data from relational and multidimensional data source. It is a powerful tool to present business data in effective way (on demand and by subscriptions) and delivery of this information to decision makers throughout the entire organization. Allow viewing and managing over a world wide web base connection makes reporting services more flexible to deploy, manage and integrated with different type applications.

【主讲人】NitaAzuaga ；Nita has 20 years experience working at both the Federal and Provincial levels of government. She is a dynamic and highly engaging educator and presenter with the ability to motivate and inspire others through superior communication and visioning skills. She has been conferred a Bachelor of Arts, Honours degree from Trent University and Bachelor of Education from the University of Toronto. She is also fluent in English, French and Spanish.

Having effective communication skills is imperative for your success. Positive communication will certainly increase the opportunities you find in your career. Having good communication skills will enable you to get ahead.  Today's job market is changing at a rapid pace.  Being good at your job is not enough.  You must also be able to communicate effectively with your clients, co-workers and managers in order to get the recognition you deserve.  Most people in technical fields are naturally introverted so communicating is not their priority.  In order to be successful in today's job market, you must make it a priority.  Managers know that good communication is essential to building a cohesive and effective team. Good managers will consult a lot with their teams, using them as a resource for information and suggestions. Being a good communicator means winning the trust of those around you.  Good communication skills will enable you to work more closely with your team members and will help you work towards your professional goals.  As a good communicator, you will know the difference between being assertive and aggressive. You will be able to keep a professional and impersonal tone in the face of provocation and this will help you deal with conflict situations. You need to be able to clearly explain any concerns you have and negotiate issues with a minimum of friction. Your manager also needs to feel confident that he or she can raise issues with you and that you will be responsive to them. Basically, your skills as a communicator are felt in nearly all of your business dealings. If you communicate well, you maximize efficiency and you will be recognized not only for your technical expertise but also for your effectiveness as a team player and as a leader.