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

The Excel Ribbon

The Excel  Ribbon is one of the first topics covered on our Introduction to Excel. Ribbon, first introduced with Microsoft Office 2007, is the key component of the Excel interface and offers access to

Continue reading

Microsoft Confirm Excel’s Role in Business Intelligence with MCSA Exam 70-779

Microsoft’s MCSE (Microsoft Certified Solution Expert) and MCSA (Microsoft Certified Solution Associate) qualifications do not normally include an assessment of an IT pro’s ability to use Microsoft

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

Nested IFs and Russian Dolls

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

Continue reading