{"id":18119,"date":"2024-12-31T05:03:10","date_gmt":"2024-12-31T05:03:10","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=18119"},"modified":"2024-12-31T05:03:11","modified_gmt":"2024-12-31T05:03:11","slug":"visualising-kpis-in-power-bi","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/","title":{"rendered":"A Step-By-Step Guide to Visualising KPIs in Power BI"},"content":{"rendered":"\n<p><strong>Summary: <\/strong>This guide covers visualising KPI in Power BI, from setting up the tool and preparing data to selecting the right visuals and enhancing dashboards. It emphasises the importance of using interactive elements, conditional formatting, and customising visuals for effective decision-making and business performance tracking.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 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\" style=\"cursor:inherit\">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 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Introduction\" >Introduction<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Understanding_KPIs\" >Understanding KPIs<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Setting_Up_Power_BI_for_KPI_Visualisation\" >Setting Up Power BI for KPI Visualisation<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Installing_Power_BI_Desktop\" >Installing Power BI Desktop<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Connecting_to_Data_Sources\" >Connecting to Data Sources<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Preparing_Data_for_Visualisation\" >Preparing Data for Visualisation<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Data_Cleaning_and_Transformation_Techniques\" >Data Cleaning and Transformation Techniques<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Creating_Calculated_Columns_and_Measures\" >Creating Calculated Columns and Measures<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Choosing_the_Right_Visuals_for_KPIs\" >Choosing the Right Visuals for KPIs<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Available_Chart_Types_in_Power_BI\" >Available Chart Types in Power BI<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Best_Practices_for_Selecting_Visuals\" >Best Practices for Selecting Visuals<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Creating_KPI_Dashboards\" >Creating KPI Dashboards<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Step-by-Step_Guide_to_Building_a_Dashboard\" >Step-by-Step Guide to Building a Dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#How_to_Use_Filters_and_Slicers_for_Interactivity\" >How to Use Filters and Slicers for Interactivity<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Enhancing_KPI_Visualisation_with_Conditional_Formatting\" >Enhancing KPI Visualisation with Conditional Formatting<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#How_to_Use_Color_Coding_and_Data_Bars\" >How to Use Color Coding and Data Bars<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Customising_Visuals_for_Better_Clarity_and_Impact\" >Customising Visuals for Better Clarity and Impact<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Sharing_and_Publishing_Dashboards\" >Sharing and Publishing Dashboards<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Exporting_Reports_and_Dashboards\" >Exporting Reports and Dashboards<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Sharing_Options_within_Power_BI_Power_BI_Service\" >Sharing Options within Power BI (Power BI Service)<\/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.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Closing_Words\" >Closing Words<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#Frequently_Asked_Questions\" >Frequently Asked Questions&nbsp;<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#How_Do_I_Visualise_KPIs_in_Power_BI\" >How Do I Visualise KPIs in Power BI?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#What_are_the_Best_Visuals_for_KPIs_in_Power_BI\" >What are the Best Visuals for KPIs in Power BI?&nbsp;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#How_Can_I_Enhance_KPI_Dashboards_in_Power_BI\" >How Can I Enhance KPI Dashboards in Power BI?&nbsp;<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In today\u2019s data-driven world, Key Performance Indicators (KPIs) are crucial in guiding business decisions. KPIs help organisations track progress toward their goals, assess performance, and make informed decisions. Visualising these KPIs is essential for quick insights and effective analysis.&nbsp;<\/p>\n\n\n\n<p><a href=\"https:\/\/pickl.ai\/blog\/power-bi-tutorial\/\">Power BI<\/a> is an excellent tool for this purpose, offering powerful features to create interactive, dynamic visualisations that bring data to life. This blog aims to provide a step-by-step guide on visualising Power BI KPIs, enabling users to make better, data-backed decisions and improve their overall business strategy.<\/p>\n\n\n\n<p><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Power BI is an excellent tool for KPI visualisation.<\/li>\n\n\n\n<li>Select the right visuals based on KPI types.<\/li>\n\n\n\n<li>Clean and structure data for better insights.<\/li>\n\n\n\n<li>Use conditional formatting for impactful visuals.<\/li>\n\n\n\n<li>Enhance interactivity with filters and slicers.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"understanding-kpis\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Understanding_KPIs\"><\/span><strong>Understanding KPIs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Key Performance Indicators (KPIs) are measurable values demonstrating how effectively a company achieves its business objectives. KPIs vary across industries and functions, with common types including <strong>lagging indicators<\/strong> (e.g., revenue growth) and <strong>leading indicators<\/strong> (e.g., customer satisfaction scores). Operational, financial, and customer-related KPIs help assess different facets of business performance.<\/p>\n\n\n\n<p>KPIs clearly show an organisation&#8217;s success in meeting strategic goals. By tracking KPIs, businesses can identify areas for improvement, make data-driven decisions, and ensure they remain on track to achieve long-term objectives.<\/p>\n\n\n\n<h2 id=\"setting-up-power-bi-for-kpi-visualisation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Setting_Up_Power_BI_for_KPI_Visualisation\"><\/span><strong>Setting Up Power BI for KPI Visualisation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To effectively visualise KPIs in Power BI, the first step is to set up the tool and connect it to your data sources. This process is essential for ensuring your visuals are populated with accurate, real-time data for meaningful insights.<\/p>\n\n\n\n<h3 id=\"installing-power-bi-desktop\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Installing_Power_BI_Desktop\"><\/span><strong>Installing Power BI Desktop<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Start by downloading and installing Power BI Desktop, the free version of Power BI. It\u2019s available for Windows and can be downloaded from the Microsoft website or the Microsoft Store.&nbsp;<\/p>\n\n\n\n<p>Once installed, launch the application, and you\u2019ll be ready to begin importing your data and creating dashboards. Power BI Desktop offers a range of features for building reports and conducting data analysis.<\/p>\n\n\n\n<h3 id=\"connecting-to-data-sources\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Connecting_to_Data_Sources\"><\/span><strong>Connecting to Data Sources<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>After installing Power BI Desktop, you\u2019ll need to connect it to your data sources. Power BI supports various data connections, including <a href=\"https:\/\/pickl.ai\/blog\/advanced-excel-chart-types\/\">Excel<\/a>, <a href=\"https:\/\/pickl.ai\/blog\/dynamic-sql-in-sql-server\/\">SQL Server<\/a>, and cloud-based sources like Azure and Google Analytics.&nbsp;<\/p>\n\n\n\n<p>To connect to a data source, click the <strong>Home<\/strong> tab and select <strong>Get Data<\/strong>. Choose the appropriate connector based on your data source type (e.g., Excel or SQL Server). Once connected, you can import your data directly into Power BI, where you can build visualisations.<\/p>\n\n\n\n<p>By setting up Power BI correctly, you\u2019ll ensure a seamless process for visualising and analysing KPIs across various business functions.<\/p>\n\n\n\n<h2 id=\"preparing-data-for-visualisation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Preparing_Data_for_Visualisation\"><\/span><strong>Preparing Data for Visualisation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXco_sJC3FHLdtsFYd2l-aypxvVE3203x-d6sYgQROipu85aGKMgRYLoGgq7QsBvFSDznYEWJ8OdEEbfdglpvISW1IQ9mHPcSjD2BR0k_hmTKOUjZOqLu-htWSDvgfXMkEAPQOGf?key=ap-2vAx4X3vpe6GwBIeKSgZI\" alt=\"Preparing Data for Visualisation\"\/><\/figure>\n\n\n\n<p>Before diving into creating visuals in Power BI, ensuring your data is clean, structured, and ready for analysis is crucial. This stage involves <a href=\"https:\/\/pickl.ai\/blog\/what-is-data-cleaning-in-machine-learning\/\">data cleaning<\/a>, transformation, and creating calculated columns or measures that will help generate meaningful KPIs.<\/p>\n\n\n\n<h3 id=\"data-cleaning-and-transformation-techniques\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data_Cleaning_and_Transformation_Techniques\"><\/span><strong>Data Cleaning and Transformation Techniques<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Data cleaning involves removing inconsistencies, correcting errors, and handling missing values. In Power BI, you can use the <strong>Power Query Editor<\/strong> to filter out irrelevant data, eliminate duplicates, and fill in missing values. To ensure dataset consistency, you can also standardise formats, such as date and time.<\/p>\n\n\n\n<p>Transforming the data may involve reshaping it into a format more suited for analysis. This could include pivoting columns, splitting columns into multiple fields, or merging tables to combine related data. Power BI offers an intuitive interface for these tasks, enabling you to perform complex transformations without writing code.<\/p>\n\n\n\n<h3 id=\"creating-calculated-columns-and-measures\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_Calculated_Columns_and_Measures\"><\/span><strong>Creating Calculated Columns and Measures<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Once the data is clean, the next step is creating calculated columns and measures. <strong>Calculated columns<\/strong> add new information to your data, such as categorising sales data or calculating profit margins based on existing fields. These columns are computed row by row.<\/p>\n\n\n\n<p>On the other hand, <strong>measures<\/strong> are dynamic calculations that aggregate data based on context. For example, DAX (Data Analysis Expressions) measures can calculate total revenue or average sales. Measures are vital for creating KPIs as they summarise data across entire datasets or periods.<\/p>\n\n\n\n<h2 id=\"choosing-the-right-visuals-for-kpis\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Choosing_the_Right_Visuals_for_KPIs\"><\/span><strong>Choosing the Right Visuals for KPIs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When visualising KPIs in Power BI, selecting the right chart or visual is crucial for clarity and effective decision-making. The visuals should align with the type of KPI you are tracking and the insights you want to convey. Power BI offers a variety of chart types that can transform raw data into actionable information.<\/p>\n\n\n\n<h3 id=\"available-chart-types-in-power-bi\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Available_Chart_Types_in_Power_BI\"><\/span><strong>Available Chart Types in Power BI<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Power BI provides several powerful visuals to represent KPIs, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Bar\/Column Charts<\/strong>: Ideal for comparing data across categories, like sales by region or revenue by product. These visuals allow for easy comparison of different values at a glance.<\/li>\n\n\n\n<li><strong>Line Charts<\/strong>: Best for tracking changes over time, such as year-over-year growth or sales trends. They effectively show patterns and variations in continuous data.<\/li>\n\n\n\n<li><strong>Card Visuals<\/strong>: Simple yet effective for showing individual KPI values, like total revenue or units sold. Cards provide a quick snapshot of performance.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"best-practices-for-selecting-visuals\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Best_Practices_for_Selecting_Visuals\"><\/span><strong>Best Practices for Selecting Visuals<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The choice of visual should match the data\u2019s nature and the insights you wish to highlight:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Trends and Comparisons<\/strong>: Use line or area charts to track performance over time.<\/li>\n\n\n\n<li><strong>Categorical Comparisons<\/strong>: Bar or column charts work best for comparing values across categories.<\/li>\n\n\n\n<li><strong>Single Values<\/strong>: Card visuals display a single KPI and focus on key metrics.<\/li>\n<\/ul>\n\n\n\n<p>By matching the visual type to the data, you ensure your KPIs are informative and easy to interpret.<\/p>\n\n\n\n<h2 id=\"creating-kpi-dashboards\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_KPI_Dashboards\"><\/span><strong>Creating KPI Dashboards<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"step-by-step-guide-to-building-a-dashboard\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-by-Step_Guide_to_Building_a_Dashboard\"><\/span><strong>Step-by-Step Guide to Building a Dashboard<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A well-designed KPI dashboard provides a visual summary of critical business metrics, allowing decision-makers to monitor performance easily. In Power BI, building an effective KPI dashboard involves organising data, choosing appropriate visuals, and ensuring interactivity for users to drill down into specific insights. Here\u2019s how you can create a compelling KPI dashboard in Power BI.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select Your Data Sources: <\/strong>Start by connecting your data sources from Excel, SQL, or another system. Ensure the data contains all the KPIs you want to track.<\/li>\n\n\n\n<li><strong>Create and Customise Visuals: <\/strong>Choose from Power BI\u2019s range of visualisations (e.g., cards, gauges, bar charts) to represent each KPI. Customise the visuals by adjusting colours, titles, and formats to make the dashboard user-friendly.<\/li>\n\n\n\n<li><strong>Arrange Visuals on the Canvas: <\/strong>Organise your visuals on the dashboard canvas in a logical, easy-to-read layout. Prioritise the most important KPIs at the top or centre of the dashboard.<\/li>\n<\/ul>\n\n\n\n<h3 id=\"how-to-use-filters-and-slicers-for-interactivity\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Use_Filters_and_Slicers_for_Interactivity\"><\/span><strong>How to Use Filters and Slicers for Interactivity<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Filters and slicers enhance user experience by enabling interactivity. With slicers, users can select specific data subsets (like periods or product categories) to view KPI results for those filters. To add a slicer:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Insert a Slicer: <\/strong>From the visualisation pane, choose the slicer icon. Drag a field (e.g., Date, Region) into the slicer.<\/li>\n\n\n\n<li><strong>Customise Slicer Appearance: <\/strong>Adjust the slicer style to match the overall dashboard theme. Users can now click on the slicer to dynamically update the KPI visuals based on their selection.<\/li>\n<\/ul>\n\n\n\n<p>This combination of static and interactive elements ensures your KPI dashboard is informative and engaging.<\/p>\n\n\n\n<h2 id=\"enhancing-kpi-visualisation-with-conditional-formatting\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Enhancing_KPI_Visualisation_with_Conditional_Formatting\"><\/span><strong>Enhancing KPI Visualisation with Conditional Formatting<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXezJNzdeSUBc42woCIEqXTM3HapUIRJdLLPUviWdBoZ8qfpLIh1CEjmPFA4aKFQfcBm_AI3v2BxydLDX6Ce18PAavrxXACao-K45sxt5nreoETeRxfKFZFlv1z98VtBmV23WhHjpw?key=ap-2vAx4X3vpe6GwBIeKSgZI\" alt=\"Enhancing KPI Visualisation with Conditional Formatting\"\/><\/figure>\n\n\n\n<p>Conditional formatting is a powerful feature in Power BI that helps enhance the visual impact of your KPI dashboards. By using colour coding, data bars, and other formatting techniques, you can make key metrics stand out and improve the clarity of your visuals.&nbsp;<\/p>\n\n\n\n<p>Let&#8217;s explore how to use these tools to create more insightful and effective KPI visualisations.<\/p>\n\n\n\n<h3 id=\"how-to-use-color-coding-and-data-bars\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Use_Color_Coding_and_Data_Bars\"><\/span><strong>How to Use Color Coding and Data Bars<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Colour coding allows you to convey trends and performance against targets quickly. Power BI provides an easy way to apply colour scales to your visuals, such as heat maps or gradient colours, based on the values of your KPIs.&nbsp;<\/p>\n\n\n\n<p>For example, you can set a rule where green indicates performance above target, yellow indicates target met, and red indicates target below target. This simple visual cue helps viewers assess data at a glance.<\/p>\n\n\n\n<p>Similarly, data bars within tables or matrix visuals quickly indicate relative performance. A longer data bar typically reflects a higher value, making comparing KPIs across multiple categories or periods easier.<\/p>\n\n\n\n<h3 id=\"customising-visuals-for-better-clarity-and-impact\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Customising_Visuals_for_Better_Clarity_and_Impact\"><\/span><strong>Customising Visuals for Better Clarity and Impact<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Beyond colour coding, Power BI offers customisation options like adding icons, adjusting text sizes, and modifying chart labels to improve visual clarity. You can also set specific thresholds to change the formatting dynamically, ensuring the KPIs align with the business goals. Tailoring these visuals to your audience ensures that the information is clear and impactful.<\/p>\n\n\n\n<h2 id=\"sharing-and-publishing-dashboards\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sharing_and_Publishing_Dashboards\"><\/span><strong>Sharing and Publishing Dashboards<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Once you&#8217;ve created your KPI dashboards in Power BI, the next crucial step is sharing and publishing them for others to access. Power BI provides several options for exporting and sharing dashboards, making collaboration easier and more efficient.<\/p>\n\n\n\n<h3 id=\"exporting-reports-and-dashboards\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Exporting_Reports_and_Dashboards\"><\/span><strong>Exporting Reports and Dashboards<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Power BI allows you to export your reports and dashboards to formats like PDF or PowerPoint. This is particularly useful for presenting insights to stakeholders who may not use Power BI.&nbsp;<\/p>\n\n\n\n<p>To export, simply select the &#8220;File&#8221; option, select &#8220;Export&#8221;, and select your desired format. This feature ensures that your reports are accessible and easy to share across teams, regardless of whether they can access Power BI.<\/p>\n\n\n\n<h3 id=\"sharing-options-within-power-bi-power-bi-service\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sharing_Options_within_Power_BI_Power_BI_Service\"><\/span><strong>Sharing Options within Power BI (Power BI Service)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>For real-time sharing and collaboration, Power BI Service offers robust sharing options. After publishing your report to the Power BI Service, you can share it with colleagues directly via email. You can also provide access by sharing a link, enabling others to view or interact with the dashboards.&nbsp;<\/p>\n\n\n\n<p>Additionally, you can manage permissions, ensuring only authorised individuals have access to sensitive data. Power BI Service supports embedding dashboards into websites, SharePoint, or apps, providing even more flexibility in presenting your visualisations.<\/p>\n\n\n\n<p>These sharing and publishing options make Power BI an ideal tool for collaborative decision-making and ensuring that critical KPI insights are easily accessible.<\/p>\n\n\n\n<h2 id=\"closing-words\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Closing_Words\"><\/span><strong>Closing Words<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Visualising KPIs in Power BI enables businesses to track their performance effectively and make informed decisions. With powerful features such as customisable visuals, interactivity, and conditional formatting, Power BI simplifies monitoring KPIs. Following the steps outlined in this guide, businesses can leverage these insights to drive strategic growth and improve performance.<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"how-do-i-visualise-kpis-in-power-bi\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_Do_I_Visualise_KPIs_in_Power_BI\"><\/span><strong>How Do I Visualise KPIs in Power BI?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can visualise KPIs in Power BI by connecting to your data sources, choosing the right visuals (cards, bar charts, line charts), and customising them to match your business goals. Interactivity can be added with slicers to enhance user experience.<\/p>\n\n\n\n<h3 id=\"what-are-the-best-visuals-for-kpis-in-power-bi\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_are_the_Best_Visuals_for_KPIs_in_Power_BI\"><\/span><strong>What are the Best Visuals for KPIs in Power BI?&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The best KPIs for Power BI KPIs include card visuals for individual metrics, bar\/column charts for comparisons, and line charts for tracking trends. Each visual should align with the KPI type and the insights you want to communicate.<\/p>\n\n\n\n<h3 id=\"how-can-i-enhance-kpi-dashboards-in-power-bi\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_Can_I_Enhance_KPI_Dashboards_in_Power_BI\"><\/span><strong>How Can I Enhance KPI Dashboards in Power BI?&nbsp;<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can enhance KPI dashboards using conditional formatting, such as color coding to highlight performance against targets. Customising visuals with icons and adjusting labels improves clarity and makes the dashboard impactful.<\/p>\n","protected":false},"excerpt":{"rendered":" Master KPI visualisation in Power BI to drive strategic business decisions and performance improvements.\n","protected":false},"author":26,"featured_media":18120,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2293],"tags":[3646],"ppma_author":[2216,2627],"class_list":{"0":"post-18119","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-power-bi","8":"tag-kpis-in-power-bi"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Guide to Visualising KPI in Power BI<\/title>\n<meta name=\"description\" content=\"Learn to visualise KPI in Power BI effectively for better decision-making and business performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Step-By-Step Guide to Visualising KPIs in Power BI\" \/>\n<meta property=\"og:description\" content=\"Learn to visualise KPI in Power BI effectively for better decision-making and business performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-31T05:03:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-31T05:03:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Smith Alex, Hitesh bijja\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Smith Alex\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/\"},\"author\":{\"name\":\"Smith Alex\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/48117213c22e77cd42d9af9b6b4b4056\"},\"headline\":\"A Step-By-Step Guide to Visualising KPIs in Power BI\",\"datePublished\":\"2024-12-31T05:03:10+00:00\",\"dateModified\":\"2024-12-31T05:03:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/\"},\"wordCount\":1883,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image3-3.png\",\"keywords\":[\"KPIs in Power BI\"],\"articleSection\":[\"Power BI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/\",\"name\":\"Guide to Visualising KPI in Power BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image3-3.png\",\"datePublished\":\"2024-12-31T05:03:10+00:00\",\"dateModified\":\"2024-12-31T05:03:11+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/48117213c22e77cd42d9af9b6b4b4056\"},\"description\":\"Learn to visualise KPI in Power BI effectively for better decision-making and business performance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image3-3.png\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/image3-3.png\",\"width\":800,\"height\":500,\"caption\":\"Guide to Visualising KPIs in Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/visualising-kpis-in-power-bi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/power-bi\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"A Step-By-Step Guide to Visualising KPIs in Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/48117213c22e77cd42d9af9b6b4b4056\",\"name\":\"Smith Alex\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_26_1723028835-96x96.jpg74f69d8707f58519398bb6ba829c2ad9\",\"url\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_26_1723028835-96x96.jpg\",\"contentUrl\":\"https:\\\/\\\/pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/avatar_user_26_1723028835-96x96.jpg\",\"caption\":\"Smith Alex\"},\"description\":\"Smith Alex is a committed data enthusiast and an aspiring leader in the domain of data analytics. With a foundation in engineering and practical experience in the field of data science\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/smithalex\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Guide to Visualising KPI in Power BI","description":"Learn to visualise KPI in Power BI effectively for better decision-making and business performance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"A Step-By-Step Guide to Visualising KPIs in Power BI","og_description":"Learn to visualise KPI in Power BI effectively for better decision-making and business performance.","og_url":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/","og_site_name":"Pickl.AI","article_published_time":"2024-12-31T05:03:10+00:00","article_modified_time":"2024-12-31T05:03:11+00:00","og_image":[{"width":800,"height":500,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png","type":"image\/png"}],"author":"Smith Alex, Hitesh bijja","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Smith Alex","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/"},"author":{"name":"Smith Alex","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/48117213c22e77cd42d9af9b6b4b4056"},"headline":"A Step-By-Step Guide to Visualising KPIs in Power BI","datePublished":"2024-12-31T05:03:10+00:00","dateModified":"2024-12-31T05:03:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/"},"wordCount":1883,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png","keywords":["KPIs in Power BI"],"articleSection":["Power BI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/","url":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/","name":"Guide to Visualising KPI in Power BI","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png","datePublished":"2024-12-31T05:03:10+00:00","dateModified":"2024-12-31T05:03:11+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/48117213c22e77cd42d9af9b6b4b4056"},"description":"Learn to visualise KPI in Power BI effectively for better decision-making and business performance.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png","width":800,"height":500,"caption":"Guide to Visualising KPIs in Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/visualising-kpis-in-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Power BI","item":"https:\/\/www.pickl.ai\/blog\/category\/power-bi\/"},{"@type":"ListItem","position":3,"name":"A Step-By-Step Guide to Visualising KPIs in Power BI"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/48117213c22e77cd42d9af9b6b4b4056","name":"Smith Alex","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_26_1723028835-96x96.jpg74f69d8707f58519398bb6ba829c2ad9","url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_26_1723028835-96x96.jpg","contentUrl":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_26_1723028835-96x96.jpg","caption":"Smith Alex"},"description":"Smith Alex is a committed data enthusiast and an aspiring leader in the domain of data analytics. With a foundation in engineering and practical experience in the field of data science","url":"https:\/\/www.pickl.ai\/blog\/author\/smithalex\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/12\/image3-3.png","authors":[{"term_id":2216,"user_id":26,"is_guest":0,"slug":"smithalex","display_name":"Smith Alex","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/08\/avatar_user_26_1723028835-96x96.jpg","first_name":"Smith","user_url":"","last_name":"Alex","description":"Smith Alex is a committed data enthusiast and an aspiring leader in the domain of data analytics. With a foundation in engineering and practical experience in the field of data science"},{"term_id":2627,"user_id":34,"is_guest":0,"slug":"hiteshbijja","display_name":"Hitesh bijja","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_34_1722405514-96x96.jpeg","first_name":"Hitesh","user_url":"","last_name":"bijja","description":"Hitesh has graduated from Indian Institute of Technology Varanasi in 2024 and majored in Metallurgical engineering. He also worked as an Analyst at Corizo from 2022 to 2023, which further solidified his passion for this field and provided with valuable hands-on experience. In free time, he enjoys listening to music, playing cricket, and reading books related to business, product development, and mythology."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/18119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=18119"}],"version-history":[{"count":1,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/18119\/revisions"}],"predecessor-version":[{"id":18121,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/18119\/revisions\/18121"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/18120"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=18119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=18119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=18119"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=18119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}