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

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

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

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;

Power BI Essentials Quiz 1: The Power BI Product

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

Infographic: Power BI – Unpivot Columns

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

INFOGRAPHIC: Nesting VLOOKUP Functions