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 | News
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...
by Nikolai Pavlov | Apr 10, 2020 | Articles
Even before the start of the global COVID pandemic experts warned about an upcoming economic slowdown in 2020. Now with many countries in lockdown to contain the virus, the global economy is taking a hit. In such circumstances, companies should look closer at BI and...
