SparkData provides training and career development programs on big data analytics, financial analysis and information technology, such as SAS/SQL/R/Python/Hive/Spark programming, business analytics, consumer data analysis, database marketing, credit risk analysis and management, machine learning and predictive modeling, computer science and software engineering etc.

Our goal is aimed to close the gap between university education and the industry. Our hands-on training programs come from different industries and are designed by data science experts and business partners. These programs enable students to gain real-world business knowledge, technical and soft skills quickly through live lectures, case studies and hands-on projects. Furthermore, we support out students with career consultation, network and referral opportunities, which are valuable for them to land on job offers and start their career in Canada.


TRAINING PROGRAM

Beginning SAS/SQL Programming

Timeline: 8 weeks

This training is for beginners with no knowledge and skills in programming. It focuses on the big data analysis by using SAS and SQL programming. You will gain the most important and essential skills for data analysts and scientists via this program. 

Furthermore, students can pass SAS Base/Adv exams to gain the global SAS programming certificates via this training.

Outlines: 

  • Fundamental knowledge and concepts about SAS programming.
  • Read in data from various sources such as CSV, delimited files, Excel and databases.  
  • Data Manipulation and Analysis:
    Sort/dedup data, subset and expand data, data aggregation and rollup,  data reshape and mutation, create analytic reports.
  • SQL and Macro Advanced Programming
  • Write out data to create external files such as CSV, text, Excel, HTML  etc. 
  • Homework after each lecture and a financial case study for you to practice.

SQL/Hive/Spark Programming

Timeline: 5 weeks

Structured Query Language (SQL) is a data query tool built in with relational databases such as Oracle, DB2, Teradata, SQL Server etc. 

For data analysts and scientists, SQL programming is a must-have skill set, because all the corporate data  is stored in relational databases. The first step in our daily work is to access and extract data from our corporate warehouse.

Recently, big data has been attracting the attention of data professionals from many fields. Numerous companies, institutes, governments are migrating from traditional databases to Hadoop to store, manage and analyze data. Therefore, this course will include:

  • Develop SQL queries in a real database environment to access and extract data from remote databases.
  • Perform data manipulation and analysis with SQL programming:
    Sort/dedup data, subset and expand data, data aggregation and rollup, data reshape and mutation, create analytic reports.
  • Upgrade and extend SQL skills to Hive/Spark programming, which enable you to work with the industry leading Hadoop and GCP databases.
  • Assign homework after each lecture and a financial case study for you to practice.

Python Programming

Timeline: 5 weeks

This Python training is for beginners with zero knowledge and skills in programming. It focuses on the numpy and pandas packages which are especially for data processing and manipulation. This program will offer you the most important and essential skills for data scientists in real work. 

Outlines:

  • Data types in Python: scalar, list, tuple, dict, series, data frame etc.
  • Read in data from various sources such as CSV, delimited files, Excel and databases.  
  • NumPy and pandas packages for data analysis and manipulation:
    Sort/dedup data,  subset and expand data, data aggregation and rollup,  data reshape and mutation, create analytic reports.
  • Write out data to create external files such as CSV, text, Excel, HTML etc. 
  • Homework after each lecture and a financial case study for you to practice.

Big Data & Business Analytics Camp

Timeline: 4 months

Note:  Each project requires hands-on coding by SAS, R or Python, and a 30 min oral presentation in class.

This training program is suitable for people who have SAS, R or Python programming skills. You can choose any of the above 3 tools to work on projects. This intensive training will focus on both technical skills such as programming, statistical analyses and more important, domain knowledge and business insights. It will enable you to gain the fundamental knowledge and skills for business analytics quickly.

It includes 4 hands-on projects in customer marketing and risk management, covering financial, telecom, and retail and credit risk industries:

  • Customer Distribution and Deactivation Analyses of Wireless Telecom Business.
  • Financial Campaign Development and Management
  • Distribution, Profiling and RFM Analyses of Retail Customers
  • Credit Risk Analytics and Management

Your gain:

  • Hands-on experience, domain knowledge, business insights and analytic skills in consumer insights and business analytics.
  • Tailor resumes by industry experts and distinguished professionals.
  • Improve interview skills by interview clinic
  • Help with job offer negotiation and reference check.

Machine Learning & Predictive Modeling in Business Analytics

Timeline: 2 months

This is an advanced training designed for people with intermediate to experienced data analysis and statistics knowledge. Machine learning and predictive modeling utilizes statistics and mathematics in order to predict future outcomes. It is the core technology behind key analytic processes and models such as database marketing, customer loyalty and retention, customer churn and win back, credit risk analysis and management etc.

  • Multiple linear regression, logistic regression, decision tree, neural network, deep learning.
  • Model diagnostics and residual analysis
  • Model building process: performance definition, data sampling, data cleansing, variable transformation/imputation, missing values /outliers, WOE technique, variable selection procedure.
  • Model validation: cross validation, decile analysis, lift curve, odds chart, KS, GINI , ROC, AUC.
  • Model implementation and strategies

In contrast to university courses, this training pays close attention to the practical uses and approaches of statistical modeling in real industries. Instead, we focus on practical modeling methods, real work practice, business insights, interpretation and application. It includes 3 hands-on projects which will allow you to grasp these advanced concepts in no time.

VIP

  1. 1V1 职业规划,VIP 全程托管
  2. 名企导师一对一精心辅导
  3. 小班课程系统学习专业技能和面试技巧
  4. 度身定制简历,针对性地进行模拟面试
  5. 内部推荐职位
  6. 帮助薪资谈判和完成背景调查

适合学员适合具有较强数学和统计知识,能够使用 SAS/SQL/Python 分析工具。请联系我们咨询详细情况。

Contact Us

Contact us today so that you can start in the right direction towards your dream job, and learn how we can tailor our services to help you get there. Please email us:  info@sparkdata.ca

You can also create a new account and join in the discussions on big data analytics at our forums!

error: Content is protected !!