Category: Analytics

Categories
Analytics Growth Troubleshooting

Jumping In For Analytics

(Decorist : 11/19-11/19)

Challenge

A newly-added Custom Dimension VWO wasn’t tracking.

Action

We had just introduced VWO into the stack for A/B testing when one of the experiements wasn’t reporting correctly.

I jumped in with PROD to debug and worked with VWO to resolve and figured out there was a race condition with our Angular code preventing the beaconing of the Custom Dimension.

I fixed the issue and deployed to prod.

Results

  • Collaborated w/Product Manager to get VWO experimentation working.
Categories
Analytics Troubleshooting

Improving Our Data Collection

(Decorist : 6/19-6/19)

Challenge

Anytime instrumentation changes were made, different engineers applied different standards of implementation, causing discrepencies in data collection.

Action

Created templatized checklist in Jira (in conjunction with Dir of Data Sci) to improve analytics instrumentation.

Results

  • Introduced checklist leading to consistent data analytics collection, growing trust with non-technical stakeholders.
Categories
Analytics Troubleshooting

Missing Mixpanel

(Decorist : 3/19-5/19)

Challenge

Late discovery that new initaitive/partnership was missing a key metrics instrumentation.

Action

Jumped in and instrumented, verifying in Mixpanel. Worked with Director of Data Science to formulate Jira stories breaking down the problem into discrete chunks/units-of-work towards cleaning up/adding new events in the future.

Results

  • Launched new strategic initiative on time and empowered the business to have greater analytics clarity.
Categories
Analytics Database demand-side Frontend

Web-Based Data Warehousing Tool

(IAEA : 3/06-4/06)

The customer had been using static reports in the form of data cubes embedded in a VB 6.0 application. When he asked for a web-based way to view the information more dynamically, we chose OWC PivotTables as the way to go.

To realize the customer’s request, I created several cubes under MS Analysis Services and hooked them to PivotTables embedded in a web-page.

Results

  • Implemented a web-based, SQL Server-driven data warehousing solution for sales reporting using OLAP technology
  • Successfully upgraded customer’s reports one-for-one and gave customer greater insight on sales data
  • Created OLAP tools to pull and aggregate sales data on a daily basis
Categories
Analytics APIs Building buy-in Collaboration Full-Stack Process Prototyping supply-side

The Portal for Nuclear Information

(IAEA : 8/05-8/05)

At the end of 2004, the IAEA had well over 200 scientific and technical information resources (e.g. databases, websites, applications, etc.)

In order to reduce the effort to maintain these (saving time for graphic designers, software engineers, DBAs, and resource custodians alike,) a single portal was conceived and made a priority deliverable for the IT and MIS sections.

As the Lead Information Architect, I was responsible for gathering technical details about the resources, supporting the technical architect, and driving the design behind the user experience.

Results

  • led requirements gathering and implemented modular components for the authoritative web resource on scientific and technical nuclear information
  • Met with and built buy-in among information stakeholders
  • Abstracted the business processes of the organization to the 50,000 ft view
  • Utilized user-centered methods to inform the design of the portal
  • Implemented the beta version using OpenText, LiveLink, and Java APIs for each
Categories
Analytics Content Management demand-side Full-Stack Innovation

Multilingual Workflow Application

(IAEA : 8/03-10/03)

To more efficiently track internal publishing, the IT section created a custom workflow application in October of 2003. The application serves approximately 50 people all the way from editors to translators to printers to distributors.

Results

  • Worked with multi-lingual users to implement v2.0 of a translation workflow application
  • Gathered requirements after leading focus group sessions with users speaking Chinese, French, Russian, English, Spanish, Arabic
  • Migrated v1.0 data store from MS Access to SQL Server