Top 5 Tips & Tricks For Planning, Budgeting and Forecasting in Power BI & Excel

Top 5 Tips & Tricks For Planning, Budgeting and Forecasting in Power BI & Excel In this blog I am covering learnings, tips, and trick from implementing planning, forecasting and budgeting systems with Power BI and modern Excel features. Tip 1: It Stands & Falls With The Data Model As with any aspect of corporate […]

Materialize Calculated Power BI Result Sets

Materialize and Synchronize Power BI with a Data Warehouse “Materialize” is a database concept that refers to storing the result of a query, often in conjunction with a SQL view. The advantage here is that when using the result set you can query stored values as opposed to having to run calculations with typically a […]