How donbugan/ebitda-dashboard works
This repository is an early-stage EBITDA Power BI dashboard project, not yet a complete dashboard application. Its documented goal is to present Revenue through EBITDA, but the README lists loading, star-schema measures, and visuals as next steps. The current tree contains SQL schemas, transformations and SEC/DA tag-discovery queries, plus helper scripts and data directories. No source excerpts were provided, so relationships below are limited to data stages and purpose explicitly described in the README; SQL and script interactions are not inferred from filenames.
Main entry points: raw Raw data · interim Interim data · metric_definitions.md Metric definitions · 01_schemas.sql Schemas
Components 18
Data stages
- Raw data
data/raw - Interim data
data/interim - Processed data
data/processed
SQL model
- Schemas
sql/01_schemas.sql - Table creation
sql/01_create_tables.sql - Transformations
sql/02_transforms.sql - Raw count DDL
sql/10_raw_line_item_counts_ddl.sql - Raw count copy
sql/11_raw_line_item_counts_copy.sql - Selected companyfacts copy
sql/20_copy_companyfact_selected.sql - SEC tag discovery
sql/discovery/10_sec_tag_discovery.sql - DA tag discovery
sql/discovery/11_da_tag_discovery.sql - Selected tags
sql/discovery/12_selected_tags.sql
EBITDA metrics
- Metric definitions
docs/metric_definitions.md - EBITDA dashboard
Data access
- Companyfacts extraction
scripts/30_extract_companyfacts_selected.sh - SQL runner
scripts/20_psql_file.sh - PostgreSQL service
docker/docker-compose.yml
Other components
- Source dataset
Connections 7
- Source dataset → Raw data: stores originals
README.md - Raw data → Interim data: cleaned outputs
README.md - Interim data → Processed data: curated outputs
README.md - Schemas → EBITDA dashboard: supports model
- Transformations → EBITDA dashboard: supports metrics
- Metric definitions → EBITDA dashboard: defines metrics
README.md - EBITDA dashboard → Metric definitions: Revenue to EBITDA
README.md