Blog Archives - Page 7 of 7 - G Com Solutions Limited

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

13th February 2018
/ Power BI
/ By G Com Solutions Training

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

Infographic: Power BI – Unpivot Columns

24th December 2017
/ Power BI
/ By Grant Gamble

Nested IFs and Russian Dolls

9th December 2017
/ Excel
/ By Grant Gamble

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

INFOGRAPHIC: Nesting VLOOKUP Functions

6th December 2017
/ Excel
/ By Grant Gamble

Combining LEFT, SEARCH and VLOOKUP

3rd December 2017
/ Excel
/ By Grant Gamble

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

Connecting to Web Page Data in Power BI

21st October 2017
/ Power BI
/ By Grant Gamble

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

Getting Started with Power BI – Pt 4

25th September 2017
/ Power BI
/ By Grant Gamble

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

Getting Started with Power BI – Pt 3

11th September 2017
/ Power BI
/ By Grant Gamble

Part 3 (of 4): Creating a Report in Power BI Desktop 1 Click here to download the tutorial work files Power BI online training So far, we have connected to a data source and we now have these two tables

Getting Started with Power BI – Pt 2

14th July 2017
/ Power BI
/ By Grant Gamble

Part 2 (of 4): Working in the Query Editor Click here to download the tutorial work files Power BI online training Let us now look in a bit more detail at the three parts of Power BI that we saw earlier:

Getting Started with Power BI – Pt 1

11th July 2017
/ Power BI
/ By Grant Gamble

Part 1 (of 4): the Power BI Product Click here to download the tutorial work files Power BI online training Microsoft Power BI consists of three parts Power BI Desktop, the Power BI service and Power

Category Archives for Blog