
Completed
Posted
Paid on delivery
I need a Power BI dashboard built from an Excel spreadsheet containing a content audit of website pages. The goal is to create a clear, interactive dashboard that helps identify: • pages not recently updated • ownership by division • traffic levels 2. Data Source Primary dataset (Excel) 3. Key Requirement: Definition of “Pages Not Modified” For this dashboard: Pages Not Modified = pages where Date Modified is between 2017 and 2022 (inclusive) This represents pages that have not been updated in over 3 years. Note: • This is a fixed year range for this version • A future version may use a dynamic date approach 4. Dashboard Requirements A. Summary of Pages Not Modified Show: • Total number of pages modified between 2017–2022 • % of total pages B. Pages Not Modified by Year (2017–2022) Show: • Year Modified • Number of pages • % of pages not modified C. Pages Not Modified by Division Show: • Number of pages not modified per division • % of pages not modified per division D. Traffic Levels of Pages Not Modified Group pages into: • No traffic • Very low • Low • Moderate • Medium • High • Very high • Exceptional Show: • number of pages • total views • % of pages not modified E. Page-Level Detail Table Include a table filtered to 2017–2022 pages only, with: • title • url • divisions • date modified • views • traffic band • action (keep / revise / remove) Table must be interactive/filterable. 5. Data Modeling Instructions (Important) • Use ONLY the main dataset • Do NOT use pre-calculated summary tables (Year, Division, Stats) as source data • All calculations should be created within Power BI 6. Required Calculated Fields Please create: • Modified Year • “Pages Not Modified” flag (2017–2022) • Traffic Band (based on Views thresholds) • Division Type (Single vs Shared) 7. AI Visuals (Required) Include the following: Q&A Visual Allow users to ask questions such as: • pages by division • pages by traffic band • pages by year Decomposition Tree • Analyze: count of pages not modified • Allow breakdown by: o division o traffic band o year Key Influencers Analyze: • what factors are associated with low/no traffic pages • what factors are associated with pages not modified 8. Dashboard Layout (Simple) Top • Total pages • Pages Not Modified (2017–2022) • % Not Modified Middle • Pages Not Modified by Year • Pages Not Modified by Division • Traffic Levels of Pages Not Modified Bottom • Decomposition Tree • Key Influencers • Page detail table 9. Design Expectations • Clean, minimal design • Plain language labels • Easy to read and present 10. Slicers included • Slicers for: o year o division o traffic band 11. Deliverables • Power BI (.pbix) file • Short explanation of calculations • Dashboard must work locally in Power BI Desktop (for demo purposes) 12. Context for Use This dashboard will be used for: • internal decision-making • content review and prioritization • presentations to stakeholders Clarity and storytelling are more important than technical complexity. ✅ Final Summary for Freelancer • Use one dataset only • Focus on pages modified between 2017–2022 • Show division + traffic insights clearly • Include AI visuals (Q&A, Decomposition Tree, Key Influencers) • Keep design simple and presentation-ready
Project ID: 40379976
46 proposals
Remote project
Active 30 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
46 freelancers are bidding on average $141 CAD for this job

Hi! I specialize in building interactive Power BI dashboards that turn raw Excel data into clear, AI-powered insights with 9+ years of experience in data visualization, analytics, and business intelligence. Here's how I can help: * Transform your Excel content audit into a clean Power BI data model * Build interactive dashboards with Q&A, decomposition tree & key influencers * Design visuals that answer your specific content performance questions * Optimize data structure for fast, accurate insights and reporting I’d like to understand—what key questions do you want the dashboard to answer, and how is your Excel file structured (columns/tables)?
$140 CAD in 7 days
7.2
7.2

Hi, I can turn your Excel audit into a clean, interactive Power BI dashboard with built-in AI visuals so you can answer your questions easily. I will: Prepare and model your data properly (clean structure, relationships, measures) Build key visuals and KPIs based on your questions Configure AI features (Q&A, Key Influencers, Decomposition Tree) Create a user-friendly layout for quick insights Set up refresh and provide a short walkthrough You’ll get a dashboard that’s easy to use and flexible for future updates. Ready to start once you share the file and your questions. Best regards, Muhammad Usman
$180 CAD in 3 days
6.7
6.7

