data-science – Incorporating data storytelling into Power BI Core Visuals

January 29, 2025

Dynamic Stacked Bar and Radial Bar Chart Combo

This guide demonstrates how to create an interactive combination of stacked and radial bar charts in Power BI using native visuals. I first developed this visualization as a static design in Excel and PowerPoint for my Onyx Data challenge submission, but later recreated it in Power BI to add dynamic interactivity. Use Cases Combining two…

Power BI

business-intelligenece, data-analysis, data-science, data-visualization, Power BI, radial-bar-chart, stacked-bar-chart
January 5, 2025

Visualizing Variance Alongside Bar Charts

This article demonstrates how to create additional lollipop charts alongside bar charts to visualize year-over-year variance, a technique inspired by Bas Dohmen. Use Case and Limitation Bar charts effectively visualize data for comparisons between distinct categories. This case study uses bar charts to compare sales and profits across sub-categories, supplemented by variance lollipop plots to…

Power BI

bar-chart, business-intelligence, data-analysis, data-analytics, data-science, data-storytelling, data-visualization, lollipop plot, Power BI
January 4, 2025

Alternative Approach to Visualize Surplus and Deficit

This article discusses alternative visualizations of surplus and deficit using clustered column charts, with a focus on the variance between actual and target profit. In a previous post, I explained how to visualize surplus and deficit amounts with stacked column charts. This post explores a different approach using clustered column charts. It compares monthly actual…

Power BI

business-intelligence, column-chart, data-analysis, data-science, data-storytelling, data-visualization, line-chart, Power BI
December 27, 2024

Visualizing Monthly KPIs Using the JFMAMJJASOND Calendar Format

This article guides you through creating visually-appealing monthly metrics reports in Power BI by converting month names to abbreviations for a cleaner look. Foreword Dashboard design requires careful consideration of visual elements. For example, text length can significantly impact the size and layout of visuals, potentially requiring additional space and reducing valuable white space. One…

Power BI

business-intelligence, data-analysis, data-analytics, data-science, data-storytelling, data-visualization, dax, line-chart, Power BI, power-query

Tag: data-science

Dynamic Stacked Bar and Radial Bar Chart Combo

Visualizing Variance Alongside Bar Charts

Alternative Approach to Visualize Surplus and Deficit

Visualizing Monthly KPIs Using the JFMAMJJASOND Calendar Format