๊ณ ์ ๋ ํธ์
Faith๐ธ๐ธ
2.7K posts

Faith๐ธ๐ธ
@feith_i
AltSchool Africa | Data Analyst | Building in public with Power Bi & Excel | #LearnWithMe.
Lagos, Nigeria ๊ฐ์
์ผ Haziran 2025
749 ํ๋ก์445 ํ๋ก์
Faith๐ธ๐ธ ๋ฆฌํธ์ํจ

๐๐ถ๐๐ซ ๐๐ฎ๐ฟ๐ฒ ๐ท๐๐๐ ๐ฝ๐๐ ๐ถ๐ป ๐ฎ ๐ฏ๐ถ๐ฑ ๐๐ผ ๐บ๐ฎ๐ป๐ฎ๐ด๐ฒ ๐ฎ๐๐ต๐น๐ฒ๐๐ฒ ๐บ๐ฒ๐ฑ๐ถ๐ฐ๐ฎ๐น ๐ผ๐ฝ๐ฒ๐ฟ๐ฎ๐๐ถ๐ผ๐ป๐ ๐ฎ๐ ๐๐ต๐ฒ ๐ฎ๐ฌ๐ฎ๐ด ๐ข๐น๐๐บ๐ฝ๐ถ๐ฐ๐.
As the major health provider for a prominent sports league, the executive team needs to audit 4 years of injury data โ 60+ clubs, 800 athletes, 5 sports โ before they pitch.
Three individuals are leading this pitch, starting with the Chief Medical Officer.
Dr. Claire needs to walk into that pitch room knowing what FitX Care has handled, what worked, and where the gaps are. Her questions are the same ones the Olympic committee will ask:
๐ค๐ญ: What's the scale of what we've managed?
โ 16,800+ injuries across 2022โ2025. All 800 athletes affected. Ligament Sprain dominates every year, Ankle the most impacted body part.
๐๐ฉ๐ฆ ๐ค๐ฐ๐ฏ๐ด๐ช๐ด๐ต๐ฆ๐ฏ๐ค๐บ ๐ช๐ด ๐ข ๐ด๐ต๐ณ๐ฆ๐ฏ๐จ๐ต๐ฉ โ ๐ช๐ต ๐ฎ๐ฆ๐ข๐ฏ๐ด ๐ต๐ฉ๐ฆ ๐ต๐ฆ๐ข๐ฎ ๐ฉ๐ข๐ด ๐ฅ๐ฆ๐ฆ๐ฑ ๐ฑ๐ข๐ต๐ต๐ฆ๐ณ๐ฏ ๐ณ๐ฆ๐ค๐ฐ๐จ๐ฏ๐ช๐ต๐ช๐ฐ๐ฏ. ๐๐ฆ๐ข๐ฅ ๐ต๐ฉ๐ฆ ๐ฑ๐ช๐ต๐ค๐ฉ ๐ธ๐ช๐ต๐ฉ ๐ต๐ฉ๐ช๐ด.
๐ค๐ฎ: Are things getting better or worse?
โ Injuries rose from 4,266 (2022) to 4,410 (2024), then dropped to 3,765 in 2025. Average recovery fell from 44.7 to 35.6 days โ a 20% improvement. AugustโSeptember spikes repeat every year.
๐๐ฉ๐ฆ ๐ณ๐ฆ๐ค๐ฐ๐ท๐ฆ๐ณ๐บ ๐ช๐ฎ๐ฑ๐ณ๐ฐ๐ท๐ฆ๐ฎ๐ฆ๐ฏ๐ต ๐ช๐ด ๐ต๐ฉ๐ฆ ๐ฉ๐ฆ๐ข๐ฅ๐ญ๐ช๐ฏ๐ฆ. ๐๐ถ๐ช๐ญ๐ฅ ๐ต๐ฉ๐ฆ ๐๐ญ๐บ๐ฎ๐ฑ๐ช๐ค ๐ด๐ต๐ข๐ง๐ง๐ช๐ฏ๐จ ๐ฎ๐ฐ๐ฅ๐ฆ๐ญ ๐ข๐ณ๐ฐ๐ถ๐ฏ๐ฅ ๐ต๐ฉ๐ฆ ๐ด๐ฆ๐ข๐ด๐ฐ๐ฏ๐ข๐ญ ๐ด๐ฑ๐ช๐ฌ๐ฆ ๐ฑ๐ข๐ต๐ต๐ฆ๐ณ๐ฏ.
๐ค๐ฏ: What has treatment cost us?
โ โฌ12.9M over 4 years, rising from โฌ3.07M to โฌ3.45M annually. Ligament Sprains and Fractures consistently dominate the spend.
๐๐ฐ๐ด๐ต๐ด ๐ข๐ณ๐ฆ ๐ณ๐ช๐ด๐ช๐ฏ๐จ ๐ง๐ข๐ด๐ต๐ฆ๐ณ ๐ต๐ฉ๐ข๐ฏ ๐ช๐ฏ๐ซ๐ถ๐ณ๐บ ๐ท๐ฐ๐ญ๐ถ๐ฎ๐ฆ โ ๐ช๐ฏ๐ท๐ฆ๐ด๐ต๐ช๐จ๐ข๐ต๐ฆ ๐ธ๐ฉ๐ฆ๐ต๐ฉ๐ฆ๐ณ ๐ต๐ณ๐ฆ๐ข๐ต๐ฎ๐ฆ๐ฏ๐ต ๐ฎ๐ช๐น ๐ฉ๐ข๐ด ๐ด๐ฉ๐ช๐ง๐ต๐ฆ๐ฅ ๐ต๐ฐ๐ธ๐ข๐ณ๐ฅ ๐ฎ๐ฐ๐ณ๐ฆ ๐ฆ๐น๐ฑ๐ฆ๐ฏ๐ด๐ช๐ท๐ฆ ๐ช๐ฏ๐ต๐ฆ๐ณ๐ท๐ฆ๐ฏ๐ต๐ช๐ฐ๐ฏ๐ด.
๐ค๐ฐ: How effective are our outcomes?
โ 43.7% recovery rate overall. 48.5% reinjury rate. The Injury Log exposes every case with progress bars, treatment method, and color-coded outcomes โ chronic cases flagged red.
๐๐ฉ๐ฆ ๐ณ๐ฆ๐ช๐ฏ๐ซ๐ถ๐ณ๐บ ๐ณ๐ข๐ต๐ฆ ๐ช๐ด ๐ต๐ฉ๐ฆ ๐ฃ๐ช๐จ๐จ๐ฆ๐ด๐ต ๐ณ๐ฆ๐ฅ ๐ง๐ญ๐ข๐จ. ๐๐ต๐ณ๐ฆ๐ฏ๐จ๐ต๐ฉ๐ฆ๐ฏ๐ช๐ฏ๐จ ๐ณ๐ฆ๐ต๐ถ๐ณ๐ฏ-๐ต๐ฐ-๐ฑ๐ญ๐ข๐บ ๐ฑ๐ณ๐ฐ๐ต๐ฐ๐ค๐ฐ๐ญ๐ด ๐ฃ๐ฆ๐ง๐ฐ๐ณ๐ฆ ๐ต๐ฉ๐ฆ ๐ฃ๐ช๐ฅ ๐ช๐ด ๐ฏ๐ฐ๐ฏ-๐ฏ๐ฆ๐จ๐ฐ๐ต๐ช๐ข๐ฃ๐ญ๐ฆ.
๐ค๐ฑ: Where is risk concentrated?
โ Severe injuries held at ~17% for three years, then spiked to 23.9% in 2025. Regional League carries the highest severity at 27.5%.
๐๐ฉ๐ฆ 2025 ๐ด๐ฆ๐ท๐ฆ๐ณ๐ช๐ต๐บ ๐ด๐ฑ๐ช๐ฌ๐ฆ ๐ฏ๐ฆ๐ฆ๐ฅ๐ด ๐ข ๐ณ๐ฐ๐ฐ๐ต ๐ค๐ข๐ถ๐ด๐ฆ ๐ข๐ฏ๐ข๐ญ๐บ๐ด๐ช๐ด โ ๐ธ๐ข๐ด ๐ช๐ต ๐ธ๐ฐ๐ณ๐ฌ๐ญ๐ฐ๐ข๐ฅ, ๐ด๐ค๐ฉ๐ฆ๐ฅ๐ถ๐ญ๐ช๐ฏ๐จ, ๐ฐ๐ณ ๐ด๐ฐ๐ฎ๐ฆ๐ต๐ฉ๐ช๐ฏ๐จ ๐ด๐บ๐ด๐ต๐ฆ๐ฎ๐ช๐ค?
โ
Next: the Performance Director (availability, training load, return-to-play)
โ
Based on these numbers โ a 20% recovery improvement but a 48.5% reinjury rate and a rising severity trend โ would you recommend FitX Care send the bid? What would you fix first? Let me know in the comments๐
@iam_daniiell
#DataAnalytics #PowerBI #HealthcareAnalytics #DataVisualization #DAX #SportsAnalytics