Hello, With over 7 years of experience in Excel and Data Visualization, I have the expertise to assist you in transforming your content audit data into an interactive Power BI dashboard. I have carefully reviewed your project requirements and understand the need for an AI-driven dashboard that can answer specific questions using advanced visual features like Q&A, decomposition, and influencers. To achieve this, I will start by structuring and cleaning the data from your Excel file, ensuring that it is optimized for Power BI. I will then create visually appealing and interactive dashboards that provide insights into your content audit data. Utilizing Power BI's AI features, I will implement functionalities like Q&A to enable natural language querying, decomposition for in-depth analysis, and influencers for identifying key factors impacting your content audit. I believe that my skills and experience make me the perfect candidate for this project. I would love to discuss your requirements further and collaborate on creating a customized solution that meets your needs. Please feel free to connect with me in the chat for a detailed discussion. You can visit my Profile: https://www.freelancer.com/u/HiraMahmood4072 Thank you.
$100 CAD in 2 days
6.3
6.3

Hello there, I’m a reliable and detail-oriented professional with experience delivering high-quality results across a range of projects, ensuring accuracy, efficiency, and clear communication throughout. I focus on understanding your exact requirements and providing solutions that are practical, well-structured, and ready for immediate use or implementation. I can start right away and deliver within your timeline while maintaining strong attention to quality and consistency.
$140 CAD in 1 day
5.1
5.1

Hi there, I am a Data Scientist,I specialize in advanced data visualization and reporting using Power BI, DAX formulas, Tableau, and Looker Studio to transform raw data into meaningful insights. My expertise includes creating custom dashboards, KPI tracking, interactive reports, and automated data models that help businesses make data-driven decisions with clarity. With strong command over DAX calculations, drill-through reports, and cross-platform integration, I ensure accuracy and actionable outcomes. I focus on delivering clean, visually appealing, and performance-optimized dashboards tailored to your business goals. My commitment is to provide scalable, insightful, and user-friendly solutions that empower stakeholders and enhance decision-making. Let's discuss this further via chat, and I'll start your project right now. Thank you. Gdev
$100 CAD in 7 days
5.4
5.4

Hi there, I understand you need to transform your Excel content audit into a sophisticated Power BI dashboard that leverages advanced AI features like Q&A, Decomposition Trees, and Key Influencers. With a background in data visualization and Power BI development, I can build a solution that allows you to explore your data through natural language and root-cause analysis rather than just static charts. My approach will center on creating an augmented analytics experience. I will first model your Excel data in Power BI to ensure that dimensions such as Page Category and Content Type are correctly linked to performance metrics like Page Views and Bounce Rate. I will then implement the Decomposition Tree to help you drill down into what drives high traffic across your site hierarchy. I will also configure the Key Influencers visual to identify which specific attributes correlate most strongly with your success metrics. Finally, I will optimize the Q&A feature by training it with your specific terminology, so you can type questions like "Which authors have the highest engagement?" and receive an instant visualization. QUESTION: Which specific outcome is your primary focus; reducing bounce rates or identifying factors for higher lead conversions? Let’s chat and get started now! Regards, Shehwani.
$75 CAD in 1 day
4.8
4.8

As a team deeply invested in the power and potential of AI, we're the perfect fit for transforming your content audit data into an interactive Power BI dashboard. My name is Shadab and in addition to our AI expertise, we also excel in Data Visualization - a skill that will be paramount for this project. Our unique approach to AI is focused on building practical, scalable, and production-ready systems rather than mere proofs of concept. This aligns perfectly with your need for a functional and intuitive dashboard that can answer specific questions using AI visual features like Q&A, decomposition, influencers etc. On top of that, our proficiency in different tools and technologies like Odoo ERP and IoT hardware design means we bring an extensive understanding of diverse datasets and workflows. As you may know, AI is most impactful when fully integrated with existing systems, and that's what we're practiced at. So if you're looking to put your content audit data from Excel to work using Power BI's capabilities fully, look no further. Let's build a powerful dashboard together.
$250 CAD in 7 days
4.2
4.2

Hi there! ? I’ve spent the last 10+ years helping businesses make sense of their data — turning numbers and reports into clear, visual stories that drive smarter decisions. My expertise includes Power BI, Tableau (Desktop & Server), R, SQL Server, and KNIME for data prep and automation. Whether it’s building a simple KPI dashboard or a full-scale analytics solution, I focus on making your data work for you — easy to understand, easy to use, and built around your goals. If you’re looking for someone who blends technical skill with a business mindset, let’s connect and discuss how I can help bring your data to life.
$140 CAD in 4 days
4.4
4.4

Hi, I’ve reviewed your requirements and understand that you already have the Excel data and key questions in mind, but need help transforming everything into a clear and interactive Power BI dashboard. I can help organize the data model, create useful visuals, and build AI-powered features such as Q&A, decomposition trees, and key influencers so you can explore your content audit data more effectively. I can also make the dashboard easy to navigate and explain how each visual answers your specific questions. The final result will be a clean, user-friendly Power BI dashboard that helps you gain insights from the data without needing advanced technical knowledge.
$30 CAD in 1 day
4.5
4.5

