The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Built a forecasting model to predict the number of insurance claims
expected over the next 6 months, broken down by business-relevant
categories, for a large-scale insurance claims dataset.
The project followed a full 5-stage process: business & data
understanding, data assessment & cleaning, data preparation, model
development/evaluation/deployment, and implementation & knowledge
transfer.
We tested and compared multiple forecasting approaches — Auto ARIMA,
Auto ETS, Auto Theta, Prophet, LightGBM, and XGBoost — to select the
best-performing model for each claim category.
Results:
Improved MAPE by 47%, from a 6.42% baseline to 3.43% in production
The production model outperformed the baseline on 96% of claim types
Identified and corrected 19+ data quality issues during the cleaning phase
Delivered 48 visualizations giving the client deeper insight into their own claims data
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
E-Commerce Intelligence & Predictive Analytics Platform
HR Analytics Dashboard | Power BI
Project Overview
I built an interactive HR Analytics Dashboard in Power BI to transform employee data into meaningful workforce insights and support HR-focused decision-making.
The project covered the complete dashboard development process — from understanding and preparing the dataset to creating KPIs, developing interactive visuals, designing a custom wireframe, and building the final dashboard.
Rather than directly copying the layout from the learning tutorial I followed, I first created my own wireframe and used it as the blueprint for the final dashboard.
Tools & Skills Used
Tools:
Power BI | Power Query | DAX | Excel/CSV
Skills:
Data Cleaning | Data Transformation | Data Analysis | Data Visualization | KPI Development | Dashboard Design | DAX Measures | Data Storytelling | Business Intelligence
What I Built
The dashboard provides an overview of employee demographics, workforce composition, employee attrition, salary levels, job roles, experience, and job satisfaction.
Key KPIs include:
Total Employees
Active Employees
Attrition Count
Attrition Rate
Average Age
Average Experience
The dashboard also analyzes:
Attrition by Department
Attrition by Gender
Attrition by Age Group
Attrition by Salary Slab
Attrition by Years of Experience
Job Role and Job Satisfaction
Employee distribution across departments
The final dashboard contains 1.42K employees, 1.19K active employees, 231 attritions, and a 16.3% attrition rate based on the cleaned dataset used for the project.
Data Preparation & Power Query
One of the first things I learned from this project was that importing a dataset into Power BI does not mean the data is automatically ready for analysis.
I used Power Query to inspect and prepare the dataset before building the dashboard.
I checked the data for empty values and removed unnecessary rows. I also used Group By and Count Rows on Employee ID to investigate whether employee records appeared more than once.
This was particularly useful because I initially did not understand why the tutorial was grouping Employee IDs.
I learned that grouping an ID and counting rows can be used as a duplicate-checking technique. Filtering the count so that it does not equal 1 helps identify IDs that appear more than once and therefore require further investigation.
This helped me understand the difference between simply following a Power Query step and understanding why that step is being performed.
DAX & KPI Development
I created measures to calculate the key HR metrics used throughout the dashboard.
One of the concepts that stood out to me was Active Employees.
The dataset contains an Attrition field indicating whether an employee left the organization.
Therefore:
Attrition = Yes → employee has left
Attrition = No → employee is considered active
To calculate Active Employees, I used the employee count together with an Attrition = No filter.
This helped me understand how a column that does not directly contain the metric I need can still be used to create a meaningful KPI.
I also worked with measures for Attrition Count, Attrition Rate, Average Age, and Average Experience.
Dashboard Design
Before developing the visuals, I created a custom wireframe in my preferred design tool.
I wanted the final dashboard to have its own visual identity rather than replicate the layout of the tutorial.
I chose a purple, white, and ash/gray color palette and structured the dashboard around six KPI cards followed by analytical sections for departments, attrition, salary, age, experience, and job satisfaction.
The wireframe helped me plan the visual hierarchy, spacing, and placement of each component before recreating the design in Power BI.
This was an important part of the project because it reinforced the value of planning the user experience before building the actual dashboard.
Challenges & What I Learned
One of the biggest learning moments was understanding Attrition and how it can be used to derive other HR metrics.
Initially, I questioned why the Employee Count needed to be filtered using the Attrition column when creating the Active Employee KPI.
Understanding that Attrition = No represents employees who have not left the organization made the calculation much clearer.
I also learned more about Power BI's sorting behavior.
For example, the salary slab visual was sorted by Attrition Count in descending order, rather than by the salary categories themselves. This meant the salary slab with the highest attrition appeared first.
Understanding this helped me realize that sorting is not simply a formatting decision — it can change what information a chart emphasizes.
Another important lesson was understanding the difference between data cleaning and data validation. Finding duplicate or empty records does not automatically mean they should be deleted. The analyst needs to understand why the records exist and whether removing them is appropriate.
Outcome
This project strengthened my practical skills in:
Power BI | Power Query | DAX | Data Cleaning | Data Analysis | Data Visualization | Dashboard Design | Business Intelligence
More importantly, it helped me move beyond simply building charts and start thinking about the reason behind each transformation, calculation, and visualization.
The project reinforced my approach of:
Understand → Clean → Validate → Analyze → Visualize → Communicate
I’m continuing to build projects that demonstrate not only my technical skills, but also my ability to turn raw data into clear and useful business insights.
Learning Credit
This project was inspired by a Power BI HR Analytics tutorial that I followed as a hands-on learning exercise, while designing my own wireframe and dashboard layout.
🍥 What if Naruto’s Rasengan could actually be controlled with your hands?
As a kid, it was just something I saw in anime.
This time, I decided to see if I could bring that idea to life with Python.
So I built Naruto Hand VFX Studio — a real-time computer vision project where hand gestures control:
🔵 Rasengan
⚡ Chidori
🔥 Fireball
💥 Energy Beam
And the interesting part?
These aren’t pre-recorded effects.
Using Python, OpenCV, MediaPipe, and NumPy, the system tracks my hand movements and generates the VFX in real time.
What started as a fun Naruto idea turned into a project where I got to combine computer vision, hand tracking, gesture recognition, animation logic, and procedural VFX in one application.
My setup isn’t a professional studio.
But this project reminded me that you don’t always need a perfect setup to build something interesting.
Sometimes, you just need an idea — and the willingness to build it.
#Python #ComputerVision #OpenCV #MediaPipe #NumPy #VFX #PythonProjects #MachineLearning #Programming #Naruto #BuildInPublic
