SQL Query to Excel Pivot Automation
Budget: ₹1,500 – ₹12,500 INR
I am looking for a PowerShell expert to assist with a unique project. The objective is to automate the process of importing query results from an SQL database into Excel. Further requirements include:
- Applying column filters to the raw data.
- Constructing a pivot table with the imported and filtered data.
- Finally, embedding a snapshot of the generated pivot table into the body of an email.
The freelancer must have a solid understanding of PowerShell programming and SQL databases. They should be proficient at manipulating data with Excel and using email generation modules in PowerShell. Familiarity with SQL query writing is essential since the process revolves around accurate results. An ideal candidate would be someone who is detail-oriented and can determine appropriate filters and pivot table structures to showcase the required data effectively.
Precision is crucial in this task - selecting specific columns from the raw data for inclusion in the Excel sheet is part of the job. The project is urgent, and prompt execution would be appreciated.
- Applying column filters to the raw data.
- Constructing a pivot table with the imported and filtered data.
- Finally, embedding a snapshot of the generated pivot table into the body of an email.
The freelancer must have a solid understanding of PowerShell programming and SQL databases. They should be proficient at manipulating data with Excel and using email generation modules in PowerShell. Familiarity with SQL query writing is essential since the process revolves around accurate results. An ideal candidate would be someone who is detail-oriented and can determine appropriate filters and pivot table structures to showcase the required data effectively.
Precision is crucial in this task - selecting specific columns from the raw data for inclusion in the Excel sheet is part of the job. The project is urgent, and prompt execution would be appreciated.