Category: Power BI

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” →

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

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” →

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” →

How To Create Tables By Combining UNION and ROW Functions In Power BI [2023 Update]

Posted on by Annie D

In this tutorial, Sam will show how you can use Power BI’s ROW and UNION functions to create tables. This flexible technique can be used with user input or imported calculations to create dynamic tables. The approach allows you to hard-code results or automatically update tables based on changes in the underlying data. With this technique, you can create custom tables to meet your specific needs and easily visualize data in new ways.

*****Video Details*****
00:00 Introduction
01:27 Using ROW to create a sorting table
02:40 Combining ROW with UNION
05:02 Segmenting customers
05:40 Virtual table
09:08 Filtering the dates table
10:11 Conclusion

***** Learning Power BI? Continue reading “How To Create Tables By Combining UNION and ROW Functions In Power BI [2023 Update]” →

Dataset permissions required for App report in Power BI? What am I missing??? (Re-Upload)

Posted on by Annie D

Struggling with Power BI App permissions when using shared datasets? Adam looks at how this works. Even for PRO users!!!

Composit model permission blog (Older information):
https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/

📢 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 Tools page – rel=”nofollow”>https://guyinacube.com/tools/

#PowerBI #Permissions #GuyInACube

The POWER of Microsoft Lists and Power BI

Posted on by Annie D

Learn how Microsoft Lists / SharePoint Lists can take advantage of Power BI! Daniel walks through how easy it is to start using today!

Create a report quickly from a SharePoint list or library
https://learn.microsoft.com/power-bi/create-reports/service-quick-create-sharepoint-list

Daniel Glenn:
https://twitter.com/DanielGlenn
https://www.linkedin.com/in/danielglenn/
https://365mcs.com/
https://www.youtube.com/365mcs

📢 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
— Continue reading “The POWER of Microsoft Lists and Power BI” →

How To Create Deneb IBCS-style Performance Visual In Power BI

Posted on by Annie D

Using IBCS-style performance visuals in Power BI can improve communication by using clear and concise visualizations to convey performance data, making it easier for viewers to understand key metrics and identify trends. This can lead to more informed decision-making and better business outcomes. In this tutorial, Greg shows how to create IBCS-style Performance Visual using Deneb/Vega-Lite in Power BI.

*****Video Details*****
00:00 Introduction
00:50 IBCS features
02:00 Target visual
03:38 Current Year vs Previous Year
10:50 Variance amounts
24:06 Variance percent
29:20 Legend
31:40 Final visual
41:20 Summary

*****Related Links*****
Enterprise DNA Deneb Showcases – https://forum.enterprisedna.co/c/deneb-showcase/58​
IBCS-style Performance Visual DENEB Template and Power BI file – rel=”nofollow”>https://forum.enterprisedna.co/t/deneb-template-ibcs-performance-visual/31534​
DENEB website – https://deneb-viz.github.io/​
Vega-Lite website – https://vega.github.io/vega-lite/​
IBCS website – https://www.ibcs.com/

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events

#EnterpriseDNA #Deneb #DenebTutorial #VegaLite #VegaLiteTutorial #IBCS #PowerBI #PowerBIDesktop #PowerBITutorial

Creating Dynamic Outlier Trigger Points – Advanced Power BI Analysis Technique [2023]

Posted on by Annie D

Creating outlier trigger points dynamically in Power BI provides increased flexibility in adjusting the threshold for identifying outliers based on different scenarios and business needs, as opposed to using a static number. This allows for more accurate and relevant outlier detection, which can lead to better insights and decision-making. In this tutorial, Sam will demonstrate how you can create dynamic outlier trigger points in Power BI.

VIEW FULL WORKSHOP HERE – https://www.youtube.com/live/uG32PtbWfTI?feature=share

*****Video Details*****
00:00 Introduction
02:23 The goal
03:05 Sales grouping
03:30 Dynamic non-outlier sales
04:20 Parameters
06:24 Changing static formulas to dynamic
07:20 Displaying the dynamic outliers

***** Learning Power BI? *****
FREE COURSE – Continue reading “Creating Dynamic Outlier Trigger Points – Advanced Power BI Analysis Technique [2023]” →