
Closed
Posted
Paid on delivery
I have multiple Excel workbooks that now demand a unified, visually compelling view in Power BI. Your task is to take those files, structure the data model, and design interactive dashboards that tell the story at a glance—no additional data sources are involved, so you can focus purely on optimizing the connection to Excel. What I need • A clean PBIX file with well-labeled tables, calculated columns/measures, and relationships • At least two interactive pages that surface key metrics, slicers, and drill-throughs • Built-in refresh that pulls the latest Excel data without manual intervention • Simple colour palette and layout so non-technical users can understand insights immediately Acceptance criteria • All visuals load without errors when sample Excel files are replaced by the live ones • Refresh completes in under two minutes on a standard workstation • No hard-coded file paths—relative or parameter-driven connections only If you enjoy shaping data into stories and know your way around DAX, this should be straightforward. I’ll supply the Excel files and a short brief on the specific metrics once we start.
Project ID: 40533510
21 proposals
Remote project
Active 3 mins ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average ₹21,167 INR for this job

As a Data Scientist and Machine Learning Expert with a comprehensive background in data analysis and visualization, I am well-equipped to handle your Excel-based Power BI Dashboard project. With over 5 years of experience, I have honed my skills in managing, analyzing, and visualizing diverse dataset to provide informative insights. Additionally, my proficiency in Power BI will ensure that your dashboards not only look visually compelling but also function flawlessly. With a meticulous approach, I'll carefully structure the data model of your existing workbooks within Power BI while implementing well-labeled tables, calculated columns/measures, and establishing appropriate relationships. This will pave a way for clear navigation and ease of use for non-technical users. Furthermore, my prior usage of Power BI with Excel allows me to optimize the connection between data sources, effectively utilizing Excel files as the base. In conclusion, with my extensive knowledge within DAX (Data Analysis Expressions), robust skill set across Python and R programming languages, coupled with my deep understanding of various machine learning algorithms; I am confident that my tailored approach will prove highly valuable for this data-centric project. Looking forward to assisting you in turning your multitude of excel sheets into coherent stories inplace with your business needs and objectives!
₹25,000 INR in 7 days
7.3
7.3

I can build a clean, well-structured Power BI solution from your Excel workbooks with a strong focus on usability, performance, and clarity. I will organize the data model with properly labeled tables, relationships, and required `DAX` measures, then design at least two interactive dashboard pages that highlight the key metrics through clear visuals, slicers, and drill-through navigation. I will also set up the Excel connection in a parameter-driven way so refresh remains reliable and maintainable without hard-coded paths. My approach is to keep the report simple for end users while making the underlying model solid and easy to extend. I will ensure the final `PBIX` refreshes smoothly, visuals load correctly when live Excel files are swapped in, and the layout is polished enough for non-technical stakeholders to understand the story immediately.
₹12,500 INR in 20000 days
3.5
3.5

Hi, This project is a great fit for my experience in Power BI, Power Query, Excel data modeling, and dashboard design. I can transform your Excel workbooks into a clean, scalable Power BI solution that is easy to maintain and understand. What I will deliver: • Structured Power BI data model with well-named tables, relationships, and measures • Power Query transformations for efficient data preparation • At least two interactive dashboard pages with KPIs, slicers, drill-throughs, and trend analysis • DAX measures and calculated columns with clear naming conventions • Parameter-driven or relative-path file connections to avoid hard-coded dependencies • Optimized refresh performance and dashboard responsiveness • Clean, business-friendly design focused on usability and insight discovery • Fully documented PBIX file for future maintenance My approach focuses on building a robust data model first, ensuring reliable refreshes and fast performance, then designing dashboards that allow stakeholders to quickly understand trends and key metrics without technical expertise. Regards, Ateeb Rahil Mahedvi
₹25,000 INR in 3 days
3.2
3.2

Your Excel workbooks need a unified Power BI model with parameter-driven connections to refresh seamlessly. I recently built an automated reconciliation dashboard for complex e-commerce settlement reports using Power Query and advanced DAX. As an Analytics Engineer running a multi-source data platform (Synlitics), I specialize in turning raw tables into minimalist, easy-to-read visuals for non-technical users. I will build your PBIX file, structure the data model, and deliver both interactive pages within 3 days. What is the rough row count of your largest Excel workbook?
₹14,000 INR in 7 days
2.0
2.0

