---
title: "Discussion on \"Designing a Dimensional Model for Sales Analysis and SQL Queries for a car repair shop Using an Invoice.\" | Hashnode"
description: "Discussion on \"Designing a Dimensional Model for Sales Analysis and SQL Queries for a car repair shop Using an Invoice.\". The image above is the Entity Relationship Diagram as inspired by the invoice sample here. You can access a better view of the image in the Google Drive here.\nDESCRIPTION OF EACH TABLE AND COLUMN\nDefinition of Primary Keys for Each Table\nPrimary keys..."
url: "https://hashnode.com/posts/designing-a-dimensional-model-for-sales-analysis-and-sql-queries-for-a-car-repair-shop-using-an-invoice/66b34d07555eebc046b82ea0"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Designing a Dimensional Model for Sales Analysis and SQL Queries for a car repair shop Using an Invoice.](https://the-ayodele-adeniyi.hashnode.dev/designing-a-dimensional-model-for-sales-analysis-and-sql-queries-for-a-car-repair-shop-using-an-invoice?utm_source=hashnode&utm_medium=feed)

The image above is the Entity Relationship Diagram as inspired by the invoice sample here. You can access a better view of the image in the Google Drive here. DESCRIPTION OF EACH TABLE AND COLUMN Definition of Primary Keys for Each Table Primary keys...

Aug 7, 2024 · 5 min read · the-ayodele-adeniyi.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#dimensional-data-modeling](https://hashnode.com/tag/dimensional-data-modeling)
-   [#relational-database](https://hashnode.com/tag/relational-database)

## Written by

[Ayodele Adeniyi](https://hashnode.com/@JoseyMiles)

@JoseyMiles · Nigeria

  
[View profile](https://hashnode.com/@JoseyMiles)

Data Analyst, Data Scientist

I am a certified data analyst with extensive experience working with datasets across various niches and sectors. My passion for data analytics stems from a desire to contribute to the technological ecosystem by enabling organizations leverage data for informed decision-making that drives growth. I am proficient in using tools such as Excel, PowerBI, SQL, Tableau, and Python to derive valuable insights. When I am not deriving insights from data, I enjoy playing chess and engaging in thoughtful discussions to share opinions and perspectives with others. Welcome to my blog, where you will find projects I have undertaken both individually and collaboratively with other teams.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
