Power Query Trap: Formula Autofill

Power Query Trap:  Formula Autofill If you output the results of Power Query to a table in Excel then it’s often really useful to be able to add an extra calculated column or two onto the end of this output table.   I used to do this all the time when using Microsoft Query. However, now [...]

2018-03-26T14:04:10+08:00Power BI, Power Query|

Combine multiple tables with Excel Power Query

How to combine multiple tables with Excel Power Query If you have multiple tables of data in a file and you want to view a single report based on these tables then it can be time consuming and risky to manually copy and paste them into a single table before creating pivot [...]

The Top 3 New Features of Excel 2016

The next version of Microsoft Office is just around the corner and we’re nearly as excited as this girl! So here are the top 3 new features (according to us) … let us know if you agree (download preview). 1. Cool new charts Check them out! 2. More Powerful Power Query Power Query has been with [...]

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

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

Learn from highly qualified finance professionals with international experience

Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.

Get Ahead of the Game – Book Your Training Now!