Comprehensive Data Analysis and Reporting
Budget: ₹750 – ₹1,250 INR
I require an expert in Excel, SQL, and Power BI to help me with a complex data analysis and reporting project.
Key Tasks:
- Data Manipulation and Analysis: Your primary responsibility will be to handle extensive data manipulation and analysis using Excel. This would include cleansing, transforming, and summarizing data to provide meaningful insights.
- Creating Charts and Graphs: You will be required to create visually appealing and informative charts and graphs to represent the data effectively.
- Automating Tasks with Macros: You will need to automate various tasks using macros to improve efficiency.
SQL Work:
- Database Design and Creation: You will be involved in designing and creating a database that will support our data needs.
- Query Optimization and Performance Tuning: You'll need to optimize queries and ensure they run efficiently for the analysis.
- Data Extraction and Transformation: Extracting the required data from the database and transforming it into a usable format for the analysis will also be part of your responsibilities.
Skills:
- Proficiency in Excel: You should be an expert in Excel, capable of handling complex data manipulation and analysis, creating charts, and automating tasks.
- Strong SQL Knowledge: Thorough understanding of SQL, with experience in database design, query optimization, and data extraction.
- Power BI Experience: Prior experience with Power BI for data visualization and reporting is highly preferred.
If you have a strong background in these areas and can deliver high-quality work within a specified time frame, I'd like to work with you.
Key Tasks:
- Data Manipulation and Analysis: Your primary responsibility will be to handle extensive data manipulation and analysis using Excel. This would include cleansing, transforming, and summarizing data to provide meaningful insights.
- Creating Charts and Graphs: You will be required to create visually appealing and informative charts and graphs to represent the data effectively.
- Automating Tasks with Macros: You will need to automate various tasks using macros to improve efficiency.
SQL Work:
- Database Design and Creation: You will be involved in designing and creating a database that will support our data needs.
- Query Optimization and Performance Tuning: You'll need to optimize queries and ensure they run efficiently for the analysis.
- Data Extraction and Transformation: Extracting the required data from the database and transforming it into a usable format for the analysis will also be part of your responsibilities.
Skills:
- Proficiency in Excel: You should be an expert in Excel, capable of handling complex data manipulation and analysis, creating charts, and automating tasks.
- Strong SQL Knowledge: Thorough understanding of SQL, with experience in database design, query optimization, and data extraction.
- Power BI Experience: Prior experience with Power BI for data visualization and reporting is highly preferred.
If you have a strong background in these areas and can deliver high-quality work within a specified time frame, I'd like to work with you.