Category: Business

How to Do Running Total Sum in Excel #shorts

Posted on by Annie D

Two ways to calculate a running total in Excel.
The first method is the sum of the cell in this row and the running total from above.
The second method is an expanding dynamic range.

This video answers these common search terms:
Calculate Cummulative Sum In Excel
Excel How To Do A Cumulative Sum
How To Add Cumulative Sum In Excel
How To Calculate A Cumulative Sum In Excel
How To Calculate A Running Sum In Excel Table
How To Caluclate A Cumulative Sum In Excel
How To Create A Cumulative Sum In Excel
How To Create A Running Sum On Excel
How To Create Excel Running Sum
How To Cumulative Sum Continue reading “How to Do Running Total Sum in Excel #shorts” →

How To Identify And Optimize Slow Power BI Visuals

Posted on by Annie D

It’s crucial to pinpoint slow visuals in Power BI as slow performance can lead to a poor user experience, frustration, and potentially missed opportunities. Slow visuals can result from various factors, such as the data source, the complexity of the query, or the visualization type.

By identifying and addressing slow visuals in Power BI, users can optimize the performance of their reports and dashboards, improving the user experience and ensuring accurate and timely decision-making. In this video, Brian demonstrates how you can identify slow Power BI visuals and optimize it. It sounds pretty simple but there’s more to it that Continue reading “How To Identify And Optimize Slow Power BI Visuals” →

Using Excel To Calculate Five Number Summary – 2571

Posted on by Annie D

The five-number summary in Excel is Min, first quartile, median, upper quartile and Max. This video shows three ways:
Method 1: Three formulas
Method 2: LET function
Method 3: LAMBDA function

This video answers these Search terms:
does excel already have a 5 number summaryy option
how do you obtain a five number summary in excel
how do you use excel to find 5 number summary
how to create a 5 number summary in excel
how to create a five number summary in excel
how to determine five number summary excel
how to do 5 number summary in excel
how to do a 5 number summary in excel
how to do a five Continue reading “Using Excel To Calculate Five Number Summary – 2571” →

Count Files in Folder Using Excel? Power Query!!! Excel Magic Trick # Short 01

Posted on by Annie D

Learn how to use Power Query in Excel to cynamically count how many files are in a folder and list file names in the worksheet.
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp,

Power Query Group By: Basic to Advanced. 10 Examples. 365 MECS Class 16

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/16-M365ExcelClassVideoFiles.zip
This video teaches how to use the Group By feature in Power Query. The 10 examples cover many helpful applications of how to use Group By for calculations and Data Analysis.
This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:32) What does Group By do?
3. (01:07) When to use Group By or other tools such as PivotTables
4. (01:44) Basics of Group By feature
5. (03:41) Table.Group Continue reading “Power Query Group By: Basic to Advanced. 10 Examples. 365 MECS Class 16” →

Excel Random No Repeats – Even Shorter for Microsoft 365 – Episode 2570

Posted on by Annie D

How to generate a random selection in Excel with no repeats.

Choose random names from the Data Set, but do it without repeating a namek. In a revisit to Episode #1471, how will Bill assure that there are no repeats in the Random selection? Follow along with Episode #2570 today to learn the answer and solve the challenge.

This video requires new Excel functions available in Microsoft 365. If you don’t yet have RANDARRAY, SORTBY, or SEQUENCE, then use the old method in video 1471: https://www.youtube.com/watch?v=g8FFgxmE70g

The PowerBall lotto formula shown near the end of the video is:
=TEXTJOIN(“, “,,SORT(TAKE(
SORTBY(SEQUENCE(69),RANDARRAY(69)),5)),”PB=”&RANDBETWEEN(1,26))

Table Continue reading “Excel Random No Repeats – Even Shorter for Microsoft 365 – Episode 2570” →

How To Take Over Data Gateways In Power BI

Posted on by Annie D

An on-premise data gateway is a tool in Power BI that allows users to securely connect their on-premise data sources to Power BI’s cloud-based services. The gateway acts as a bridge between the cloud-based Power BI service and the on-premise data sources, allowing data to flow securely and reliably between the two.

The benefits of using an on-premise data gateway include the ability to access and analyze on-premise data in real-time without having to move it to the cloud, as well as the ability to securely share that data with others within the organization. In this video, Greg is going to Continue reading “How To Take Over Data Gateways In Power BI” →

Excel Random No Repeats – Updated for Microsoft 365 – 2570

Posted on by Annie D

How to generate a random selection in Excel with no repeats.

Choose random names from the Data Set, but do it without repeating a namek. In a revisit to Episode #1471, how will Bill assure that there are no repeats in the Random selection? Follow along with Episode #2570 today to learn the answer and solve the challenge.

This video requires new Excel functions available in Microsoft 365. If you don’t yet have RANDARRAY, SORTBY, or SEQUENCE, then use the old method in video 1471: https://www.youtube.com/watch?v=g8FFgxmE70g

The PowerBall lotto formula shown near the end of the video is:
=TEXTJOIN(“, “,,SORT(INDEX(SORTBY(SEQUENCE(69),RANDARRAY(69)),
SEQUENCE(5))),”PB=”&RANDBETWEEN(1,26))

Table Continue reading “Excel Random No Repeats – Updated for Microsoft 365 – 2570” →

How do THIN reports work with Power BI Deployment Pipelines?

Posted on by Annie D

Using Power BI Deployment Pipelines and curious what happens when the report and dataset are in different workspaces? How does it work when you promote to another pipeline? Kevin Arnold shows us!

Kevin Arnold:
https://twitter.com/kevarnold
https://www.linkedin.com/in/kevarnold/

📢 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/
— <a href="https://guyinacube.com" Continue reading “How do THIN reports work with Power BI Deployment Pipelines?” →

How To Track Sales Trends Through Time In Power BI Using DAX [2023 Update]

Posted on by Annie D

Understanding how to track sales trends through time in Power BI is crucial for businesses as it helps them make data-driven decisions and identify opportunities for growth. By creating clear and intuitive visualizations, users can analyze sales trends and patterns more effectively.

Mastering this skill in Power BI can enable businesses to optimize their performance and maximize profitability. In this tutorial, Sam is going to showcase how you can track sales trends through time in Power BI using DAX.

*****Video Details*****
00:00 Introduction
02:10 Quarterly sales growth
03:35 Product growth
04:31 Conditional formatting
05:45 Monthly tracking
07:03 Other applications

***** Learning Power BI? *****
FREE COURSE – Ultimate Continue reading “How To Track Sales Trends Through Time In Power BI Using DAX [2023 Update]” →

Art of the Possible with Power Platform and Azure Synapse

Posted on by Annie D

What happens when you combine Power BI, Power Apps and Azure Synapse Analytics? MAGIC! Join Gaston Cruz as he shows a way to bring the Power Platform together with Azure Synapse!

Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/

📢 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/
— rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube