PowerBI - Create Dashboard
Budget: $15 – $25 CAD
The goal of this project is to design dashboards on PowerBI. The data sources are CMDB (assets with information on who the owner is, business unit, dns, IP, etc) and another data source that has DNS, IP, Issue-Discovered-Date, Criticality.
The type of dashboards / visual that are expected are:
- How many Critical are assigned to each Owner
- Trendline based on when the Issue was discovered
- Issues by Business Units
- Sum of Issues
- Missing data from Data Source (ex: missing owners info).
Some of the fields may have FQDN (hostname.domain.local) and others just a shortname (hostname). Matching / correlating data should be on FQDN, DNS, Shortname, or IP.
This will be a remote session only during GMT -5.
Approximate time to complete is 5-8 hours.
This is a Proof of Concept that requires to be completed by Tuesday Marc 22nd.
The type of dashboards / visual that are expected are:
- How many Critical are assigned to each Owner
- Trendline based on when the Issue was discovered
- Issues by Business Units
- Sum of Issues
- Missing data from Data Source (ex: missing owners info).
Some of the fields may have FQDN (hostname.domain.local) and others just a shortname (hostname). Matching / correlating data should be on FQDN, DNS, Shortname, or IP.
This will be a remote session only during GMT -5.
Approximate time to complete is 5-8 hours.
This is a Proof of Concept that requires to be completed by Tuesday Marc 22nd.
Related categories:
Microsoft PowerBI