Portfolio - Rama Gopala Krishna Masani

PowerBI Project

Business Insights 360

Domain/Function: Finance | Sales | Marketing | Supply Chain | Executive

I created a Power BI dashboard called Business Insights 360 for AtliQ Hardware, a company that sells computer hardware. The dashboard helps them to understand their financial, sales, marketing, supply chain, and executive performance. It also shows them how accurate their predictions are and where

View Project
Engagement

View Project
on GitHUB

This is the finance view, which shows the important details of finance such as revenue, profit, cost, budget, variance, and ROI.

This is the executive view, which shows the key indicators of the company’s performance and how it compares to its competitors.

Project Details

I developed a comprehensive business performance dashboard for AtliQ Hardwares, a leading computer hardware company in India, to drive data-informed decision-making across critical business functions.

Data Integration: Consolidated data from Excel/CSV files and MySQL databases using Power Query and DAX within Power BI.

Data Modeling & Visualization: Designed a scalable data model and created insightful visual reports encompassing Finance, Sales, Marketing, Supply Chain, and Executive metrics.

Interactivity: Enhanced user experience by implementing filters, slicers, drill-down capabilities, and tooltips for intuitive data exploration.

Performance Optimization: Leveraged DAX Studio and best practices to optimize report speed and refresh efficiency.

Business Impact: Empowered AtliQ Hardwares to identify operational strengths and weaknesses, uncover growth opportunities, and support strategic initiatives through a unified, interactive dashboard.

Live Interactive Dashboard

PowerBI Project

AtliQ IQ Insights: Hospitality Analysis

Domain/Function: AtliQ IQ Insights: Hospitality Analysis

Revive Insights 360 for AtliQ Hospitality Analysis: a Power BI project revealing weekly hotel performance metrics, occupancy trends, room distribution, and KPI cards tailored for executive-level decision-makers.

View Project
Engagement

View Project
on GitHUB

Curated for executives, it showcases hotel performance metrics, weekly occupancy trends, room class distribution and realization percentage changes.

Offers weekly hotel performance metrics, correlating guest stays with ratings and showcasing revenue/RevPAR trends across properties.

Project Details

Leveraged Power BI to craft a data-driven tool boosting AtliQ's hospitality game. Revive Insights 360 equips them with:

🔎 Booking Bonanza: Identifies top booking platforms.
🚫 Cancellation Conquering: Reveals cancellation patterns.
🤫 Guest Guru: Discovers guest preferences.

Features include:
📊 Dashboard of Destiny: Key metrics at a glance.
🏨 Hotel Hero Headquarters: Drill down into hotel performance.
🔄 Room Roulette Revolution: Optimize room allocation.

Benefits:
🤓 Smarter Decisions: Data-driven decisions.
💰 Revenue Renaissance: Boost bookings & revenue.
🌟 Guest Satisfaction Soars: Understand guests better.

This project helps AtliQ shine brighter in the hospitality industry!

Live Interactive Dashboard

SQL Project

Instagram Influencer Account Analysis

Domain/Function: Social media analysis

Analyzed Instagram influencer data using SQL to uncover engagement trends, track growth metrics, and evaluate content performance across post types, helping identify effective strategies for improving reach and audience engagement.

View Project
Engagement

View Project
on GitHUB

View Project
on Social media

SQL analysis of highest and lowest impressions by post type. Shows IG Reels perform best, while other formats have lower reach, supported by table and chart visuals.

SQL report showing monthly Instagram performance with total profile visits and new followers. Includes a chart to track growth trends and compare engagement across months.

Project Details

This project focuses on analyzing Instagram activity data of a tech influencer using SQL. The objective was to explore post performance, measure account growth, and identify high-performing content strategies. I analyzed unique post types and their engagement metrics, identified highest and lowest impressions across formats, and tracked profile visits and follower growth month-over-month. I also calculated total reach percentage by post type and categorized posts with monthly distribution. Additionally, I created a stored procedure to compute weekly total shares. Key insights revealed that Reels generated the highest impressions (339.7K), while Carousels had the lowest (3,264). May recorded the highest profile visits, whereas February showed the lowest follower growth. This project demonstrates strong SQL skills in data analysis, aggregation, and business insight generation.

Project video

Excel Project

Sales and Finance Analytics

Domain/Function: Sales and Finance Analytics

AtliQ Sales and Finance Analytics Reports showcases my exploration into customer and market performance, financial health, and strategic decision-making. Leveraged ETL methodologies, Power Query, Power Pivot, and DAX to craft impactful reports.

View Project
Engagement

View Project
on GitHUB

The report discovers key insights and growth trends. A comprehensive analysis of various customers shaping the success of business.

This report uncovers key insights shaping our global business journey.

Project Details

Project Details

Sales Report Insights:

Analyzed customer sales figures and year-over-year growth in the Customer Performance Report.

Compared market performance against sales targets in the Market Performance and Sales Targets Comparison.

Finance Report Insights:

Evaluated financial performance over different time frames in Profit & Loss reports by fiscal year and month.

Provided market-wise benchmarking insights in Profit & Loss reports by markets.

Technical Skills Gained:

Applied ETL methodology for efficient data processing.

Created date tables and derived fiscal months and quarters using Power Query.

Built data model relationships and integrated supplementary data with Power Pivot.

Soft Skills Gained:

Developed user-centric, accessible reports.

Optimized report generation processes for efficiency.

Planned and executed systematic report-building strategies.

PowerBI Project

Zomato Business Intelligence Dashboard

Domain/Function: Business Intelligence / Data Analysis

Designed an interactive Business Intelligence dashboard for Zomato to analyze sales, ratings, order volume, and city-wise performance. Provided clear insights into food category trends and yearly growth using visual storytelling techniques.

View Project
Engagement

View Project
on GitHUB

Zomato overview shows ₹987M sales, 2M items, 150K orders; Tirupati leads in sales, 2018 had peak yearly revenue at ₹0.41B.

City-wise Zomato stats with ₹987M sales, 2M quantity, 150K orders; top cities include Tirupati, Bikaner, and Noida-1.

Project Details

Built a Business Intelligence dashboard for Zomato to visualize key performance metrics.
Tracked sales, order quantities, ratings, and performance across 150 K+ locations and 100K restaurants.
Analyzed yearly sales trends from 2017 to 2020, highlighting peaks and drops.
Showcased top-performing cities like Tirupati, Electronic City, and Baner (Pune).
Provided a category-wise sales breakdown: Veg, Non-Veg, and Others.
Displayed key KPIs: Revenue (987M), Orders (150K), Quantity (2M), and Ratings (148K).
Used charts and graphs for better decision-making and storytelling.
Helped identify customer preferences and business growth patterns through data.

Hello, I am

Rama Gopala Krishna Masani

1

3

1

About

Key

My

Business Insights 360

AtliQ IQ Insights: Hospitality Analysis

Instagram Influencer Account Analysis

Sales and Finance Analytics

Zomato Business Intelligence Dashboard

My

Awards

Contact Me

Email

Github

Linkedin

Call

Rama Gopala Krishna Masani

Download Resume