Power BI dashboard driven by excel files

Job ID: 32901607

Budget: $250 – $750 USD

Seeking a PowerBi dashboard template. Will be fed by separate excel spreadsheets that will be manually updated. Excel data source file will reside in sharepoint location eventually. local file source for now.
Potential mock up diagram attached, and starting point for excel data files

BOX1: Color status report(Red/Green) at top If no incidents in past 24 hours in Transaction procissuessheet1.xlsx or settlmentissuessheet2.xlsx

BOX 2: Color status RED/GREEN Daily File uploads Sheet4.xlsx, past 24 hours, Green if Completed is yes, Red if no

BOX 3: Color status RED/GREEN Daily File uploads Sheet4.xlsx past 24 hours, Green if Completed is yes, Red if no

BOX 4: Color status RED/GREEN Daily File uploads Sheet4.xlsx past 24 hours, Green if Completed is yes, Red if no


BOX 5: Transaction Processing Summary Read from Transaction procissuessheet1.xlsx for last 5 days, display 1 item per line
BOX 6: Settlement Processing Summary Read from settlmentissuessheet2.xlsx for last 5 days, display 1 item per line

BOX 7: Eventually a Upcoming change requests(will be an api call)

BOX 8: Graph of data from dailytotals.xlsx for past 90 days

BOX 9: static HTML links to to internal toosl placeholder