Having worked extensively with enterprise Business Intelligence tools for over twenty-five years, and with Microsoft Power BI, SQL Server Analysis Services (SSAS Multidimensional and Tabular) and Reporting Services (SSRS) since their respective inceptions, Bill Pearson has implemented enterprise Analysis and Reporting Systems within a wide variety of environments and industries. Bill is a career independent business intelligence architect at Island Technologies ®, where his extensive background in Finance, Accounting, and general business supports a practical and efficient approach to custom-fit analysis and reporting solutions that scale and adapt.
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.… Read more
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.… Read more
Quietly, Microsoft has been making radical improvements to Reporting Services; but precisely what was introduced, and when? We asked Bill Pearson, the well-known BI expert, to come up with a definitive survey of the more recent changes and how they help the user of Reporting Services. … Read more