Cases

RSC Leaderboard

Data Source: Service Titan(CRM)

Analysis Tool: PowerBI, Azure Databricks(SQL)

The client is an HVAC company (one of North America’s largest air conditioning and heating repair brands, with more than 100 service centers in the U.S. and Canada). They wanted to modernize the reporting & analytics landscape & needed a PowerBI dashboard to monitor their Residential Sales Consultant Performance(on various key metrics).

Customer Survey Dashboard

Data Source: Commend(Survey Tracking System)

Analysis Tool: PowerBI

The client is an HVAC company (one of North America’s largest air conditioning and heating repair brands, with more than 100 service centers in the U.S. and Canada). They wanted to modernize the reporting & analytics landscape & needed a PowerBI dashboard to analyze the customer surveys(what are the customers saying about the company/different technicians).

AdventureWorks(Demo Dashboard)

Data Source: folder of raw csv files, which contain information about

transactions, returns, products, customers, and sales territories.

Analysis Tool: PowerBI

AdventureWorks is a global manufacturing company that produces cycling equipment and accessories. The management team needs a way to track KPIs (sales, revenue, profit, returns), compare regional performance, analyze product-level trends, and identify high-value customers.

Maven Roasters Coffee Shop Sales (Demo Dashboard)

Data Source: We are provided with 6months(Jan-June2023) of transactional data for Maven Roasters, a coffee shop chain with three locations in the New York City.

Analysis Tool: Excel

The Goal is to build a dynamic dashboard which can be utilized by the chain owners to identify trends & opportunities for the Business.