Hi @gutolima8168, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!
will this forecast auto refresh after the new data is added in published PBI service? since the python code runs in local env. Do I need to run this locally and update the dashboard?
If auto-refresh is important, consider moving the Python process to an external ETL pipeline that updates your data source. Then, you can set the dataset to refresh in the Power BI Service automatically.
Hi Shereen, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers! Sign up here: app.enterprisedna.co/sign-up
Hi Ada, Thank for watching our video and taking your time to post it. We’re not entirely sure for your specifc case because we can't see the actual data. But you can keep the date simple mm-dd-yyyy in your xlsx to avoid having to do a lot of transformations. Hoping you find this useful! If you haven't yet, you can subscribe to our TH-cam channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA
Check out our FREE courses: bit.ly/3N00AJw
totally delivered title's promise in a simple way. good job.
Hi @gutolima8168, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!
Very much useful with real time project work...Really Appreciate
Personally I like to use xgboost when I do regression like this but I've never even heard of the model you used I'll have to do some research.
How can we choose the right forecast model that fit our business?
will this forecast auto refresh after the new data is added in published PBI service? since the python code runs in local env. Do I need to run this locally and update the dashboard?
I think we would need to refresh locally and publish again
If auto-refresh is important, consider moving the Python process to an external ETL pipeline that updates your data source. Then, you can set the dataset to refresh in the Power BI Service automatically.
@@MrJunaidtayyab Thank you for getting back to me. It helps a lot !
where can I get the excel file you're using in this video
Hi, I signed up and have been trying to find the source of dataset but can't find it. can you please help me. thank you
What is the source for forecast table where we run the python script
Hi Shereen, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers!
Sign up here: app.enterprisedna.co/sign-up
how are your dates formatted in your .xlsx? I keep getting a weird Y axis of years instead of my cost.
Hi Ada,
Thank for watching our video and taking your time to post it.
We’re not entirely sure for your specifc case because we can't see the actual data. But you can keep the date simple mm-dd-yyyy in your xlsx to avoid having to do a lot of transformations.
Hoping you find this useful! If you haven't yet, you can subscribe to our TH-cam channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
AttributeError: 'function' object has no attribute 'forecast'
I always get hate comments if I say first but I won’t answer my hate comments
# 'dataset holds the input data for this script
df = dataset
import pandas as pd
df['Date'] = pd.to_datetime(df['Date'])
ts = df.set index ('Date')
ts =ts.asfreq('d')
from statsmodels.tsa.holtwinters import ExponentialSmoothing
train = ts.iloc[:290]
test =ts.iloc [290:]
model = ExponentialSmoothing(train, trend= 'mul', seasonal= 'mul'‚seasonal_periods=7).fit ()
forecast = pd. Dataframe(model, forecast (30))
forecast = forecast.reset_index()
forecast.columns= ['Date', 'pageviews']