Category: Power BI

Rethinking Dashboard Design – Creation Of An Analytics Hub | Business Intelligence Summit Session 7

Posted on by Annie D

Session 7: Rethinking Dashboard Design – Creation Of An Analytics Hub

When is it?
August 24th – 12am Los Angeles (PDT), 3am New York (EDT), 8am London (BST), 9am Bern (CEST), 5pm Sydney (AEST), 7pm Auckland (NZST)

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 Oscar Martinez Valero, PWC Manager of Business Intelligence

During This Free Event, You Will Learn:

• Understand the concept and anatomy of the Analytics Hub concept in Power BI
• Know the tools that support us in creating an Analytics Hub such as development of HTML Continue reading “Rethinking Dashboard Design – Creation Of An Analytics Hub | Business Intelligence Summit Session 7” →

Field Parameters Combined With Small Multiples In Power BI – An Amazing Combination

Posted on by Annie D

In this video, Sam is going to demonstrate such a cool technique in Power BI — field parameters overlaid by small multiples.

***** Video Details *****
00:00 Introduction
01:21 Measures used
01:59 Overview of visualization
02:20 Field parameter
03:40 Small multiples

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online Continue reading “Field Parameters Combined With Small Multiples In Power BI – An Amazing Combination” →

How To Translate Texts Using Python For Power BI

Posted on by Annie D

In this video, Gaelim is going to show how to perform language or texts translation using Python and pipe that over into Power BI. This is a cool technique that can make your reports a bit more interesting.

***** Video Details *****
00:00 Introduction
00:24 Data set
01:08 Transform data
02:35 Python script
07:46 Running the code
09:19 Other languages
09:48 Applying in Power BI

***** Related Links *****
Natural Language Processing Using TextBlob – https://thinkinfi.com/natural-language-processing-using-textblob/

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax Continue reading “How To Translate Texts Using Python For Power BI” →

🔴 Visualization Q&A – LIVE w/ Alberto Cairo (Sept 3, 2022)

Posted on by Annie D

Prioritizing questions around visualizations, design, etc…

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

Connect with Alberto Cairo:
https://twitter.com/AlbertoCairo
https://www.linkedin.com/in/albertocairo/
http://albertocairo.com/
http://www.thefunctionalart.com/

📢 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 Continue reading “🔴 Visualization Q&A – LIVE w/ Alberto Cairo (Sept 3, 2022)” →

Get creative with buttons in Power BI!

Posted on by Annie D

Want to know how to create a button in Power BI that has an icon along with text? Adam walks you through how to set this up and to have colors sync when interacting with it.

Get feedback from your Power BI report users!
https://www.youtube.com/watch?v=0WfITrMl0hc

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

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

#PowerBI #Buttons #GuyInACube

Enterprise DNA Challenge 21 Judging Of Entries – YouTube Data Analysis

Posted on by Annie D

We’ve recently wrapped up Enterprise DNA Challenge 21 and we’re excited to share the output that our participants have developed!

The objective for this challenge is to understand the Enterprise DNA TV channel’s audience better and have a strategy to drive more channel engagement. This is an Exploratory Data Analysis (EDA) where the participants were encouraged to explore the dataset and share what they think are the most important aspects of their findings.

In this video, watch as our panel of judges consisting of Enterprise DNA Experts Brian Julius and Mudassir Ali, Gustaw Dudek, and Solar Zhu share their insights and the Continue reading “Enterprise DNA Challenge 21 Judging Of Entries – YouTube Data Analysis” →

Refresh and NO DATA in my Power BI visuals???

Posted on by Annie D

Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you.

Troubleshooting refresh scenarios
https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

Data types in Power BI Desktop
https://docs.microsoft.com/power-bi/connect-data/desktop-data-types

Damu Venkatesan:
https://twitter.com/vdamu
https://www.linkedin.com/in/damuvenkatesan/

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

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

#PowerBI #Visuals #GuyInACube

How To Use Custom Grouping and Ranking In Power Query

Posted on by Annie D

You’ll most probably encounter data analysis requirements wherein you’ll need to group and rank values in order to show the needed insights and trends within your data set. In this video, Melissa is going to deal with a scenario that requires using custom grouping and ranking in Power Query.

***** Video Details *****
00:00 Introduction
00:22 Objective
01:01 Data set
01:14 Table.Partition
04:59 Table.AddRankColumn
07:08 Filter
08:24 Table.RemoveColumns
10:24 Combine tables

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – rel=”nofollow”>http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerQuery #PowerQueryTutorial #PowerBI #PowerBIDesktop #PowerBITutorial

Get started with SPARK in Azure Synapse Analytics

Posted on by Annie D

Using Spark in Azure Synapse Analytics opens up a lot of possibilities to work with your data. Venk joins us to get you started with setting it up and quickly using data.

Connect with Venk:
https://www.linkedin.com/in/venkatesh-titte-4907467/

Apache Spark in Azure Synapse Analytics
https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-overview

Azure Open Datasets
https://docs.microsoft.com/azure/open-datasets/dataset-catalog

📢 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
— rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

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

#AzureSynapse #Spark #GuyInACube

Upcoming Business Intelligence Summit 2022 – Our Biggest Event To Date!

Posted on by Annie D

We’ve gathered experts from across the globe from top authors and content creators, including 11 Microsoft MVPs, Enterprise Experts, and popular YouTube instructors sharing their expertise from various industries into one big event this coming August 24-26, 2022!

For this year’s Business Intelligence Summit, you get to attend 20+ sessions focused on innovative techniques in #DAX and #PowerQuery for 3 days absolutely FREE!

We’d like to thank our sponsors Microsoft, Zebra BI, Funnel, Numerro, Dataddo, novyPro, DevScope, Nova Silva, Acterys and Info River for supporting #BIS2022.

Register now!  https://bit.ly/3zrKqFj

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “Upcoming Business Intelligence Summit 2022 – Our Biggest Event To Date!” →

🔴 100th Power BI Q&A Live Stream!!! (August 20, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 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 Continue reading “🔴 100th Power BI Q&A Live Stream!!! (August 20, 2022) (Member Chat 2nd Half)” →

🔴 Power BI tips from the Pros – LIVE (August 13, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (August 13, 2022) (Member Chat 2nd Half)” →