IT Expert System

Data Architect/Data Analytics Module

Overview

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.

Database Administration

Database Combo Course

Course Content

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