Month: August 2022

Four New Excel Features Debut!

Posted on by Annie D

Wyn’s book for shipment to USA:
https://mrexcel.e-junkie.com/product/1750249/Power-BI-for-the-Excel-Data-Analyst-Print-Book-to-USA-Only

This video covers six exciting things:
1) The Show Changes feature which had been in Excel Online is now in Desktop Excel
2) Data Validation partial matching is working again
3) There is a new look for Excel Options
4) A new IMAGE function comes to Excel to display an image
5) Wyn Hopkin’s new Power BI for the Excel Analyst book… it drops on November 1, but I have 3 cases to ship now…. US only.
6) The 14 functions for text and array manipulation are coming to general availability.

Table of Contents
(0:00) Four new features today
(0:54) Show Continue reading “Four New Excel Features Debut!” →

Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?

Posted on by Annie D

You have different options in Power BI when it comes to slicers and filters. Just put the slicer on the report, use a slicer panel or have them in the filter pane. But which one is faster??? Patrick explores a few scenarios to think about!

Should you hide the filter pane in Power BI?
https://greyskullanalytics.com/should-you-hide-the-filter-pane-in-power-bi/

📢 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
— <a Continue reading “Slicers vs. Slicer Pane vs. Filter Pane! Which is faster?” →

DAX Counterculture: Alternative Perspectives on DAX | Business Intelligence Summit Session 23

Posted on by Annie D

Session 23: DAX Counterculture: Alternative Perspectives on DAX

When is it?
August 25th – 4pm Los Angeles (PDT), 7pm New York (EDT)
August 26th – 12am London (BST), 9am Sydney (AEST), 11am 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 Greg Deckler (MVP), VP at Fusion Alliance

During This Free Event, You Will Learn:

• Showcase effective ways when and when not to use CALCULATE
• Determine when not to use Time Intelligence functions (always)
• Learn how to loop in DAX efficiently
• See how to use the greatly maligned EARLIER Continue reading “DAX Counterculture: Alternative Perspectives on DAX | Business Intelligence Summit Session 23” →

The Ultimate Power BI Freestyle Session | Business Intelligence Summit Session 24

Posted on by Annie D

Session 24: The Ultimate Power BI Freestyle Session

When is it?
August 25th – 8pm Los Angeles (PDT), 11pm New York (EDT)
August 26th -4am London (BST), 1pm Sydney (AEST), 3pm 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 Sam McKay, Founder & CEO of Enterprise DNA

During This Free Event, You Will Learn:

• Build a comprehensive and compelling Power BI report within an hour from scratch!
• Learn how to use our automation tools and techniques in your own workflow
• See how much easier Power BI can be Continue reading “The Ultimate Power BI Freestyle Session | Business Intelligence Summit Session 24” →

🔴 DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)

Posted on by Annie D

Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, 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 SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training Continue reading “🔴 DAX Studio 3 is out! LIVE w/ Marco Russo (Aug 27, 2022)” →

Teaching About Data Visualization Thru Humor | Business Intelligence Summit Session 20

Posted on by Annie D

Session 20: Teaching About Data Visualization Thru Humor

When is it?
August 25th – 7am Los Angeles (PDT), 9am Peru (PET), 10am New York (EDT), 3pm London (BST)
August 26th – 12am Sydney (AEST), 2am 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 Carlos Barboza, Guerilla Data Analyst

During This Free Event, You Will Learn:

• The importance on reading about data visualization theory
• Compare and contrast the positives and negatives in visuals
• The benefits of Zebra BI visuals for Power BI reports
• Knowing more DAX for hacking Power Continue reading “Teaching About Data Visualization Thru Humor | Business Intelligence Summit Session 20” →

Row-Level-Security Hacks | Business Intelligence Summit Session 22

Posted on by Annie D

Session 22: Row-Level-Security Hacks

