Powerful Insights carved from Data

We are a team of 2 strong analysts with each having an experience of 8 years in different domains across different industries. We bring an end-to-end package of data manipulation, analysis, and visualization.

Industry :
Sonali Bhat [SB] - FMCG, Pharmaceuticals, Logistics & Transportation, Retail
Dhruv Aggarwal [DA] - Retail consulting and Food tech

Tool expertise :
SB - Data visualization using tools like Tableau, Excel VBA, Power BI
DA - Python, SQL, SAS, Excel

Domain :
SB - Procurement, spend analytics, fleet management, quality management, digital marketing
DA - A/B testing, customer engagement strategies, Churn model, Business intelligence, Campaign analysis, targeted marketing campaigns, customer life cycle and affinity segments, automation

Work Highlights :
SB -
1. Company Profit and Loss report
- Worked with the higher management including the COO to create a complex Tableau dashboard used internally across the organization to track the Profit/Loss at different levels like client, groups, departments, reporting manager, project lead, etc.
- This is directly used as an input for the appraisal process of individuals (managers and above)

2. Support for Pharmaceutical Clients
- Commodity dashboard : Created a tableau dashboard to track the future prices for various commodities
- Engagement Satisfaction Survey : Created a tableau and QlikView dashboard to provide insights on the stakeholder’s engagement and satisfaction with the procurement team
- Fleet Analytics : Facilitated the Fleet management project set-up to track the inventory and their costs

3. Incentive plan
- Strategized and implemented a new incentive plan along with a process of setting monthly targets for the sales reps

4. Up-sell and cross-sell
- Lead a team to develop a fully automated solution in R that was integrated
with its internal customer database (residing on a SQL server) to identify
product up-sell and cross-sell opportunities for a leading US-based logistics and transportation com

Founded: 2012