Advanced Excel KPIs Integration for Data Enhancement
₹1500-12500 INR
Betales ved levering
Objective:
To set up an advanced executive reporting system by integrating Excel KPIs with Looker Studio for visualization and using GPT for generating insightful reports.
Project Scope:
Server/Hosting Setup:
Task: Set up a cloud server to run scripts and handle data processing.
Details: Choose a cloud provider (AWS, GCP, Azure), create an account, and set up a virtual machine (VM) or cloud instance. Install necessary software (Python, Looker SDK, OpenAI API).
Domain Purchase and Configuration (Optional):
Task: Purchase and configure a domain if we decide to host a web application.
Details: Register a domain from a provider like GoDaddy or Namecheap. Configure DNS settings to point to our server.
Looker Studio Setup:
Task: Set up Looker Studio for data visualization.
Details: Sign up for Looker Studio (free for creators and viewers), configure connections to our database where Excel data will be stored, set up user roles, and permissions.
Database Configuration:
Task: Configure a database to store imported Excel data.
Details: Choose a database (e.g., Google BigQuery, PostgreSQL), create schema/table structures, ensure the database is accessible to Looker Studio, and set up necessary permissions.
OpenAI API Key:
Task: Obtain an API key for GPT integration.
Details: Sign up for an API key on the OpenAI website and keep it secure for use in our scripts.
Development Environment Setup:
Task: Set up a Python development environment.
Details: Install Python, Looker SDK, OpenAI API, and other necessary libraries. Create a virtual environment and install required packages.
Script Development:
Task: Write scripts to fetch data from Looker Studio, send it to GPT for analysis, and generate reports.
Details: Develop a Python script to integrate Looker data fetching and GPT analysis. Ensure the script is robust and handles errors gracefully.
Integration and Testing:
Task: Integrate all components and conduct thorough testing.
Details: Test the entire workflow to ensure data accuracy and report generation. Debug and refine scripts as needed.
Final Adjustments and Documentation:
Task: Make final adjustments and create comprehensive documentation.
Details: Fine-tune the setup, document the process, and create user guides for future reference.
- - - - - - -
I'm using Excel 2019 to track my KPIs manually and I'm looking to enhance the visualization of this data by integrating Looker Studio and GPT.
Key requirements:
- You need to be proficient in Excel, specifically Excel 2019, as I currently track my KPIs using this tool manually.
- It's essential that you have experience with Looker Studio, as I'm looking to enhance the visualization of my data through this integration.
- Familiarity with GPT would be beneficial, as I'm also looking to incorporate natural language summaries into my reporting.
This project is primarily aimed at enhancing the visualization of my KPIs, so a strong grasp of data visualization techniques and tools is crucial. The final deliverable should ensure that the reporting of my KPIs is more insightful and visually appealing.
Prosjekt-ID: #38251974
Om prosjektet
6 frilansere byr i gjennomsnitt ₹5750 for denne jobben
Python │Excel │R │ MATLAB │SPSS │Research Writer Greetings I am experienced MS Machine Learning expert & Data Scientist, Software Engr, MS Excel Expert and Certified Graphics Designer. I have 08 yrs of experience in Mer
Hello, I just read out your description and am interested in your project. Am Expert in Advance Excel and also done certain type of project. If you need quality work than feel free to contact me. Thanks
As an adept and experienced full-stack developer with a strong proficiency in Excel 2019, Looker Studio, and OpenAI's GPT, I possess the necessary skills to not only integrate your KPI data effectively but also signifi Mer
