Why Learn SQL?

Recent Articles

July 16, 2021

Why Learn SQL?

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?

Read More >

July 09, 2021

Multiple Python Positional Parameters - *args

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.

Read More >

June 15, 2021

Python Magic Commands in Jupyter

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.

Read More >

May 18, 2021

Data Frames and DataFrames

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.

Read More >

May 14, 2021

What is Visualize the list in SharePoint?

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.

Read More >

May 13, 2021

The pandas DataFrame groupby() method

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.

Read More >

April 23, 2021

Code-Based Tools for Analysing Data

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.

Read More >

March 19, 2021

Take Your Power BI Skills to the Next Level

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

Read More >

March 08, 2021

Top 5 tips for sitting the DA-100 exam

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.

Read More >

March 03, 2021

Our Top 8 announcements from Microsoft Ignite 2021

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

Read More >

March 02, 2021

Learn to simplify repetitive actions in R

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.

Read More >

February 05, 2021

Increase Productivity with Python & R

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. 

Read More >

January 29, 2021

WaterNSW Transform with Microsoft Cloud Services

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.

Read More >

January 22, 2021

Power Apps Cheat Sheet

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.

Read More >

January 14, 2021

UNSW Teams Success: Integrating AI in Education

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.

Read More >

December 10, 2020

Teaching and Technology: UNSW's Teams Success

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.

Read More >

December 07, 2020

Navigating Power BI on Mobile

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.

Read More >

December 04, 2020

Microsoft Technology for Learning Difficulties

A look at Microsoft's approach to assistive technology & accessibility and how Microsoft's products can assist those with learning difficulties.

Read More >

December 01, 2020

Managing Alerts and Subscriptions on Power BI

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.

Read More >

November 23, 2020

How to export from Power BI

Power BI Video Series | Episode 6
Learn about the different options available when exporting from Power BI in this short tutorial video by Microsoft Certified Trainer, Steven Knight.

Read More >

Topics