Month: August 2022

What is this delta lake thing?

Posted on by Annie D

You may be using a lake for your data and it may just be regular parquet files. In this video, Stijn joins us to explain why you should be using a delta lake instead and how this works in Azure Synapse Analytics.

Connect with Stijn
https://twitter.com/SQLStijn

What is Delta Lake
https://docs.microsoft.com/azure/synapse-analytics/spark/apache-spark-what-is-delta-lake

Delta Lake Documentation
https://docs.delta.io/latest/delta-intro.html

📢 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!
*******************

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

#AzureSynapse #DeltaLake #GuyInACube

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

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

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

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

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

Excel & Power BI Data Analysis Complete Class in One Video – 365 MECS 04

Posted on by Annie D

Download Excel Zipped Folder with all files: https://excelisfun.net/files/MECS04DownloadFiles.zip
Course taught by Excel MVP and Highline College Professor, Mike Girvin.
Topics in video:
1. (00:00) Introduction
2. (03:52) What is Data Analysis?
3. (04:37) Sorting and Filtering. Example 1 & 2
4. (13:24) FlashFill. Example 3.
5. (15:58) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4.
6. (20:25) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5.
7. (34:07) First look at Power Query’s Functional Language: M Code
8. (55:05) Power Query to Import and combine 12 tables into one Continue reading “Excel & Power BI Data Analysis Complete Class in One Video – 365 MECS 04” →

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

Excel Switch All Pivot Value Fields To Average or Max 2498

Posted on by Annie D

Jeremy asks Is there a way to select multiple headings and change all of their “Summarize value field by” at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once?

This episode shows some simple VBA to do this quickly.

How to create a personal macro workbook: https://www.youtube.com/watch?v=ld2SU2zJvHA

Table of Contents
(0:00) Welcome
(0:41) VBA
(1:55) Looping each field
(2:35) Copying for Sum, Max, Min
(3:10) Other calculations
(3:42) Easier way Continue reading “Excel Switch All Pivot Value Fields To Average or Max 2498” →

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