by Nikolai Pavlov | May 12, 2020 | Articles
Power BI introduced the smart narratives feature that allows users to add dynamic and interactive narratives to reports. Preparing a management report is a tedious task, which requires time and effort. It often comes down to finding the right balance between showing...
by Nikolai Pavlov | Apr 27, 2020 | Video
In this video we will discuss when and why merge queries in Power BI using Power Query editor. Combining queries is one of the most essential tasks in Power BI. There are two options to combine queries: the append and merge functions in Power Query. In our last video...
by Nikolai Pavlov | Apr 23, 2020 | Uncategorized
Businesses around the world are adapting to the remote work environment during the COVID-19 pandemic. Microsoft came up with a new Power BI dashboard that helps companies gain insights on the productivity of their remote workers. The Business Continuity Dashboard for...
by Nikolai Pavlov | Apr 17, 2020 | Video
In this video, we will show you how to append multiple Excel files from one folder in Power BI using Power Query. Finance professionals regularly put together weekly and monthly reports. When a new month comes out, many still do it manually. They copy and paste the...
by Nikolai Pavlov | Apr 14, 2020 | Video
In this video, we will learn how to create relationships between tables as part of a data modeling process in Power BI. Many business users rely on Excel’s powerful VLOOKUP function to pull information from different tables and sheets. This is an important step before...
