Data & Business Analytics

Engineering Data for Strategic Visibility.

I manage and streamline complete data ecosystems. From extracting raw API data to building automated ETL pipelines and deploying interactive Power BI dashboards, I transition organizations from manual reporting to real-time analytics.

Ashok Singh

System Architecture & Intelligence

Bridging the gap between raw, fragmented data and executive decision-making.

As a Business Analyst, I am responsible for managing the complete data lifecycle across multiple operational verticals—from Admissions and Marketing to Finance and Campus Operations. My core expertise lies in data collection, cleaning, and transformation to support strategic decision-making.

I architect automated data pipelines that extract and consolidate information from ERP systems, APIs, and disparate spreadsheets into centralized reporting databases. By identifying inefficiencies in manual workflows, I deploy Google Apps Script solutions that reduce reporting effort by up to 60%.

Beyond data wrangling, I design and maintain comprehensive Power BI dashboards. By defining strict KPIs and aligning metrics with business requirements, I ensure leadership teams have real-time visibility into their performance, preparing the ground for advanced predictive modeling.

Technical Expertise

Core competencies in analytics, machine learning, and process automation.

Analytics & BI Tools

  • Power BI Dashboard Design
  • SQL Database Querying
  • Advanced Microsoft Excel
  • Google Sheets Query & Logic
  • KPI Design & Tracking

Data Science & ML

  • Python (Pandas, NumPy)
  • Machine Learning Algorithms
  • Natural Language Processing (NLP)
  • Exploratory Data Analysis (EDA)
  • Jupyter Notebooks

Engineering & Cloud

  • AWS & Cloud Computing
  • Big Data Analytics (Spark)
  • ETL Pipeline Construction
  • API Data Integration
  • Git & Version Control

Process Automation

  • Google Apps Script (GAS)
  • Automated Email Reporting
  • Trigger-based Workflows
  • Scripted Data Pipelines
  • Manual Process Optimization

Analytics & Development Portfolio

A selection of BI dashboards, web portals, and multi-domain operational reporting systems.

Note on Data Privacy: All dashboards, KPIs, and reports linked below utilize anonymized, sample datasets to protect proprietary company information and maintain absolute confidentiality.
Marketing Dashboard

Marketing & Conversion Analytics

Domain: Sales & Marketing
Problem: Fragmented tracking of lead walk-ins and digital campaign ROI.
Approach: Built a Power BI model integrating lead discovery sources and CPL/CPT metrics.
Power BI Data Modeling Sales KPIs
Ameyo Dashboard

Telecalling & Counselor Analytics

Domain: Admissions (Ameyo Platform)
Problem: Lack of visibility into counselor call volumes, effective connects, and lead dispositions.
Approach: Engineered a Power BI tracking suite analyzing talk times and walk-in conversion ratios.
Power BI Performance Metrics ETL
Enterprise Operations Command Center

Enterprise Ops Command Center

Domain: Enterprise Operations & Academics
Problem: Leadership needed a unified view of staff attendance, transport delays, and school-wide compliance.
Approach: Developed a macro-level BI dashboard consolidating multi-campus data via APIs into an executive summary.
Power BI ERP API Executive Strategy
Operations Summaries

Multi-Domain Ops & Audit Trackers

Domain: Housekeeping, Security & Support
Expertise: Demonstrates advanced G-Sheet architecture to track compliance (e.g., Night Guard audits, ticketing SLAs).
Outcome: Standardized reporting across distinct operational branches using unified spreadsheet logic.
Advanced Sheets Logic Formulating Cross-functional
Finance and Inventory

Financial Realization & Stock Analytics

Domain: Finance & Procurement
Problem: Lack of immediate visibility into monthly fee dues and undocumented inventory consumption.
Approach: Engineered dynamic tracking sheets mapping item-wise consumption against financial payables.
Financial KPIs Inventory Logic Data Visualization
Comprehensive Operations Summary

Comprehensive Operations Summary

Domain: Cross-Campus Operations
Problem: Need for a centralized, daily operational digest summarizing housekeeping, security, and infrastructure across all locations.
Approach: Designed a robust Google Sheets reporting architecture that aggregates multi-branch daily inputs into a single executive snapshot.
Data Aggregation Google Sheets Automated Summaries
TGS Operations Portal

Enterprise Operations Portal

Domain: Administration Web App
Problem: Siloed management of transport utilization and compliance risks.
Approach: Developed a unified, interactive web application serving AI insights for logistical compliance.
Apps Script HTML/JS Web App Deployment
School Information Portal

Centralized Information Portal

Domain: Internal Communications
Problem: Disjointed access to fees, academic calendars, and standard operating procedures.
Approach: Architected a scalable internal portal serving as a single source of truth across regional branches.
Google Apps Script UI/UX Design Document Management

Machine Learning Models

Documentation for Predictive Demand (Linear Regression) and Loan Company Exploratory Data Analysis currently being finalized for deployment.

Coming Soon

Micro-Automations & Scripts

Solving everyday business bottlenecks through programmatic triggers and automated workflows.

⚡

Automated Data Pipelines

Scripts that automatically extract, clean, and standardize raw data outputs from internal ERPs into structured datasets ready for BI consumption, eliminating daily manual pasting and data silos.

📧

Scheduled Email Reporting

Custom Google Apps Script triggers that compile daily and weekly performance metrics (e.g., support tickets, calling audits) and dispatch formatted HTML email summaries directly to leadership.

⚙️

Ticketing & Support Triage

Automated categorization of incoming support concerns (Academic, ERP, Transport, Infrastructure), calculating real-time resolution percentages to enforce SLAs across departments.

The Design Process

How I architect systems from raw data to executive visibility.

01. Data Integrity

Before writing a single line of visualization logic, I ensure the underlying pipeline is bulletproof. A dashboard is only as effective as the cleanliness and reliability of its source data.

02. Automation First

Manual intervention in reporting is a point of failure and a waste of analytical talent. I architect workflows that eliminate repetitive friction, ensuring data flows seamlessly from input to executive view.

03. Actionable Clarity

Data should answer questions, not create more. I design KPIs and interfaces that immediately highlight bottlenecks—whether in marketing spend or operational logistics—allowing leaders to pivot strategy instantly.

Initiate a Discussion

Available for conversations regarding BI development, data engineering, and transitioning raw operational metrics into scalable reporting infrastructures.