Creating a VBA-free Excel dashboard
August 24, 2009 at 12:10 am | In Accountant, Lenses, Marketing Performance, Performance Analysis, Predictive Analytics, Scenario Analytics | Leave a CommentTags: Analytic Lens, Analytics, financial, marketing, performance, Predictive Analytics, storyboard, transactions
This post discusses the use of VBA in Excel dashboards and links to a VBA-free Excel dashboard
via Creating a VBA-free Excel dashboard.
Cheers,
Nick www.scenario2.com
How To: Excel at Excel for SEM Applications, Part 1
May 31, 2009 at 11:05 pm | In Marketing, Marketing Performance, NeuroPersona, Performance Analysis, Uncategorized | Leave a CommentTags: Analytic Lens, Analytics, NeuroPersona, numerati, performance, Predictive Analytics
Simple and practical way to use Excel to measure your effectiveness and provide guidance for your Search and Media focus and spend.
How To: Excel at Excel for SEM Applications, Part 1 Posted using ShareThis
Cheers,
Nick www.neuropersona.com
Microsoft Anhialates adCenter Analytics
March 24, 2009 at 5:22 am | In Marketing Performance, Microsoft adCenter, Performance Analysis, Persona Behaviour, Scenario Analytics | Leave a CommentTags: Analytics, performance, persona, Story, storyboard, strategy
Microsoft anhialtes adCenter analytics or as posted here Microsoft Kills AdCenter Analytics
This is HUGE as analytics acts as an on-ramp to adCenter–see the Story Lens where we make the connection between Story, Process, Software, Brand and Metrics/Analytics. Unless customers understand which words impact the Story to Analytics continuum they don’t know the most effective way to spend their money or event focus their attention.
MISSING LINK –> Search words uses change at a rate of 30% daily
WHAT NOW? –> Understand the Persona Behaviours and you will succeed by being in their ‘word proxity’
Word proximity means that they will understand that the search word combinations that you selected COMBINED with the story you have linked to the words will serve their needs BETTER than their other options.
PREDICTION –> Microsoft will buy another analytics provider, soon, whether it is Yahoo, Omniture or other…IMHO
Cheers,
Nick
The LENS WEARER Persona
January 12, 2009 at 6:26 am | In Accountant, Lenses, Marketing, Marketing Performance, Performance Analysis, Persona Behaviour, Scenario Analytics | Leave a CommentTags: Analytic Lens, financial, Lens, performance, persona, scenario, storyboard, strategy

- MAGIC LENS
GRYO Analytics is the ability for the numbers and the stories used in Analysis or Analytics to adjust according to the needs of the user without programming or modification. This is done with the concept of the MAGIC LENS.
A LENS provides the wearer PERSPECTIVE for CLARITY in their environment. LENSES may be combined according to the need of the wearer, time, place and people which are being viewed. This is a LENS WEARER…

Cheers,
Nick www.scenario2.com
NeuroPersona and Story Lenses
January 5, 2009 at 11:20 pm | In Lenses, Marketing Performance, Performance Analysis, Persona Behaviour, Scenario Analytics | Leave a CommentTags: financial, Lens, marketing, performance, persona, Story, strategy
A NeuroPersona sees the world through LENSES and WE BUILD LENSES!

NeuroPersona LENSES
To understand the NeuroPersona or Persona behind the LENSES please see:
http://numerati.wordpress.com/2009/01/05/chanel-no5-and-neuropersona-behaviour/
Stories make up the mask of a NeuroPersona and are important to Numerati as they also are at the core of numbers.
Comments on LENSES that you may use are appreciated here:
http://numerati.wordpress.com/2009/01/05/neuropersona-and-story-lenses/
Cheers,
Nick www.scenario2.com
Introduction to Lenses–Story, Time, Value & Persona Lenses
January 5, 2009 at 11:01 pm | In Lenses, Marketing Performance, Performance Analysis, Persona Behaviour, Scenario Analytics | Leave a CommentTags: Analytic Lens, financial, Lens, marketing, persona, scenario, Story, strategy
A storyteller is a ‘lens maker’ and provides tools to help people understand where they are and where they can go.
The atomic elements of any lens are Stories and Numbers as highlighted in the Story Lens below and found here:

Sample Lens STORY PERSONA PROMISE TIME MODEL
1. Story Lens:
Story<->Process<->Software<->Brand<->KPI
A lens provides a unique way of using stories and numbers to provide perspective to its wearer and may be used in may ways. From a commercial perspective a lens provides assessments of current state of an enterprise and its market environment and supports the alignment of content (sell side) to Customer or Persona needs (buy side).
2. TIME Lens: C,C,E,S,S
Clock Time–Past, Present, Future (most common way of viewing Time)
Cycle Time–Relative Time based on intereaction of Processes (some flowers only bloom when Salmon are running)
Event Time–Event and Time only starts when participants arrive (party, cultural event…)
Story Time–Stories may be used to change Value of past, present and future data
Scenario Time–Time unfolds according to interaction of stories
3. PROMISE Lens –> see bottom of this post for a Promise Lens diagram
Sell Side–Value Promise and Deliver
Buy Side–Persona Need and Ability to use or Accept the product
4. PERSONA Lens
Buy Side–Persona Needs and Content Navigation requirements
Sell Side– Company Product or Content creation and deliver
5. MODEL Lens
This lens provides a description of the relationships, mathematical or stories, that exist in a business environment. It can provide details or a high level view depending on the wearer’s need or the speed by which the wearer must apply the lens. In our experience higher level views of models are generally sufficient and detail can be provided by using the other lenses available much more quickly than building detail models and structures.
My speciality is connecting the big picture to small details. Sometimes this means Strategy to Action, which is difficult for most Strategy or Scenario Analysis people. I do it with stories, lenses and with an understanding that stories are at the core of all numbers.
Cheers,
Nick www.scenario2.com

PROMISE Lens Example
Promise Lens
It was created when I was mappng Buy vs Sell side objectives about 15 years ago in San Francisco.
In the simplest case a buyer will deliver a Promise story to a Buyer.
The Buyer interacts with the Seller because there is a Desire.
Once there is enough alignment for the Buyer to buy the Seller then must Deliver.
After delivery the Buyer consumes or will ACCEPT the product according to their capacity.
Using the two hands helps me quickly describe the combinations possible between buyers and sellers.
KPIs or measures can be created or enhanced according to how the lens is applied for each client.
Analysis can highlight examples of:
positive states — under promise+over deliver OR under deliver+over accept …
negative states — over promise+under deliver OR under promise+under accept …
Overlaying other lenses provides superb clarity, for example:
Story Lens — aligns Promise to process, Scenario or other buyer values
Persona Lens — aligns Promise to appropriate Desire
Time Lens — provides differentiator to competitors by shifting time and value derived
Analyze this STRATEGY
December 16, 2008 at 1:32 pm | In Marketing, Marketing Performance, Performance Analysis, Scenario Analytics | Leave a CommentTags: financial, marketing, performance, strategy
BETTER TO ASK FORGIVENESS THAN PERMISSION is the mantra of the Analysis challenged and in a commercial context analysis is generally considered an essential success component.
In the last twenty years I have noticed a shift from the lauded and methodical READY, AIM, FIRE approach to analysis and action to the manic READY, FIRE, AIM sequence where the role of Analysis appears to have shifted from careful consideration before acting to backward facing justification of acts done. Ignoring the value of Analysis is justified by the generic North American ‘first mover wins’ where many avoid the risk of Analysis slowing action.
STRATEGY is supposed to be better, a carefully considered and analyzed long term view of business opportunity and deployment of assets to create market value to serve commercial and non-commercial communities and enterprises.
Oddly enough STRATEGY suffers from the same fate as Analysis as contrary to the fiction of the ‘NUMERATI‘ or data priests, most enterprises, communities or people are uncomfortable with measuring and measures. There is an awkwardness, discomfort or simple ignorance of how to connect numbers and stories that typically results in:
- ANALYSIS PARALYSIS
- ACT FIRST, MEASURE LATER
ANALYSIS PARALYSIS is an affliction, not just a slogan, though it shouldn’t be confused with measurement denial and acting first and measuring later shouldn’t be confused with the ability to measure.
How can numbers help us avoid conditioned behaviour of analysis paralysis or acting first, measuring later?
- Understand how to MEASURE the CURRENT STATE of your decision environment.
- Clarify and QUANTIFY your OBJECTIVE.
- Consider multiple future SCENARIOS or STORY groups in your future environment.
- Envision ACTION options that may be AVAILABLE depending on the future that unfolds.
- Take multiple PERSPECTIVES when measuring past, current or future PERFORMANCE
As a fully recovered accountant I discovered that stories underly numbers and indeed stories are numbers and numbers are stories where you become comforatable with the nuances of storytelling. Don’t get dscouraged if you can tell a story because most that believe they can have a little way to go in this sequence:
- Hear a Story
- Tell a Story
- Modify a Story to fit an environment
- Create your own Story to craft a Scenario
- Live a Story from multiple simultaneous Perspectives
If the idea of telling stories or connecting numbers and stories is new to you then read as many stories as you can and observe how the numbers relate to the story and how the story would have changed without numbers.
Remember numbers are necessary to measure and it is difficult to know where you you came from, where you are or where you are going without numbers.
Cheers,
Nick www.scenario2.com
Numerati and the stories behind Persona behaviours.
November 1, 2008 at 8:03 am | In Marketing, Marketing Performance, Performance Analysis, Persona Behaviour, Scenario Analytics, Uncategorized | Leave a CommentTags: financial, marketing, performance, persona, strategy
Marketers are just catching up to artists when it comes to understanding the value of the Persona construct. What is a Persona and how do different Personae interact? A simple definition of a Persona is a mask that someone wears, not to hide their identity but rather to simply and clearly indicate the behaviour that they are predisposed towards.
Artists understand that they can wear and discard masks or Personae at will and this is explored further in personati.wordpress.com and www.scenario2.com and while Artists are story focused, Marketers look for and consume numbers in their quest for selling products and ideas.
Why is it that we distinquish and divide stories and numbers? –Conditioning, pure and simple.
If you are an accountant, actuary, economist or practice any othe commercial profession that depends on numbers consider that underlying every number, individually or in combination, there lies a story or two.
Financiers, Venture Capitalists and other Master’s of the Universe often forget that stories preceed numbers and actually manifest their forecasts. Oddly enough once these stories manifest numbers the numerati then forget their existance and attempt to understand and influence the future with numbers alone.
You are welcome to explore the relationship between numbers, stories and numerati here and at www.scenario2.com or www.marketstory.com or www.storyflow.com to see different perspectives of links between stories and numbers, now or in the future.
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.