
Closed
Posted
I am completing a capstone project that must showcase end-to-end work inside Power BI. The source data sits in SQL Server and is modest in size—well under 10 k rows—so performance tuning will centre on clean Query Folding rather than heavy aggregation tricks. Here is what I need done: • Connect Power BI to the SQL Server instance through Power Query, document each step, and keep every transformation foldable. • Shape and load the tables, then model them with the correct many-to-many relationship where required. Please do this in the Model view so the links are visually clear. • Create essential DAX measures—CALCULATE(), RELATED(), and any supporting columns you find helpful—so the model answers typical summary and slice-and-dice questions. • Design an intuitive report page set that demonstrates best-practice visuals: bar or line charts where trends matter, KPI cards for single figures, and slicers for smooth filtering. The focus is clarity rather than quantity. • Supply the finished PBIX plus a brief markdown or Word note explaining each major query step, relationship choice, and measure logic so the project can be defended during presentation. Acceptance is straightforward: the file opens without credential errors, refreshes in one click, returns accurate numbers against the original SQL, and renders clean visuals with no warning icons. If you are comfortable working entirely inside Power Query, Data Model view, and DAX—and enjoy squeezing every bit of performance from a small but busy dataset—this should be a fast, focused engagement.
Project ID: 40203311
25 proposals
Remote project
Active 10 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
25 freelancers are bidding on average ₹1,018 INR/hour for this job

Hi, I’m Karthik, a BI developer with 10+ years’ experience in Power BI and SQL-based reporting. I’ve delivered many academic and business dashboards where clean modeling, foldable queries, and clear storytelling mattered—so your capstone is a great fit. How I’ll support your capstone ✔ Connect to SQL Server via Power Query with fully documented, foldable steps ✔ Clean shaping/loading and clear modeling in Model view (incl. many-to-many where appropriate) ✔ DAX measures using CALCULATE(), RELATED(), and helper columns for strong analysis ✔ Intuitive report pages with best-practice visuals (trends, KPIs, slicers) focused on clarity ✔ Well-structured notes explaining queries, relationships, and DAX logic What you’ll receive • Error-free PBIX that refreshes in one click • Accurate numbers aligned to source SQL • Clean visuals with no warnings • Concise documentation for presentation defense I focus on best practices and explaining the “why,” not just the “how,” which helps in academic reviews. Can complete this quickly with high quality. Happy to start right away. —Karthik
₹1,300 INR in 40 days
4.4
4.4

With over 14 years of experience as a .NET developer, I am the ideal fit for your Power BI Capstone project. I have a strong command of Power Query, Data Model view, and DAX which are pivotal to seamlessly connecting Power BI to SQL Server instances like yours. My proficiencies have always revolved around improving performance tuning and this project will be no exception. I am well-versed in shaping and loading tables, modeling them with appropriate relationships, and creating essential DAX measures that prove helpful in addressing data analysis queries. Additionally, my design aesthetic leans toward best-practice visuals which aligns with your need for clear and insightful report pages. My approach focuses on quality over quantity to ensure your PBIX files are functional with clean visuals. Feasibility of the project is dear to me and successful completion is a personal standard. I assure you that upon implementation, the file will open without any credential hurdles or compromise in data accuracy from SQL. Consider this an invitation to fast-track delivery while ensuring our shared interests in performance optimization are satisfied. I'm excited to pour all of my extensive skills and experience into making this capstone project truly remarkable!
₹750 INR in 40 days
2.6
2.6

I can help you deliver a clean, presentation-ready Power BI capstone that clearly demonstrates end-to-end best practices. I have hands-on experience connecting Power BI to SQL Server using fully foldable Power Query transformations, building clear data models in the Model view, and creating reliable DAX measures with CALCULATE and RELATED for meaningful analysis. I’ll design a focused report with intuitive visuals, KPI cards, and slicers that highlight insights without clutter. Along with the final PBIX, I’ll provide concise documentation explaining query steps, relationships, and DAX logic so you can confidently defend every design choice during your presentation.
₹1,000 INR in 40 days
0.0
0.0

=-♠♠♠♠-= I have recently handled a Power BI capstone project where I connected SQL Server data under 10k rows, ensuring query folding and creating many-to-many relationships with DAX measures like CALCULATE() and RELATED(), so this work is right up my alley. I have 5 years of experience in Power BI development and data modeling, focusing on clean query folding and intuitive report design with KPI cards and slicers. I will deliver a fully functional PBIX file that opens without errors and includes clear documentation for every step to help you defend your project easily.=-♠♠♠♠-= Please open the chat window so that I can share my portfolio and we can proceed further on this project. In addition to your project needs, I'll provide you with clean source code, free bug patches, and maintenance. I am awaiting your positive response. Regards, Siddarth N.
₹750 INR in 40 days
0.0
0.0

