Category Archives for Power BI

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

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

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

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

Getting Started with Power BI – Pt 3

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 loaded into the data model available for building reports. On the left, we have three […]

Getting Started with Power BI – Pt 2

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: Power BI Desktop, the Power BI service and Power BI mobile apps. We will […]