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 7, 2020 | Articles
In this article, we look at Power Query Editor, a data management and transformation tool in Excel and Power BI. Microsoft Excel is a legendary tool used in many organizations across the world. Companies of all kinds and sizes rely on the spreadsheet software to...
by Nikolai Pavlov | Mar 29, 2020 | Articles
In this article, we look at Visual Planner, a custom Power BI visual from Power ON. The Visual Planner solution provides direct write-back from Power BI to a database. This visual single-handedly turns Power BI into the best planning and forecasting tool in the...
by Nikolai Pavlov | Feb 16, 2020 | News
Gartner recognized Microsoft Power BI as the leader in its 2020 Magic Quadrant for Analytics and Business Intelligence (BI) platforms. In the Magic Quadrant report, Gartner evaluates the strengths and weaknesses of 22 most significant providers of BI and analytics in...
