Gregory C Ebbecke

My biggest takeaway is that managers need not be experts in the generating/capturing information in order to maximize the knowledge potential of the company. By having a broad understanding of overarching data philosophy and strategy, managers can delegate data strategy to specialized experts and instead allocate their time to the interpretation…[Read more]

Last week’s speakers were incredibly engaging. The visuals were especially powerful and their personalities brought the concepts to life in a very engaging manner. Overall, the most critical takeaway for me was that companies should avoid waiting for the perfect candidate (i.e. the MIT post-doc). At this stage, even moving the needle from 50% on…[Read more]

Data mart example: Information on media insertions placed through the agency

Facts: Estimate ID, Property/Station ID, Weeks Active

Measures: Quantity Ordered, Spend

Dimensions: Client, Media Type (Product), Time

This mashup shows the relationship between the presence of a loaded gun in a household and deaths by firearm within state populations (per 100k people):

http://www.datamasher.org/mash-ups/households-loaded-firearm-times-deaths-due-injury-firearms-100k-0

Q1: I think it is possible to use data, but in many cases the execution is flawed. For example, media buying involves a great deal of math. As a result, we give all new applicants a math competency test to see how they handle “basic math”. The problem is that, in practice, almost all math related to our work is done in Excel or via a third-party…[Read more]

We use a number of KPIs across the agency, but, for the sake of this exercise, our primary measure of a successful media initiative is based on the ability to correlate resort booking to media exposure. We achieve this through various ad-tracking technologies which can sort through all bookings to identify which conversions were driven by what…[Read more]

Travel/Resort Bookings

Leading Indicator: Time Spent per Page, Rate Query
Lagging Indicator: Confirmed Reservations

http://mediamatters.org/blog/2010/06/28/updated-worst-chart-ive-seen-all-day/166862

http://www.informationisbeautiful.net/visualizations/million-lines-of-code/

While the chart presents a lot of comparison, it does a great job of presenting the sheer size and complexity of the Healthcare.gov codebase compared to other easy to visualize comparables. The combination of “honest” scaling and delineated color selections allow for a…[Read more]

– Referential integrity ensures stable relationships between tables by maintaining consistency in values across linked tables.

– Foreign keys need not be unique (specifically in many-to-many relationships), although mapping can be made easier if unique values can be maintained.

– The level of complexity is the primary factor when evaluating…[Read more]

In my line of work, client spending information is captured when an insertion order (insertion ID) is generated at the vendor/partner level (Partner ID). Multiple vendor “buys”, typically identified by an estimate ID, roll up to a specific client (Client ID). Lastly, client activity is rolled up for internal use by account team (Dept./Employee…[Read more]

Team:
Greg Ebbecke – tue83901@temple.edu or greg.ebbecke@gmail.com
Ryan Lucera – ryan.lucera@gmail.com
Matt Cohan – tue87167@temple.edu

We have identified critical inconsistencies in how client and corporate information is collected at an advertising agency. This leads to ineffective collaboration on projects due to unnecessary information…[Read more]

A key component for successfully designing an ERD system is to incorporate outside stakeholder perspective prior to committing to any details. This will help lend additional detail in how stakeholder information might be communicated into the ERD while also ensuring individual bias is minimized. While final decisions need to remain with the…[Read more]