What is the relationship between Excel and Data Analysis?
Excel is known to be one of the most commonly used data software. In this article, we take a closer look at what makes it just so effective for data analysis, and how to get started.
Data Analytics
Which Is Better: Data Science Or Data Analysis?
Big data provides actionable results and insights that have made it a crucial component of today's tech world. To sort through such massive datasets and retrieve the right information, you must have the right tools and understand how to use them.
How to become a Data Visualisation Analyst
Big data is playing a bigger and bigger role in almost every industry. On the back of our increasing reliance on data to make decisions, there are many new types of roles popping up, including that of a Data Visualisation Analyst.
5 Reasons why we love Power BI!
Power BI's unique benefits and inclusions undeniably distinguishes it from its competitors in the business intelligence platform market. In this article, find out exactly what these 5 features are and why we love them so much.
Why SQL?
A perusal of any article about data will lead to the conclusion that in the internet age, data is pretty much everything. See why SQL is so valuable.
BERT - Combining Excel and R
One of our recent discoveries is BERT aka the Basic Excel R Toolkit. This is a package for working with the R programming language functions from Excel. It's a wonderful resource for adding functionality to Excel and best of all, it is free!
Janitor Package in R | Cleaning Data
The R package, janitor, contains easy-to-use and convenient functions for basic data cleaning jobs and examining data. Let's take a look at some of these functions.
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?
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.
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.
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.
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.
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.
phone
email
enquiry