With over two decades of experience in IT and an extensive skillset including Database Administration, XtrazCon Technology is well-suited to deliver the Power BI Capstone Build you are looking for. This project is specifically tailored to our strengths in Power Query, Data Model view, and DAX, and we have previously excelled in similar end-to-end projects with a focus on performance tuning through Query Folding. Our approach to your project will be marked by speed, precision, and an unwavering commitment to squeezing every last ounce of performance from a dataset. Your modestly sized data will not diminish our attention to detail or our dedication to providing clean visuals that render accurately. In addition to delivering the finished PBIX file that meets all your acceptance criteria, we'll also provide you with detailed markdown notes that meticulously explain each major query step, relationship choice, and measure logic. This documentation will enable you to confidently defend your project during your presentation - a service that sets us apart from the competition. So choose XtrazCon Technology for this project and get ready for digital excellence.
₹1,000 INR in 40 days
4.5
4.5

Hi! I can help complete your Power BI capstone project with clean, foldable Power Query transformations, accurate DAX measures (CALCULATE, RELATED), and visually clear report pages. I’ll also provide concise documentation explaining queries, relationships, and measures so your work is easy to defend. I look forward to reviewing the dataset and getting started efficiently.
₹1,000 INR in 40 days
0.0
0.0

I will connect Power BI to SQL Server using Power Query and ensure all transformations remain fully foldable. I will clean, shape, and model the data with clearly defined relationships in the Model view, create essential DAX measures for analysis, and design intuitive report pages with best-practice visuals. I will also document each step, explain modeling and DAX logic, and deliver a fully refreshable PBIX file that accurately reflects the source data.
₹1,000 INR in 40 days
0.0
0.0

=-♠♠♠♠-=- I have 5 years experience in Power BI, SQL Server, and DAX, and I have already done similar work where I built an end-to-end Power BI project using query folding, data modeling, and DAX measures for a capstone project.=-♠♠♠♠-=- Please open the chat window so that I can share my portfolio and we can proceed further on this project. In addition to your project needs, I'll provide you with clean source code, free bug patches, and maintenance. I am awaiting your positive response. Regards, Ritesh
₹750 INR in 40 days
0.0
0.0

Hello, I’m a Data Analyst who has delivered multiple end-to-end Power BI projects using data from SQL Server, Shopify, and QuickBooks. I work daily with Power Query (Query Folding), Model view, and DAX, so this capstone project is straightforward for me. I’ve connected Power BI directly to SQL Server, kept all transformations fully foldable, modelled many-to-many relationships correctly, and built clear DAX measures using CALCULATE() and RELATED() to support real slice-and-dice analysis. For your project, I’ll connect to the SQL Server source, document each Power Query step, and ensure clean, foldable transformations. I’ll build the data model in the Model view with visually clear relationships, then create essential DAX measures and a small, focused set of report pages using best-practice visuals - trend charts, KPI cards, and slicers, prioritising clarity over quantity. You’ll receive a clean PBIX that opens without credential issues, refreshes in one click, matches SQL results exactly, and renders without warnings, along with concise documentation explaining query steps, relationships, and DAX logic for presentation defence. Estimated delivery: 1–2 business days. Best regards, Suhel
₹1,000 INR in 40 days
0.0
0.0

Hello, My name is Saheli and I have worked extensively on Power BI for the past 4.5 years and created multiple dashboards with data coming from different sources from scratch for multiple clients ranging from logistics to healthcare. So I have good knowledge of complex DAX formulas and measures. I can also create the dashboard design if you want. Please feel free to contact me for any queries. Looking forward to working with you. Thank you. Saheli
₹1,200 INR in 40 days
0.0
0.0

Hi there! I am a Data Analyst. I have experience in data analysis, data visualization and building dashboards in Tableau, Power BI and Excel. I have understood your requirement; I can help you with making Capstone Project in Power BI with mentioned points that you are looking for. I ensure you that I will complete your work in a satisfactory manner and in the committed time. You can view my portfolio here- https://www.freelancer.in/u/Kirti048. We can discuss more about the project in the chat box. Looking forward to work with you. Thank you.
₹1,000 INR in 40 days
0.0
0.0

With 5 years of hands-on experience as a data analyst, coupled with a robust proficiency in Power BI, SQL, and Python, I am confident in my ability to contribute effectively to your project. Throughout my career, I have honed my skills in extracting actionable insights from complex datasets, utilizing a combination of Power BI, SQL, and Python. I have a proven track record of transforming raw data into visually compelling and informative dashboards and reports, empowering stakeholders to make data-driven decisions efficiently. My specialization lies in creating impactful visualizations using Power BI, enabling stakeholders to grasp key trends and patterns at a glance. Moreover, my expertise in SQL allows me to manipulate large datasets swiftly and accurately, ensuring data integrity and reliability. I am eager to discuss how I can contribute to your project's success further. Thank you for considering my application. I look forward to the opportunity to work together.
₹1,000 INR in 40 days
0.0
0.0

