Power BI MCSA Certification Tips – Part 1 : M Language Overview

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). However, there is a huge overlap

Continue reading

G Com Solutions Running Scheduled Courses in Central London

G Com Solutions Limited is proud to announce the launching of our new central London training centre. The location is at Tower Bridge Business Centre, 46-48 East Smithfield, close to Tower Hill and Fenchurch

Continue reading

MyWorkspace, App Workspaces, Apps and Template Apps

Once you have configured your Power BI tenant, the next major aspect of Power BI which you need to address is the configuration of app workspaces. But what exactly are app workspaces and how do they differ

Continue reading

Free Power BI Books

  Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools

Continue reading

Removing Unnecessary Rows in Power Query

One of the most common  data cleansing  operations performed in Power Query is the removal of unwanted rows. And this is a topic which we cover in almost all of our Power BI training courses. In this

Continue reading

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

Power Training for Microsoft Excel Users

Microsoft Excel is an essential tool for most modern businesses, providing a dazzling array of features for manipulating and analysing organisational data. The concept of power training for Excel users

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