Advanced Data Analyst for Interactive Dashboard -- 2
$60-100 CAD
Оплачується при отриманні
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.
ID Проекту: #38844450
Про проект
Доручено:
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 Більше
12 фрілансерів(-и) готові виконати цю роботу у середньому за $81
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 Більше
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, Більше
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 Більше
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) Більше
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 Більше
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 Більше
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 Більше
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 Більше
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 Більше
