Industry Hard Skills Enhancement
With the development of big data and artificial intelligence, more and more business decisions are being driven by data. Therefore, data analysis has become a necessary skill or an absolute advantage across various industries, from venture capital in finance to management consulting, and from user operations to digital marketing
Zero Foundation Needed
Quick to Learn
The course is explained in a simple yet profound manner, refined by the teaching research team + a major support system. A gold-medal instructor will guide you from zero foundation, ensuring high learnability.
High-Quality Video Courses
Full of Substance
Not your traditional recorded lectures, but carefully edited to ensure the course’s fluency, completeness, and density of practical content, aiming for the best learning experience.
Project-Based Teaching
Job-Oriented
Professional content output with a career orientation, each course includes 1-3 projects, striving to break down the barriers from knowledge to application.
Excel for Financial Modeling
Skills learned in the course
- Basic and advanced Excel functions
- Statistical tools: Pivot Table
- Visualization tools: Charts
- Decision-making tools: Solver
Project Overview
- Project #1 – Fund Asset Allocation Decision: Use Solver for asset allocation to optimize investment return.
- Project #2 – Stock Price Simulation: Build a stock price simulation model, combined with Monte Carlo simulation to predict stock trends.
VBA for Business Problem Solving
Skills learned in the course
- Batch processing data, liberating from massive reports
- Creating financial models for automated data management
- Automation programming tool: VBA
Project Overview
- Project #1 – Business Process Automation: Use Excel VBA for one-click automated presentation and storage of analysis results.
- Project #2 – VBA Data Visualization
SQL for Business & Data Analytics
Skills learned in the course
- Data manipulation by joining and modifying various tables and records
- Data cleaning by filtering and aggregating features and instances
- Data reporting by organizing data and generating reports
- Use of Common Table Expressions
- Use of Stored Procedures and Triggers
- Explanation of Leetcode major company interview questions
Project Overview
- Project #1 – Retail and FMCG Industry Database Analysis: Help a retail company organize and analyze sales, inventory, and other information in the database and generate reports.
- Project #2 – Banking Industry Credit Card Marketing Campaign Analysis: Help a bank analyze the Credit Limit Increase Campaign.
Python for Data & Business Analytics
Skills learned in the course
- Iterative processing of data
- Custom functions and Lambda functions
- Data analysis tools: Numpy, Pandas, Matplotlib, etc.
- Cleaning data, summarizing data, filtering data, and creating visual representations for analysis
- Explanation of Leetcode major company interview questions
Project Overview
- Project #1 – Data Analysis using Pandas: From reading and inspecting data to cleaning, summarizing, and filtering data, until the final data analysis and visualization, completing the entire business data analysis process.
Python for Machine Learning
Skills learned in the course
- Mainstream machine learning models: Regression, classification, clustering models, etc.
- Mainstream machine learning algorithms: Linear regression, logistic regression, decision trees, artificial neural networks, k-nearest neighbors, etc.
Project Overview
- Project #1 – Predicting Fatal Traffic Accidents: Use various machine learning algorithms for modeling, predict the rate of fatal traffic accidents and evaluate the prediction results of each model.
- Project #2 – Image Recognition: Use neural network algorithms in deep learning for modeling and image recognition.
Tableau for Business Intelligence
Skills learned in the course
- Creating visual presentations: Common chart creation in Tableau
- Dynamic result presentation: Design and create dashboards, using parameters to make data presentation dynamic within dashboards
- Expert certification exam preparation: Core knowledge points and sharing of mock exam questions
Project Overview
- Project #1 – Design and Creation of a Business Intelligence Dashboard: Use Tableau to create a Business Intelligence Dashboard, providing business analysis and insights.
Power BI for Business Intelligence
Skills learned in the course
- Data cleaning and processing with Power BI
- Creation of visualized reports in Power BI
- Advanced data processing
Project Overview
- Project #1 – Analysis of Toronto’s Airbnb Market: Analyze and process Airbnb website data, analyze the Toronto market, and create visual analysis reports.
- Project #2 – Multidimensional Data Analysis Using Data from Different Sources: Use various open-source data from government websites, complete data ETL using Power BI’s powerful data cleaning capabilities, and extract valuable information in preparation for further visualized reporting.
- Project #3 – Creating an Interactive Report for Real Estate Purchase Decisions with Power BI: Learn common business decision analysis methods, perform advanced ETL on data, and use Power BI’s DAX to break down an abstract business problem, creating an interactive formatted report for business analysis.