Category: Power BI

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

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

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

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

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

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

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

Offset Magic: Make DAX Time Intelligence Disappear | Business Intelligence Summit Session 15

Posted on by Annie D

Session 15: Offset Magic: Make DAX Time Intelligence Disappear

When is it?
August 24th – 4pm Los Angeles (PDT), 7pm New York (EDT)
August 25th – 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 Brian Julius, Chief Content Officer – Enterprise DNA

During This Free Event, You Will Learn:

• The theory behind offsets and how to generate them
• How offsets dramatically simplify DAX by rendering DAX time intelligence functions unnecessary
• How to use offsets to easily handle non-standard use cases such Continue reading “Offset Magic: Make DAX Time Intelligence Disappear | Business Intelligence Summit Session 15” →

How To Do Projection In Power Query/M Language

Posted on by Annie D

The field-access expression is used to select a value from a record or to “project” a record or table to one with fewer fields or columns, respectfully. In this tutorial, Melissa is going to delve into Projection in the Power Query/M Language, what it means, and how you can use it.

***** Video Details *****
00:00 Introduction
00:47 BaseRecord
01:50 Record.SelectFields
03:15 BaseTable
03:53 Table.SelectColumns

***** 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 Continue reading “How To Do Projection In Power Query/M Language” →

Everything About Power BI Security | Business Intelligence Summit Session 14

Posted on by Annie D

Session 14: Everything About Power BI Security

When is it?
August 24th – 3pm Los Angeles (PDT), 6pm New York (EDT), 11pm London (BST)
August 25th – 8am Sydney (AEST), 10am 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 Chris Wagner (MVP), Senior Finance Data Analytics Solutions Architect at Rockwell Automation

During This Free Event, You Will Learn:

• Workspace & App Security
• Dataflow & Dataset Security
• Report Security
• Row Level Security
• Object Level Security
• Internal & External Sharing

If you have questions regarding this training, please send it to Continue reading “Everything About Power BI Security | Business Intelligence Summit Session 14” →

Simulate Hierarchies with Field Parameters in Power BI

Posted on by Annie D

Struggling with field parameters and hierarchies in Power BI? They just don’t work! Patrick has an approach that looks to simulate hierarchies by using field parameters in this way.

Let report readers use field parameters to change visuals (preview)
https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters

📢 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/
— Continue reading “Simulate Hierarchies with Field Parameters in Power BI” →

Clean Your Data Like A Pro | Business Intelligence Summit Session 12

Posted on by Annie D

Session 12: Practical Power Query Solutions: Clean Your Data Like A Pro

When is it?
August 24th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
August 25th – 5am Sydney (AEST), 7am 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 Melissa de Korte, Enterprise DNA Expert

During This Free Event, You Will Learn:

• Explore common data cleaning scenarios.
• Use Power Query/ M effectively to prepare data for analysis.
• Built reusable solutions to make this task something to look forward to!
• Learn how to create Continue reading “Clean Your Data Like A Pro | Business Intelligence Summit Session 12” →