Feeds

Seeing the answer

Diagramming boosts your (business) intelligence

  • alert
  • submit to reddit

3 Big data security analytics techniques

Workshop Business intelligence (BI) is a many-headed beast that has spawned a thousand different analytical applications in areas such as financials, key performance indicators, supply chain and so on.

In essence, though, BI is about dipping into data and delivering it for viewing in a relevant format. Diagramming software offers the tools you need to create smart visuals that present the data in more digestible forms.

At the low end it’s simply a matter of simply presenting a basic dashboard, higher up the scale it’s about creating decision support systems, for example a data visualisation of a retail store’s sales updates by location, product or employee.

Such a system can pinpoint poorly performing products, locations or staff, and enables management to make on-the-fly decisions about what to do to increase sales.

Researcher Gartner’s January 2011 Magic Quadrant for Business Intelligence Platforms cited Microsoft, IBM, SAP, MicroStrategy, Information Builders and SAS as the leading BI vendors. But the firm says that half of BI implementations do not meet business expectations.

Part of the problem is that BI is an emerging technology still grappling with a range of thorny issues, such as semi-structured data, open source technologies, content from social networking sites, other management technologies, real-time analytics and cloud-based BI services.

Data visualisation is part of the answer. Visio Services publishing Visio 2010 diagrams onto SharePoint 2010, for example, makes sense of business data by allowing the user to collate data, link it from an external data source, apply graphics and refresh in almost real time.

Andrew Binns of Premier Computer Solutions is a fan of Shapesheets, a section that offers ways of creating smart shapes. “What impresses me about Visio 2010 is its versatility,” he says. “With Shapesheets and Visual Studio, the user can create some amazing solutions.”

He cites the example of pivot diagrams his company created for a customer using star ratings from a data graphic to view the performance of sales managers, whether daily, weekly or monthly.

BI-curious

Do most IT managers share Gartner’s view of Visio as a BI tool, bearing in mind that it requires a pretty steep learning curve on some implementations and skills in several different object models (.Net, database, among others)?

Al Edlund, US-based former Microsoft Most Valued Professional (Visio), says: “You have to come back to the question of does the company have a data visualisation strategy? A look at the add ons and templates available across the different editions shows the breadth of areas Visio might be applied to.

“Obviously, there are many products out there that can focus on individual areas better than Visio does, but nobody has a broader canvas to work with.”

Edlund also fears that some line managers do not know the product well enough to sanction the necessary third-party add-ons. “The tool tends to be used in individual departments and by a few advocates. In my experience, the boss might be willing to buy the tool for me but was reluctant to buy what I considered to be necessary add-ons to get the most value out of it.”

But there is little doubt that there is a renewed focus on BI since the launch of Visio 2010. Its attractions when combined with SharePoint 2010 and Visio Services include data overlaid onto diagrams to make information more meaningful; the ability to connect to a variety of data sources (for example Excel, Access, SQL server, SharePoint) and combine the data on the same diagram.

You can also publish Visio diagrams to SharePoint Server 2010 to share data-driven diagrams via a browser so users do not need a Visio runtime on their machines. But isn’t dedicated reporting software replacing the use of diagramming software?

Chris Hatton, senior consultant at Waterstons, puts it in context. “Visio is a useful tool for BI. I would use tools like PerformancePoint, ProClarity or Sql Server Reporting Services, for interactive graphs, reports and scorecards, and then add Visio into the solution for any data-driven diagrams,” he says.

For Melvin Lancelot, practice manager at Aditi Technologies, even though Excel continues to improve its graphics functionality Visio often remains the tool of choice for the BI specialist.

“On the whole Excel is not suitable because so many different versions make collaborative working very hard. However Excel Services in SharePoint complementing Excel can be a powerful tool to provide a platform for collaborative decision making,” he says. ®

SANS - Survey on application security programs

More from The Register

next story
Android engineer: We DIDN'T copy Apple OR follow Samsung's orders
Veep testifies for Samsung during Apple patent trial
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Windows 8.1, which you probably haven't upgraded to yet, ALREADY OBSOLETE
Pre-Update versions of new Windows version will no longer support patches
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
Red Hat to ship RHEL 7 release candidate with a taste of container tech
Grab 'near-final' version of next Enterprise Linux next week
Ditch the sync, paddle in the Streem: Upstart offers syncless sharing
Upload, delete and carry on sharing afterwards?
prev story

Whitepapers

Designing a defence for mobile apps
In this whitepaper learn the various considerations for defending mobile applications; from the mobile application architecture itself to the myriad testing technologies needed to properly assess mobile applications risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.