How To Create A Forecast Model In Power BI With Python

In this tutorial, Gaelim is going to show how you can make a forecast model in Power BI using Python. You can utilize the Power BI forecasting feature, which allows you to visually forecast the data you have to as specific day but it will have its limitations. With Python, you can optimize the model a bit more by changing the additive nature of the trend and seasonality, and add predictions into the data set.
**** Video Details ****
00:00 Introduction
00:28 Forecasting samples
00:49 Power BI limitations
01:30 Trend analysis
02:18 Python code
07:22 Power BI implementation
08:10 Python script
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - www.enterprisedna.co/power-bi-...
FREE - 60 Page DAX Reference Guide Download - www.enterprisedna.co/dax-form...
Enterprise DNA Membership - www.enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - www.enterprisedna.co/enterpri...
#EnterpriseDNA #Python #PythonTutorial #PythonForPowerBI #PowerBI #PowerBIDesktop #PowerBITutorial #MachineLearning

[@EnterpriseDNA]

Check out our FREE courses: bit.ly/3N00AJw

[@one_life9294]

Very much useful with real time project work...Really Appreciate

[@gutolima8168]

totally delivered title's promise in a simple way. good job.

[@EnterpriseDNA]

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!

[@Kim-bn4ub]

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

[@dylanarmstrong9328]

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.

[@beccabruner]

how are your dates formatted in your .xlsx? I keep getting a weird Y axis of years instead of my cost.

[@EnterpriseDNA]

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 RUclips 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

[@shereenfathima41]

What is the source for forecast table where we run the python script

[@EnterpriseDNA]

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

[@aosreelakshmi9296]

AttributeError: 'function' object has no attribute 'forecast'

[@Digitalcircus185]

I always get hate comments if I say first but I won’t answer my hate comments

[@RILZ756]

# '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']