Automate a report that is Excel via SQL
Budget: $30 – $250 USD
Data Analysis Report Automation from EXCEL to SQL
Purpose of the report: Data analysis
Skills and Experience:
- Strong experience in data analysis and automation
- Proficiency in SQL Server database
- Familiarity with EXCEL and its data formats
- Knowledge of data visualization techniques
Project Description:
The current report process is to process the report via Excel by appending the new data in some excel sheets and calculating sheets in the FORMULA sheet(etc). The project is to automate the whole process through SQL. So in other words, to import the tables and have a query that would encode the excel formulas to SQL queries. After that, to merge it in one file. I know the basics in SQL however, i don't know where to start for this project and i genuinely feel lost. There are small details or setbacks that consume so much on my own hence I would really appreciate someone who can guide and teach me. I am looking for a freelancer who can teach me and mentor me through this project as I am lost in where to start and how to solve the minor setbacks I face.
I also do like to mention, that there are other tasks I would need help in for the future after completing this one.
Key Requirements:
1. Data Analysis: The freelancer should have a strong background in data analysis and be able to use various statistical techniques to extract insights from the imported data.
2. SQL Server: The report should be imported into a SQL Server database, so the freelancer should be proficient in SQL Server and have experience working with its database management system.
3. EXCEL Expertise: The freelancer should be familiar with EXCEL and its data formats to accurately extract and transform the data for analysis.
4. Data Visualization: The freelancer should have knowledge of data visualization techniques to present the analyzed data in a clear and visually appealing manner.
If you have the required skills and experience in data analysis, SQL Server, and EXCEL
Purpose of the report: Data analysis
Skills and Experience:
- Strong experience in data analysis and automation
- Proficiency in SQL Server database
- Familiarity with EXCEL and its data formats
- Knowledge of data visualization techniques
Project Description:
The current report process is to process the report via Excel by appending the new data in some excel sheets and calculating sheets in the FORMULA sheet(etc). The project is to automate the whole process through SQL. So in other words, to import the tables and have a query that would encode the excel formulas to SQL queries. After that, to merge it in one file. I know the basics in SQL however, i don't know where to start for this project and i genuinely feel lost. There are small details or setbacks that consume so much on my own hence I would really appreciate someone who can guide and teach me. I am looking for a freelancer who can teach me and mentor me through this project as I am lost in where to start and how to solve the minor setbacks I face.
I also do like to mention, that there are other tasks I would need help in for the future after completing this one.
Key Requirements:
1. Data Analysis: The freelancer should have a strong background in data analysis and be able to use various statistical techniques to extract insights from the imported data.
2. SQL Server: The report should be imported into a SQL Server database, so the freelancer should be proficient in SQL Server and have experience working with its database management system.
3. EXCEL Expertise: The freelancer should be familiar with EXCEL and its data formats to accurately extract and transform the data for analysis.
4. Data Visualization: The freelancer should have knowledge of data visualization techniques to present the analyzed data in a clear and visually appealing manner.
If you have the required skills and experience in data analysis, SQL Server, and EXCEL