As a seasoned Financial Analyst and Business Consultant well versed in Excel, I can assure you that your Power BI project is within my wheelhouse. I specialize in turning complex data into actionable insights, which is exactly what you need for your excel-based dashboards. Not only do I have a deep understanding of DAX and Power BI, but I also bring to the table top-notch skills in structuring data models and design effective visuals that resonate with non-technical users. My proven track record includes delivering investment-grade financial models and board-level business plans—precisely what your project demands. My expertise in strategic business planning, investment analysis, market research, and commercial due diligence aspects aligns well with the broader context of your project. These skills combined with my proficiency in scenario & sensitivity analysis and executive-level reporting make me the perfect fit to transform your disparate Excel workbooks into cohesive, meaningful dashboards in Power BI. What differentiates me from other freelancers is my focus on quality over volume, senior-level judgment, and my ability to communicate complex analysis with precision and impact. With me at the helm of your Power BI project, you are guaranteed not just a unified visualization tool for your Excel files, but an executive-grade interface that delivers insights at a glance. Choose me for a transformative, insightful and high-quality end result!
₹20,000 INR in 7 days
1.7
1.7

With over a decade of experience in data analysis and proficiency in Power BI, Excel, and DAX, I'm thrilled to offer my services for your Excel-based Power BI Dashboards project. I am adept at transforming raw data into meaningful insights that resonate with non-technical users. I'll provide a clean PBIX file with well-structured tables, calculated columns/measures, and relationships to ensure your key metrics are clearly surfaced. What makes my work unique is the comprehensive and scalable nature of my solutions. I don't just build dashboards; I engineer digital products designed for long-term growth. In this case, I will set up an automated refresh process that pulls the latest data from Excel without any manual intervention, and with a standard workstation, refreshing your dashboards should take no more than two minutes. Lastly, for me, transparency and seamless communication are paramount. I'll be sure to keep you updated on every step of the process and ensure the acceptance criteria are met efficiently. Choose me for a collaborative partnership where we transform your data into a compelling story together!
₹15,000 INR in 7 days
1.2
1.2

With over 10 years of senior developer experience, I bring a wealth of expertise to the table. Proficient in backend development using Python and R, I'm well-equipped to create robust platforms. My database management skills include MySQL, SQL, and SQLite, ensuring efficient data organization. Using web frameworks like Flask and Django, I can build scalable and responsive web applications. Web scraping, data analysis, and visualization are second nature, thanks to tools like Beautifulsoup, Selenium, Pandas, Seaborn, Numpy, and Matplotlib. Additionally, I have hands-on experience in machine learning with PyTorch, TensorFlow, Keras, DNN, GAN, CNN, and Scikit-learn. My commitment to transparency, quality, and full-time availability makes me an ideal choice for your project. Let's collaborate to bring your vision to life.
₹25,000 INR in 7 days
1.7
1.7

- I have hands-on experience building Power BI dashboards from Excel-based datasets for sales, finance, operations, and executive reporting. - My expertise includes Power BI, Power Query, DAX, Excel, data modeling, KPI reporting, and dashboard performance optimization. - I can consolidate multiple Excel workbooks into a scalable star-schema model with well-structured relationships, reusable DAX measures, and parameter-driven data connections. - I have experience designing interactive dashboards with KPI cards, trend analysis, drill-throughs, slicers, bookmarks, and responsive layouts that make business insights easy to understand. - In a recent project, I developed a PHP API, integrated database data into Power BI, and created automated real-time dashboards for business performance monitoring. - The solution will include automated refresh using parameterized file paths, optimized Power Query transformations, and clean visual storytelling for non-technical users. - I focus on building fast, maintainable reports with documented calculations, organized data models, and best practices for future scalability. - Deliverables will include the PBIX file, documented DAX measures, parameterized queries, and a hand-off guide explaining refresh and maintenance. Reference work is available in my profile.
₹15,000 INR in 3 days
1.0
1.0

