Project AutoPro
Budget: $750 – $1,500 USD
1-We have multiple Product Lines and each machines have KPIs(in total 80+ KPIs)
2- Frequency of capture (daily, weekly, event-based, others…, more than one frequency like both daily and weekly, etc.)-Shiftly, daily, weekly
3-Source of data (share point list, excel/csv, access, API, screen-scrapping [not recommended though], API, on prem database…)
4- Data transformation or formatting requirements
5- Data validation rules (what constitutes valid data, what to do in case data is not valid: Ignore, assume a default/minimum value, abandon, log/alert/notify, …)
6- Need to provide output requirements, including:
a. Dashboard(powerbi)
b. Reports
i. Filters
ii. Type of report (tabular, graph, etc.)
iii. Output columns and their formatting
2- Frequency of capture (daily, weekly, event-based, others…, more than one frequency like both daily and weekly, etc.)-Shiftly, daily, weekly
3-Source of data (share point list, excel/csv, access, API, screen-scrapping [not recommended though], API, on prem database…)
4- Data transformation or formatting requirements
5- Data validation rules (what constitutes valid data, what to do in case data is not valid: Ignore, assume a default/minimum value, abandon, log/alert/notify, …)
6- Need to provide output requirements, including:
a. Dashboard(powerbi)
b. Reports
i. Filters
ii. Type of report (tabular, graph, etc.)
iii. Output columns and their formatting