by Joseph Sorrenti | Sep 18, 2018 | PowerPivotPro
A common accounting task is to consolidate the financial results of subsidiary companies into combined results of a parent company. A parent company can have one or multiple subsidiaries. Each subsidiary can also have one or multiple subsidiaries beneath it.… This...
by Gaston Cruz | Sep 13, 2018 | PowerPivotPro
In this article, I will describe different approaches regarding definitions concerning BI governance. In different projects and real-world experiences implementing Corporate BI regarding deployments, environments and decisions regarding reports and panels distribution...
by Narayana Windenberger | Sep 11, 2018 | PowerPivotPro
How often do you think about quality checking your reports? Sounds about as fun as listening to a lecture from Ferris Bueller’s professor, right? Why Test? Quality testing is one of those things that few of us enjoy but is… This post first appeared...
by Matthew Mowrey | Sep 4, 2018 | PowerPivotPro
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper. When… This post first appeared...
by Hanna Vessey | Aug 30, 2018 | PowerPivotPro
I wanted to share my experience more as a thank you than as a technique to share. About a year ago, I moved into a new role in health care as a clinical performance analyst. My previous experience easily qualified… This post first appeared...
by Ryan Bergstrom | Aug 28, 2018 | PowerPivotPro
Recently I was teaching a private course on Power BI to one of our clients. We were learning about the ALL() function and how to use it to get % of total calculations. After demonstrating how to get an individual… This post first appeared...
