Blog

Power BI – Check a model’s memory usage with VertiPaq Analyzer

Johan Vermeire
07/08/2019

One of the things you could do to refresh your data quicker and speed up calculations is resizing the data model. But how do you even figure out the current size of your data model? Is it the same as its file size?  

Power BI: Styling and storytelling in reports and dashboards

Frank Bastien
29/07/2019

Most Power BI users are impressed with the possibility to create custom visuals, which sometimes results in very colourful reports/dashboards – and occasionally even leads to documents that teeter on the edge between looking professional or amateurish. Where do you need to draw the line?

Power BI: Using multiple date fields

Frank Bastien
23/07/2019

Like several similar solutions, Power BI works best if data are structured in a star schema, which is a structure that consists of fact and dimension tables. Typically, one of these dimensions is the date dimension. This dimension can filter your data based on calendar-type fields. If there are multiple Date fields in the fact table (such as OrderDate, DueDate, ShipDate…), there are some considerations to take into account.

Power BI: Row and filter context

Frank Bastien
15/07/2019

As mentioned in earlier posts, Power BI uses an expression language called DAX (Data Analysis Expressions) to create calculations. At first glance, this language is similar to Excel formulas, but there are some important differences. Most importantly, DAX uses a row and filter context when executing expressions. 

Power BI: What is the difference between DAX and Excel formulas?

Frank Bastien
07/06/2019

When you start using DAX, you might think that it looks strangely much like Excel formulas – but while they do look similar, they work in completely different ways. In order to execute calculations correctly, it’s important that you understand these differences.

Excel: How to lock a column in table formulas

Pieter Bollen
08/02/2019

Can’t get enough of Excel? Good! In this blog post, we’ll teach you another Excel trick. When Microsoft introduced tables in Excel in 2007, it became impossible to use the dollar sign ($) to lock rows or columns. This isn’t much of a problem for rows, but what about columns? Read on – I’ll explain how you can still lock these.

Excel VBA tip 7: Create a recordset based on 2 different worksheets

Pieter Bollen
25/01/2019

This is the seventh and last blog post in our series about how you can speed up data transformation in Excel VBA. In this blog post, we’ll discuss how you can merge two tables and add them to one recordset. 

Excel VBA tip 6: Use a recordset to read data from multiple files without opening them

Pieter Bollen
22/01/2019

This is the sixth in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In the previous blog post, we explained how you can save data in a recordset. This time, we’ll show you how to use this technique to open all files in a folder and transfer their data to a target file. 

Excel VBA tip 5 : Save data in a recordset

Pieter Bollen
10/01/2019

This is the fifth in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In this blog post, we’ll explain how you can save data in a recordset.

Excel VBA tip 4: Open several files and transfer data to a destination file

Pieter Bollen
04/01/2019

This is the fourth in a series of 7 blog posts explaining how to speed up data transformation in Excel VBA with a few simple techniques. This blog post is a variation on the example from our previous blog post, where we transferred data from one file to a target file: this time, we’ll transfer data from multiple files.

Bring your knowledge and skills to a higher level

Subscribe for our monthly newsletter and receive:

  • Exclusive tips & tricks
  • Information about our courses
  • Trends on courses
  • Invitations to seminars and events

Most popular courses

Xylos brands