
Closed
Posted
Paid on delivery
I have a dataset that needs to come alive inside Excel. Using Pivot Tables as the core engine, I want the workbook to surface trends, outliers and drill-down views that update automatically when fresh data is dropped in. On top of that, I’d like the same model—or its cleaned data layer—pulled into Power BI so I can compare the interactive experience between the two platforms and understand how each handles refreshes, slicers and visual storytelling. Here’s what I need from you: • Build the Excel file so every chart, KPI card and slicer is driven by well-structured Pivot Tables, not hard-coded ranges. • Set up a companion Power BI report that mirrors the logic and lets me explore identical metrics there. • Give me a short screen-share walkthrough (recorded is fine) explaining the steps, so I can practise the process myself later; I’m keen to develop stronger skills in SQL, Python, Tableau and the main Python data-viz libraries, so please highlight where similar thinking would transfer to those tools. I’m a fresher, so clear explanations matter as much as polished deliverables. If you’ve helped newcomers before, mention it when you respond. A straightforward link to a sample Pivot-Table-driven dashboard or a live Power BI report will help me choose quickly. I’ll mark the job complete when: 1. The Excel file accepts new rows in the source sheet and all visuals refresh correctly. 2. The Power BI report connects to the same data, refreshes without errors and reflects the same calculations. 3. Your walkthrough leaves me confident I can repeat the workflow on a new dataset. Looking forward to collaborating and learning from you.
Project ID: 40277306
8 proposals
Remote project
Active 11 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average ₹2,463 INR for this job

With over a decade of experience in data management and fluent with the Excel, I’m well-suited to undertake your project. Dedicating myself to advancing my skills in Excel and Google Sheets, means I'm highly proficient with functions, formulas, formatting, pivot tables, and creating interactive graphs and charts that incorporate city key performance indicators as you need. Notably, your task description aligns with my strong suit in transforming raw data into actionable insights. Additionally, my skill set extends to Power BI, where I can artfully mirror the logic of your Excel workbook so that both platforms reflect identical metrics and smoothly handle refreshes, slicers, and visual storytelling. To put your mind at ease regarding my communication skills, I've assisted numerous beginners in their journey to understand complex datasets presentation - a fact which underscores my knack for delivering clear explanations. To further prove the depth of my skills, it'll only take a moment to demonstrate how SQL's dashboarding capability compares to what we achieve on Excel and PowerBI. So let's get started on this journey and in no time you’ll be deftly handling SQL, Python, Tableau and the main Python data-viz libraries; making smarter business decisions based on solid evidenced-backed data analysis. Let me make your learning experience smooth and rewarding.
₹5,000 INR in 1 day
2.3
2.3

Hello, I’m interested in helping you build an interactive Excel dashboard and a companion Power BI report. I have experience working with Excel Pivot Tables, dashboards, and data structuring to make datasets easier to analyze and visualize. For this project, I will design the Excel workbook so that all charts, KPIs, and slicers are powered by properly structured Pivot Tables instead of hard-coded ranges. This will ensure that when new data is added to the source sheet, the dashboard updates correctly after refresh. I will also create a Power BI report connected to the same dataset, mirroring the same calculations and metrics so you can compare how both platforms handle filtering, slicers, and visual storytelling. Since you mentioned you are learning and want to strengthen your skills, I will also provide a clear walkthrough video explaining: • How the Pivot Table model is structured • How the Excel dashboard updates with new data • How the Power BI report connects and refreshes • How similar concepts apply to SQL, Python data analysis, and other BI tools My goal is not only to deliver the working dashboards but also help you understand the workflow so you can repeat the process with other datasets in the future. Looking forward to working with you. Best regards, Thyanesh
₹950 INR in 7 days
0.0
0.0

