by Nikolai Pavlov | Jun 5, 2020 | Video
In this video, we discuss the calendar table in Power BI. When building a report in Power BI, it is recommended to create a calendar table. The calendar helps to better organize data and perform a more in-depth analysis using time-intelligence functions. In this...
by Nikolai Pavlov | May 27, 2020 | Video
In this video, we will discuss how to clean and format a sales table using Power Query. Bad data is a big pain for everyone. Data analysts spend most of their time cleaning data, as it rarely comes in the format they need. Power Query comes as a perfect solution to...
by Nikolai Pavlov | May 15, 2020 | Video
In this video, we discuss how to clean and transform financial data in Power BI using Power Query. Watch our short video to see how you can quickly transform financial data into a proper database format for further analysis: Finance professionals spend a lot of their...
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 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...