addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

From KPIs to Dashboards: Coloring meaningful data for deep insight - Ani Lopez

For April's presentation we'll have Meetup's co-organizer Ani Lopez talking about dashboards.

More than happy to have NextAnalytics sponsoring the venue. Their plugin for Excel is the most powerful way to integrate data from Google Analytics, Facebook, Twitter, Linkedin and more in Excel dashboards. Almost 300 free ready-to-use dashboards to download from their site.

Not only we are going to have nachos for attendees thanks to them, we'll raffle a NextAnalytics plugin license ($199 value) to all those members who tweet:

I'm attending next #VanSEM Meetup 'From KPIs to Dashboards' sponsored by

before the presentation.


  • Organizing KPIs for a meaningful representation
  • How to design an effective dashboard
  • Less is more, make the charts talk clearly

Recommended to take a look at Death by Powerpoint Excel charts before the MeetUp


Ani Lopez, SEO Manager & Web Analytics consultant
Working for well-known agencies in Europe gave him the opportunity to lead SEO campaigns and workshops for brands like Nokia, (an company), Carrefour, Amadeus, Barcelona Football Club, Ritz Hotel to mention some.

He moved  to Vancouver from Barcelona where he developed his more than 12 years long career. Started to work for VKI Studios in March 2010 mainly as SEO consultant but also stepping more into the Web Analytics and Traffic Analysis area, a natural complement to his main field of expertise in organic traffic.

VKI Studios joined forces with WebShare and PublicInsite to create a major agency, Cardinal Path, in March 2011 where he continues working in the same areas.


  • 6:00pm - 6:30pm - Relaxing, drinking, talking with colleagues.
  • 6:45pm - 7:30pm - Presentation and Q&A
  • 7:30pm on - More relaxing, drinking and talking with colleagues.

Join or login to comment.

  • Michel B.

    Ani Lopez's Excel(ent) tips on how a Dashboard can make a difference were by far one of the most well-prepared, visually sound and practical presentations that I personally attended at VanSEM Meetups, to paraphrase the co-organizer Jose Uzcategui who summarized it well for the 96% of its near-record 600 membership that missed it. Surprisingly, it commanded one of the poorest no-show attendance so far. Well beyond optimizing tips using good taste (ie. sober) in design and improving color, one can predict a future beyond wooing a CEO, IT or marketing target audience to such plugins for Excel, including NextAnalytics, who sponsored the event. In our case, comes to mind data-heavy media kits for our clients' potential advertisers. Many of our targets can no longer bear another 30+ slide presentation (with as many stand-alone pie and bar charts) from one more web publisher.

    April 19, 2011

  • A former member
    A former member

    Thanks Ani, great insights on dashboards. For those of you who missed it, I highly recommend you look at the presentation when it's uploaded.

    April 19, 2011

23 went

Our Sponsors

  • RTown

    RTown is providing financial support for our main annual event.

  • Bing Ads Canada

    Bing Ads Canada is offering financial support to our main annual event.

  • SweetIQ

    Sweet IQ is providing financial support for our Vancouver annual event

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy