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

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;

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

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

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

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

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

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: