From the course: Time Series Modeling in Excel, R, and Power BI
Join today to access over 24,800 courses taught by industry experts.
Power BI modeling
From the course: Time Series Modeling in Excel, R, and Power BI
Power BI modeling
- [Instructor] We can also run time series models in Power BI through its built-in modeling and visualization capabilities, as well as through R code, we can integrate into the application through Power Query, or within the R standard data visualization. And Power BI desktop, let's create a data model by first importing our data through the Power Query editor. Let's select the initial data connector for the web option. Now let's copy the URL for the raw data for the monthly weather from GitHub. We'll then paste it into our web connector URL. Once we select to transform the data, we see that because we're automatically connecting to a CSV file, it reads that way in Power Query. We can then transform it as needed within the query editor. There's a lot that we can do in Power Query, but for our model, let's first remove all the columns except Date and TAVG, by holding down the control key to select both of them, then right clicking…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.