A collection of SQL projects that demonstrate my ability to analyze data, answer business questions, and generate actionable insights using SQL.
Each project follows a complete analytics workflow—from data exploration and SQL analysis to interactive dashboard creation and business reporting.
- Strengthen SQL skills through hands-on projects
- Solve real-world business problems using data
- Build portfolio-quality SQL case studies
- Create interactive dashboards and visualizations
- Demonstrate analytical thinking and data storytelling
- SQL
- SQLite
- SQLite Online
- Visual Studio Code
- Zoho Analytics (Data Visualization & Dashboards)
| Project | Description | Status |
|---|---|---|
| Housing Price Analysis | Analyze residential housing data using SQL and visualize key insights with Zoho Analytics dashboards. | Complete |
- SELECT
- WHERE
- ORDER BY
- LIMIT
- DISTINCT
- Aggregate Functions
- GROUP BY
- HAVING
- CASE Statements
- Aliases
- Data Exploration
- Data Analysis
- Dashboard Development
- Data Visualization
Each project follows a structured analytics process:
- Import and inspect the dataset
- Clean and prepare the data
- Explore the data using SQL
- Answer business questions with SQL queries
- Create interactive dashboards in Zoho Analytics
- Summarize findings and business recommendations
Each project is designed to answer business questions using SQL and data visualization, such as:
- Which properties have the highest selling prices?
- Which suburbs have the highest average home values?
- How do property characteristics influence price?
- Which regions have the most listings?
- What trends can be identified from the data?
- How can interactive dashboards support business decision-making?
As I continue learning SQL, this repository will expand with additional case studies covering new datasets and business domains.
LaQuita Jordan
M.S. in Data Analytics Graduate Student ('27)
Passionate about transforming data into actionable business insights through SQL, analytics, AI, and data visualization.
- Portfolio: https://mydatafolio.com/p/laquita-jordan
- LinkedIn: https://www.linkedin.com/in/laquitajordan-memphis/
- GitHub: https://github.com/lajordan09