NETMAP BLOG: TALES FROM THE TRENCHES

Posted by Andrew Sumner
,
29 Nov 2017

By nature we are visual creatures, we find it much easier to perceive patterns in images than in raw data - and I’m not just talking about the Marketing team.

 

Most corporations have many years of detailed information stored away in fortress-like databases, often never to be looked at again. It makes sense that Data Visualisation is used to bring this data to the foreground, unlock its secrets and make informed decisions off the back of it.

 

At the risk of using more buzzwords, utilising "big data" to create actionable "business intelligence" is most certainly harder than it looks.

 

Complex Loss Prevention Solution

 

We all know how effective Data Visualisation should be in accomplishing this, but over many years of working with a variety of businesses and government departments, my experience is that very few come close to analysing their data as effectively as they should. Some don’t visualise their data at all, while others create charts in programs such as Excel, usually in an isolated & sporadic way which is only scratching the surface of what’s possible.

 

The result is that all too often, data keeps its secrets hidden away from view and key executive decisions are made in the absence of vital business intelligence.

 

Why is this so? Put simply, it’s because visualising data effectively is much harder than most people expect. I’ve met many managers who say the equivalent of “come on, it can’t be that hard”, believing that the data just needs to be thrown into a charting software package and out spill all manner of graphs telling you everything you need to know.

 

our data visualisation analyst

 

 

 

 

 

Unfortunately, the reality is quite different. There are several stumbling blocks that can easily derail a Data Visualisation project. Let’s imagine a project where a senior manager has appointed a staff member - I’ll call her “Alison” - to perform a deep dive into company data to identify opportunities or risks.

 

CHOOSING A TOOLSET...

Firstly, she will need to decide on which charting software package to use. There are many such packages available now, and working out which provides the best functionality is not easy. Alison will also need to choose software that matches her computer skill-set, otherwise, considerable time could be wasted learning how to use a new product, but balanced against this is the danger of choosing simpler software with limited capabilities. Mistakes made at this stage could jeopardise the entire project.

 

GETTING THE DATA...

Next, the data has to come from somewhere - usually, it’s one, two, three or more corporate databases with different file structures. To get access to this data, Alison will nearly always need to involve the IT department, who of course have a busy schedule of their own, have little understanding or appreciation of the type of analysis to be performed and which data would be appropriate. Usually, the best IT will offer is a simple extract of data, hopefully with nothing missing or corrupted, and in a portable format such as CSV.

 

At this point, Alison will need to display a significant level of technical skill. The data from IT may need to be joined with data from other sources, such as spreadsheets. It may also need to be manipulated in various ways, such as the cleaning of test values to ensure they match up properly or calculating statistics to be displayed in the charting tool. To do this, she may need to use a staging database and write SQL scripts.

 

Basic heat map for loss prevention

 

 

 

 

 

 

VISUALISING THE DATA...

Next up, the charting software will need to be told the structure of the data in her staging database, including the type of each field and how multiple files are linked together. Alison will actually need the skill level of a Database Administrator to pull this off.

 

Lastly, the charting software itself will often need to perform complex calculations in order reveal answers to questions asked of the data. This will come as no surprise to anyone who’s pushed the boundaries of tools like Microsoft Excel. If the selected charting package fails to provide pivot-table, join, filtering, aggregation and summary calculations, its graphs will fall short of the mark.

 

Along with strong technical skills, Alison will need a thorough knowledge of her organisation’s business requirements and an imaginative analytical mind. If she doesn't know what questions to ask of the data, or how to use the charting tool to pose those questions, her charts will ultimately be irrelevant and the whole project will have accomplished nothing. On the other hand, If she has a thorough knowledge of their business but lacks the ability to work with the data and program complex queries, she’ll end up frustrated, able to only produce simplistic charts that fail to unlock anything of value.

 

Simple Graph - But what does it mean for Loss Prevention?

 

TO SUM IT UP...

Our analyst needs a mix of technical skills, business knowledge and analytical ability. The success or failure of Data Visualisation really does come down to the quality and experience of the people working on the project. The fact is that most organisations don’t have many people with that mix of skills and experience, or when they do, those people are often already far too busy to work on such a project.

 

I’ve come to the conclusion that the best way to succeed at visual data analysis is to involve consultants who specialise in the field. At NetMap Analytics, we not only offer powerful charting software, we also have decades of experience in solving the technical issues and working alongside our clients to design customised chart dashboards that directly address business concerns across a wide range of applications, including insurance, marketing, loss prevention, risk management, logistics, retail sales analysis and more. If your business could be made more productive, more efficient and more competitive through better analysis of your own data, why not drop us a line?

