𝗨𝘀𝗲𝗿 𝗕𝗲𝗵𝗮𝘃𝗶𝗼𝗿 𝗮𝗻𝗱 𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗗𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 - 𝗚𝗮𝗺𝗶𝗻𝗴 𝗣𝗹𝗮𝘁𝗳𝗼𝗿𝗺 (𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗣𝗿𝗼𝗷𝗲𝗰𝘁)

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄

This dashboard project focuses on analyzing user-level behavioral and revenue data from a simulated gaming platform. The goal was to uncover actionable insights related to user engagement, churn risk, monetization patterns, and retention strategies using Power BI.

The dataset includes details such as play sessions, in-game purchases, device type, game preferences, and login activity for 10,000 users.

𝗧𝗼𝗼𝗹𝘀 & 𝗦𝗸𝗶𝗹𝗹𝘀 𝗔𝗽𝗽𝗹𝗶𝗲𝗱

1.𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 - Dashboard creation and data modeling

2.𝗗𝗔𝗫 - Creating measures and segmentation logic

3. 𝗘𝘅𝗰𝗲𝗹 - Data cleaning and exploration

4.𝗗𝗮𝘁𝗮 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴 - With clean visuals and actionable summaries

𝗞𝗲𝘆 𝗩𝗶𝘀𝘂𝗮𝗹𝘀 & 𝗙𝗲𝗮𝘁𝘂𝗿𝗲𝘀

𝗔𝗰𝘁𝗶𝘃𝗲 𝗨𝘀𝗲𝗿 𝗧𝗿𝗲𝗻𝗱𝘀: Daily, Weekly, and Monthly Active Users (DAU, WAU, MAU)

𝗥𝗲𝘃𝗲𝗻𝘂𝗲 𝗕𝗿𝗲𝗮𝗸𝗱𝗼𝘄𝗻: Time-based trends, device type, user segment, and game title

𝗨𝘀𝗲𝗿 𝗦𝗲𝗴𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻: Light, Moderate, and Highly Engaged users by session count

𝗖𝗵𝘂𝗿𝗻 𝗥𝗶𝘀𝗸 𝗗𝗲𝘁𝗲𝗰𝘁𝗶𝗼𝗻: Inactivity analysis based on last login

𝗖𝗼𝗵𝗼𝗿𝘁 & 𝗙𝘂𝗻𝗻𝗲𝗹 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀: Tracking user journey from signup to repeat engagement

𝗖𝗹𝘂𝘀𝘁𝗲𝗿𝗶𝗻𝗴: Scatter chart showing relationship between session frequency and revenue

𝗞𝗲𝘆 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀

𝗠𝗼𝗱𝗲𝗿𝗮𝘁𝗲 𝗨𝘀𝗲𝗿𝘀 𝗗𝗿𝗶𝘃𝗲 𝗥𝗲𝘃𝗲𝗻𝘂𝗲: Users with 10–30 sessions made up the largest group and generated the most revenue

𝗣𝗲𝗮𝗸 𝗨𝘀𝗮𝗴𝗲 𝗠𝗶𝗱-𝗪𝗲𝗲𝗸: Tuesday and Wednesday had the highest user activity, suggesting ideal days for campaigns or updates.

𝗖𝗵𝘂𝗿𝗻 𝗥𝗶𝘀𝗸 𝗶𝘀 𝗛𝗶𝗴𝗵: Over 8,300 users hadn't logged in for 14+ days - a clear churn risk segment.

𝗘𝗮𝗿𝗹𝘆 𝗗𝗿𝗼𝗽-𝗼𝗳𝗳 𝗪𝗮𝗿𝗻𝗶𝗻𝗴: Users with less than 5 sessions and short play durations were most likely to churn early.

 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗥𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀

Target moderate users with loyalty rewards or personalized offers to increase retention and lifetime value.

Schedule feature drops or promotions mid-week to align with user activity spikes.

Launch re-engagement campaigns for users inactive over 14 days.

Improve early onboarding with guided walkthroughs or early incentives for new users.


Live Dashboard

Linkedin Post

--- For more, check out my portfolio:

𝗵𝘁𝘁𝗽𝘀://𝗹𝗶𝗻𝗸𝘁𝗿.𝗲𝗲/𝗞𝗶𝗿𝗮𝗻_𝗦𝗼𝗱𝗵𝗲𝗷𝗮










Comments

Post a Comment

Popular posts from this blog

Ad-hoc Insights (Consumer Goods Domain)

Projects Details   AtliQ Hardware is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they did not get enough insights to make quick and smart data-informed decisions. Hence, the company decided to conduct an SQL challenge. As part of the SQL Project Challenge, I successfully completed a project with the following key highlights: 1.SQL: Utilized advanced SQL concepts such as Subqueries, Multiple Joins, Common Table Expressions (CTE), and Window Functions to query the database effectively. 2. Power BI: Employed Power BI to visualize the extracted data, creating visuals like Bar Charts, Line Charts, and Donut Charts. These visuals were instrumental in clearly communicating insights derived from the data. Using my skills, I efficiently handled and analyzed database information. Applying these concepts, I turned raw data into useful insights, playing a key role in shaping the company's strategic de...
Read more

Generate Insights to Solve a Supply Chain Issue in the FMCG Domain

Project Details Tools Used: Data Visualization: Power BI Database: MS Excel Problem Statement: AtliQ Mart, a growing FMCG manufacturer in Gujarat, India, faces challenges in retaining key customers and aims to expand to other cities in the next two years. The company has identified service issues, leading to non-renewal of contracts by some key customers. To address this, the supply chain analytics team is tasked with tracking the 'On Time' and 'In Full' delivery service levels for all customers daily. The goal is to swiftly respond to issues and ensure customer satisfaction. Task: As the data analyst in the supply chain team, I was tasked to build a dashboard that measures 'On-Time Delivery (OT) %,' 'In-Full Delivery (IF) %,' and 'On-Time In Full (OTIF) %' against the target service levels for each customer. The objective is to provide insights and solutions to improve customer service. I have created relevant metrics, and a dashboard, and un...
Read more
Image
I am excited to share that I have successfully completed all three levels of SQL certification on HackerRank - Basic, Intermediate, and Advanced. Throughout this journey, I strengthened my understanding of: Basic SQL: SELECT statements, filtering, sorting, and aggregations Intermediate SQL: JOINs, subqueries, grouping, Advanced SQL: Window functions and complex query optimization These skills have helped me improve the way I analyze data, build logic, and solve real-world business problems. Looking forward to applying this knowledge in future data projects! hashtag # SQL hashtag # HackerRank hashtag # DataAnalyst Linkedin Post
Read more