Power BI, Excel and MS Industry News

Filter by Category or Experience Level:

Power BI Updates for November 2019

Considering we are Power BI consultants, it only makes sense that we share the latest news and information that comes with every monthly Power BI update. Every month, Microsoft Power BI comes with new updates to the internal applications and processes, and in this month’s case, there is a new modern ribbon that aligns Power BI…

Read more

Useful Features in Microsoft Excel

Microsoft Excel   To those who don’t use Microsoft Excel regularly, it can appear as quite a confusing and complicated program to understand. However, nothing could be further from the truth. Once you are able to understand its key features, how to use them and how they might potentially benefit you in the workplace, you…

Read more

Power BI Updates for October 2019

Microsoft Power BI’s update last month brought a wide range of new additions and improvements. Performance enhancements for DirectQuery and multi-dimensional models, a few more extras to the DAX expression library, and a visual guide for data visualisation in PowerApps were only a few of the updates for Power BI for the month of September.…

Read more

Power BI – An Overview

A Brief History of Power BI Microsoft Power BI is a relatively new product and whilst it’s become quite a popular choice of business intelligence software for many companies these days, its origins can be traced back as far back as a decade ago. While the ‘Power BI’ name wasn’t coined until recently, many of…

Read more

DAX – Data Analysis Expression

Introduction – What is DAX? Data Analysis Expression (DAX) is a formula language used in Microsoft Power BI. DAX formulas include functions, operators and values. Formulas allow users to define customised calculations and queries on data in related tables and columns. End users were previously limited to Microsoft Excel functions, and DAX gives users more…

Read more

Power BI Updates for September 2019

What is Microsoft Power BI? Power BI, a business analytics service that provides insights into data analysis and visualisation, is a consistently updated program. One of its perks is its ability to generate easy-to-read reports and dashboards with ease from excessive amounts of raw data. Power BI’s ability to explore and analyse data using creative…

Read more

Conditional Formatting Basics

What is Conditional Formatting? Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets specific criteria. It serves to highlight important information and allows users to configure specific formatting to cells automatically. Conditional formatting applies sets of rules to cells using basic, intermediate or advanced formulas…

Read more