Need some suggestions on the Sales dashboard(beginner level)

[vijay89]

Hi All,

I have created some dashboards in order to analyze the following steps but need to have some better understanding of how to use Sales predictive analytics and if someone could correct me with my dashboards.

Is there any way I can attach my dashboard/worksheet here? 

I couldn't see any option to attach my dashboard to this forum.

[v-jianhe-msft]

Hi,

The forecasting feature utilizes built-in predictive forecasting models to automatically detect the step (monthly/weekly/annually) and seasonality in your data to provide forecasting results.

When you add a forecast line, you will have two sets of options available to configure. You can control the styling of the forecasting, similar to the controls you have for trend lines. You can also control settings specific to forecasting.

For the predictive analysis feature, you could refer to Using the Analytics pane in Power BI Desktop, Predict your milestones with forecasting in Power BI Desktop, Data Forecasting and Analytics with Power BI Desktop.

Also, to upload pbix demo, you could upload and share the sample files with some file hosting services like OneDrive, Dropbox etc.

Best Regards,

Henry

[vijay89]

Thanks Henry for the information. I will surely check it out.

I have attached the .pbix file link https://1drv.ms/u/s!ApyHNYIp5fUYaijeL_j6Kv64Fa8 for the dashboard I have created.

It would be great if experts like you could review and correct me. I tried predective analysis as well but got an error saying the "data is not consistent".

Thank you! 

[v-jianhe-msft]

Hi,

Thank you for your reply. I have to say it is a really nice report you made! 

For the error "data is not consistent". I think it is because of your original datasource. To use the predictive analysis feature, there is some requirement on the data source, for example, to satisfy some algorithm, the data should be consistent and no interrupt. So it may be required to modify the datasource for data continunity. 

Best Regards,

Henry 

[vijay89]

Hi Henry,

I understand your point. I know that the data is not consistent and the error was sepcific to date being inconsistent.

So, if you could help me drive one forecast graph using the data from my .pbix file will be great. I am a begineer, so your guidance with steps will be of great help.

Thank you!