Advanced Data Analyst for Interactive Dashboard -- 2
$60-100 CAD
Paid on delivery
I need a skilled data analyst to create an automated interactive dashboard that analyses my order data. The program should be able to generate detailed reports based on various parameters such as Order number, Client, Item, Batch, Model, Description, Amount, Waiting PO, Late Order, and Current status. Data cleaning, structure, visualizing, slicer and desktop and mobile support, exportable in CSV PDF format
Key Requirements:
- Connects to Excel files and SQL database
- Generates a separate Pivot table
- Creates a complete, interactive Dashboard
- Automatically updates all tables after a new order is added
- Performs forecast analysis (time, client, items)
- Conducts graphic analysis (using Bar, line etc.)
- Allows export of reports in CSV, PDF formats
- Offers mobile compatibility for dashboard access
- A separate sheet must be provided for all formulas/arguments for each column function.
The most critical feature of this program is an interactive dashboard. Experience with Excel, SQL, and dashboard creation is essential. Understanding data analysis and visualization techniques will be beneficial. Please note, that the program must be able to auto-update and provide real-time insights.
I prefer dashboard development using Excel and Microsoft One Drive platforms.
Bid only if you're expert on Excel, SQL,Python and available to chat.
Project ID: #38844450
About the project
Awarded to:
Hello, I have carefully reviewed the details before placing a bid on your project. I am confident that I can complete the task and provide you with an effective solution. With over 14 years of experience in reporting More
12 freelancers are bidding on average $81 for this job
Hello there, I am experienced in web scraping and building scripts or a Windows desktop application using Python. I am also experienced in large data scraping from a given website, bypassing IP, Captcha, and anti-bot More
Hi there, I am a Data Scientist and a professional responsible for extracting actionable insights and knowledge from large volumes of data for Microsoft applications Development. I can write clean Excel, Word, Access, More
Dedicated Freelancer Ready to Elevate Your Project for Advanced Data Analyst for Interactive Dashboard -- 2. I have a solid background in Excel Macros, Excel VBA, Visual Basic, Microsoft Access and Excel, I bring valua More
Hi Sir, I have worked as a finance manager in local NGOs, Schools, Chartered Accountant Company & Super Markets, and I have over 15 years of experience. My qualification is an MBA (Master of Business Administration) More
Hi Habib H., I came across your project and believe I’m a great fit to help you achieve your goals. With my experience & skills such asVisual Basic, Excel VBA, Excel, Excel Macros and Microsoft Access, I can deliver h More
Hello Dear! Good Day! Hope you are doing fine. This is Ruhul Ajom Sagor. I am an expert "Web Developer" with 10+ years of working experience in PHP, HTML5, CSS3, JavaScript, jQuery, Bootstrap, MySql and different Fra More
I’m excited to assist with your automated interactive dashboard project. With expertise in Excel, SQL, and data analysis, I can create a dashboard that connects to Excel/SQL databases, auto-updates, and generates repor More
Drawing from my comprehensive background in data analysis, particularly with Excel and SQL, I am confident in my ability to create a dynamic and robust automated interactive dashboard aligned with your vision. Let's le More
Building insightful and user-friendly dashboards is my bread and butter. What sets me apart is my deep proficiency in Excel, its formulas and pivot tables that are crucial for your project. I have leveraged Excel to it More
