Business Intelligence

Home/Business Intelligence

Data is the oil of the 21st Century – Analytics is the engine

  Data is the oil of the 21st Century - Analytics is the engine “Data … the next natural resource” (Virginia Rometty, CEO, IBM, 2013) Oil - the commodity that got us here Current generations might be forgiven for being blasé about the mega role of oil in our daily lives. For most of us, [...]

How do you get 4 million rows of data into Excel?

So firstly lets face facts.  Not many people need to bring 4 million rows of data into Excel.  Point accepted. However, some do, and I recently needed to do this. If you've ever checked  (Press End then the down arrow key) Excel has just over 1 million rows, but if you start adding a formula [...]

Microsoft Power BI Desktop Introduced

We’ll go into much more detail on these in future posts but this is very new stuff and we thought we’d let you know about it Key Points: It’s free and it’s pretty amazing. If you want to get more advanced then it is $9.99 per user per month. Pull your data together from single [...]

 Microsoft Leading In Agile Business Intelligence

Microsoft Leading in Agile Business Intelligence Forrester Report The battle over customer versus internal business processes requirements and priorities has been fought — and the internal processes lost. Game over. Customers are now empowered with mobile devices and ubiquitous cloud-based unlimited access to information about products, services, and prices. Customer stickiness is [...]

 Using Data To Create A Competitive Advantage

Using Data to Create a Competitive Advantage As we outlined in What is ‘Big Data’; and why is it such a big deal?, effective analysis of large volumes of data can identify new opportunities, products and services, and result in significant cost savings and operational improvements. “To paraphrase the Rime of the Ancient Mariner by [...]

 What Is “Big Data”; And Why Is It Such A Big Deal?

What is "Big Data"; and why is it such a big deal? By Access Analytic     For a year or two, management pundits around the world have been nominating ‘Big Data’ as the ‘next big thing’ – and the key to sustainable competitive advantage in a brave new world of business. But – [...]

 Data-Driven Decisions

Data-Driven Decisions Case Study: Using PowerPivot and Power BI to Drive Strategy By Jeff Robson A national recruitment company provided us with some data from their internal systems about the placements they were making around Australia. The data included all sorts of information: Demographic information: age, nationality, location, etc How long it took to [...]

 Free (& Useful) Datasets

Free (& Useful) Datasets By Jeff Robson You're collecting a lot of data inside your company, which enables you to discover all kinds of interesting insights. But there's also a whole world of interesting and useful data sets that you can get from within Excel. Introducing the Microsoft Azure Marketplace It provides you with [...]

 Data Analytics Is The New Black

Data Analytics is the New Black Why everyone is so focussed on improving their data By Jeff Robson Businesses want to be more efficient, save costs, & improve revenues. These reasons are almost always the primary goals for implementing new systems.  So why don’t they achieve their goals? The #1 reason is analytics (aka [...]