In the working world, data is never perfect and needs cleaning up before you analyse it. If you’ve ever been handed a big data set for analysis, you’ll know they come full of duplicate values! This means it’s crucial to…
When dealing with Data analytics, comparing data populated in two or more columns is common practice. Manually comparing data could take hours or even days, depending on the amount of the data in question. But when it comes to…
Suppose you have financial statistics in prepared in USD, and need it converted to GBP. Why not use Excel to solve your problem? You can use currency pairs and currency exchange rates to convert currency. Excel doesn’t come packed…
In this post, we will review how to calculate the Percentage Difference in Excel. Percentage Difference is the absolute value change of two values, divided by the average of them. The result is then multiplied by 100. Excel has…
Page Layout is the group of commands that control how you spreadsheet looks. This guide will go over the best options to keep control of your Excel Document. This will help you make your Excel pages more readable, more…
Who hasn’t had a project delayed because of an unforeseen dependency or delay? This then ripples out to the delivery of all of the related parts of the project causing chaos, if you’re not on top of things. As the old…
Excel has every data analysis tool that you’ll ever need. That’s great if you know about all of them. You can focus on the fun stuff and get Excel to do the heavy lifting. Our Microsoft Excel course has been…
Histograms are visualisations of the distribution of your data. For a simple example, think about breaking down exam scores into grade bands. Professionals from industries across the globe rely on histograms to make sense of patterns and trends. Knowing how…
Automated machine learning is the process of automating the tasks of applying machine learning to real-world problems. AutoML covers the complete pipeline from the raw dataset to the deployable machine learning model. Automated Machine Learning (AutoML) in Power BI for…
Learn how to utilize Microsoft Power Query Editor’s pivot and unpivot features in your data queries. Pivoting describes the process of turning distinct row values into columns. Pivot rotates a column from vertical to horizontal. Pivoting data in Power BI…
Power BI is a visualisation and Business Intelligence (BI) tool from Microsoft, aimed at helping turn data into insights. Power BI allows you to stitch together data from across your organisation and create beautiful reports and dashboards. You can connect…
There are countless ways to load data into Power BI. When you’re learning Power BI, this trick for loading multiple files from a folder at the same time should be near the top of your list – it can save…
