Month: March 2023

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

Excel Shortcut To Unhide Columns Not Working – 2569

Posted on by Annie D

One of these four shortcut keys stops working in Windows versions of Excel:
Ctrl+9 to hide rows
Ctrl+Shift+9 to Unhide rows
Ctrl+0 to hide columns
Ctrl+Shift+0 to unhide columns
If the last one is not working for you, it is because the Windows shortcut to switch language is assigned to Ctrl+Shift. This video shows the Control Panel setting to make Ctrl+Shift+0 or Ctrl+Shift+) start unhiding columns again.

Evaluating New Customer Sales – Advanced Analytics in Power BI [2023 Update]

Posted on by Annie D

Understanding the sales breakdown between new and steady customers is crucial to gain valuable insights into your business’s performance. It helps you identify which customer segment is driving revenue growth and which needs attention.

By utilizing advanced Power BI analytics, you can achieve this breakdown and unleash endless analysis potential to optimize your business strategy and maximize profitability. In this tutorial, Sam will show how you can effectively and dynamically evaluate new customer sales.

*****Video Details*****
00:00 Introduction
00:54 The objectives
02:24 Identifying new customers
04:20 New customer sales
07:44 Percentage of new customer sales

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “Evaluating New Customer Sales – Advanced Analytics in Power BI [2023 Update]” →

How To Use A Decision Tree To Predict Classes In Power BI Using Python

Posted on by Annie D

A decision tree is a data mining technique used in Power BI to visualize a sequence of decisions and its possible outcomes. It helps users understand the factors that affect a specific outcome and identify the most effective decision path.

By learning how to use decision trees in Power BI, users can make more informed and data-driven decisions that lead to better business outcomes. In this video, Gaelim is going to demonstrate how to use a decision tree classifier to help distinguish between 2-3 types of classes.

*****Video Details*****
00:00 Introduction
00:33 Case scenario
03:54 Data set
04:38 Bringing in data
05:35 Decision tree
06:58 Python script

***** Continue reading “How To Use A Decision Tree To Predict Classes In Power BI Using Python” →

7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/15-M365ExcelClassVideoFiles.zip
This video teaches how to use the 7 types of Joins when you use Merge in Power Query. Many easy to understand examples.
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:19) Defined the 7 types of Merge Joins in Power Query
3. (02:48) Accessing Merge Join in Excel, Power BI Desktop or Dataflows
4. (03:02) Files for Power BI example
5. (03:17) MUST use Queries NOT Excel Continue reading “7 Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15” →

How To Use Conditional Formatting Based On Strings Fields – Power BI February 2023 Updates

Posted on by Annie D

In this video, Brian is going to share one of the new features in the Power BI February 2023 Updates — the Conditional Formatting Based On String Fields. This new feature has been added to allow users to set conditional formatting rules based on string fields, which was highly requested. This new capability can be accessed through the formatting pane dialog, allowing for conditional formatting of column chart colors, among other things. Watch as Brian demo this new feature.

*****Video Details*****
00:00 Introduction
01:06 Data set
01:34 Conditional formatting
02:35 Field value
03:34 Advantages in using SWITCH TRUE
05:29 Text operators
05:58 Complex conditions
06:23 Dynamic highlighting of outliers
08:04 Continue reading “How To Use Conditional Formatting Based On Strings Fields – Power BI February 2023 Updates” →

Why Is Excel Advanced Filter Using Partial Matching 2388

Posted on by Annie D

Today’s question from Bill.
Did you know that Excel’s Advanced Filter is returning partial matches?
A phrase in the criteria range is treated as Phrase*.
This is an annoying problem.

Excel Help sort of alludes to this problem and suggests a formula in the criteria range of Advanced Filter. But if you try to automate the creation of those formulas in the criteria range, it does not work.

In this video, a convoluted set of steps to automate formula creation with a carat in place of the equals sign, then Replace to change the text into a formula. This allows the Advanced Filter to work.

This Continue reading “Why Is Excel Advanced Filter Using Partial Matching 2388” →