79 thoughts on “Data Visualisation – It’s Harder Than It Looks!”

    Michael Hammer

    Great article, totally matches what I see in the business world. However I think it should be noted that the “getting the data” term always makes people think raw files are enough. Real data integration takes a significant time, maybe 3-8 workdays of a very skilled ETL Enginner to really automate in a reliable manner which will establish trust. The other steps combined might take half this time. ETL and Data Integration are truely where the “rubber hits the road”

    Steveitefs

    Hello. And Bye.

    Sergioweede

    Hot and juicy women in your city want sex: http://ralive.de/bestadultdating2837420444

    Carlosavoib

    Finde eine heiГџe Frau fГјr guten Sex in deiner Stadt: https://arill.us/bestsexofferinyourcity61920

    DonaldNak

    Paid Surveys: Earn $3,000 Or More Per Week: http://www.short4free.us/bestinvestsystem15508

    DonaldNak

    How to Turn $3,000 into $128,000: http://freest.at/bestinvestsystem13459

    DonaldNak

    Les femmes chaudes et juteuses de votre ville veulent du sexe: http://freest.at/bestsexygirlsinyourcity12009

    DonaldNak

    Trouvez une femme chaude pour du bon sexe dans votre ville: http://www.abcagency.se/bestsexygirlsinyourcity31060

    DonaldNak

    Les femmes chaudes et juteuses de votre ville veulent du sexe: http://www.short4free.us/bestsexygirlsinyourcity38009

    DonaldNak

    Fuck tonight juicy woman in your town: http://go.fireontherim.com/bestadultdating80546

    DonaldNak

    Hot women for good sex every day: https://atho.me/3PZU

    DonaldNak

    HeiГџe Frauen fГјr guten Sex jeden Tag: http://corta.co/sexywomaninyourcity82432

    DonaldNak

    Fick heute Nacht saftige Frau in deiner Stadt: http://webhop.se/sexywomaninyourcity53906

    Justinfat

    Where to invest $ 3000 once and receive every month from $ 55000: https://lil.ink/howtoinvest300031263

    Justinfat

    Where to invest $ 3000 once and receive every month from $ 55000: http://valeriemace.co.uk/howtoinvest300049830

    Davidboums

    How to make $450 per hour: http://to.ht/bestinvestsystems63541

    Davidboums

    Hot women for sex in your town: http://corta.co/bestadultdating61164

    Davidboums

    Hot and juicy women in your city want sex: http://yourls.site/bestsexygirlsinyourcity36457

    Davidboums

    Enquêtes rémunérées: gagnez 3 000 € ou plus par semaine: http://wntdco.mx/bestinvestsystem92481

    Davidboums

    Quel est le moyen le plus simple de gagner 3000 € par mois: http://webhop.se/bestinvestsystem81667

    Davidboums

    J’ai 23 000 €. Comment l’utiliser au mieux pour gagner plus d’argent: http://www.lookweb.it/bestinvestsystem32378

    Davidboums

    Wie man € 10.000 pro Tag SCHNELL macht: http://jnl.io/5500097650

    Davidboums

    What is the best cryptocurrency to invest in 2019: http://corta.co/BESTINVESTMETHOD5500096619

    Davidboums

    Find yourself a girl for the night in your city: http://go.fireontherim.com/bestforex97414

    Davidboums

    Meet sexy girls in your city: http://goto.iamaws.com/bestforex79128

    Davidboums

    Sexy girls for the night in your town: https://aaa.moda/bestforex11051

    Charlessog

    Conheça garotas sensuais em sua cidade: http://yourls.site/bestforex86946

    Shawnslofe

    Sexy girls for the night in your town: http://ralive.de/adultdating39572

    Shawnslofe

    Find yourself a girl for the night in your city: http://tropaadet.dk/adultdating17233

    Ronaldtweby

    Treffen Sie sexy Mädchen in Ihrer Stadt: http://www.lookweb.it/bestsexygirlsxxx28490

    Ronaldtweby

    Suchen Sie sich ein Mädchen für die Nacht in Ihrer Stadt: http://wntdco.mx/bestsexygirlsxxx73330

    Ronaldtweby

    Treffen Sie sexy Mädchen in Ihrer Stadt: http://ralive.de/bestsexygirlsxxx77815

    Ronaldtweby

    Forex Trader predicts and makes $10,000 less than 3 hours: http://profit.bitcoin-forex-invest.com/online-game-earn-money-telugu.php

    Ronaldtweby

    How To Make $10,000 a Day Trading Forex – The Most EASIEST Way For Beginners (SECRET REVEALED): http://profit.bitcoin-forex-invest.com/online-real-money-earning-games.php

    Ronaldtweby

    Win iPhone X: http://jnl.io/winiphonexs97864

    Ronaldtweby

    Win iPhone X: http://jnl.io/winiphonexs79397

    Ronaldtweby

    Win iPhone X: https://tinyurl.com/winiphonexs18276

    Ronaldtweby

    Top cryptocurrencies to invest in 2019: http://wntdco.mx/15354

    Ronaldtweby

    Auto Mass Money Maker: https://arill.us/192257

    Ronaldtweby

    Simple biz + new tool = $450 per hour: http://yourls.site/178325

    Ronaldtweby

    Get $1000 – $6000 A Day: https://arill.us/1361066

    Shawnglank

    Sexy girls for the night in your town: http://www.lookweb.it/bestadultdatingsite57853

    Shawnglank

    Sexy girls for the night in your town: http://ralive.de/bestadultdatingsite12892

    Shawnglank

    Meet sexy girls in your city: http://yourls.site/bestadultdatingsite23461

    Shawnglank

    Meet sexy girls in your city: http://goto.iamaws.com/bestadultdatingsite32430

    Shawnglank

    Find yourself a girl for the night in your city: http://www.abcagency.se/bestadultdatingsite49746

    Shawnglank

    Forex 1000 To 1 Million – Turning $10,000 into $1 Million in Forex: http://ralive.de/1000perday74509

    Shawnglank

    Forex Prodigy Makes $10,000 in 30 Minutes! – Market Traders Institute: http://go.fireontherim.com/1000perday33683

    Shawnglank

    Sexy girls for the night in your town: http://wntdco.mx/bestadultapp17503

    Shawnglank

    Sexy girls for the night in your town: http://valeriemace.co.uk/bestadultapp98574

    Shawnglank

    $10000 per day Trading Bitcoins on the Binary Options Market: http://perkele.ovh/10000perday54770

    Shawnglank

    Suchen Sie sich ein Mädchen für die Nacht in Ihrer Stadt: http://www.lookweb.it/appadultdating37120

    Shawnglank

    Beautiful women for sex in your town: https://arill.us/getsexinyourcity66131

    Shawnglank

    Sexy girls for the night in your town: http://www.lookweb.it/getsexinyourcity58002

    KevinBum

    Natural Stress Solutions CBD Capsules Night (Sleep): http://valeriemace.co.uk/aturaltressolutions63544

    KevinBum

    Natural Stress Solutions Pure CBD Tincture: http://go.fireontherim.com/aturaltressolutions36716

    DanielHiemi

    Top tips for lasting longer in bed: http://www.lookweb.it/LastLongerinBed81424

    Santosjab

    How to Make $30000 FAST | Fast Money | The Busy Budgeter: http://perkele.ovh/investcrypto90051015

    KevinBum

    Natural Stress Solutions: CBD Products: http://www.lookweb.it/investcrypto34278

    Santosjab

    The best women for sex in your town: http://www.lookweb.it/bestsexygirldating27238

    KevinBum

    Sexy girls for the night in your town: http://yourls.site/bestsexygirldating72081

    KevinBum

    Meet sexy girls in your city: http://www.lookweb.it/bestsexygirlsdating28573

    DanielHiemi

    The best women for sex in your town: http://webhop.se/bestsexygirlsdating74001

    KevinBum

    Cryptocurrency Investing 2019: http://jnl.io/cryptoinvestbitcoin51079

    DanielHiemi

    Wie man aus € 3.000 € 128.000 macht: http://jnl.io/cryptoinvestbitcoin34125

    Miguelephed

    Comment utiliseriez-vous 3000 € pour gagner plus d’argent: http://valeriemace.co.uk/cryptoinvestbitcoin54051

    Miguelephed

    Forex Prodigy Makes $10,000 in 30 Minutes! – Market Traders Institute: https://tinyurl.com/milliondollarsforex53879

    DanielHiemi

    How to Make $30000 FAST | Fast Money | The Busy Budgeter: http://jnl.io/milliondollars15322

    Santosjab

    The Beginner’s Guide to Getting More High Quality Traffic: http://webhop.se/getmoretraffic96105

    KevinBum

    Senuke Tng Reviews-Can Senuke Tng Make Your Affiliate Marketing: http://webhop.se/bestseotools55980

    KevinBum

    Trouvez-vous une fille pour la nuit dans votre ville: http://www.abcagency.se/bestsexygirlsadultdating84231

    DanielHiemi

    Encuentra una chica para pasar la noche en tu ciudad.: http://valeriemace.co.uk/bestsexygirlsadultdating99762

    KevinBum

    Top Cryptocurrencies To Invest In 2018-2019: https://tinyurl.com/15000investbinarycrypto34998

    DanielHiemi

    Turning $10,000 into $1 Million in Forex | DailyForex: http://perkele.ovh/15000investbinarycrypto27408

    Santosjab

    Paid Surveys: Earn $30,000 Or More Per Week: http://jnl.io/15000investbinarycrypto97052

    Miguelephed

    $10000 per day Bitcoin Brokers | Top Bitcoin Brokers Reviews | Bitcoin Binary Options: http://webhop.se/15000investbinarycrypto65013

    DanielHiemi

    How You Can Make $100,000 Every Month Trading Forex: http://corta.co/15000investbinarycrypto92343

    KevinBum

    The best women for sex in your town: http://valeriemace.co.uk/adultdating16188

    Miguelephed

    Beautiful girls for sex in your city: http://www.abcagency.se/adultdating19299

Leave a Reply

Your email address will not be published. Required fields are marked *

63 − 55 =

Let us demonstrate the power of NetMap Analytics

REQUEST A DEMO