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

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

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

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

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

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 

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

PUBLIC SPEAKING

NEGOTIATION