InfoTekGuide

Time: 32 hours (for each module) 

 

Course Description:

 

Data analysis/ architects develop, analyze, and administer data for businesses, schools, and other organizations. They need sophisticated design and development skills to collect data and translate it for use in computer applications and systems. Data architects are like data ninjas who figure out how to create and manage data for companies in complex, creative, and innovative ways. Data analysts review the data, visualize the data and find out the data patterns and based on perform data predictions.  

​

Course Topics:

​

1. Data Analysis Overview

• Database vs Information

• Data Story

• Data Analysis vs Business Intelligence

• How to present data

• How to collect data

• How to clean data

• Statistics Overview

• Data Analysis Use cases

• Data Analysis Tools and Technology

  • (Excel, Python, Power BI, Tableau, R Programming)

• LAB: Data Analysis  

• Homework

​

2. Data Analysis with Excel

• Data Analysis with Excel

• Linear Regression

• Correlation

• Excel Solver

• Forecasting

• Quiz one

• LAB

• Homework

​

3. Data Analysis with Power BI

• Power BI Desktop Overview

• Power BI Query Overview

• Data Cleansing

• Power BI Visualization

• Power BI Reports

• Power BI Dashboard

• Power BI DAX

• Group Project

 

4. Data Analysis with R Programming

• R Programming Syntax

• Vector vs Data Frame

• R Graphics Library

• AI/ML library: Association, Classification, Clustering, Decision Tree, Prediction, Recommendation

• LAB – Data Visualization

• Group Project

​

5. Data Analysis End to End Automation

• Data Analysis Pipeline

• Data Analysis Pipeline Best Practices

• Case Study

• Simplification and Automation

• Homework

• Certification Preparation

 

6. Capstone Project

 

Who should take this course?

 

• Project Manager

• Database programmer

• Web Developer

• Architect

​

​

Note: Students can combine modules to get a combo discount.