As an accomplished Full Stack Developer, my proficiency in a wide array of relevant skills positions me as an excellent fit for your Content Audit Dashboard project using Power BI. Drawing on over five years of experience in software engineering, I have developed a keen intuition for integrating AI into real-life scenarios to enable intelligent solutions. My profound expertise with AI systems like OpenAI API and Anthropic, as well as experience in RAG pipelines, LangChain, and more would be invaluable in executing the AI visual features you desire for your dashboard. Another predominant advantage I bring to the table is my comprehensive knowledge and practical application of Power BI. I understand that though you have a clear vision about the questions you want answered through the dashboard, you are relatively new to Power BI. My expertise would not only help navigate this situation smoothly but also elevate your content audit process by using Q&A, decomposition, influencers and other valuable AI features. Furthermore, my versatility extends beyond Power BI. With proficiency in Excel combined with database scripting skills (MySQL, PostgreSQL, MongoDB), I am not only able to transform your Excel file into an interactive dashboard but also ensure robustness and efficiency through intelligent database management and optimization.
$150 CAD in 2 days
3.9
3.9

Hi, My name is Ali and I can certainly help you transform your content audit data into an AI-powered Power BI dashboard that uncovers the "why" behind your website's performance. AI-Driven Analysis: I will integrate advanced visual features like the Decomposition Tree to break down traffic by content category, Key Influencers to identify what drives high engagement, and the Q&A visual to let you query your data using natural language. Structured Data Modeling: I'll clean your Excel audit via Power Query and build a robust model that connects your URLs, metadata, and performance metrics, ensuring your slicers and AI visuals work across the entire dataset. Interactive Storytelling: I will design a user-friendly layout with custom tooltips and drill-throughs, allowing you to move from a high-level audit overview down to specific page-level insights with a single click. I’m ready to take a look at your Excel file and the list of questions you want answered to get this set up for you.
$140 CAD in 7 days
3.2
3.2

Hi, I can help turn your Excel content audit into a clean, interactive Power BI dashboard that answers your key questions clearly and uses features like Q&A, decomposition tree, and key influencers effectively. I’ve worked on similar dashboards where raw audit data was structured, modeled, and transformed into insights with proper relationships, measures, and visuals that non-technical users can easily explore. For your case, I can structure the data model, create the right DAX measures, build intuitive visuals, and set up AI features so you can ask questions naturally and get meaningful answers. I’ll also make sure everything is easy for you to maintain and extend later. Best regards, George
$140 CAD in 7 days
3.0
3.0

Hey there For AI visuals like Q&A and key influencers, data structure matters a lot. Is your Excel file already cleaned with clear columns like content type, traffic, status, or do we need to reshape it first in Power BI? Also, do you want the Q&A to work with natural language like “which pages have low traffic but high value”? From my experience, the main issue in content audit dashboards is not visuals, but proper data modeling. I usually build a clean data model, define relationships, and create measures so features like decomposition tree and influencers give correct insights. Then we design simple visuals that answer your exact questions. I can help you go from raw Excel to a clear, interactive dashboard step by step, and keep it easy for you to update later. looking forward to discuss more on chat Best, Kostiantyn
$140 CAD in 7 days
2.8
2.8

Hi, I can turn your Excel content audit into a clean, interactive Power BI dashboard with AI features like Q&A, Key Influencers, and Decomposition Tree. The key is structuring your data properly first, then building visuals that actually answer your questions. I’ll keep it simple, fast, and focused on insights like what drives traffic, conversions, and which pages need updates
$100 CAD in 7 days
2.8
2.8

As a skilled Power BI expert, I have deep experience in visualizing complex datasets, and my proficiency in Excel will be invaluable. Your project aligns precisely with my areas of expertise. I have developed and customized multiple dashboards using data from diverse sources and provided clients with interactive, user-friendly visuals that meet their unique needs. I not only have the technical skills to create your Content Audit Dashboard but also the creativity to design a clean, minimalistic interface that centers around storytelling, making it easy for all stakeholders to decipher. Moreover, my knowledge of VB/VBA will enable me to automate various repetitive tasks within the Power BI environment to ensure the accuracy, consistency, and efficiency of your data analysis process. As per your project requirements, I can implement slicers for year, division, and traffic band seamlessly into the dashboard layout for easy filtering. I'm particularly excited about bringing AI-powered visuals like Q&A Visual, Decomposition Tree and Key Influencers visualization opportunities to life in this project.
$140 CAD in 1 day
2.9
2.9

