
Đã hoàn thành
Đã đăng vào
I need clear, visually engaging reports built first in Excel and then surfaced in Power BI, all driven by our operational data. The focus is strictly on project-level information, and within that I am only interested in the timelines: how each project is progressing, planned versus actual dates, and any slippage that needs attention. You will start by shaping the raw operational tables in Excel—cleaning, normalising and structuring them so they form a reliable data model. From there, create at least one summary sheet that management can filter by project, phase and date range. Once the numbers look right, move the model into Power BI and design an interactive dashboard. I expect an intuitive timeline (Gantt-style) view, milestone variance indicators, and a quick-glance KPI card that flags projects drifting off schedule. Deliverables • An organised Excel workbook containing the cleaned data, a refreshable Power Query or VBA routine (your choice) and a validation tab that proves counts and dates match the source. • A Power BI (.pbix) file linked to that workbook, with clearly named measures, formatted visuals and slicers for project, phase and date. • Brief hand-off notes explaining how to refresh both files. The work is complete once I can open the report, refresh the data with one click and immediately see an accurate, up-to-date picture of every project timeline.
Mã dự án: 40255878
27 đề xuất
Dự án từ xa
Hoạt động 21 ngày trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
27 freelancer chào giá trung bình $35 USD/giờ cho công việc này

Hello, I will shape your raw operational data in Excel by cleaning, normalising, and structuring the tables into a reliable data model. I’ll create a summary sheet for filtering by project, phase, and date range, then move the model to Power BI to deliver an interactive timeline (Gantt-style), milestone variance indicators, and a KPI card that flags drift. The Excel work will include a refreshable Power Query/VBA routine and a validation tab to prove counts and dates match the source. In Power BI, I’ll connect the workbook, build clear measures, and format visuals with slicers for project, phase, and date so management can refresh with one click and see an accurate picture of every project timeline. Hand-off notes will explain how to refresh both files and keep data aligned. What is the exact source system for your operational data and where are the files stored? What are the key project fields (project ID, name, phase, dates, status) and any optional fields I should include? How often will data refreshes occur and which source supports a one-click refresh? Do you have preferred date ranges for the initial dashboard (e.g., current quarter, rolling 12 months)? What is the expected level of detail for the Gantt view (milestones, tasks, or milestones-only)? Should I treat weekends/holidays as non-working days in the timeline? Are there any security or access restrictions on the Power BI report or Excel workbook? What naming conventions should I follow for measures,
$25 USD trong 33 ngày
7,3
7,3

With over 10 years of experience in data visualization and operational dashboard creation, I understand the importance of clear and engaging reports for tracking project timelines. Your requirement for Power BI Operational Timeline Dashboards is a challenge I am ready to tackle head-on. In the past, I have successfully delivered similar projects for clients in the fintech and eCommerce industries, providing them with visually appealing and user-friendly dashboards that met their specific needs. My expertise in Excel data modeling and Power BI dashboard design makes me confident in my ability to create the interactive timeline view and KPI cards you are seeking. I am excited to work on this project with you and deliver a high-quality solution that not only meets but exceeds your expectations. Feel free to reach out to me to discuss further details and get started on creating your operational timeline dashboards. Let's make your project's timeline visualization a success together.
$40 USD trong 15 ngày
6,7
6,7

Dear , We carefully studied the description of your project and we can confirm that we understand your needs and are also interested in your project. Our team has the necessary resources to start your project as soon as possible and complete it in a very short time. We are 25 years in this business and our technical specialists have strong experience in Visual Basic, Data Processing, Project Management, Excel, Microsoft Access, Data Visualization, Power BI, Data Modeling and other technologies relevant to your project. Please, review our profile https://www.freelancer.com/u/tangramua where you can find detailed information about our company, our portfolio, and the client's recent reviews. Please contact us via Freelancer Chat to discuss your project in details. Best regards, Sales department Tangram Canada Inc.
$30 USD trong 5 ngày
6,3
6,3

