{"id":764,"date":"2026-10-26T17:42:14","date_gmt":"2026-10-26T12:12:14","guid":{"rendered":"https:\/\/www.itvedant.com\/blog\/?p=764"},"modified":"2026-10-26T17:44:08","modified_gmt":"2026-10-26T12:14:08","slug":"power-bi-sales-dashboard-using-excel","status":"publish","type":"post","link":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/","title":{"rendered":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide"},"content":{"rendered":"\n<p>Businesses generate sales data every day, but spreadsheets filled with thousands of rows do not always make it easy to identify trends. Managers need to know which products sell the most, which regions perform well and whether revenue is improving.<\/p>\n\n\n\n<p>A Power BI sales dashboard helps turn this raw data into meaningful visual reports.<\/p>\n\n\n\n<p>In this guide, you will learn how to create a beginner-friendly sales dashboard in Power BI using Excel data, from importing a dataset to designing charts and calculating key performance indicators (KPIs).<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#What_Is_a_Power_BI_Sales_Dashboard\" title=\"What Is a Power BI Sales Dashboard?\">What Is a Power BI Sales Dashboard?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_1_Prepare_Your_Sales_Dataset_in_Excel\" title=\"Step 1: Prepare Your Sales Dataset in Excel\">Step 1: Prepare Your Sales Dataset in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_2_Import_Excel_Data_into_Power_BI\" title=\"Step 2: Import Excel Data into Power BI\">Step 2: Import Excel Data into Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_3_Clean_Your_Data_Using_Power_Query\" title=\"Step 3: Clean Your Data Using Power Query\">Step 3: Clean Your Data Using Power Query<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_4_Create_Important_DAX_Measures\" title=\"Step 4: Create Important DAX Measures\">Step 4: Create Important DAX Measures<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_5_Build_the_Sales_Report\" title=\"Step 5: Build the Sales Report\">Step 5: Build the Sales Report<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#KPI_Cards\" title=\"KPI Cards\">KPI Cards<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Sales_by_Region\" title=\"Sales by Region\">Sales by Region<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Sales_by_Product\" title=\"Sales by Product\">Sales by Product<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Sales_Trend\" title=\"Sales Trend\">Sales Trend<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Interactive_Filters\" title=\"Interactive Filters\">Interactive Filters<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_6_Make_the_Report_Easy_to_Read\" title=\"Step 6: Make the Report Easy to Read\">Step 6: Make the Report Easy to Read<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Step_7_Turn_the_Project_into_a_Portfolio_Case_Study\" title=\"Step 7: Turn the Project into a Portfolio Case Study\">Step 7: Turn the Project into a Portfolio Case Study<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Common_Mistakes_to_Avoid\" title=\"Common Mistakes to Avoid\">Common Mistakes to Avoid<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Frequently_Asked_Questions\" title=\"Frequently Asked Questions\">Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#1_Can_I_build_a_Power_BI_sales_dashboard_without_coding\" title=\"1. Can I build a Power BI sales dashboard without coding?\">1. Can I build a Power BI sales dashboard without coding?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#2_Is_Excel_enough_to_start_a_Power_BI_project\" title=\"2. Is Excel enough to start a Power BI project?\">2. Is Excel enough to start a Power BI project?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#3_What_DAX_formulas_should_beginners_learn\" title=\"3. What DAX formulas should beginners learn?\">3. What DAX formulas should beginners learn?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#4_Can_I_include_a_Power_BI_project_on_my_resume\" title=\"4. Can I include a Power BI project on my resume?\">4. Can I include a Power BI project on my resume?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#5_Is_Power_BI_useful_for_data_analyst_jobs\" title=\"5. Is Power BI useful for data analyst jobs?\">5. Is Power BI useful for data analyst jobs?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Is_a_Power_BI_Sales_Dashboard\"><\/span><strong>What Is a Power BI Sales Dashboard?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A Power BI sales dashboard is a visual reporting solution that helps businesses monitor sales performance through metrics, charts and interactive filters.<\/p>\n\n\n\n<p>Sales teams commonly use these reports to track:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Total sales revenue<\/li>\n\n\n\n<li>Total orders<\/li>\n\n\n\n<li>Average order value<\/li>\n\n\n\n<li>Sales by region<\/li>\n\n\n\n<li>Best-performing products<\/li>\n\n\n\n<li>Monthly sales trends<\/li>\n<\/ul>\n\n\n\n<p>In Power BI Desktop, you initially create a report. A dashboard, in Microsoft&#8217;s specific terminology, is a separate feature in the Power BI service, where visuals can be pinned to a single canvas.<\/p>\n\n\n\n<p>For this tutorial, we will build an interactive sales report in Power BI Desktop.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1_Prepare_Your_Sales_Dataset_in_Excel\"><\/span><strong>Step 1: Prepare Your Sales Dataset in Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Create an Excel worksheet containing these columns:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Order ID<\/strong><\/td><td><strong>Date<\/strong><\/td><td><strong>Product<\/strong><\/td><td><strong>Region<\/strong><\/td><td><strong>Quantity<\/strong><\/td><td><strong>Unit Price<\/strong><\/td><\/tr><tr><td>1001<\/td><td>01-10-2026<\/td><td>Laptop<\/td><td>Mumbai<\/td><td>2<\/td><td>\u20b945,000<\/td><\/tr><tr><td>1002<\/td><td>02-10-2026<\/td><td>Mouse<\/td><td>Pune<\/td><td>5<\/td><td>\u20b9800<\/td><\/tr><tr><td>1003<\/td><td>03-10-2026<\/td><td>Keyboard<\/td><td>Delhi<\/td><td>3<\/td><td>\u20b91,500<\/td><\/tr><tr><td>1004<\/td><td>04-10-2026<\/td><td>Monitor<\/td><td>Mumbai<\/td><td>2<\/td><td>\u20b912,000<\/td><\/tr><tr><td>1005<\/td><td>05-10-2026<\/td><td>Laptop<\/td><td>Bengaluru<\/td><td>1<\/td><td>\u20b945,000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><em>This is a fictional practice dataset.<\/em><\/p>\n\n\n\n<p>Store unit prices as numeric values in Excel, not strings containing the rupee symbol. Format the cells as currency separately.<\/p>\n\n\n\n<p>Select the data, press Ctrl + T to create an Excel table, and name it <strong>Sales<\/strong>.<\/p>\n\n\n\n<p>Save the workbook as Sales_Data.xlsx.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2_Import_Excel_Data_into_Power_BI\"><\/span><strong>Step 2: Import Excel Data into Power BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Open Power BI Desktop and follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select Home \u2192 Get data \u2192 Excel workbook.<\/li>\n\n\n\n<li>Choose Sales_Data.xlsx.<\/li>\n\n\n\n<li>Select the Sales table in the Navigator.<\/li>\n\n\n\n<li>Click Transform Data to open Power Query.<\/li>\n<\/ol>\n\n\n\n<p>Power Query allows you to prepare the dataset before creating visualizations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_3_Clean_Your_Data_Using_Power_Query\"><\/span><strong>Step 3: Clean Your Data Using Power Query<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Check the following before loading your data:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Remove unnecessary blank rows.<\/li>\n\n\n\n<li>Confirm each Order ID is valid.<\/li>\n\n\n\n<li>Change the Date column to the Date data type.<\/li>\n\n\n\n<li>Set Quantity to Whole Number.<\/li>\n\n\n\n<li>Set Unit Price to Decimal Number or Fixed Decimal Number.<\/li>\n\n\n\n<li>Check duplicate records before removing them.<\/li>\n\n\n\n<li>Investigate missing values rather than automatically replacing them with zero.<\/li>\n<\/ul>\n\n\n\n<p>For example, if Unit Price is stored as text, Power BI may not calculate revenue correctly.<\/p>\n\n\n\n<p>Once your data is cleaned, select <strong>Close &amp; Apply<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_4_Create_Important_DAX_Measures\"><\/span><strong>Step 4: Create Important DAX Measures<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>DAX stands for Data Analysis Expressions. It is the formula language used in Power BI to create calculations.<\/p>\n\n\n\n<p>For this example, use the table name Sales.<\/p>\n\n\n\n<p><strong>Total Sales Revenue<\/strong><\/p>\n\n\n\n<p>Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Unit Price])<\/p>\n\n\n\n<p>This measure multiplies the quantity of each row by the unit price and adds the results.<\/p>\n\n\n\n<p><strong>Total Orders<\/strong><\/p>\n\n\n\n<p>Total Orders = DISTINCTCOUNT(Sales[Order ID])<\/p>\n\n\n\n<p>This counts unique orders.<\/p>\n\n\n\n<p><strong>Total Quantity Sold<\/strong><\/p>\n\n\n\n<p>Total Quantity = SUM(Sales[Quantity])<\/p>\n\n\n\n<p><strong>Average Order Value<\/strong><\/p>\n\n\n\n<p>Average Order Value = DIVIDE([Total Sales], [Total Orders], 0)<\/p>\n\n\n\n<p>For the five example orders, the measures produce:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Metric<\/strong><\/td><td><strong>Value<\/strong><\/td><\/tr><tr><td>Total Sales<\/td><td>\u20b91,67,500<\/td><\/tr><tr><td>Total Orders<\/td><td>5<\/td><\/tr><tr><td>Units Sold<\/td><td>13<\/td><\/tr><tr><td>Average Order Value<\/td><td>\u20b933,500<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>These calculations assume each Order ID represents a distinct order and the dataset contains no returns or cancelled sales.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_5_Build_the_Sales_Report\"><\/span><strong>Step 5: Build the Sales Report<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Create a report page with the following visuals.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"KPI_Cards\"><\/span><strong>KPI Cards<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add four Card visuals:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Total Sales<\/li>\n\n\n\n<li>Total Orders<\/li>\n\n\n\n<li>Total Quantity<\/li>\n\n\n\n<li>Average Order Value<\/li>\n<\/ul>\n\n\n\n<p>Place them in the top section so users can understand overall performance immediately.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sales_by_Region\"><\/span><strong>Sales by Region<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Insert a clustered bar chart.<\/p>\n\n\n\n<p>Use &#8216;Region&#8217; as the category and &#8216;Total Sales&#8217; as the value.<\/p>\n\n\n\n<p>This helps identify the regions generating the most revenue.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sales_by_Product\"><\/span><strong>Sales by Product<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Create a column chart comparing revenue across products.<\/p>\n\n\n\n<p>It can help answer questions such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Which product generates the highest revenue?<\/li>\n\n\n\n<li>Which product sells the most units?<\/li>\n\n\n\n<li>Are a few products responsible for most sales?<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sales_Trend\"><\/span><strong>Sales Trend<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add a line chart with date on the horizontal axis and total sales on the vertical axis.<\/p>\n\n\n\n<p>When working with a larger dataset, aggregate the information by month to identify trends.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Interactive_Filters\"><\/span><strong>Interactive Filters<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add slicers for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Region<\/li>\n\n\n\n<li>Product<\/li>\n\n\n\n<li>Date range<\/li>\n<\/ul>\n\n\n\n<p>When a user selects Mumbai, the connected visuals update to show the relevant sales data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_6_Make_the_Report_Easy_to_Read\"><\/span><strong>Step 6: Make the Report Easy to Read<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>A professional Power BI report should be informative without being overcrowded.<\/p>\n\n\n\n<p>Use consistent colours, clear chart titles and currency formatting.<\/p>\n\n\n\n<p>Place KPI cards at the top, trend visuals in the middle and detailed comparisons below.<\/p>\n\n\n\n<p>Avoid unnecessary 3D charts and excessive decorative elements.<\/p>\n\n\n\n<p>Also verify that totals remain correct when slicers are applied.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_7_Turn_the_Project_into_a_Portfolio_Case_Study\"><\/span><strong>Step 7: Turn the Project into a Portfolio Case Study<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Building the report is only one part of the project. A strong data analyst portfolio should explain the business problem and the insights generated.<\/p>\n\n\n\n<p>Your case study can include:<\/p>\n\n\n\n<p><strong>Business problem:<\/strong> A retailer needs a clearer view of product and regional sales.<\/p>\n\n\n\n<p><strong>Data source:<\/strong> Fictional sales transaction data stored in Excel.<\/p>\n\n\n\n<p><strong>Tools used:<\/strong> Excel, Power Query, Power BI and DAX.<\/p>\n\n\n\n<p><strong>Analysis:<\/strong> Revenue, order volume, regional performance and product contribution.<\/p>\n\n\n\n<p><strong>Outcome:<\/strong> An interactive report that allows users to explore sales performance.<\/p>\n\n\n\n<p>Include screenshots and describe what the analysis reveals. Do not claim a real business improvement unless you have evidence.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Common_Mistakes_to_Avoid\"><\/span><strong>Common Mistakes to Avoid<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Many beginners focus on chart design and overlook data quality.<\/p>\n\n\n\n<p>Common mistakes include adding sales totals without checking duplicate rows, treating dates as text, using incorrect relationships and selecting unsuitable visualisations.<\/p>\n\n\n\n<p>Remember that a visually attractive report is not necessarily an accurate report.<\/p>\n\n\n\n<p>Data validation should always come first.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Can_I_build_a_Power_BI_sales_dashboard_without_coding\"><\/span><strong>1. Can I build a Power BI sales dashboard without coding?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Yes. Power BI provides a visual interface for importing data and building reports. Learning basic DAX will help you create more useful calculations.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_Is_Excel_enough_to_start_a_Power_BI_project\"><\/span><strong>2. Is Excel enough to start a Power BI project?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Yes. Excel is a practical data source for beginner projects. As your skills improve, you can connect Power BI to SQL databases and other systems.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_What_DAX_formulas_should_beginners_learn\"><\/span><strong>3. What DAX formulas should beginners learn?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Start with SUM, SUMX, COUNTROWS, DISTINCTCOUNT, CALCULATE and DIVIDE. Learn how filter context affects their results.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_Can_I_include_a_Power_BI_project_on_my_resume\"><\/span><strong>4. Can I include a Power BI project on my resume?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Yes. Include your project objective, tools, measures, screenshots and a clear explanation of what the report helps users understand.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_Is_Power_BI_useful_for_data_analyst_jobs\"><\/span><strong>5. Is Power BI useful for data analyst jobs?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Power BI is widely used for reporting and business intelligence. It is useful alongside SQL, Excel, data cleaning and analytical problem-solving skills.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Creating a Power BI sales dashboard is a practical way to develop data analytics skills. It teaches you how to prepare data, define business metrics and convert raw numbers into useful visual insights.<\/p>\n\n\n\n<p>If you want to strengthen your Excel, SQL, Power BI and analytics skills through structured learning, explore <a href=\"https:\/\/www.itvedant.com\/\" title=\"\">Itvedant&#8217;s<\/a><a href=\"https:\/\/www.itvedant.com\/data-science-and-ai\"> Data Science &amp; Analytics with AI Course<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Businesses generate sales data every day, but spreadsheets filled with thousands of rows do not always make it easy to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":765,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5],"tags":[551,549,550,552],"class_list":["post-764","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-science","tag-excel-to-power-bi","tag-power-bi-dashboard-project","tag-power-bi-project-for-beginners","tag-sales-dashboard-in-power-bi"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"itvedant\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Itvedant Blogs: Master Data Science, AI &amp; IT Skills - Practical training and industry insights to make you job-ready\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"How to Build a Sales Dashboard in Power BI\" \/>\n\t\t<meta property=\"og:description\" content=\"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-10-26T12:12:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-10-26T12:14:08+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"How to Build a Sales Dashboard in Power BI\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#blogposting\",\"name\":\"How to Build a Sales Dashboard in Power BI\",\"headline\":\"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide\",\"author\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/author\\\/itvedant\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/Build-a-Sales-Dashboard-in-Power-BI-20kb.jpeg\",\"width\":1200,\"height\":653,\"caption\":\"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide\"},\"datePublished\":\"2026-10-26T17:42:14+05:30\",\"dateModified\":\"2026-10-26T17:44:08+05:30\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#webpage\"},\"articleSection\":\"Data Science, Excel to Power BI, Power BI dashboard project, Power BI project for beginners, sales dashboard in Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itvedant.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/category\\\/data-science\\\/#listItem\",\"name\":\"Data Science\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/category\\\/data-science\\\/#listItem\",\"position\":2,\"name\":\"Data Science\",\"item\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/category\\\/data-science\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#listItem\",\"name\":\"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#listItem\",\"position\":3,\"name\":\"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/category\\\/data-science\\\/#listItem\",\"name\":\"Data Science\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/#organization\",\"name\":\"Itvedant Blogs: Master Data Science, AI & IT Skills\",\"description\":\"Practical training and industry insights to make you job-ready\",\"url\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/author\\\/itvedant\\\/#author\",\"url\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/author\\\/itvedant\\\/\",\"name\":\"itvedant\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3e2e8562c173f06f1cd8b8b32a02e1c?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"itvedant\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#webpage\",\"url\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/\",\"name\":\"How to Build a Sales Dashboard in Power BI\",\"description\":\"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/author\\\/itvedant\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/author\\\/itvedant\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/Build-a-Sales-Dashboard-in-Power-BI-20kb.jpeg\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#mainImage\",\"width\":1200,\"height\":653,\"caption\":\"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/power-bi-sales-dashboard-using-excel\\\/#mainImage\"},\"datePublished\":\"2026-10-26T17:42:14+05:30\",\"dateModified\":\"2026-10-26T17:44:08+05:30\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/\",\"name\":\"Itvedant Blogs: Master Data Science, AI & IT Skills\",\"description\":\"Practical training and industry insights to make you job-ready\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itvedant.com\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to Build a Sales Dashboard in Power BI","description":"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.","canonical_url":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#blogposting","name":"How to Build a Sales Dashboard in Power BI","headline":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide","author":{"@id":"https:\/\/www.itvedant.com\/blog\/author\/itvedant\/#author"},"publisher":{"@id":"https:\/\/www.itvedant.com\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.itvedant.com\/blog\/wp-content\/uploads\/2026\/10\/Build-a-Sales-Dashboard-in-Power-BI-20kb.jpeg","width":1200,"height":653,"caption":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide"},"datePublished":"2026-10-26T17:42:14+05:30","dateModified":"2026-10-26T17:44:08+05:30","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#webpage"},"isPartOf":{"@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#webpage"},"articleSection":"Data Science, Excel to Power BI, Power BI dashboard project, Power BI project for beginners, sales dashboard in Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/www.itvedant.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog\/category\/data-science\/#listItem","name":"Data Science"}},{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog\/category\/data-science\/#listItem","position":2,"name":"Data Science","item":"https:\/\/www.itvedant.com\/blog\/category\/data-science\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#listItem","name":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#listItem","position":3,"name":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide","previousItem":{"@type":"ListItem","@id":"https:\/\/www.itvedant.com\/blog\/category\/data-science\/#listItem","name":"Data Science"}}]},{"@type":"Organization","@id":"https:\/\/www.itvedant.com\/blog\/#organization","name":"Itvedant Blogs: Master Data Science, AI & IT Skills","description":"Practical training and industry insights to make you job-ready","url":"https:\/\/www.itvedant.com\/blog\/"},{"@type":"Person","@id":"https:\/\/www.itvedant.com\/blog\/author\/itvedant\/#author","url":"https:\/\/www.itvedant.com\/blog\/author\/itvedant\/","name":"itvedant","image":{"@type":"ImageObject","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/f3e2e8562c173f06f1cd8b8b32a02e1c?s=96&d=mm&r=g","width":96,"height":96,"caption":"itvedant"}},{"@type":"WebPage","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#webpage","url":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/","name":"How to Build a Sales Dashboard in Power BI","description":"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.itvedant.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#breadcrumblist"},"author":{"@id":"https:\/\/www.itvedant.com\/blog\/author\/itvedant\/#author"},"creator":{"@id":"https:\/\/www.itvedant.com\/blog\/author\/itvedant\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.itvedant.com\/blog\/wp-content\/uploads\/2026\/10\/Build-a-Sales-Dashboard-in-Power-BI-20kb.jpeg","@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#mainImage","width":1200,"height":653,"caption":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide"},"primaryImageOfPage":{"@id":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/#mainImage"},"datePublished":"2026-10-26T17:42:14+05:30","dateModified":"2026-10-26T17:44:08+05:30"},{"@type":"WebSite","@id":"https:\/\/www.itvedant.com\/blog\/#website","url":"https:\/\/www.itvedant.com\/blog\/","name":"Itvedant Blogs: Master Data Science, AI & IT Skills","description":"Practical training and industry insights to make you job-ready","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.itvedant.com\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"Itvedant Blogs: Master Data Science, AI &amp; IT Skills - Practical training and industry insights to make you job-ready","og:type":"article","og:title":"How to Build a Sales Dashboard in Power BI","og:description":"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.","og:url":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/","article:published_time":"2026-10-26T12:12:14+00:00","article:modified_time":"2026-10-26T12:14:08+00:00","twitter:card":"summary_large_image","twitter:title":"How to Build a Sales Dashboard in Power BI","twitter:description":"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts."},"aioseo_meta_data":{"post_id":"764","title":"How to Build a Sales Dashboard in Power BI","description":"Learn to build a Power BI sales dashboard using Excel data. Follow practical steps for data cleaning, DAX measures, KPIs and interactive charts.","keywords":null,"keyphrases":{"focus":{"keyphrase":"Power BI sales dashboard","score":54,"analysis":{"keyphraseInTitle":{"score":3,"maxScore":9,"error":1},"keyphraseInDescription":{"score":9,"maxScore":9,"error":0},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":4},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInSubHeadings":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":[],"keywordDensity":{"score":0,"type":"low","maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-10-26 12:02:39","updated":"2026-10-26 12:20:14"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.itvedant.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.itvedant.com\/blog\/category\/data-science\/\" title=\"Data Science\">Data Science<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.itvedant.com\/blog"},{"label":"Data Science","link":"https:\/\/www.itvedant.com\/blog\/category\/data-science\/"},{"label":"How to Build a Sales Dashboard in Power BI Using Excel Data: Step-by-Step Guide","link":"https:\/\/www.itvedant.com\/blog\/power-bi-sales-dashboard-using-excel\/"}],"_links":{"self":[{"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/posts\/764"}],"collection":[{"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":1,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"predecessor-version":[{"id":766,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/posts\/764\/revisions\/766"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/media\/765"}],"wp:attachment":[{"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itvedant.com\/blog\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}