English

Before you clean messy data in python, you need to explore it fast.
Pandas has a great way on exploring the dataset ๐
.head() / .tail() โ peek
.info() โ structure + missing
.describe() โ stats
.value_counts() โ categories
.isnull().sum() โ missing values
#Pandas #DataCleaning

English
Faith๐ธ๐ธ ๋ฆฌํธ์ํจ

For the @ZoomCharts #4Ureport Challenge, I designed an Executive KPI report around four core principles: Unique, User-friendly, Uncovering, and Understandable.
The goal was to create an executive-ready experience that not only presents data clearly, but also helps decision-makers quickly see insights, explore performance, and act with confidence.
The home page of this report is the anchor, it presents a snap shot of all the KPIs and its progress against the business target.
Report Link: shorturl.at/k4FMu
#Datavisualization #builtwithzoomcharts #datafam #dataanalysis #ExecutiveKPI




English

Under 7.1K followers?
Support Small Account ๐ค๐ค
Type = hi ๐
Lets connect and grow โ

JACK@Nybuzi
Under 8000 followers๐ Just Type Done ๐ and Repost ๐ We will add you with Active connections๐
English

Email churn analysis complete โ 5.1% overall unsubscribe rate.
Promotions (5.4%).
Top reasons: โNot relevantโ (promos) & โPrivacy concernsโ (newsletters).
๐ Best send hour: 7 AM.
3 fixes: improve promo relevance, optimize for mobile, address privacy fears.
#EmailMarketing




English

Happy new week, data friends! Your nulls be few and your insights be game-changing.
Donโt fear the p-value. Trust the data but question the source. Letโs make this week a clean, queried, visualized win. ๐ก
#HappyNewWeek #DataAnalytics #SQL #DataStudent
English





