Hello There. ⇛My Philosophy is “Quality is never an accident it is always the result of an intelligent effort! Professional Multilingual Service Provider. Given the chance to be in long-term Cooperation! ▶Expertise and Specialties is? & What Services I Provide? ✔️Excel ✔️DAX ✔️Python ✔️SQL ✔️Tableau ✔️Scraping ✔️PPT ✔️Google-Sheets ✔️Typing ✔️ Web Scraping ✔️Data Extraction ✔️Data collection ✔️Leads ✔️Spreadsheet - Formulas ✔️PDF-MS Expert ✔️power-BI specialist ✔️Functions ✔️Macros ✔️VBA ✔️Dashboards ✔️Graphs ✔️Charts ✔️Pivot tables ✔️Flow charts ✔️ODOO ✔️Data Analysis ✸ Google-sheets ✔️Data Processing ✔️ Please leave a message here in via chat box. Thank You!
$25 USD trong 5 ngày
4,6
4,6

Hi, I’m excited about the opportunity to create clear and visually engaging Power BI operational timeline dashboards. With your focus on project-level information, I can leverage my expertise in data visualization and processing to ensure you have accurate timelines that reflect actual versus planned dates. I have over 7 years of experience in software development, particularly in data modeling and Excel data processing. I will clean, normalize, and structure your operational data into a reliable model in Excel before moving it to Power BI. Once the data is processed, I'll design an intuitive interactive dashboard featuring a Gantt-style view and quick-glance KPI cards for easy monitoring. My goal is to deliver organized workbooks with refreshable routines and clear hand-off notes for seamless data updates. I'm looking forward to helping you visualize your project's progress effectively.
$25 USD trong 16 ngày
4,1
4,1

Hello, I understand the critical importance of accurate project tracking through effective data visualization. I have extensive experience in transforming raw operational data into structured Excel models and subsequently into Power BI dashboards. My approach starts by meticulously cleaning and normalizing your data in Excel to create a solid foundation for analysis. Once structured, I'll develop summary sheets that allow management to easily filter by project, phase, and date range, ensuring all figures are correct. Transitioning to Power BI, I will deliver an intuitive Gantt-style timeline view, accompanied by milestone variance indicators and KPI cards to highlight schedule deviations. You'll receive a well-organized Excel workbook, complete with a Power Query for data refresh, and a Power BI file with thoughtfully designed measures and visuals. I look forward to collaborating on this project to present your operational timelines clearly and efficiently. Best regards, Osama
$50 USD trong 1 ngày
0,0
0,0

Hello, I am Vishal Maharaj, with 20 years of experience in Data Visualization and Power BI. I have carefully reviewed your project requirements for creating operational timeline dashboards in Power BI. To begin, I will clean, normalize, and structure the operational data in Excel to form a reliable data model. I will then create a summary sheet with filters for project, phase, and date range. Moving into Power BI, I will design an interactive dashboard featuring an intuitive Gantt-style timeline view, milestone variance indicators, and KPI cards for tracking project schedules. The deliverables will include an organized Excel workbook with a refreshable Power Query or VBA routine, a Power BI file linked to the workbook, and hand-off notes for data refresh guidance. Let's discuss further details. Cheers, Vishal Maharaj
$45 USD trong 40 ngày
0,0
0,0

Round Rock, United States
Phương thức thanh toán đã xác thực
Thành viên từ thg 5 16, 2017
$10-30 USD
$10-30 USD
$10-30 USD
$10-30 USD
₹750-1250 INR/ giờ
$30-250 USD
₹600-1500 INR
$15-25 AUD/ giờ
$30-250 USD
₹100-400 INR/ giờ
₹1500-12500 INR
₹750-1250 INR/ giờ
$250-750 USD
₹75000-150000 INR
₹600-1500 INR
₹600-1500 INR
₹12500-37500 INR
$100-200 USD
₹600-650 INR
₹750-1250 INR/ giờ
$10-30 USD
₹400-750 INR/ giờ
$30-250 USD
$15-25 AUD/ giờ