Category: Power BI

Track Changes Using Dimensions In Power Query | Business Intelligence Summit Session 6

Posted on by Annie D

Session 6: Track Changes Using Dimensions In Power Query

When is it?
August 23rd – 11pm Los Angeles (PDT)
August 24th – 2am New York (EDT), 7am London (BST), 4pm Sydney (AEST), 6pm 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 Cristian Angyal – Business Applications Manager, Flex

During This Free Event, You Will Learn:

• Showcase how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension
• Design in a precise way to facilitate tracking changes over time for Continue reading “Track Changes Using Dimensions In Power Query | Business Intelligence Summit Session 6” →

Learn To Visualise Using DAX Tricks In Power BI | Business Intelligence Summit Session 9

Posted on by Annie D

Session 9: Learn To Visualise Using DAX Tricks In Power BI

When is it?
August 24th – 2am Los Angeles (PDT), 5am New York (EDT), 10am London (BST), 7pm Sydney (AEST), 9pm 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 Pragati Jain (MVP), Senior Consultant at Avanade

During This Free Event, You Will Learn:

• Explore basic DAX expressions which will be use-case driven
• Learn how to add visualization capabilities using basic DAX expressions
• Discover how to add formatting tricks to visuals using DAX expressions
• Showcase problem statements Continue reading “Learn To Visualise Using DAX Tricks In Power BI | Business Intelligence Summit Session 9” →

Become A Power BI Power User With DAX | Business Intelligence Summit Session 8

Posted on by Annie D

Session 8: Become A Power BI Power User With DAX

When is it?
August 24th – 1am Los Angeles (PDT), 4am New York (EDT), 9am London (BST), 6pm Sydney (AEST), 8pm 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 Henk Vlootman (MVP), Founder & CEO of Quanto

During This Free Event, You Will Learn:

• Control the Query, Filter, and Row contexts to write DAX expressions
• Realize what you can achieve when you use the CALCULATE function to inject a filter context
• Learn how to do a calculated Continue reading “Become A Power BI Power User With DAX | Business Intelligence Summit Session 8” →

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