Business Intelligence

/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 [...]

Business Intelligence, Power BI|

Could your KPIs do more?

In the current environment, reducing costs and increasing productivity are the keys to success. This was emphasised strongly by a recent PriceWaterhouseCoopers (PwC) report which found that profits at the world's top 40 mining companies, including BHP Billiton and Rio Tinto, slumped by half between 2011 and 2013 as the mining boom came off its [...]

 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 [...]

Business Intelligence, Power BI|

 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 [...]

Business Intelligence, Power BI|

 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 – [...]

Business Intelligence, Power BI|

 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 [...]

Business Intelligence, Power BI|

 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 [...]

Business Intelligence, Power BI|