News & Tips
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…
Loading Multiple Files From A Folder Into Power BI
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.…
Power BI Report Builder
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…
Dynamic Row Level Security in Power BI
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…
How to Export From Power BI to Excel
This article shows how to export data from Power BI to Microsoft Excel. You can import data into Power BI from a variety of sources including databases, flat files, REST APIs and cloud services. Conversely, you can export visualisations and…
Recreating 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…
Power BI – Custom Columns
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…
Microsoft Project Schedules – Complete Guide
Microsoft Project provides a comprehensive approach to scheduling. It allows you to plan and manage your projects efficiently. You can create detailed schedules that outline tasks, deadlines, and resources, helping you to stay on track. So, whether you’re a seasoned…
Mastering Microsoft Project Views
Deadlines, resources, dependencies… It can all become overwhelming pretty quickly! That’s where Microsoft Project comes in. With its powerful project management tools, it’s a go-to choice for professionals across a wide range of industries. And one of the key features…
Creating A Planner In Microsoft Project
In the dynamic realm of project management, meticulous planning and effective organisation are the cornerstones of success. Microsoft Project, a powerful and acclaimed software, is the ultimate ally for project managers seeking to optimise their planning process. From project initiation…
How to Share Your Files And Folders With SharePoint!
You may wish to share particular files or folders with users who do not usually have access to the site. The files you save on your SharePoint site are typically accessible to anybody with site rights. You may choose to…