Advanced Data Analyst for Interactive Dashboard -- 2
$60-100 CAD
Teslim sırasında ödenir
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.
Proje NO: #38844450
Proje hakkında
Seçilen:
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 Daha Fazla
Bu iş için 12 freelancer ortalamada $81 teklif veriyor
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 Daha Fazla
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, Daha Fazla
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 Daha Fazla
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) Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
