Data Architect / Data Analytics moduleData Analytics Module

Data analysts review, visualize and find patterns in data, then make predictions. This hands-on module covers Excel, Power BI, R programming and pipeline automation.

Book an appointment Call 847-350-9034

Hands-on labsGroup projectsCapstone project

Six parts of the course

From data basics to a capstone project. 1

Data analysis overview

Collecting, cleaning and presenting data, statistics overview, tools and use cases.2

Analysis with Excel

Linear regression, correlation, Excel Solver and forecasting.3

Analysis with Power BI

Query, data cleansing, visualization, reports, dashboards and DAX.4

Analysis with R

R syntax, graphics library and AI/ML libraries.5

End-to-end automation

Analysis pipeline, best practices, case study and certification preparation.6

Capstone project

Apply the skills in a final project.

Detailed course content

Topics covered in each part.

1. Data analysis overview

✓Database vs information, data story✓Data analysis vs business intelligence✓How to present, collect and clean data✓Statistics overview and use cases✓Tools: Excel, Python, Power BI, Tableau, R✓Lab and homework

2. Data analysis with Excel

✓Linear regression and correlation✓Excel Solver and forecasting✓Quiz, lab and homework

3. Data analysis with Power BI

✓Power BI Desktop and query overview✓Data cleansing and visualization✓Reports, dashboards and DAX✓Group project

4. Data analysis with R programming

✓R syntax, vector vs data frame✓R graphics library✓Association, classification, clustering, decision tree, prediction, recommendation✓Data visualization lab and group project

5-6. Automation and capstone

✓Data analysis pipeline and best practices✓Case study, simplification and automation✓Homework and certification preparation✓Capstone project

Support and salient features

Career support and classroom features that come with the course.

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and 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 and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Explore more training

See other programs, funding options and the class schedule. All training programs Education grant program Upcoming classes

Ready to work with data?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program

Six parts of the course

From data basics to a capstone project.1

Data analysis overview

Collecting, cleaning and presenting data, statistics overview, tools and use cases.2

Analysis with Excel

Linear regression, correlation, Excel Solver and forecasting.3

Analysis with Power BI

Query, data cleansing, visualization, reports, dashboards and DAX.4

Analysis with R

R syntax, graphics library and AI/ML libraries.5

End-to-end automation

Analysis pipeline, best practices, case study and certification preparation.6

Capstone project

Apply the skills in a final project.

Detailed course content

Topics covered in each part.1

Data analysis overview

✓Database vs information, data story✓Data analysis vs business intelligence✓How to present, collect and clean data✓Statistics overview and use cases✓Tools: Excel, Python, Power BI, Tableau, R✓Lab and homework2

Data analysis with Excel

✓Linear regression and correlation✓Excel Solver and forecasting✓Quiz, lab and homework3

Data analysis with Power BI

✓Power BI Desktop and query overview✓Data cleansing and visualization✓Reports, dashboards and DAX✓Group project4

Data analysis with R programming

✓R syntax, vector vs data frame✓R graphics library✓Association, classification, clustering, decision tree, prediction, recommendation✓Data visualization lab and group project5

5-6. Automation and capstone

✓Data analysis pipeline and best practices✓Case study, simplification and automation✓Homework and certification preparation✓Capstone project

Support and salient features

Career support and classroom features that come with the course.1

Staffing support

✓Resume preparation✓Mock interview preparation✓Phone interview preparation✓Face to face interview preparation✓Project and technology preparation✓Internship with internal project work✓Externship with client project work2

Our salient features

✓Hands-on labs and homework✓Group discussion and case study✓Course project work✓Regular quiz and exam✓Regular support beyond the classroom✓Students can re-take the class at no cost✓Dedicated conference rooms for group project work✓Live streaming for remote students✓Video recording to catch up on a missed class

Explore more training

See other programs, funding options and the class schedule.All training programs Education grant program Upcoming classes

Ready to work with data?

Call 847-350-9034 or book an appointment to talk about this course and funding options.Book an appointment Call 847-350-9034 Education grant program