Developing a Modular Visual Data Manipulation Framework for Data Exploration in the Consumer Packaged Goods Industry

The rapidly increasing reliance on data analytics to drive strategic decision-making in today’s digital economy means that efficient and user-friendly data analysis tools are becoming increasingly important. Even as understanding and manipulating data becomes more critical, the technical complexity of traditional query languages like SQL often poses a substantial barrier to non-technical users. In this thesis, we present a fully visual analytics framework that can be arbitrarily integrated with relational data stored in an analytics platform. We describe the design and implementation of a frontend client by which nontechnical users can construct rich queries involving relational operations such as aggregations and filters on promotional data and view their outputs in tabular or graphical form. We also describe a protocol for uniquely and unambiguously describing these queries and the design and implementation of an engine by which these queries are efficiently executed.

Name thesis:degree_name

Master

Department dc:contributor.department

Massachusetts Institute of Technology. Department of Electrical Engineering and Computer Science

Grantor dc:publisher

Massachusetts Institute of Technology

Year dc:date.issued

2023

Author dc:creator

• Huang, Allen

Advisors dc:contributor.advisor

• Eng, Tony
• Wey, Scott

Statement dc:rights

• In Copyright - Educational Use Permitted
• Copyright retained by author(s)

Licence dc:rights.uri

• https://rightsstatements.org/page/InC-EDU/1.0/

Handle dc:identifier.uri

https://hdl.handle.net/1721.1/152637

OAI identifier oai:identifier

oai:dspace.mit.edu:1721.1/152637