cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hidenseek9 Member
Member

How to forecast sales with Power BI

Power BI community,

 

I am wondering how to create sales forecast dashboard with Power BI.

I know it is capable of it, but not sure how to achieve this.

 

I want to show the final output to be in a monthly calendar format as below.

 

2018-01-30 15_08_22-A&P Master Dashboard_v2 - Power BI.png

 

First off, I have 3 different dataset.

  1. Actual figures (Historical Data)
  2. Current month data
  3. Year to go data

 

If the current month is July, then 1 would be Jan-June, 2 would be July and 3 would be Aug-Dec.

 

Please find below as the Power BI with sample data loaded in.

Sample Data

 

Here is what I would like to do.

  1. Using historical/actual data, I would like to forecast the volume for all the months in 3. Year to go data. (In the data I loaded, I have dummy volume numbers, but would be nice to forecast volume using 12 months seasonality)
    • Using Historical dataset in Sample Data.pbix, I would like Power BI to forecast the volume in Aug-Dec'18
  2. With the volume forecasted in number 1, I would like Power BI to calculate Gross Sales to Net Net Sales. (If you can show me a way to calculate First Commissions for example, then I will do the same process for the rest of the categories)
    • With the volume forecasted in 1, would like Power BI to forecast First Commissions. I will do the same for the rest of categories such as Second commissions.
  3. In current month, I have a data from Gross Sales to Invoiced Sales for all the days. With the trend in the month, I would like Power BI to calculate the volume to be achieved by the end of the month along with Gross Sales
    • With Current Month dataset in Sample Data.pbix, I would like Power BI to forecast the volume and Gross Sales to be achieved in the month. 
  4. With all the data forecasted from step 1-3 above, I would like to put all of them together in a calendar view as the screenshot above.

I understand that there are a lot of questions, but once someone can teach me how to do forecasting in Power BI,

I should be able to figure out the rest, maybe.

 

Appreciate your support in advance.

 

Many thanks,

 

H

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
stretcharm Senior Member
Senior Member

Re: How to forecast sales with Power BI

2 REPLIES 2
Highlighted
stretcharm Senior Member
Senior Member

Re: How to forecast sales with Power BI

hidenseek9 Member
Member

Re: How to forecast sales with Power BI

@stretcharm

 

Perfect!

Let me try and get back to you!

 

Many thanks,

 

H

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 257 members 2,764 guests
Please welcome our newest community members: