Forecasting analysis in Power BI can be completed in quite an effective manner if you utilize the time intelligence functions in DAX effectively. In this example, I go through the many options you have available to automatically create a forecast in Power BI based on historical information. Your forecasts in a lot of cases will
If you want to have a real-world example scenario of forecasting using Power BI, you’re in the right page. You’ll find in this tutorial a forecasting technique that you can surely implement in your own work environment. In the example, I compare my actual results to my forecasts and look at them cumulatively. The cumulative
The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. ALLSELECTED DAX function is a derivative of the ALL functions. So there’s ALL, ALLSELECTED and ALLEXCEPT. They all do something similar, which is remove the context or filters. Here, we’ll focus on
I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact. This has great potential mostly because it paves the way for highly effective analysis. It also enables you to automate some of the insights that you
So we’re going to really dive into some problem-solving in this Power BI training. This is some really great stuff that you can do with Power BI, but if we just step back for a moment, the key here is, first of all, you’ve got to be able to think analytically. And that’s what I
