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.