Course Content
SQL Data Analytics Project
Purpose: Analyze sales data to identify trends, top-selling products, and revenue metrics for business decision-making. Description: In this project, you will dive into a large sales dataset to extract valuable insights. You will explore sales trends over time, identify the best-selling products, calculate revenue metrics such as total sales and profit margins, and create visualizations to present your findings effectively. This project showcases your ability to manipulate and derive insights from large datasets, enabling you to make data-driven recommendations for optimizing sales strategies. Additional Tools: Excel or data visualization tools like Tableau or Power BI can help you create visually appealing charts and graphs to present your findings effectively. Excel: Used for data manipulation, calculations, and basic visualizations. Data visualization tools like Tableau, Power BI, or Google Data Studio: Used for creating interactive and visually appealing dashboards and charts.
0/8
SQL Projects
About Lesson

Purpose: Analyze student performance data to identify patterns, factors influencing academic success, and propose strategies for improvement.

Description: Education is a crucial domain where data analysis can drive positive outcomes. In this project, you will work with a student performance dataset that includes grades, attendance records, and demographic information. By applying SQL, you will analyze patterns in student performance, identify factors that influence academic success, and propose strategies for improvement. This project demonstrates your ability to use data to make informed decisions in the education sector.

Additional Tools: Excel or data visualization tools can help you create visual representations of student performance and identify correlations between different factors.

  • Excel: Used for data manipulation, calculations, and basic visualizations.
  • Data visualization tools like Tableau, Power BI, or Google Data Studio: Used for creating interactive and visually appealing dashboards and charts.

About Dataset

Context

Marks secured by the students

Content

This data set consists of the marks secured by the students in various subjects.

Acknowledgements

http://roycekimmons.com/tools/generated_data/exams

Inspiration

To understand the influence of the parents background, test preparation etc on students performance

 

Exercise Files
StudentsPerformance.csv
Size: 70.35 KB