🧠 HR BI Project — PostgreSQL + SQL + Tableau + Python Automation

This project is a Business Intelligence (BI) showcase built on real HR data.
It integrates PostgreSQL + SQL Views + Python Export + Tableau Dashboards, making it perfect for data storytelling and job interview presentations.

---

📊 Project Overview

HR_BI is a lightweight HR analytics platform.
It supports SQL-based queries and automatically exports analytical views into .csv files for Tableau.

---

🔧 Tech Stack

• 🛢️ PostgreSQL – backend storage for HR data
• 🧠 DBeaver – ERD and database management
• 🐍 Python – automation of .csv view exports
• 📊 Tableau – storytelling and dashboarding
• ⚙️ VS Code – full project environment
• 🔐 dotenv – secret and config management

---

• 🧠 DBeaver – SQL query testing, ERD design, and live view debugging

📁 Project Structure

mlops_hr_bi_project/
│
├── README.md
├── .env.example
├── requirements.txt
│
├── data/                    # exported CSV views
│   ├── employee_full_info_*.csv
│   ├── avg_salary_by_department_*.csv
│   ├── count_by_position_*.csv
│   └── salary_trends_*.csv
│
├── sql/
│   ├── ddl/
│   │   ├── create_tables.sql
│   │   └── create_views.sql
│   ├── dml/
│   │   └── insert_data.sql
│   └── dql/
│       ├── analysis_queries.sql    
│       └── test_selects.sql 
│
├── scripts/
│   └── export_views.py
│
└── tableau/
    ├── dashboard.twbx
    └── screenshots/
        ├── story_overview.png
        └── trends.png

Story Section	PDF Link
📊 Employees per Department	Story 1
💼 Employees per Position	Story 2
💰 Avg Salary by Department	Story 3
🧠 Who Earns More?	Story 4
📈 Hiring Trend	Story 5

📄 Download Story PDFs

Each story point is exported as a PDF for quick access or offline use.

🗂️ Downloadable Tableau Stories (PDFs) Every story point from the Tableau dashboard is exported as a standalone PDF. These are perfect for quick reviews, presentations, or adding to your job interview materials.

⚙️ How It Works

• SQL scripts create the schema and generate analytical views

• Python exports those views into .csv for Tableau

• Tableau dashboards visualize key metrics and patterns

• 📌 Example Views

-- View: Average salary by department

SELECT dept_name, AVG(salary) AS avg_salary
FROM employee_full_info
GROUP BY dept_name;

-- View: Employees with latest salary change

SELECT emp_id, emp_name, MAX(changed_at) AS last_changed_at
FROM employee_salary_history
GROUP BY emp_id, emp_name;

💾 .env Setup

DB_NAME=hr_bi
DB_USER=postgres
DB_PASSWORD=your_password
DB_HOST=localhost
DB_PORT=5432

🚀 How to Run

# Activate environment

conda activate mlops_hr_bi_env

# Export all views into /data/

python scripts/export_views.py

📸 Dashboard Preview

Interactive Tableau Story with hiring trends

• 🪄 What’s Next?

• ✔️ Finish Tableau dashboard & Story (1 file with all insights)

• 📎 Export as PDF & screenshots for resume & LinkedIn

• 📌 Add storytelling section + links once live

• ⭐ Give the repo a star if you'd use this as a template for BI storytelling projects

📢 Stay Connected!

💻 GitHub Repository: Evgenii Matveev
🌐 Portfolio: Data Science Portfolio
📌 LinkedIn: Evgenii Matveev