​Data Analysis and Visualization

MICROSOFT EXCEL

  • Excel Power Query, Power Pivot and DAX

  • Advanced Excel and Formulas

  • Data Analysis with Excel Pivot Tables

PYTHON 3

  • NumPy

  • Pandas

  • Matplotlib

  • Seaborn

  • SciPy

  • SciKit-Learn

  • Data Capstone Project

SQL

  • Take control of dataset - insert, update and delete records from database 

  • Answer specific business questions by using SQL's aggregate functions 

  • Triggers, sequences, local and global variances, indexes, etc.

  • Create, design and operate SQL databases

TABLEAU

  • Visualize data in the form of various chars, plots, maps, and interactive dashboards

  • Work with time-series data

  • Create data extracts

  • Aggregation, granularity and level of detail

  • Create data hierarchies

POWERBI​

  • Connect and transform the raw data

  • Build a relational data model

  • Add calculated fields with DAX

  • Design interactive Power BI reports

​Data Science & Machine Learning

PYTHON

  • Linear Regression

  • Logistic Regression

  • Cross Validation and Bias-Variance Trade-Off

  • K Nearest Neighbours

  • Decision Trees and Random Forests

  • K Means Clustering

  • Principal Component Analysis

  • Natural Language Processing

  • Neural Nets and Deep Learning

Big Data

HADOOP

  • Manage big data on a cluster with HDFS and MapReduce

  • Write programs to analyze data on Hadoop with Pig and Spark

  • Store and query data with Sqoop, Hive, MySQL, HBase, Cassandra, MongoDB, Drill, Phoenix, and Presto

  • Learn how the cluster is managed with YARN, Mesos, Zookeeper, Oozie, Zeppelin, and Hue

  • Handle streaming data in real time with Kafka, Flume, Spark Streaming, Flink, and Storm

APACHE SPARK WITH SCALA

  • Translate complex analysis problems into iterative or multi-stage Spark scripts

  • Scale up to larger data sets using Amazon's Elastic MapReduce service

  • Understand how Hadoop YARN distributes Spark across computing clusters

  • Practice using other Spark technologies, like Spark SQL, DataFrames, DataSets, Spark Streaming, and GraphX

Finance & Accounting

SAGE 300

  • Understand Debits and Credits in sub-ledgers

  • Print AR reports such as Batch listing, invoices, Posting Journals, Customer Reports and Aged Trial Balance

  • Print AP reports such as Batch listing, invoices, Posting Journals, AP Vendor reports, and Aged Payables Report

  • Print GL reports such as Trial Balance (3 types), Transactions Listing and Posting Journals to name a few

  • Recognize and deal with overpayments in AR

FINANCIAL MODELLING

  • Build a P&L statement from a raw data extraction

  • Build a cash flow statement

  • Know how to value a company

  • Build a valuation model from scratch

  • Create a model with multiple scenarios

  • Create professional and good-looking advanced charts

FINANCIAL ANALYSIS

  • Accounting, Financial Statements, and Financial Ratios: Debits and Credits, Profit and Loss statements,Balance Sheets, Liquidity, Solvency, Profitability, and Growth Financial Ratios

  • Finance Basics: Interest Rates, Financial Math Calculations, Loan Calculations, Time Value of Money, Present and Future Value of Cash Flows

  • Capital Budgeting: Decide whether a company's project is feasible from a financial perspective and be able to compare between different investment opportunities

Website Design and Development 

WORDPRESS

  • Navigate around the Wordpress dashboard

  • Create pages and posts

  • Create custom menus and navigation systems

  • Correctly use post categories and tags

  • Configure Wordpress for best results

  • Understand, find and install plugins & themes and how to find/install them

  • Protect Wordpress website from hackers and spammers

HTML5 & CSS3

  • Create any website layout

  • Support any device size with Responsive (mobile-friendly) Design

  • Add tasteful animations and effects with CSS3

  • Use common vocabulary from the design industry

  • Learn jQuery effects like animations, scroll effects and "sticky" navigation

JAVASCRIPT, NODE, REACT

  • Master backend development with Node

  • Master frontend development with React

  • Learn the latest frameworks and technologies, including Javascript ES6, Bootstrap 4, MongoDB

  • Master frontend development with React

Digital Marketing

SEO

  • Bring in more organic traffic from Google & other search engines

  • Make websites to load in less than 0.5 seconds & increase sales / conversions by 2X

  • Get Page speed insights score of up to 100 for both desktop and mobile

  • Learn the Essential skills to optimize websites for Google and Bing search engines

  • Immune websites against Negative SEO attacks and identify bad backlinks to your site​

GOOGLE ANALYTICS

  • Load Demo Data from a Real Online Store

  • Add Filters to Remove Internal Traffic

  • Analyze Real Time, Audience, Acquisition and Behaviour Reports

  • Deep Dive Into Data with Dimensions & Segments

  • Track Marketing Campaigns with Campaign Tagging

  • Remove Spam Traffic

  • Master new features like Analytics Intelligence

GOOGLE ADS

  • Set up conversion tracking and track phone calls from websites

  • Track sales, revenue and form submissions using Google AdWords

  • Write and A/B test ads 

  • Structure accounts, campaigns, ad groups and keyword lists for optimal results

  • Use tools like SEMrush and Optmyzr to automate optimization tasks and run better analyses 

Video Editing & Game Development

ADOBE PREMIERE PRO CC

  • ​Edit short documentary using the supplied footage (video clips, photos, graphics, music, etc.)

  • Export and save videos for HD playback

  • Color correct videos to fix issues with white balance and exposure

  • Apply visual effects such as stabilizing shaky video, removing grain, and making video more cinematic with overlays

  • Edit green screen footage and add backgrounds

​C# UNITY DEVELOPMENT

  • Gain an excellent general knowledge of video game design

  • Make 2.5D and 3D games in Unity

  • Get experience using Unity 2017 - a very versatile 3D tool

  • Transfer knowledge to .NET, other languages, and more

  • Learn how object oriented programming works in practice

     

MAYA 3D

  • Build and design 3D objects

  • Animate 3D objects with keyframes

  • Model, shade, texture, light beautiful designs

  • Render projects for high quality playback

  • Rig a 3D character for animation

  • Simulate dynamic effects like water, cloth, and smoke

  • Combine an entire 3D animated scene

Presentation and Communication Skills

NEGOTIATION

Contact

+1-236-455-2400

#930 - 470 Granville Street Vancouver, BC V6Z 1S4

© 2017-2020 Alba Inc.