When is it?
August 25th – 10am Los Angeles (PDT), 1pm New York (EDT), 6pm London (BST)
August 26th – 3am Sydney (AEST), 5am 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 Pascal Kiefer, Founder of BI Samurai

During This Free Event, You Will Learn:

• Implement some creative Row-Level-Security techniques effectively
• Discover how to allow drill-down only for certain users
• Learn how to dynamically anonymize data
• Other creative ways to use Row-Level-Security

If you have questions regarding this training, please send it to <a href="https://forum.enterprisedna.co/" Continue reading “Row-Level-Security Hacks | Business Intelligence Summit Session 22” →

Advanced Data Modeling & DAX Techniques | Business Intelligence Summit Session 21

Posted on by Annie D

Session 21: Advanced Data Modeling & DAX Techniques

When is it?
August 25th – 8am Los Angeles (PDT), 11am New York (EDT), 4pm London (BST)
August 26th – 1am Sydney (AEST), 3am 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 Thomas Martens (MVP), Solution Architect – Munich Re

During This Free Event, You Will Learn:

• Learn how to answer questions faster that come with the event-in-progress and the previous value challenge
• Discover advanced data modeling and DAX techniques to speed up DAX query execution
• Know how the vertipaq Continue reading “Advanced Data Modeling & DAX Techniques | Business Intelligence Summit Session 21” →

Using DAX To Unlock Potential Of Data Visualization | Business Intelligence Summit Session 19

Posted on by Annie D

Session 19: Using DAX To Unlock Potential Of Data Visualization

When is it?
August 25th – 6am Los Angeles (PDT), 9am New York (EDT), 2pm London (BST), 11pm Sydney (AEST)
August 26th – 1am 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 Gustaw Dudek, Enterprise DNA Expert

During This Free Event, You Will Learn:

• Discover sample DAX techniques that enhance business insights
• Review the possibilities of field parameters
• Explore DAX formulas to leverage conditional formatting options

If you have questions regarding this training, please send it to <a href="https://forum.enterprisedna.co/" Continue reading “Using DAX To Unlock Potential Of Data Visualization | Business Intelligence Summit Session 19” →

Power Query Going Back To Basics | Business Intelligence Summit Session 17

Posted on by Annie D

Session 17: Power Query Going Back To Basics

When is it?
August 25th – 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 Miguel Felix (MVP), Business Intelligence Specialist, DevScope

During This Free Event, You Will Learn:

• Learn the basics of data types in Power Query
• Showcase how to build custom functions
• Explore the use of EACH function
• Debugging code with TRY OTHERWISE
• Utilize some helpful hints on Power Query

If you have questions Continue reading “Power Query Going Back To Basics | Business Intelligence Summit Session 17” →

CALCULATE Deep Dive | Business Intelligence Summit Session 16

Posted on by Annie D

Session 16: CALCULATE Deep Dive

When is it?
August 24th – 10pm Los Angeles (PDT)
August 25th – 1am New York (EDT), 6am London (BST), 3pm Sydney (AEST), 5pm 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 Antriksh Sharma, Enterprise DNA Expert

During This Free Event, You Will Learn:

• Learn how to establish an order of evaluation in CALCULATE parameters
• Understand the difference between table functions and CALCULATE modifiers and how to use them correctly
• Evaluate a table expression in the context of a FILTER/CALCULATETABLE
• Observe how context Continue reading “CALCULATE Deep Dive | Business Intelligence Summit Session 16” →

Machine Learning In Power BI | Business Intelligence Summit Session 18

Posted on by Annie D

Session 18: Machine Learning In Power BI

When is it?
August 25th – 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 Leon Gordon (MVP), Partner at Pomerol Partners

During This Free Event, You Will Learn:

• What is Machine Learning (ML)
• How to use Automated Machine Learning to identify sales leads likely to convert using Power BI Premium and PPU
• Know how to integrate Python with Power BI
• Showcase how to identify sales Continue reading “Machine Learning In Power BI | Business Intelligence Summit Session 18” →