Hello there. I hear you. You have the Excel data and you know what questions you want answered. But Power BI is new to you and right now it feels like a wall you cannot climb. That is exactly why I am here. My job is to help you get past that wall. I will take your Excel file and build the dashboard for you step by step. You do not need to learn Power BI overnight. I will handle the technical side so you can focus on getting the answers you need. I will set up the AI features like Q&A so you can simply type a question and see the answer appear as a chart. It sounds complex but I will make it simple for you to use once it is built. You will end up with a working dashboard and I will walk you through how to use it in plain language. No jargon. No confusion. Share your Excel file and the questions you want answered. I will do the rest and help you every step of the way. Available through the weekend if you need this done soon. Looking forward to your response.
$120 CAD in 7 days
3.3
3.3

Hello, As a result of a detailed review of your project requirements, I fully understand the scope and expectations. I have experience building Power BI dashboards from Excel datasets and can turn your content audit into an interactive, insight-driven report. I bring deep expertise in Power BI, Data Visualization, Data Analysis, Excel with over 10 years of experience. One of the key challenges in projects like this is structuring the data model correctly so AI visuals like Q&A, decomposition tree, and key influencers return accurate results; I would clean and model your dataset, define relationships and measures, and build a dashboard that directly answers your questions with intuitive visuals and fast interaction. I have a couple of quick questions. • Are your questions already mapped to specific metrics or should I help define the measures in Power BI? • Does your Excel file require cleaning or is it already structured for analysis? I would also provide a short walkthrough so you can refresh and extend the dashboard confidently. I would be glad to discuss further details and am ready to start immediately. Looking forward to hearing from you. Best regards, Carlos
$30 CAD in 3 days
1.8
1.8

Dear Client, I’m an experienced data analyst and full-stack developer with 10+ years of expertise working with Excel, Power BI, and interactive data visualization. I understand you need to transform your content audit Excel file into a dynamic Power BI dashboard with AI-driven visuals like Q&A, decomposition tree, and key influencers. I’ve built similar dashboards, cleaning and modeling data, designing intuitive layouts, and enabling natural language Q&A so users can quickly extract insights without technical effort. My approach includes data preparation, relationship modeling, visual setup, and configuring AI features aligned with your specific questions. Looking forward to hearing from you. Best regards, Md Ruhul Ajom
$95 CAD in 3 days
1.2
1.2

Dear client, I can help you turn your Excel-based content audit into a clean, interactive Power BI dashboard that answers your questions effectively—especially using AI visuals like Q&A, Decomposition Tree, and Key Influencers. Approach: I’ll start by reviewing and structuring your Excel data using Power Query to ensure it’s clean and analysis-ready. Then I’ll build a well-organized data model that supports flexible exploration. Based on the questions you already have, I’ll create the necessary DAX measures and design visuals that directly answer them. I’ll also configure Power BI’s AI features: Q&A visual with properly defined synonyms for natural language queries Decomposition Tree to break down key metrics Key Influencers to identify drivers behind performance The final dashboard will be intuitive, interactive, and tailored to your needs. I’ll also guide you with a short walkthrough so you can confidently use and extend it. Timeline: 2–4 days Portfolio: https://www.freelancer.com/u/echekwa Ready to get started as soon as you share the file and questions. Regards, Chijioke
$140 CAD in 4 days
0.6
0.6

Hello there, I hope you’re well. I’m a solo Power BI developer with strong Excel data prep and visualization experience. I transform messy audit data into clear, interactive dashboards. I can connect your Excel file, model the content audit data, and design an AI-powered dashboard with Q&A, decomposition trees, and influencers to answer your specific questions. In previous work, I’ve built Power BI dashboards from Excel sources that let stakeholders drill down by page, topic, and status, with robust data modeling, DAX measures, and visuals that adapt as questions change. I will apply your questions, create a guided narrative, and ensure the dashboard is publish-ready with filters and a responsive layout. I can deliver a polished dashboard focusing on your questions within a short timeline. Ready to start and iterate based on your feedback. Best regards, Billy Bryan
$250 CAD in 2 days
0.0
0.0

Toronto, Canada
Payment method verified
Member since Aug 30, 2007
N/A
N/A
$10-30 CAD
$10-30 CAD
$10-30 USD
₹1250-2500 INR / hour
$10-30 USD
₹1500-12500 INR
£20-30 GBP
₹750-1250 INR / hour
₹1500-12500 INR
₹600-1500 INR
$15-25 USD / hour
$250-750 USD
₹100-400 INR / hour
$30-250 USD
$30-250 USD
$25-50 USD / hour
$30-250 USD
$25-50 AUD / hour
₹600-1500 INR
₹600-1500 INR
$30-250 AUD
$30-250 USD
₹400-750 INR / hour