~Get Your Files Here !

  1. What Is Data Analysis

   2. Steps in data analysis workflow.mp4

  2. What Is Hypothesis Testing

   2. Various elements of hypothesis testing.mp4

  3. Step 1 - Data Cleaning and Manipulation in Excel

   2. Practice data - Missing values.html

   3. Dealing with inconsistent values.mp4

   4.1 PD - Inconsistent value.xlsx

   6. Practice data - Outliers.html

   7. Dealing with duplicated values.mp4

   8.1 PD - duplicates.xlsx

  4. Step 2 - Exploratory Data Analysis in Excel

   2. Frequency and percentage analysis.mp4

   3.1 PD - FP analysis.xlsx

   5. Practice data - Descriptive analysis.html

   6. Group by analysis in excel pivot table.mp4

   7.1 PD - PVT analysis.xlsx

   9. Practice data - Crosstabulation analysis.html

  5. Step 3 - Statistical Analysis and Hypothesis Testing in Excel

   10. Practice data - Regression analysis.html

   2. Practice data - Independent sample t-test.html

   3. Paired sample t-test.mp4

   4.1 PD - PRDSTT analysis.xlsx

   6. Practice data - ANOVA.html

   7. Pearson correlation analysis.mp4

   8.1 PD - CORR analysis.xlsx

  6. Final step - Putting All Together in Dashboard

   2. Creating the final dashboard.mp4

   3.1 Dashboard.xlsx