Dimension Tech

Data Analytics Course

More and more companies realize the importance of big data. Nowadays, no matter where you are in your career or what field you work in, you would better to know how to deal with data and interpret it. In other words, you should learn data analysis skill and apply tomorrow.

A data analyst collects, processes, and created visualization in order to gain insights form complex data sets. various data analysis method can be used to help us to interpret the data. We would lead you to get familiar with this track path from fundamental concept to advanced skill set. Moreover, essential topic like data manipulation, data visualization and statistics foundation are also included in our training course.
The Course outline is listed below. The cost of this course is: $13000.00

Chapter 1: Instruction of becoming a data analyst in an efficient way -0.8% 10 hours
Lesson 1: What is the general path for being a data analyst
Lesson 2: How to learn and practice in this course

Chapter 2: How to think like a data analyst -8.3% 40 hours

Lesson 3: the reason of why we put this in beginning
Lesson 4: Structured principle of Data Analysis
Lesson 5: Formulation principle of Data Analysis
Lesson 6: Business principle of Data Analysis
Lesson 7:  Analysis with Quadrant Method
Lesson 8: Analysis with Multidimensional Method
Lesson 9: Analysis with hypothesis
Lesson 10: Analysis with Index Method
Lesson 11: Analysis with 28 Laws
Lesson 12: Analysis with Comparative Method
Lesson 13: Analysis with Funnel Method
Lesson 14: How those method used in real life work

Chapter 3: How analysis differ in business model -10.4% 50 Hours
Lesson 15: why business is important to consider
Lesson 16: What Indicator matter in business analysis
Lesson 17: Using indicator to estimate Marketing
Lesson 18: Using indicator to estimate Product Operational
Lesson 19: Using indicator to estimate User Behavior
Lesson 20: Using indicator to estimate E-Commerce
Lesson 21: Using indicator to estimate Traffic
Lesson 22: crate a new indicator
Lesson 23: Build a Business Analysis Framework
Lesson 24: Introduction to Marketing Model
Lesson 25: classic AARRR Model
Lesson 26: Build a User Behavior Model
Lesson 27: Build a E-Commerce Model
Lesson 28: Build a Traffic Model
Lesson 29: Business scenarios
Lesson 30: Practice for those scenarios -0.8% 10 Hours
Lesson 31: Data Management In Business

Chapter 4: Handle Data With Spreed Sheet -10.4% 50 Hours
Lesson 32: Introduction to spreed sheet
Lesson 33: Text Cleaning
Lesson 34: Exercise for text Cleaning
Lesson 35: Matching command
Lesson 36: Logical statement in spreed sheet
Lesson 37:  Statistical pre-build methods in spreed sheet
Lesson 38: Time Series in spreed sheet
Lesson 39: Frequently Asked Questions
Lesson 40: Spreed Sheet Toolkit (1)
Lesson 41: Spreed Sheet Toolkit (2)
Lesson 42: Data Analysis with spreed sheet example (1)  -0.8% 10 hours
Lesson 43: Data Analysis with spreed sheet example (2)  -0.8% 10 hours

Chapter 5: Data Visualization -10.4%  50 hours
Lesson 44:Why we care Data Visualization
Lesson 45: Fundamental Chart
Lesson 46: Advanced Chart Types
Lesson 47: Introduction to drawing tools
Lesson 48: visualization with spreed sheet based software
Lesson 49: Scatter graph
Lesson 50: strategy I — helper column

Lesson 51: bar graph
Lesson 52: Gantt diagram(1)
Lesson 53: Gantt diagram(2)
Lesson 54: FIG
Lesson 55: DuPont Analysis method
Lesson 56: Introduction to Power BI
Lesson 57: Power BI foundation
Lesson 58: Power BI advance strategy
Lesson 59: Practice with BI (1)  -0.8% 10 Hours
Lesson 60: Practice with BI (2)  -0.8% 10 Hours
Lesson 61: BI Dashboard

Chapter 6: SQL -10.4% 50 hours
Lesson 62: Instruction to install SQL
Lesson 63: relational database
Lesson 64: Other type of database
Lesson 65: SQL select statement
Lesson 66: SQL conditional statement
Lesson 67: SQL group by statement
Lesson 68: SQL group by statement advanced strategy
Lesson 69: SQL builtin Function
Lesson 70: SQL Sub-query statement
Lesson 71: SQL join statement
Lesson 72: SQL Leetcode question set
Lesson 73: SQL Load data
Lesson 74: SQL Time
Lesson 75: practice SQL project(1)  -0.8% 10 Hours
Lesson 76: practice SQL project (2)  -0.8% 10 Hours
Lesson 77: using SQL with power bi

Chapter 7: Statistics foundation-10.4% 50 hours
Lesson 78: Descriptive Statistics concept
Lesson 79: Introduction to quantile
Lesson 80: Standard deviation
Lesson 81: Introduction to Weight
Lesson 82: Advance to weight
Lesson 83: Box Line diagram
Lesson 84: Histogram usage
Lesson 85: Introduction to Probability
Lesson 86: Introduction to Bayesian
Lesson 87: Introduction to Binomial Distribution
Lesson 88: Advance to Binomial Distribution
Lesson 89: Introduction to Poisson Distribution
Lesson 90: Introduction to Normal Distribution
Lesson 91:How to test your Hypothesis

Chapter 8: Data analysis with Python  -23% 110 hours
Lesson 92: Introduction to python
Lesson 93: Data Type in python
Lesson 94: Introduction to Variable
Lesson 95: Introduction to Listing
Lesson 96: Advanced to Listing
Lesson 97: Introduction to Dictionary
Lesson 98: Introduction to Collection
Lesson 99: Introduction to Control Flow
Lesson 100: How to use Control Flow Loop in python
Lesson 101: Python Loop advanced strategy
Lesson 102: Builtin Python Function
Lesson 103: advanced Function
Lesson 104: Third Party Package