How alexochoki/solarops works
This repository is a Power BI business-intelligence product for monitoring a customer-to-service lifecycle: leads and sales, financing and payments, installations, asset usage, and service tickets. Users consume the report, which queries a semantic model over the supplied dimensional and fact data. The tree supports the product boundaries and domain coverage, but no README or source excerpts document refresh mechanics or detailed table relationships; those connections are therefore kept at the subsystem level.
Main entry points: sc.SemanticModel/definition Power BI Model · sc.Report/definition Report Definition · data CSV Data · relationships.tmdl Model Relationships
Components 17
Data Inputs
- CSV Data
data - Lead Facts
data/fact_leads.csv - Sales Facts
data/fact_sales_orders.csv - Installation Facts
data/fact_installations.csv - Finance Facts
data/fact_payments.csv - Loan Snapshots
data/fact_loan_snapshot_monthly.csv - Asset Usage
data/fact_asset_usage_daily.csv - Service Tickets
data/fact_service_tickets.csv - Business Dimensions
data
Semantic Model
- Power BI Model
report/sc.SemanticModel/definition - Model Relationships
report/sc.SemanticModel/definition/relationships.tmdl - Measures
report/sc.SemanticModel/definition/tables/ZMeasures.tmdl - Funnel Stages
report/sc.SemanticModel/definition/tables/Funnel_Stage.tmdl - Stage Aging
report/sc.SemanticModel/definition/tables/Stage_Aging.tmdl
Analytics Report
- Report Definition
report/sc.Report/definition - Report Pages
report/sc.Report/definition/pages
Other components
- Business User
Connections 8
- Business User → Report Definition: views
- Report Definition → Power BI Model: queries
- CSV Data → Power BI Model: model inputs
- Power BI Model → Model Relationships: defines links
- Power BI Model → Measures: defines measures
- Power BI Model → Funnel Stages: includes stages
- Power BI Model → Stage Aging: includes aging
- Report Definition → Report Pages: organizes pages