workout wednesday
366 TopicsFantasy Premiere League Analytics Hub v3
Multi Seasonal Report to help Fantasy managers track player performance discover hidden gems and undervalued assets Main changes from previous version: Changed the pipeline from just python > powerbi to python >sql databae > powerbi' This was done to handle multi season analysi as the previous pipeline wasnt fit to do so Utilised bronze silver gold staging in sql More contextualised kpis Customiseable charts (parameters) Utilised HTML visuals for KPIs, Visuals (player explorrer page) and tooltips Star Schema Data Model eyJrIjoiMTVjMTdkMWEtZTQwOS00NDM0LTkxYTEtMjJmODY2ZDhmMTY0IiwidCI6ImQxMjA2OTQzLWJmY2MtNGM3NC04MmQ0LTA1ZTYzYTQzMzViZiJ91.7KViews3likes2CommentsWorkout Wednesday 2026 Week 42 | Power BI: Overlay Information With Bookmarks
Hi everyone, this is my submission for this week's Workout Wednesday! Bookmarks can be a little bit tricky sometimes especially when there's lots of elements to show and hide. This Workout Wednesday uses 4 bookmarks (and even more for the bonus challenge) but it's so satisfying when it comes together. This is especially useful if there's parts of your dashboard that you'd like to explain to the user and you don't feel like a tooltip is enough.441Views1like0CommentsWorkout Wednesday 2026 Week 41: Stripe Chart Using Native Column Chart
This week's challenge is from Santhana Lakshmi Ponnurasan. What if a column chart could tell a story through color? A stripe chart uses colored stripes to reveal patterns and changes in data at a glance. In this exercise, we’ll transform Power BI’s native column chart into a stripe chart where each stripe represents a data point, and its color helps us spot patterns, changes, and unusual values. Same visual, a different way to see the data. Ready to give your column chart a makeover? For more info, see: https://www.workout-wednesday.com/pbi-2026-w41/174Views1like0Comments2026 Workout Wednesday Week 39 | Power BI: A histogram with adjustable bin width
Two sites of the same walk-in clinic report the same average wait. 14.8 minutes at Site A, 14.8 minutes at Site B. On a KPI card they are twins, and there is nothing to discuss. Then you look at the 2400 individual waits. Site A runs mostly quick, with a tail that drags out to 42 minutes. Site B never exceeds 22 minutes, but its waits pile up around 12 and 17 minutes, with a dip in between. Two different processes wearing the same number. A histogram would have shown that in one glance. Power BI has no histogram among its core visuals, and the column chart looks like a bar chart out of the box: a gap between every bar and a strip of air at both ends of the plot area. Both are settings. Under Columns > Layout, set space between categories and outer padding to 0% and the bars close up into a histogram. The harder part is the bins. How wide they are is a choice you make, and it changes the picture. At 1 minute per bin, Site B clearly has two humps. At 5 minutes per bin, they merge into one broad block and the story is gone. This week you build the bins in DAX and hand the bin width to the reader with a slicer. Then click through the widths and see what a single fixed choice would have hidden. Find the whole challenge: WOW homepage139Views0likes0Comments- 73Views1like0Comments
Bump Chart: Workout Wednesday_33
I created a bump chart using native line chart in Power BI and RANKX measure. The chart comes in two versions, one according to WW_33 requirements and second one with series labels on the right side (my preference, I believe it improves readability). Thank you for organizing Workout Wednesdays! 🙂63Views0likes0CommentsEcommerce Conversion Dashboard
This dashboard analyzes the ecommerce conversion funnel from Page Views to Adds to Cart to Purchases. It highlights conversion rates, period-over-period deltas, and performance breakdowns by department and product. eyJrIjoiOGVkNTI1MjctOTMyYi00NGQ2LWFmOWUtZTJmYzdiZDA2OWFiIiwidCI6ImE2MWFhYzQ5LWQxNTctNGU2ZS1iMzU3LTA4YmU5MmY4NDA5YiIsImMiOjEwfQ%3D%3D2.2KViews0likes2CommentsThe Finance Dashboard
The Finance Dashboard | Power BI Project 📊 Excited to share my latest Finance Dashboard built using Microsoft Power BI! This project focuses on Financial Data Analytics, Business Intelligence, and Interactive Data Visualization. Key Features: - Total Amount, Tax, Fees & Final Amount KPIs - Country-wise Financial Analysis - Company-wise Amount Analysis - Transaction Status Monitoring - Tax Analysis by Country & Company - Year & Account Type Filters - Interactive Dashboard Design This dashboard helps transform raw financial data into meaningful insights for better business reporting and data-driven decision-making. Tools: Microsoft Power BI | Data Analytics | Business Intelligence | Financial Reporting I am passionate about Data Analytics, Power BI, and turning data into actionable business insights. Your feedback is welcome! #PowerBI #PowerBIDashboard #DataAnalytics #BusinessIntelligence #FinancialAnalytics #DataVisualization #FinanceDashboard #PowerBIDeveloper #DataAnalyst #MicrosoftPowerBI887Views0likes0CommentsWorkout Wednesday 2026 Week 38 | Power BI: SVG Donuts
Hey everyone, welcome to this week's Workout Wednesday!😊 We've all been there: a stakeholder asks for a super slick, polished design, but then drops the catch - no custom visuals allowed due to security rules. In this challenge, we're getting around that limitation by using inline SVG code inside dynamic DAX measures. You'll build color-shifting progress rings that update on the fly right inside a standard Power BI Table visual. No external downloads, no compliance headaches - just a clever way to stretch native features further. Dive in and give it a shot!244Views0likes0Comments