Dashboard Creation


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 in an easy to update excel sheets.
Fantastic solution for combining all your data in one dashboard regardless the source!

 In my previous job the main issue we had was how to save time limiting manual work whilst ensuring the business was receiving the same level of information.

On top of this, data where coming from diverse sources, and we needed to report by day/week/month both comparing stats by period, budget and forecast.

Here our solution: we input daily data in a master sheet documents (traffic, ad spends, mkt/organic sales, call centres, shop,….) and use excel macros to do the job for us.

Here a quick and intuitive example of what can be done.

 

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