Skip to content

Expert610/Sakila_db_data_analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Sakila SQL Analysis

This project contains my data analysis and SQL practice work using the Sakila Sample Database in MySQL.
The goal of this project is to explore database analysis techniques, improve SQL skills, and gain insights from real-world structured data.


📊 Overview

The Sakila database is a sample dataset provided by MySQL that represents a DVD rental store.
It includes tables for customers, films, rentals, payments, and staff, making it ideal for practicing data analysis and query writing.

This project demonstrates:

  • Querying relational data
  • Using SQL joins, groupings, and aggregations
  • Analyzing customer and rental trends
  • Practicing subqueries, views, and analytical functions

🧠 Objectives

  • Strengthen SQL and data analysis concepts
  • Perform real-world style analytical queries
  • Generate insights from the Sakila dataset
  • Build query logic for data-driven decision-making

🧩 Tools & Technologies

Tool Purpose
MySQL Database management and query execution
Sakila DB Sample dataset for practice
SQL Data analysis and manipulation
Workbench / Command Line Query interface

📈 Key Insights

  • Identified most popular movie genres and rental patterns

  • Analyzed top-spending customers and store performance

  • Practiced advanced SQL techniques such as subqueries, joins, and views


🧑‍💻 Author

| Muhammad Yasir 💼 Data Analyst | SQL Enthusiast | BI Learner 📧 Contact: yaisikhan111@gmail.com

🏁 Future Improvements

  • Add visualization using Power BI or Tableau

  • Automate query execution via Python

  • Explore database optimization and indexing techniques

About

Practiced data analysis and query optimization on the Sakila MySQL sample database — exploring relationships, customer trends, and rental patterns through SQL.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors