PORTFOLIO

PowerBI   |   SQL   |   CaseStudy   |   Excel

PowerBI

Workplace Analytics

Workplace Analytics dashboard provides a quick and easy way to conduct a broad diagnostic on 2 themes:

• company's "Collaboration culture"
• "Employee experience"

The dashboard empowers organizations to enhance work-life balance, streamline meetings, and identify potential burnout risks, fostering a more productive and engaged workforce.

Dashboard

Telco Churn Analysis

The Telco Customer Churn Dashboard is a comprehensive analytical solution that offers a holistic view of customer dynamics.

Actionable insights on churn rates, demographics, contract and service details, and detailed analyses on churn reasons and revenue trends.

Which enables businesses to make informed decisions to mitigate churn and enhance customer satisfaction.

Dashboard

Service Request Management

The Service Request Management Analysis provides a representation of the overall health of the support area.

Key metrics such as year-over-year trends, request status and payments by region.

And also insights on the number of requests, monthly service requests, average daily requests, and a breakdown of completed, pending, and canceled requests.

Dashboard

HR Attiration Dashboard

The HR Attrition Analytics Dashboard offers a comprehensive exploration of workforce metrics.

The project highlights areas for strategic HR interventions, such as optimizing promotion timelines, implementing performance-based layoffs, and addressing job satisfaction concerns to enhance overall workforce management.

Dashboard

Data Job Analysis

The Data Job Analysis project, offers a comprehensive exploration of diverse data job profiles and associated metrics in the job market, empowering users to gain valuable insights into the evolving landscape of data jobs, skills, and company dynamics.

Insights into average years of experience, salaries, and trends for various job positions, types, and skills.

Analyzes company-specific metrics, such as industry-wise job distribution, average years of experience, and requested positions.

Dashboard

---

SQL

E-commerce Store Analysis

E-commerce project aimed to help grow the business and analyze performance along the way worked through powerful analytics deep dives including traffic analysis and optimization, website measure and testing, channel mix, product level performance and user behavior analysis.

Traffic Sources :   Top traffic sources   |   Conversion rates   |   Bid optimizations and Trend Analysis

Website Performances :   Top website pages and entry pages   |   Bounce rates and landing page tests   |   Building conversion funnels and testing conversion paths

Channel Portfolio Management :   Analyzing channel portfolios   |   Comparing channel characteristics   |   Cross-channel bid optimization   |   Analyzing direct, brand-driven traffic

Business Patterns and Seasonality :   Analyzing seasonality   |   Analyzing business patterns

Product Analysis :   Analyzing product sales and product launches   |   Analyzing product-level website pathing   |   Building product-level conversion funnels   |   Cross-sell analysis   |   Analyzing product refund rates

User Analysis :   Analyzing repeat visit and purchase behavior

World's Oldest Businesses

The project delves into the world's oldest businesses and unveils intriguing insights on detailed breakdowns of categories and continents.

Exploration of the longevity and diversity of businesses across the globe, with a focus on industries such as Banking & Finance, Distillers, Vintners, & Breweries, and Aviation & Transport.

Dashboard

---

Excel

Road Accident Analysis

The road accident analysis project meticulously examines road accidents in 2021 and 2022, emphasizing primary KPIs such as total casualties, accident severity distribution, and maximum casualties by vehicle type.

Secondary KPIs include insights into casualties based on vehicle type, monthly trends, road type, road surface conditions, and the correlation between casualties and location/light conditions.

Dashboard

Operation Revenue Dashboard

Dashboard project focused on providing a comprehensive overview of operational and financial aspects, featuring key metrics such as revenue, expenses, sales trends, and operational effectiveness.

Presents insights into revenue and expense variations across regions, year-over-year performance, sales-expense relationships, and departmental operational effectiveness.

Dashboard

Sales Dashboard

The Dashboard offers a dynamic and comprehensive analysis of sales, profitability, units sold, and sales versus margin trends.

Designed to empower data-driven decision-making by providing insights into various aspects of sales performance. Through interactive visualizations, users can track units sold, assess profitability, and analyze trends to optimize overall sales strategies and financial outcomes.

Dashboard

---

CaseStudy

Forage - PwC Switzerland Power BI in Data Analytics Virtual Case Experience

Call Centre Trend Analysis

Aimed to provide the Call Center Manager with a transparent and insightful overview of long-term trends in customer and agent behavior.

Dashboard with key performance indicators (KPIs) and metrics to explore call trends, assess agent performance, and monitor customer satisfaction.

Dashboard

Customer Retention

The Customer Retention Dashboard project at PhoneNow aimed to provide the Customer Retention Manager with comprehensive insights into customer demographics, churn, and retention data.

Key performance indicators (KPIs) and metrics to explore customer profiles, identify at-risk customers, and support strategic decision-making.

Dashboard

Diversity and Inclusion

The Diversity & Inclusion project at the telecom client aimed to address the challenge of slow progress in improving gender balance at the executive management level.

Key performance indicators (KPIs) in hiring, promotion, performance, and turnover

Dashboard