With successfully Finalizing the Data Analysis/Analytics course, students will have core hands
on experience in
 Core skills in Storing Data Sets
 Managing text files
 Managing CSV and Spreadsheets
 Databases
 Core skills in Computing Basic Statistics
 Using Statistical Functions
 Filtering data
 Summarizing by group
Core skills in Finding Patterns in Data Set
 Spotting trends
 Visualizing with Charts
 Statistical fluctuations
 Making Linear predictions
 Finding correlations
Core skills in Microsoft Excel formulas and Pivot Tables
VLOOKUPs in Excel
 Pivot tables
 Formulas and cell referencing
 Charting using Excel
 Core skills in Data Visualization, Reporting and Automatic Dashboards
Connecting SQL to Business Intelligence software
 Using PowerBI
 Feeding to Web Visualization
 Geospatial visualization
 Trend Analysis
 Descriptive Analytics
Core skills in Big Data Sources and Challenges
Digital libraries
Storages and data analysis processing
Hadoop and Spark Basics
Using Hive (SQL for Data Analysis)