Data Analysis

 ………………………………………………………………………………………….

MULTIPLE REGRESSION MODEL FOR DETERMINING BEST ONLINE MKT MIX

A Multiple regression model for determining best online marketing mix. How to determine feasible zones (where sales are more likely to be generated) and forecast sales using an optimization model.

 ………………………………………………………………………………………….

 DATA INTEGRATION

A Brief Introduction on how to integrate online and offline stats ensuring data and trend consistency

 ………………………………………………………………………………………….

TREND ANALYSIS

Few samples of interesting data manipulation and forecasting methodologies for:

  • Forecasting techniques: >Trend analysis and Gut Method
  • Benchmarking: > client vs. competitors activity and >  analytics vs. ad impressions

 ………………………………………………………………………………………….

DASHBOARD CREATION IN EXCEL

How to become more efficient: collect all your data in a Masterplan document and use Excel Macros to extract daily, weekly, vs. Budget insights stylishly presented on easy to update excel sheets.
Fantastic solution for combining all your data in one dashboard regardless the source!

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s