Insights & Blogs

Excel crunches numbers very effectively, but it must always be remembered that it is also a communication tool just like Dashboards.

Structured Query Language (SQL) is currently one of most desirable and transferable skills in organisations across industries. But what is SQL? and why should you start learning it?

You may have seen *args in the help documentation for Python functions and methods. This post explains what this parameter is, how to use functions that include an *args parameter and how to include *args in your own custom functions.

Python users who work in Jupyter computational notebooks have access to an extra collection of commands – known as magic commands. Magic commands are an enhancement of the interactive IPython kernel (used by Jupyter) and make performing common tasks easier than using Python code alone.

The data frame (or DataFrame) is an essential tool for anyone using R or Python to analyse data. They are rectangular or tabular data structures, that hold rows and columns of data, similar to tables in a database or an Excel spreadsheet.

Recently Microsoft has announced further information about the Visualize list feature that will be available in Microsoft Lists (aka SharePoint Lists). We'll break down what this means and how you'll be able to use it.

The pandas groupby() is a versatile DataFrame method that enables to users to quickly and efficiently separate datasets into groups by a chosen variable. It can be used to report summary statistics for each group, loop over groups and to separate data into subsets.

We have recently been training a growing number of professionals in R and Python as they migrate from other code-based analytical packages such as MATLAB, Stata, SAS and SPSS. This post outlines some of the reasons for using code-based tools and why organisations are increasingly using Python and R for their data analysis needs.

Whether you are a Business Intelligence professional, Excel guru or just starting out - these tips will help you to improve your Power BI skills.

Sitting the DA-100 exam and becoming a certified Power BI user isn't easy, but we'll show you how to make it a little less difficult with our top 5 tips.

Microsoft Ignite 2021 has just begun and we'll break down our top picks to keep you informed

The apply family of functions in R allow you to apply a function repeatedly to subsets of data in a single line of short code. Apply functions automatically to each column or row of data. Alternatively, apply functions to subsets of a data based on a category variable.

Both R and Python have a huge range of functionality available for working with data. Investing a few weeks to learn to use a programming language will enable you achieve big productivity gains. 

Looking to the future WaterNSW's sought to ensure processes and information systems could carry across the whole of the organisation to ensure seamless operation as they grew. With Microsoft's cloud products they achieved this and improved experiences for employees and customers alike.

Microsoft's Power Apps allows for the creation of quick, low-code apps without the need for a developer. However, the platforms vast functionality means beginning the process can be daunting. Read on for tips and tricks designed to make starting out as smooth as possible.

After transforming the learning experience of his first year engineering students Dr Kellerman of UNSW decided to further improve the performance of his Teams site with AI.

In 21st Century students require 21st century learning strategies. Dr Kellerman of UNSW provided just that, on a massive scale for his engineering students, all with Microsoft Teams.

Power BI Video Series | Episode 8
Learn how to effectively navigate Power BI whilst using a mobile device in this short tutorial video by Microsoft Certified Trainer, Steven Knight.

Power BI Video Series | Episode 7
Learn how to set up and manage alerts and subscriptions on Power BI in this short tutorial video by Microsoft Certified Trainer, Steven Knight.