Data Analytics
 

General Information

• Format: Online or in-person based on your choice of format.

​
Duration & Timings (EST)

• 6 Weeks

• 10.30 – 1.30 pm MTW

 

Scope
This Course covers:

• SQL Manipulation, Database Design Concepts and Data Mapping

• Data Visualization, Data Cleaning and Data Manipulation using Power BI and Tableau, SSIS, SSMS, and Visual Studio

 

Aim
By the end of this class, you will be able to understand the fundamentals of how databases are designed and how they work.
You will be adept at extracting the information you want for data analysis, creating visualizations, extracting, and cleaning
data using ETL tools.
 

Prerequisites
You will need a laptop or PC (Microsoft Windows™ only as all tools use Microsoft™ technologies.
 

Course Schedule

• Week 1 -3

  • SQL Server

  • Writing T-SQL Queries

  • DDL

  • DML

  • Data Modelling

  • Data Normalizing

• Week 4 - 5

  • Power BI Fundamentals

  • Power BI Visualizations

  • Power BI DAX

  • Tableau Fundamentals and Analytics

• Week 6

  • Data Manipulation, Cleaning

  • Data Warehousing Fundamentals

  • SSIS, SSRS and SSAS