Jun 2023 – Dec 2023

PowerPoint Add-in for Executive Research & Analytics

Hanover Research · Full Stack Developer / Data Engineer

In-app

Research Inside PowerPoint

OOXML

Automated Slide Generation

ETL → BI

Data Pipeline to Power BI

Tiered

Subscription Model

Growth & Stability

~60%

API Response Time Reduced

30+

Manual Workflows Eliminated

1000s

Real-time Synced Users

Overview

Hanover Research is a research-and-analytics firm serving corporate, higher-education, and K-12 clients. I built a Microsoft PowerPoint add-in that delivers research and analytics directly inside PowerPoint — plus the data-engineering pipeline behind it — so executives access business intelligence without leaving their presentation workflow.

The Problem

Executives switched between research tools and PowerPoint to build data-driven decks

Research and analytics lived outside the presentation workflow

Turning findings into presentation-ready slides was manual and slow

Data was scattered across multiple sources and hard to surface consistently

No tiered, monetizable access model for the delivery tool

The Solution

A PowerPoint add-in delivering research and analytics inside the native app

Automated generation of presentation-ready slides from findings via OOXML

Secure integration of multiple data sources behind the add-in

A tiered subscription model with subscription management and authentication

ETL pipelines into a data warehouse feeding Power BI dashboards

Architecture

Core Components

In-PowerPoint research and analytics add-inCustom data-visualization componentsAutomated slide generation (OOXML)Subscription management and authenticationData warehouse, ETL, and Power BI reporting layer

Technical Design

Microsoft Office add-in (Office JS API) hosted in PowerPoint

C# / .NET Framework backend exposing REST and OData feeds

ETL pipelines populating a data warehouse

Power BI dashboards with DAX measures

OAuth / Office365 / Active Directory for identity

Secure API connections to multiple data sources

My Role: Full Stack Developer / Data Engineer

Built the PowerPoint add-in with the Office JS API

Implemented OOXML slide generation for presentation-ready output

Integrated multiple data sources through secure APIs

Built ETL pipelines, the data warehouse layer, and Power BI dashboards

Implemented the tiered subscription and authentication system

Designed the UI for non-technical executive users

Key Achievements

🔥

Delivered research and analytics inside the executive's presentation workflow

🔥

Automated slide creation from research findings via OOXML

🔥

Built the data pipeline (ETL → warehouse → Power BI) behind the add-in

🔥

Implemented a tiered subscription model for the service

Impact

📊

Gave executives instant in-PowerPoint access to research and analytics

📊

Removed app-switching between research tools and presentations

📊

Improved the speed and data-driven quality of strategic decisions

📊

Enabled a subscription revenue stream for the delivery tool

Tech Stack

Backend

C#, .NET Framework, REST, OData

Frontend

React, JavaScript, Office JS API

Add-in

Office Add-in, OOXML slide generation

Data

Data Warehouse, ETL, Power BI, DAX

Identity

OAuth, Office365, Active Directory

What I Help With

Scalable Backend Systems

High-performance APIs and microservices

Complex Integrations

Stripe, Shopify, Microsoft Graph, telecom

AI & Automation

LLM workflows, document processing

Identity & Security

OAuth, Entra ID, Cognito

Let's discuss your system or project

Get expert input on your architecture, integrations, or scaling challenges.

Book a Call to Discuss Your Project