Hi there, You’re absolutely in the RIGHT PLACE. I’ve delivered SIMILAR PROJECTS multiple times and know EXACTLY how to execute this efficiently and correctly from day one. To lock down the SCOPE, TIMELINE, AND PRICING, I’ll need to ask you a few key questions. Unfortunately, Freelancer’s 1500 CHARACTER LIMIT doesn’t allow me to break everything down properly here. Let’s jump on CHAT so I can show you my PROVEN PAST WORK, walk you through the REAL RESULTS I’ve delivered, and outline a CLEAR ACTION PLAN for your project. You’ll immediately see why my approach is DIFFERENT and EFFECTIVE. If you’re serious about getting this done RIGHT, I’m ready to move forward. Looking forward to CONNECTING and WINNING TOGETHER. Cheers, Mayank
₹1,050 INR in 7 days
0.0
0.0

Hello Sir, I’d love to help you build a dynamic Excel workbook and a matching Power BI report. I specialize in PivotTable-driven dashboards and Power BI storytelling, and I’ve guided many beginners through similar workflows. Here’s what I’ll deliver: Excel file with clean structure, auto-refresh visuals, and slicers powered by PivotTables Power BI report with identical logic and refresh setup A recorded walkthrough explaining each step clearly, with notes on how this thinking applies to SQL, Python, and Tableau I’ll make sure both files refresh correctly when new data is added, and you’ll feel confident repeating the process on your own. I can also share sample dashboards if needed. Looking forward to helping you learn and build! Best regards, Ali Muhammad
₹1,050 INR in 7 days
0.0
0.0

Hello I can build a clean Pivot-Table–driven Excel dashboard where all KPIs, charts, and slicers update automatically when new data is added. I’ll also create a companion Power BI report using the same structured data model so you can compare refresh behavior, interactivity, and visual storytelling across both platforms. Since you’re a fresher, I’ll provide a clear walkthrough recording explaining each step and how the logic translates to tools like SQL, Python, and Tableau. You’ll receive an organized Excel file, Power BI report, and guidance to confidently repeat the workflow on new datasets.
₹600 INR in 2 days
0.0
0.0

Hi — Excel dashboards and Power BI are exactly what I do day-to-day. I've built dozens of Pivot-Table-driven workbooks and matching BI reports for clients across different industries. Here's my plan for your project: **Excel workbook:** - Structured data model with a clean source sheet and separate Pivot Table engine - Dynamic charts, KPI cards and slicers all driven by PivotTables (no hard-coded ranges) - Auto-refresh when you drop new rows into the source sheet **Power BI report:** - Connected to the same dataset, mirroring the Excel logic - Interactive slicers, drill-downs and visual storytelling - Refresh setup so it stays in sync **Walkthrough recording:** - Step-by-step screen recording explaining the build process - I'll highlight how the same concepts transfer to SQL, Python (pandas, matplotlib, plotly) and Tableau - Designed for beginners — clear explanations, no jargon I enjoy teaching and have helped several newcomers build their analytics skills. I can deliver the complete package in 3 days. Happy to share a sample dashboard if you'd like to see my work first.
₹1,050 INR in 3 days
0.0
0.0

Hi, I understand your requirement clearly. I can build a Pivot Table–driven Excel dashboard where all charts, KPIs, and slicers update automatically when new data is added. I will also create a matching Power BI report using the same cleaned data so you can compare both platforms easily. Since you mentioned you are a fresher, I will keep everything well-structured and easy to understand, and I will also provide a short screen-recorded walkthrough explaining the full process step by step so you can repeat it on your own dataset later. I can also share a free demo first so you can see my approach before we proceed with the full project. Looking forward to working with you.
₹5,000 INR in 2 days
0.0
0.0

Rayagada, India
Member since Feb 12, 2026
€2-6 EUR / hour
₹600-1500 INR
$250-750 USD
₹1500-12500 INR
$2-8 USD / hour
$15-25 USD / hour
$15-25 USD / hour
€250 EUR
$2-8 CAD / hour
₹100-150 INR / hour
$10-30 USD
$8-15 USD / hour
$15-25 USD / hour
$8-15 USD / hour
$10-30 USD
₹100-400 INR / hour
$1500-3000 USD
£20-250 GBP
$10-15 USD
$750-1500 USD