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...
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...
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...
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...
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...
