SQL Data Consolidation & SSRS Reporting
Budget: $250 – $750 AUD
I need a professional who can create SQL queries to consolidate various sensor readings from different instruments (like level, flow, etc) into a report. The report should be generated in SSRS (Express 2022) and should depict data points based on a time range or the previous 24-hour period. The report should include a graph of the data points along with a table.
Key Requirements:
- Create SQL queries to consolidate sensor data.
- Convert time into SQL format.
- Generate a report in SSRS (Express 2022).
- Include a graph and a table in the report, with all data points in the table for the time period.
Ideal Skills:
- Proficient in SQL and SSRS.
- Experience with data consolidation and reporting.
- Familiarity with sensor readings and data analysis.
- Able to work with daily, weekly, and specific time ranges.
Access to our SQL Server computer is available via Remote-Utilities app for development.
Key Requirements:
- Create SQL queries to consolidate sensor data.
- Convert time into SQL format.
- Generate a report in SSRS (Express 2022).
- Include a graph and a table in the report, with all data points in the table for the time period.
Ideal Skills:
- Proficient in SQL and SSRS.
- Experience with data consolidation and reporting.
- Familiarity with sensor readings and data analysis.
- Able to work with daily, weekly, and specific time ranges.
Access to our SQL Server computer is available via Remote-Utilities app for development.