Category Archives for Power BI

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

Continue reading

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

Continue reading

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;

Continue reading

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

Continue reading

5 day Power BI Certification Training Course for Exam 70-778

G Com Solutions Limited (in Peterborough) have become the first training company in the United Kingdom to offer a Power BI certification training course. (Contact G Com Solutions on 0845 129 2872 for further

Continue reading

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

Continue reading

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

Continue reading

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

Continue reading