Removing Unnecessary Rows in Power Query

One of the most common  data cleansing  operations performed in Power Query is the removal of unwanted rows. And this is a topic which we cover in almost all of our Power BI training courses. In this blog post, we will look at the key M function used to suppress unwanted rows. Table.Skip The first […]

Using Power BI Dataflows to Centralize Data Preparation

Power BI’s new dataflows allow the centralization of data cleansing and transformation operations, greatly reducing inconsistencies and duplication of effort across organizations. Instead of connecting to data sources from within a Power BI Desktop PBIX file, organizations will now be able to carry out all of their Power Query data connection and transformation centrally in […]

Using Relationship Columns to Kickstart your Data Modelling

(In this blog post/tutorial, we will use a database called “Event Sales”, which you can download here. If you wish to follow along, you will need to download and UnZip the .BAK file, then use it to restore the EventSales database on an instance of SQL Server.) When connecting to a relational database from Power […]

The Smart Way to Pass the MCSA: BI Reporting

To obtain your MCSA: BI Reporting you need to pass two exams: 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Excel). I took the 70-778 last year; and was surprised, when the 70-779 exam was announced, at how much of an overlap there was between the two exams. […]

Power Training for Microsoft Excel Users

Microsoft Excel is an essential tool for most modern businesses, providing a dazzling array of features for manipulating and analysing organisational data. The concept of power training for Excel users is not new; and the traditional route to becoming an Excel power user has been to develop a fairly large repertoire of advanced techniques; such […]

Customizing in-house Power BI training

If you are considering Power BI training, one of your first decisions is choosing between sending your staff on a scheduled training course and arranging in-house Power BI training. There are pros and cons to both approaches. Booking a place on a public Power BI training course One of the main benefits of booking a […]

The Excel Ribbon

The Excel  Ribbon is one of the first topics covered on our Introduction to Excel. Ribbon, first introduced with Microsoft Office 2007, is the key component of the Excel interface and offers access to most of its features, facilities and utilities. However, as is now the case with all sophisticated software packages, there are often […]

Power BI Essentials Quiz 1: The Power BI Product

Microsoft Confirm Excel’s Role in Business Intelligence with MCSA Exam 70-779

Microsoft’s MCSE (Microsoft Certified Solution Expert) and MCSA (Microsoft Certified Solution Associate) qualifications do not normally include an assessment of an IT pro’s ability to use Microsoft Excel. However, this has all changed with the inclusion of Exam 70-779 as a requirement for obtaining the MCSA: BI Reporting. The introduction of the Power Pivot add-in […]

5 day Power BI Certification Training Course including Exams 70-778 and 70-779

G Com Solutions Limited (in Peterborough) is one of the few training companies in the United Kingdom to offer a Power BI certification training course. (Contact G Com Solutions on 0800 998 9248 for further information.) The BI Reporting certification does not have a wide range of exam options to choose from, unlike most MCSA […]