Drawing on my proficiency as an AI and cloud data engineering specialist, I am well-placed to create Excel-based Power BI Dashboards that meet and indeed exceed your expectations. I bring to the table an exceptional ability to transform data into actionable business intelligence, which is essential in this project. Having worked across diverse industries and transformed intricate datasets into valuable insights, I've honed my skills in building manageable systems tailored to specific business needs. A key aspect of this project. With my insightful analytics, we can translate the complex data from your Excel files into visually appealing, user-friendly dashboards that offer value at a glance. My knowledge of DAX will come in handy when structuring the data model to unearth the key metrics and present them through interactive visuals as you desire. I embrace simplicity and understand the need for non-technical users to quickly grasp insights. In essence, choosing me means receiving a comprehensive solution that encompasses all your criteria in record time - well-labeled tables with calculated columns/measures, relationships for better connectivity, refreshing methods without manual intervention, attentively designed interactive pages with key metrics on display, slicers and drill-throughs for flexibility & depth exploration, efficient refreshes under two minutes and relative/parameter-driven connections to avoid hard-coded file paths.
₹21,000 INR in 4 days
0.0
0.0

Hello, Multiple Excel workbooks into an interactive Power BI dashboard that non-technical stakeholders can read at a glance, this is clearly scoped work and I can deliver it well. I am Dr. Dipankar Dutta, Associate Professor in Computer Science with a PhD and 18 years of experience in data analysis and dashboard design. I will build a clean PBIX file with labeled tables, DAX measures, and relationships across your workbooks. Two interactive pages minimum, key metrics, slicers, and drill-throughs designed for non-technical users. All connections parameter-driven, no hard-coded file paths. Refresh tested before delivery, well within your two-minute requirement. I will check every acceptance criterion before sending anything across. To start I need your Excel workbooks or a sample and a short brief on the key metrics. I can begin within a few hours of receiving your files and deliver the first draft within 48 to 72 hours. What file formats are the workbooks in, and which metric must appear first on page one?
₹13,000 INR in 3 days
0.0
0.0

Hello, I understand you're looking for more than just dashboards—you need a well-structured Power BI solution that integrates multiple Excel workbooks into a clean, interactive reporting system with optimized data modeling, efficient DAX, and seamless refresh capabilities. This aligns perfectly with my expertise in Power BI, SQL, Data Analysis, and Business Intelligence. I will: Integrate your Excel workbooks into a clean and scalable Power BI data model. Create well-organized tables, relationships, calculated columns, and optimized DAX measures. Design two interactive dashboard pages featuring KPI cards, slicers, drill-through functionality, and intuitive visualizations that help users understand business insights at a glance. Configure parameter-driven Excel connections to avoid hard-coded file paths and ensure smooth refresh when the source files are updated. Optimize the report for performance so visuals load quickly and refresh efficiently. The final PBIX will be clean, well-documented, easy to maintain, and designed for non-technical users with a simple, professional layout. I am available to start immediately and would be happy to attend an interview before hiring to discuss your reporting requirements and dashboard expectations. I look forward to the opportunity to work with you. Best regards, Gowri K
₹15,000 INR in 5 days
0.0
0.0

Hi, I'd like to take this on. I work regularly with Power BI and Excel-based data modeling, including building relationship-driven data models with calculated columns/measures rather than flat, single-table reports. For this project, here's how I'd approach it: I'll structure your Excel data into a clean Power BI model with proper relationships and DAX measures, set up parameter-driven connections so there's no hardcoded paths, and build at least two interactive pages with slicers and drill-throughs so insights are easy to find. I'll also keep the model lean to help refresh stay fast. A bit about my background: I built Unified Military Analytics Dashboard, where I worked with 140+ countries and 50+ indicators that combined statistical modeling to make data understandable at a glance — the same principle I'd apply here: clean visuals, simple palette, insights visible immediately without explanation. Can start as soon as you send the workbooks and metric brief. Looking forward to working on this. Best, Isha
₹22,500 INR in 5 days
0.0
0.0

India
Member since Dec 4, 2016
₹150000-250000 INR
₹1500-12500 INR
$250-750 USD
₹100-400 INR / hour
₹12500-37500 INR
$3000-5000 CAD
₹100-400 INR / hour
₹1500-12500 INR
₹12500-37500 INR
$3000-5000 CAD
₹600-1500 INR
$30-250 USD
$15-25 USD / hour
£750-1500 GBP
$15-25 USD / hour
₹1000-2500 INR
₹750-1250 INR / hour
$10-30 USD
₹12500-37500 INR
₹400-750 INR / hour
£10-20 GBP
₹1500-12500 INR