Data Visualisation

Create a heat map table

User Friendly

Imagine you have some data showing performance of some teams in different categories:

results table

A very quick way of showing the results more visually is to create a thermal map.  You can do this very quickly using conditional formatting!  Download the sample excel sheet here.

  • First, highlight the values in the first column (result 1)
  • Then on the Home tab, click on the small arrow next to the Conditional Formatting button (in the Styles section)
  • Click on Color scales and then More Rules

Home tab

  • Ensure that “Format all cells based on their values is selected
  • Then in the Edit the Rule description section, choose a 2-color scale and choose 2 colors.  I’ve left the default colors in place for the first column (orange and light orange)

new rule

  • When you are done, press the OK button.  The column should automatically update

first column

  • You can then repeat this for each of the other columns, using different…

View original post 82 more words

Data Visualisation

Create a dollar graph in Excel

User Friendly

One of my colleagues had a presentation to give this week regarding his program. He wanted a nice graphic / chart, to show his team which parts of the program were costing the most money. He created various charts himself, and then asked me to make one particular chart more interesting.  The original can be seen below (please note I’ve changed the labels and actual data to protect my colleague and his program):

original chart

It’s obvious in the case above that the “Jeans” series is costing the most money

My first suggestion was to reorder the categories, so that the most costly were at the bottom (In the same manner as a Pareto chart). Immediately, the information is visually easier to understand

ordered column chart

However, the chart still doesn’t look so “sexy”. So my second suggestion was to create an overlay, so that the final chart looked like a multi-coloured dollar sign. You…

View original post 773 more words


Just what sort of geek are you?

Thatthereengland - does Japan

A rather nice visualisation of the geek family tree (of course, some of us would want a check list where we could tick off about 75 per cent of the categories):


View original post


How to market yourself on Internet | Social Media | Analytics | SEO | PPC| ORM


How to market yourself on Internet.

We are launching a series of posts to guide you with the steps to market yourself on Internet.

Marketing have three mediums:

·         Direct Marketing by hiring sales team

·         Expensive Advertising

·         And of course the mainstream media

With the launch and success of Internet and it transforming into a major publishing tool Internet Marketing has emerged as necessity now a days for all.

Its a professional job, ya, it is, but still you have to be aware of the steps. We hereby will be launching posts with the steps and the procedure for the Basic Internet Marketing of your products and services through your website.

Hope it will be of great help to you all……..

seo services in delhi, web design company, Creative agency, Strategy, Web Designing, Web Development, Social Media, Analytics, SEO

View original post 10 more words


Business analytics model risk (part 4 of 5): categorizing types of BA model risk

SCTR7: Data Science and Analytics

Business analytics model risk (part 4 of 5):  categorizing model risk

Following from article 3 of 5 on Business Analytics Model Risk

Link to introductory header article (0 of 5)

Model risk cannot easily be spoken of as a singular entity.  The topic is complicated in that there are multiple ways of categorizing model risk.  As well, schemes for categorizing model risk are rarely mutually exclusive.  While we can easily categorize different types and aspects of model risk, it is difficult to propose exclusive categories.  Aspects of model risk tend to easily overlap, co-occur, or co-vary.

At the outset of this series, a categorization of contributing factors to model complexity was proposed.  Complexity is one type of categorization scheme for a particular type of model risk.  Below two more are offered which are likely more useful in segmenting and thus controlling model risk:  I) model core attributes, and II)…

View original post 1,440 more words


The Ever Disruptive Cloud


The Future is Mobile


A fascinating presentation here from industry analyst Benedict Evans gives an overview of the state of the global industry, succinctly illustrating what we already know, that mobile is doing rather well.

With the aid of some startling stats, Evans paints a dramatic picture of the explosion in smartphone and tablet sales and the simultaneous decline in the PC market, while taking in all of the major winners and losers looking ahead to 2017. Essential viewing should you harbor any doubts that the future will be mobile.

2013 05 BEA – ’Mobile is eating the World’ – by Benedict Evans Via Slideshare

View original post


Andrew Bud: How the world is banking on mobile


MEF Global Chair Andrew Bud takes a closer look at the data uncovered by MEF’s research on mobile banking globally, and draws some interesting conclusions.

MEF’s Global Consumer Survey of nearly 10,000 mobile users in 10 countries is proving to be an inexhaustible source of insight into the changing world of mobile content and commerce.  Recently we were reviewing the detailed data regarding mobile banking worldwide in 2012, and some fascinating patterns became apparent. I recently spoke to Finextra, the website for the worldwide financial technology community, who wanted to get some detailed insight into the results of the survey. You can watch the interview below, but it’s worth taking a deeper dive into such a key growth area for our industry.

Mobile banking can be classified as covering a range of activities, but I was most interested in the most mainstream of interactions – checking your bank balance, applying for…

View original post 569 more words


A Degree In Big Data? More Hands Are Needed


From the car-sharing company to the utility company and every type of business in-between, organizations can make better decisions with Big Data (Or so it is assumed). In an article at, Prachi Patel makes important points

There are many data sources today — That’s NOT the problem. The challenges begin when the aim is to clean up data gathered from many sources (structured and unstructured data), make correlations, glean insights and present such insights in ways that decision makers can factor them into the decision-making process.

That’s where there is a big need — The problem is with having people with the right skills to present insights gleaned in ways that are usable by business leaders.

Read the rest here.

Visit for more trending news on Big Data.

View original post


What i like abo…

What i like about photographs is that they capture a moment that’s gone forever, impossible to reproduce.