Category Archives for Blog

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 […]

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 […]

Infographic: Power BI – Unpivot Columns

Nested IFs and Russian Dolls

Excel Online Training When they hear the term “nested IFs”, a lot of people will visualize a structure whereby you have one parent IF statement with several IF statements nested inside it; and this is not actually the case. A better way of visualising nested IFs is to think of a Russian doll arrangement, whereby […]

INFOGRAPHIC: Nesting VLOOKUP Functions

Combining LEFT, SEARCH and VLOOKUP

Excel Online Training To complete this tutorial, you will need to download and UnZip the following file from GoogleDrive; it contains two versions of the workbook used in the tutorial: the start version and the completed version. Download the tutorial workbook(s) In the download tutorial folder, open “04 Manipulating Text”; and then open the Excel […]

Connecting to Web Page Data in Power BI

As well as retrieving data from a web URL, Power BI also allows you to retrieve data from within the web page itself. In this tutorial article, we will see how easy it is to connect to online data and incorporate it into your own data models. The files used in this tutorial can be […]

Getting Started with Power BI – Pt 4

Part 4 (of 4): Creating a Report in Power BI Desktop 2 Click here to download the tutorial work files Power BI online training In the previous tutorial in this series, we discussed the use of the synoptic panel custom visual to build a car damage report; and we examined the completed report. In this […]