SQL & Power BI Reports
Budget: ₹100 – ₹400 INR
I have an existing Microsoft SQL Server database and need clean, reliable queries that feed straight into polished paginated reports. Your focus will be data querying and reporting only—no schema redesign—using the two tools I already have in place: Power BI and SSRS.
Here’s the flow I picture: you write or refine T-SQL to pull the right slices of data, build the dataset in SSRS, and then lay out the paginated report so it exports perfectly to PDF and Excel. Where interactive exploration is useful, a companion view in Power BI would be great, but the output I absolutely must have is a set of pixel-perfect paginated reports.
Deliverables
• Efficient T-SQL queries (stored procedures or views) that return the required fields
• At least one SSRS .rdl file per report, fully parameterized where appropriate
• Optional but welcome: a matching Power BI .pbix showcasing the same metrics for ad-hoc analysis
I’ll supply database access, a data dictionary, sample report mock-ups, and the naming conventions we follow. You’ll keep everything in our Git repository so I can track changes and deploy easily.
If you’ve built paginated reports off MSSQL before and are comfortable juggling both SSRS and Power BI, this should be straightforward. Let me know your estimated timeline and anything else you need to get started.
Here’s the flow I picture: you write or refine T-SQL to pull the right slices of data, build the dataset in SSRS, and then lay out the paginated report so it exports perfectly to PDF and Excel. Where interactive exploration is useful, a companion view in Power BI would be great, but the output I absolutely must have is a set of pixel-perfect paginated reports.
Deliverables
• Efficient T-SQL queries (stored procedures or views) that return the required fields
• At least one SSRS .rdl file per report, fully parameterized where appropriate
• Optional but welcome: a matching Power BI .pbix showcasing the same metrics for ad-hoc analysis
I’ll supply database access, a data dictionary, sample report mock-ups, and the naming conventions we follow. You’ll keep everything in our Git repository so I can track changes and deploy easily.
If you’ve built paginated reports off MSSQL before and are comfortable juggling both SSRS and Power BI, this should be straightforward. Let me know your estimated timeline and anything else you need to get started.