Excel For SEO – Basic Training Guide
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…
News & Tips
Read MoreExcel For SEO – Basic Training Guide
Create Your Own Histogram In Excel
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…
[Introduction] Automated Machine Learning In Power BI
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…
Breaking Down Pivot And Unpivot Columns [Power BI Guide]
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…
Introduction to Power BI (Crash Course!)
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…
How To Load Multiple Files Into Power BI [Simple Guide]
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…
Power BI: Which Version Should I Use?
In a world of tiered service offerings and freemium models, the most successful products are those that seamlessly transition between the different levels. This is where Microsoft has done a fantastic job with the 3 different offerings of Power BI.…
Build Incredible Reports With Power BI
If you need to compile data from different sources into a report, the Power BI Report Builder is your ideal tool. It allows you to display calculated fields, tables, filters and parameters. The report can be as simple or as…
How Dynamic Row Level Security Can Help You [Complete Guide]
Using dynamic role-level security, you can restrict users’ access to reports and dashboards based on their login credentials. Row-level security is often abbreviated as RLS! This is one of Power BI’s more advanced features that is covered in our Power…
Exporting From Power BI To Excel [Fastest + Simplest Method]
Power BI has the best visualisations out there. But sometimes you need to work alongside someone who’d rather use Excel! Being flexible in the softwares you use is a great way to become an important and valued team member.…
How To Recreate Sum If In Power BI!
In this article, you will see how to use DAX (Data Analysis Expressions) in Power BI to implement the Power BI Sum If function. The Sum If function is used to sum values in a data column based on a…
Enhance Your Data Analysis With Custom Columns [Power BI Guide]
Custom Columns are the key to enhancing your data analysis. Find out their practical applications, and delve into the step-by-step process of creating them here. They offer users the ability to create calculated columns within their datasets, creating enhanced data…