Case Studies



Sales & Finance Analytics for a large Aviation Company



Develop, auotomate and maintain management reports to provide consumable insights for timely decision making

Engagement Type: Managed Services. Hybrid team working from Client Onsite and offsite locations

  • Automated and standardized the reporting process to improve productivity and reduce manual error
  • Developed SQL and Python based process for maintenance of data in readily consumable format
  • Conceptualized and developed multiple executive dashboards for CXO consumption
  • Ank value add other than automation: Introduced easy to consume Insight Dashboards for Management use

Technology used: Python, SQL and Excel, PowerBI

Engagement Duration: 18+ months (Ongoing)




Optimize procurement by monitoring Buying Efficiency

at different level for a large FMCG Company



Objective: Analyze raw material buying pattern and compare Purchase Rate with Market Price to estimate buying Efficiency

Solution: Developed automated Buying Efficiency dashboards to monitor material wise purchase quantity, Purchase price and market price by regions. Developed algorithms to calculate buying efficiency (as a % of market rate and overall buying efficiency amount) dynamically

Engagement Type: Engaged as MIS development and automation partner. Developed and maintaining 100+ tableau-based dashboards/reports. Team working remotely under the guidance of Ank SMEs

Value Delivered: Automated and streamlined data extraction and data preparation process for reports. Developed interactive insightful reports/dashboards for easy consumption by the business

Technology Used: SAP, R-Studio, SQL Server and Tableau






Improve campaign revenue by effective customer targeting

for a large global Fashion Retailer



Objective: Define analytics driven customer value management process and optimize customer targeting to improve campaign driven revenue

Solution: Implemented ML based algorithms, K-means clustering to define customer segments, Segment specific Market Basket Analysis to identify associated products and Classification model to identify target group of customers for better targeting

Engagement Type: Project based engagement for 12 months. Team working remotely under the guidance of Ank SMEs

Value Delivered: Delivered significant increase in campaign driven revenue. Achieved full year target in two quarters

Technology Used: SQL Server, R-Studio and Excel based what-if simulator




PowerBI based Financial Reporting for a US based

large multi-state Healthcare Organization



Objective: Assess existing excel based reports, develop an interactive financial reporting platform using PowerBI & SQL Server as backend data source.

Solution: Defined and implemented efficient data model to optimize report performance using large amount of data

Implemented Tabular module to make data available to the analysts for further analysis

Engagement Type: Engaged as MIS development and automation partner. Project based engagement for 12 months. Team working remotely under the guidance of Ank SMEs

Value Delivered: Migrated multiple excel based reports to PowerBI reports to deliver efficient error free management reports

Technology Used: SQL Server and PowerBI