Why Every Finance Professional Should Learn Power BI (not just Excel)
Discover how Power BI helps Finance professionals automate reports, boost efficiency and uncover deeper business insights beyond Excel
Tag Power BI
Power BI Solves the Business Continuity Problem
The business continuity problem is what happens when key spreadsheets that drive business critical reports are maintained by individual employees and then the issues that follow when those employees are out of the business. Power BI can solve this problem!
What is Power BI and How Does It Work?
What is Power BI and How Does It Work? So the big question then…what is Power BI? That’s what we’re answering in this article, so that you can start to understand what it does and how it works and why…
What is an Implicit Measure in Power BI and Excel?
What Is An Implicit Measure in Power BI and Excel? An implicit measure is an aggregating calculation like a SUM or COUNT that is automatically (or implicitly!) calculated by Power BI or PivotTables in Excel. Understanding implicit measures is a…
How to fix a merge in Power Query
Why Is My Power BI Merge Not Working? Merging in Power Query, whether in Excel or Power BI, is one of the core skills for your average data transformationalist (is that a word?!) In essence, the purpose of a merge…
What’s the big advantage in using the Sharepoint Folder connector in Power BI?
1 BIG reason to use the Sharepoint Folder connection in Power BI What’s the main advantage to using the Sharepoint Folder connector in Power BI? BUSINESS CONTINUITY. The ability for essential reporting to carry on in a business while key…
How to bypass the Excel row limit
How can I bypass the Excel row limit of 1,048,576 rows Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value…
You must be logged in to post a comment.