Hello, I’d be glad to support your Power BI capstone project and deliver a clean, end-to-end solution following best practices in Power Query, data modeling, DAX, and report design. My approach would be: • Connect Power BI to SQL Server via Power Query, keeping all transformations fully foldable and clearly documented. • Shape and load the data into a well-structured model, implementing and validating many-to-many relationships directly in the Model view. • Build essential DAX measures using CALCULATE(), RELATED(), and supporting columns as needed, ensuring accuracy and clarity. • Design a professional and intuitive report using best-practice visuals (trend charts, KPI cards, and slicers) with a focus on clarity. • Deliver the final PBIX file along with a concise written explanation (Markdown or Word) covering query steps, modeling decisions, and DAX logic. Given the dataset size, the focus will be on clean design, correct relationships, and reliable results rather than heavy performance tuning. The final file will refresh in one click, open without credential issues, and reconcile with the source SQL data. Estimated delivery time: 28 hours, depending on model and measure complexity. If this aligns with your expectations, I’d be happy to get started. Best regards, Jose
₹1,150 INR in 28 days
0.0
0.0

I deliver end-to-end Power BI solutions built on clean, foldable Power Query transformations, a well-structured data model, and efficient DAX, designed for clarity, performance, and easy stakeholder defence. What I will do: Connect Power BI to your SQL Server instance using Power Query Document every transformation step, ensuring queries remain fully foldable for optimal performance Shape, clean, and load tables following best-practice ETL principles Build a robust data model in Model view, including: Correct many-to-many relationships where required Clear, visually documented table links Create essential DAX measures using: CALCULATE() RELATED() Supporting calculated columns where appropriate to answer real-world summary, comparison, and slice-and-dice questions Reporting & visual design: Design an intuitive report page set focused on insight, not clutter Apply best-practice visuals: Bar and line charts for trends KPI cards for headline figures Slicers for smooth, logical filtering Emphasis on clarity, usability, and performance, not unnecessary visuals
₹1,655 INR in 40 days
0.0
0.0

Hello, I am Karthick, a Senior BI/Data Analytics Specialist with 6+ years of experience in Power BI, SQL Server, and ETL workflows. I have delivered 30+ dashboards across finance, healthcare, and insurance domains, ensuring clean query folding, optimized data models, and accurate DAX measures. For your capstone project, I will connect Power BI to SQL Server with foldable transformations, model tables with clear relationships, and build essential DAX measures. I will design intuitive report pages with best‑practice visuals and provide full documentation. Immediate joiner, competitive rate (₹999/hour), and presentation‑ready delivery guaranteed. Best regards, Karthick
₹899 INR in 40 days
0.0
0.0

Thanks for reading I can help on data analysis ,Dax and Creating interactive power bi dashboard. Can provide word documents with detail steps and explanations
₹1,250 INR in 10 days
0.0
0.0

Hello, I’d be glad to help complete your end-to-end Power BI project. I have hands-on experience with SQL Server connections, foldable Power Query transformations, data modeling (including many-to-many relationships), and DAX measures such as CALCULATE() and RELATED(). i am comfortable in Power Query, Data Model view, and DAX I’ll deliver a clean PBIX with documented query steps, a properly built model, essential measures, clear visuals, and concise notes explaining design and logic—ready for presentation and one-click refresh. Available to start immediately.
₹1,000 INR in 40 days
0.0
0.0

Hi, I’m a fresher Power BI analyst with hands-on experience in end-to-end Power BI projects. I’ve worked with SQL Server sources, Power Query transformations with query folding, data modeling, DAX measures, and dashboard design. This being a capstone project, I’ll focus on clean, well-documented work and clear visuals. I’m bidding at the lower end to build my Freelancer profile and will ensure timely delivery and good communication. Thanks for considering my bid.
₹750 INR in 20 days
0.0
0.0

Chandur Bazar, India
Member since Jul 26, 2025
$25-50 USD / hour
₹75000-150000 INR
£100 GBP
₹12500-37500 INR
₹400-750 INR / hour
₹75000-150000 INR
₹600-1500 INR
$25-50 USD / hour
₹400-750 INR / hour
$10-30 USD
$30-250 USD
$250-750 AUD
₹37500-75000 INR
$10-50 USD
$250-750 USD
₹12500-37500 INR
$30-250 USD
$30-250 SGD
$10-30 USD
$200-300 USD