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 Continue reading “How To Create A Forecast Model In Power BI With Python”

Excel Array Formulas & Functions: 50 Examples of How to Become an Array Expert! – 365 MECS 09

Download Excel file: https://excelisfun.net/files/09-M365ExcelClass.xlsx
Download pdf notes: https://excelisfun.net/files/09-M365ExcelClass.pdf
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (00:33) Review Topics
3. (01:06) Review of pdf notes!!!!
4. (02:15) Array Formula Fundamentals: 10 Examples and lots of Terms, Definitions, and Types
5. (23:08) Two Main Reasons to use Array Formulas:
6. (23:08) 1) Array Formulas Make Things Easy (Budget and Investment Examples)
7. (27:55) 2) Array Formulas Help Make Compact Solutions (Finance and Budget Examples)
8. (34:26) SUMPRODUCT function (Total Sales and Grading Examples)
9. (38:21) List of ALL Array Continue reading “Excel Array Formulas & Functions: 50 Examples of How to Become an Array Expert! – 365 MECS 09”

Group Dates In Pivot Table When Blanks – 2530

Lasma wants her pivot table to group daily dates up to months and years. But she has some empty rows and the Group Field is greyed out.

In this video:
Surprise! Microsoft 365 now allows blanks in the date field and you can still group.
Solution 1: Fill blank date fields with 2199 December 31
Solution 2: Add your own Year and Month fields to the data set
And, a warning from Debra Dalgleish at Contextures: if you mix dates and text, the Group Field will still be greyed out.

Table of Contents
(0:00) Pivot Group Dates with Blanks
(0:15) Fix from Excel Team
(1:10) Select empty date cells
(2:09) Continue reading “Group Dates In Pivot Table When Blanks – 2530”

Data Modelling – The 3 Steps Methodology | Industries Analytics & Applications Summit Session 16

Session 16: Data Modelling – The 3 Steps Methodology

When is it?
November 17th – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
November 18th – 6am Sydney (AEDT), 8am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Federico Pastor – Head of Platform Experience, Enterprise DNA

During This Free Event, You Will:

• Understand in-depth data modelling techniques through well established procedures
• Achieve ultimate flexibility for expansion of data points and better insights
• Generate different versions of analytics workflows with a single dataset
• Encapsulate the Continue reading “Data Modelling – The 3 Steps Methodology | Industries Analytics & Applications Summit Session 16”

Impossible Totals | Industries Analytics & Applications Summit Session 17

Session 17: Impossible Totals

When is it?
November 17th – 12pm Los Angeles (PST), 3pm New York (EST), 8pm London (GMT)
November 18th – 7am Sydney (AEDT), 9am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Greg Deckler (MVP) – Vice President at Fusion Alliance

During This Free Event, You Will:

• Self-service visualization creates extremely challenging issues for measures and particularly measure totals
• Know some things that are impossible to do in Power BI
• While you can’t solve impossible problems, there are things you can do to help Continue reading “Impossible Totals | Industries Analytics & Applications Summit Session 17”

Solve Problems w/ Power Query | Industries Analytics & Applications Summit Session 18

Session 18: Solve Problems w/ Power Query

When is it?
November 17th – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
November 18th – 8am Sydney (AEDT), 10am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Chris Aragao – Program Analyst (Data Analytics) at U.S. EPA Office of Inspector General

During This Free Event, You Will:

• Apply the Power Query best practices on your data model
• Learn how query folding and training resources power up data manipulation and data shaping to run smoothly
• Understand how Continue reading “Solve Problems w/ Power Query | Industries Analytics & Applications Summit Session 18”

Practical RPA For Shared Services Using Power Automate | Industries Analytics & Applications Summit

Session 19: Practical RPA For Shared Services Using Power Automate

When is it?
November 17th – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
November 18th – 9am Sydney (AEDT), 11am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Daniel Harley – BI Ninja & FP&A Professional

During This Free Event, You Will:

• Identify the right processes to automate with Power Automate
• Create efficiency in your business processes through the specific components of Power Automate Flows
• Discover Excel instance and how to run Continue reading “Practical RPA For Shared Services Using Power Automate | Industries Analytics & Applications Summit”

Visualizing Future Energy Transition Trends | Industries Analytics & Applications Summit Session 20

Session 20: Visualizing Future Energy Transition Trends

When is it?
November 17th – 5pm Los Angeles (PST), 8pm New York (EST)
November 18th – 1am London (GMT), 12pm Sydney (AEDT), 2pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Gerard Duggan – Associate Project Manager at KBR, Inc.

During This Free Event, You Will:

• Identify key markets and opportunities in the energy and resource sectors
• Monitor and report trends from various aspects related with energy and resource projects
• Achieve more efficiency in energy operations by leveraging Power Continue reading “Visualizing Future Energy Transition Trends | Industries Analytics & Applications Summit Session 20”

Maximising DAX Formula Patterns | Industries Analytics & Applications Summit Session 21

Session 21: Maximising DAX Formula Patterns

When is it?
November 17th – 6pm Los Angeles (PST), 9pm New York (EST)
November 18th – 2am London (GMT), 1pm Sydney (AEDT), 3pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Sam McKay, Founder & CEO of Enterprise DNA

During This Free Event, You Will:

• Learn how to use patterns of formulas to quickly find insights
• Patterns are data neutral, learn how to re-use them over and over again
• Advanced insights are not difficult when using code repositories. Check out how Continue reading “Maximising DAX Formula Patterns | Industries Analytics & Applications Summit Session 21”

Writing some DAX while looking at Relationships

Ever struggle with writing DAX and having to flip between the report view and the model view in Power BI Desktop? The struggle was real! Patrick shows you a new update that overcomes this!

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Check out my Continue reading “Writing some DAX while looking at Relationships”

Integrating Microsoft 365 w/ Power Platform | Industries Analytics & Applications Summit Session 7

Session 7: Integrating Microsoft 365 w/ Power Platform

When is it?
November 16th – 10am Los Angeles (PST), 1pm New York (EST), 6pm London (GMT)
November 17th – 5am Sydney (AEDT), 7am Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Cristian Angyal – Business Applications Manager, Flex

During This Free Event, You Will:

• Integrate Microsoft Forms with Power Automate to streamline data driven processes
• Integrate Power Apps and Power Automate with SharePoint
• Analyze data from SharePoint using Power BI
• Integrate the report with Teams to get a full Continue reading “Integrating Microsoft 365 w/ Power Platform | Industries Analytics & Applications Summit Session 7”

Using Power BI w/ Sharepoint Document Libraries | Industries Analytics & Applications Summit

Session 12: Using Power BI w/ Sharepoint Document Libraries

When is it?
November 16th – 4pm Los Angeles (PST), 7pm New York (EST)
November 17th – 12am London (GMT), 11am Sydney (AEDT), 1pm Auckland (NZDT)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Tim Weinzapfel – Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to connect Power BI with your SharePoint Document Library to gain access to the complete list of documents
• Embed URL links in your Power BI report to access SharePoint documents right from your Continue reading “Using Power BI w/ Sharepoint Document Libraries | Industries Analytics & Applications Summit”