Our Work

EDA (Exploratory Data Analysis) Operations on Dataset

In this, we import necessary libraries like numpy, Pandas, matplotlib, Seaborn etc and perform multiple operations on our dataset by using python with the help of Jupyter notebook IDE. And also We perform some Visualization and prediction by using ML

We perform SQL Analytics on our Project Dataset

In this section we perform all SQL commands on our dataset by using the MySQL in Cloudera platform.

We perform Business Analytics on our Project Dataset

In this section we perform four analytics i.e.

• Descriptive Analytics

• Prescriptive Analytics

• Diagnostic Analytics

• Predictive Analytics

Some questions arises from this analytics and then we perform SQL queries on it .

We migrate our project data with the help of data migration tool i.e. SQOOP

In this section we migrate our data with the help of Sqoop data migration tool . In this we perform four sqoop usecases i.e.

• HDFS Import

• HDFS Export

• Hive Import

• HBase Import

We perform Visualization on our project data with the help of Business Analytics (data visualization )with TABLEAU

In this section we perform business analytics (visualize data ) with the help of Tableau on our data .In this we visualize following terms:

• Monthwise Count of Confirmed , Deaths, Recovered Cases

• Dashboard of Monthwise count Confirmed,Deaths,Recovered Cases

• Dashboard Countrywise Confirmed Cases, Recovered Cases & Death Cases

• Weekwise Cases

• Story of sheets

We perform ML on PySpark on our project data by using Colab