Power BI Dashboard and Reporting for Solar Company

Create a report and subsequent Dashboard from Excel files that shows the following:

Consumption
Total Household or business consumption (kWh and $$)
Household or business consumption per circuit (kWh and $$)

Solar Production
Total Solar produced (kWh)
Total Solar consumed (kWh)
Total Solar exported (kWh)

Comparisons- Solar Production estimate vs actuals
Compare the above data vs system modeled data (what the system should produce in theory) in both kWh and $$
Hourly
Daily
Monthly
Quarterly
Yearly

Create a template and dashboard that can have changing inputs to allow for:
Cost of capital
Changes in electricity costs/prices
Inflation assumptions