Apogee Consulting Group

About the CHOOSE Project

The Croton-Harmon Options and Opportunities for a Senior Experience (CHOOSE) project is an end-of-the-year project where CHHS research a topic while working as an intern. The project is designed to help seniors transition from to post high school education or employment.

I chose to work at Apogee Consulting Group and research how data is collected and used to make predictions in industry.

About Apogee Consulting Group

Apogee Consulting Group is a consulting company, local to Croton on Hudson, NY, that specializes in revenue and category magagement through "strategic storytelling." The company is owned by Dan Isleib.

According to Mr. Isleib, "strategic storytelling" means: Aligning an organization on a path forward based upon data and insights.

What I Did

Mr. Isleib's work involves analyzing many graphs and charts, many of which he would create manually. This was a very time consuming process, often because the same graph would have to be created for multiple products.

Using Visual Basic for Applications, I created Excel Macros to automate the creation of each graph and chart. One macro I wrote, took raw data from a sydicated data provider like Neilson or IRI, format the data, calculate the necessary information, create charts and graphs for each product, and then move the most important information to a new sheet.

In total, I wrote over 1,700 lines of VBA code. The majority of the code creates graphs and charts. There are a few utility macros, one of which is used to import the other macros.

My Research

Along with the internship, the CHOOSE project has a research component. I researched how datta is collected and how that data is used to make predictions.

I found that you could catagorize data into two types: Business data and Consumer data. Business data includes all information that a business could collect about itself, as well as sydicated data (formatted data for a category ie drinks) from companies such as Nielsen or IRI. Consumer data consists of all personal information about a user or customer of a business's products. This includes identifying information, such as names and addresses, as well as behavior and interest information, such as mouse movements and the types of movies you like.

All this data is used by companies to predict what you would like to buy. Using that information they are able to create targeted ads and promotions.

View the Project

You can view my presentation below. If that does not work you can click here.

As the code I wrote is being used by Apogee Consulting Group, you cannot view it on GitHub. If you have questions about the specifics of what I did, you can contact me.