Power BI dashboard driven by excel files
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
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