Skip to content

dmortalla/project6-sql-optimization

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

💰 Financial KPI Dashboard (SQL + Power BI)

Automated financial analytics system integrating SQL, Python, and Power BI.

Workflow

  1. Python ETL merges Income, Balance, and Cash Flow data.
  2. KPIs (Net Margin, ROE, ROA, Current Ratio) computed.
  3. Data uploaded to PostgreSQL.
  4. Power BI dashboard visualizes financial performance.
  5. GitHub Actions automates daily data refresh.
  6. Dashboard embedded in Hostinger portfolio.

Tech Stack

  • Python (pandas, SQLAlchemy)
  • PostgreSQL
  • Power BI
  • GitHub Actions
  • Hostinger

About

SQL-based Financial KPI dashboard with optimized Power BI queries.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages