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
Are Excel Charts Hurting Your Business? 10 Mistakes You Should Avoid.
August 24, 2009 at 12:01 am | In Accountant, Lenses, Performance Analysis, Predictive Analytics, Scenario Analytics | Leave a CommentTags: Analytic Lens, Analytics, financial, numerati, Predictive Analytics
To squeeze some competitive advantage of using Excel in your business, you must avoid several basic mistakes everyone makes. This is a short list of 10 of them.
via Are Excel Charts Hurting Your Business? 10 Mistakes You Should Avoid..
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
Spying On Your Paid Search Competitors
May 31, 2009 at 10:59 pm | In NeuroPersona, Performance Analysis, Predictive Analytics, Uncategorized | Leave a CommentTags: NeuroPersona, performance, Predictive Analytics, strategy
Older article, still meaningful, that highlights the contribution and value of Amazon’s Alexa search platform.
Spying On Your Paid Search Competitors Posted using ShareThis
Cheers,
Nick www.neruopersona.com
Trapeze Trapeze – Web Marketing | Trapeze DAOR for Canadian Tire | Toronto & New York
April 22, 2009 at 6:50 pm | In Uncategorized | Leave a CommentManga, Prediction and Neuropersona
April 2, 2009 at 10:10 pm | In Lenses, NeuroPersona, Performance Analysis, Persona Behaviour, Predictive Analytics | 3 CommentsTags: NeuroPersona, persona, Predictive Analytics
Manga is very, very popular and illustrates the value of stories and masks brilliantly.
Consider the common facial expressions and what they convey relative to a product or service.

Consider how the common Manga images convey change in emotion or perspective, almost the same way as a person removing one Neuropersona mask and replacing it with another.
Cheers,
Nick www.neuropersona.com
Follow the Money
March 24, 2009 at 5:35 am | In Lenses, Performance Analysis, Persona Behaviour | Leave a CommentTags: persona, transactions
FOLLOW THE MONEY, not the numbers may confuse some folks but there is a huge difference.
Numbers simply represent what happened, a story or event an intersection of many stories. Money, which represents value only when it exchanged, is only exchanged after something happens or the story unfolds.
While we generally think that stories travel quickly you should consider that money money travels faster still. This simple observation is evident as when you watch an exchange of value for money there are many versions of what happened. News stations report different versions, the Point of Sale systems and marketing systems of the buyers and sellers each report slightly different versions of the story, but the money has changed hands quickly and simply.
How does ‘Follow the Money’ help us succeed?
Consider that the story ‘closest’ to the money as it changes hands is the most accurate representation of what happened and why. As we get further away we know less. Typically by the time accountants and marketers get to analyzing the transaction it is a quarter or two later and we have to reconciled three or more versions of what might have happened depending on the perspective of the story we examine.
What can we do to Follow the Money?
Focus on the people and processes connected to the exchange of Money by understanding Persona Behaviour.
Cheers,
Nick
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
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.