Nova Scotia Powerlifting Provincials 2026

Power BI class preview case study

An independent Power BI class preview translating roster and historical meet data into athlete projections, attempt patterns, and strength profiles.

An independent class-preview dashboard designed to help athletes and coaches understand the competitive field at the 2026 Nova Scotia Powerlifting Provincials.

Project type

Independent analysis

Audience

Athletes and coaches

Tools

Power BI and DAX

Published

Instagram, 2026

A Nova Scotia Powerlifting Provincials Men’s Open 120 kilogram class preview ranking four athletes with experience, recent performance, projected totals, attempt success rates, and strength profiles.

Men’s Open 120 kg class preview. Select the image to open the full-resolution dashboard.

The challenge

Registration lists establish who will compete, but they give athletes and coaches little context about the field. Historical result tables contain that context, although extracting it means searching athlete by athlete and comparing performances across different dates and meets.

I built this class preview to make the comparison immediate. The report needed to identify the likely order of the class while also explaining what sat behind that order: experience, recent performance, rate of progress, attempt reliability, and the balance among squat, bench press, and deadlift.

Data and analytical approach

I combined the Provincials roster with public competition histories and standardized athlete identities, dates, weight classes, attempts, and best lifts. The model retains the detail needed to distinguish successful and missed attempts while supporting an athlete-level summary for the report.

DAX measures identify each lifter’s latest meet, count completed competitions, calculate success rates for all nine attempts, and compare lift composition against class-level patterns. A recent-results window feeds a linear total trend and projected meet total. Ranking measures order athletes within the selected class, while a classification measure translates the lift profile and competitive position into a memorable athlete archetype.

Dashboard decisions

A forecast with context. The projected total is paired with meet history and trend direction so the ranking is understandable instead of appearing as a black-box score.

More than a projected total. Attempt reliability and lift composition reveal how athletes build their totals and where meet-day volatility may appear.

Each athlete occupies one horizontal row, with the reading order moving from identity and experience through historical performance to reliability and strength profile. Repeated positions make the four athletes easy to compare, while the podium-style rank treatment establishes the primary hierarchy. The restrained yellow accent connects the report to the provincial branding without competing with the red, amber, and green attempt-status colours.

The archetype label provides an accessible summary for social media, but it is grounded in the model’s ranking and lift-profile measures. That balance let the report stay analytically credible while remaining engaging for an audience that might not otherwise read a conventional statistical preview.

Outcome

The finished class preview was published on Instagram for athletes and coaches as an independent project. It showcases the full path from cleaning historical competition records and designing reusable DAX measures to building a dense report that remains understandable as a single social-media slide.

View the original Nova Scotia Provincials post on Instagram

Related project: Explore the CANPL Easterns 2026 scouting report.