top of page

Data Architect/Data Analytics

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.

Staffing Support
  • Resume Preparation

  • Mock Interview Preparation

  • Phone Interview Preparation

  • Face to Face Interview Preparation

  • Project/Technology Preparation

  • Internship with internal project work

  • Externship with client project work

Our Salient Features:
  • Hands-on Labs and Homework

  • Group discussion and Case Study

  • Course Project work

  • Regular Quiz / Exam

  • Regular support beyond the classroom

  • Students can re-take the class at no cost

  • Dedicated conf. rooms for group project work

  • Live streaming for the remote students

  • Video recording capability to catch up the missed class

bottom of page