Skip to content

teodorapoljak/analytics-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

analytics

This is a personal SQL project created as part of my transition into data analytics.
The database is fictional and built from scratch using SQLite in DBeaver, inspired by a typical company structure with employees, branches, clients, and sales.

The goal was to create a small, realistic structure that I can analyze end-to-end.

In Excel, I explored what a company would want to know from this data. I calculated different queries, for example sales by branch, found the top employee by sales with a Pivot Table, and flagged potential issues like a branch with no sales, checked and calculated ROI per employee. Then I made simple KPI views and quick charts.

In Tableau, I wrapped everything into one interactive dashboard. You can see KPIs, sales by branch, top employee, employees without sales, and an ROI view.

Tableau "The Office" Dashboard https://public.tableau.com/app/profile/teodora.poljak/viz/CompanyDatabase_17529553785500/Dashboard2

About

Simple SQL project based on a fictional product database. Includes table creation, sample data, and analytical queries.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors