Month: August 2022

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

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

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

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

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

The (M)agic of List.Generate | Business Intelligence Summit Session 11

Posted on by Annie D

Session 11: The (M)agic of List.Generate

When is it?
August 24th – 9am Los Angeles (PDT), 12pm New York (EDT), 5pm London (BST)
August 25th – 2am Sydney (AEST), 4am 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 Rick de Groot (MVP), Founder of BI Gorilla

During This Free Event, You Will Learn:

• What does List.Generate do?
• Use cases where List.Generate proves useful
• Working with a single variable
• Incorporating multiple variables within the function
• Return transformed lists or partial results

If you have questions regarding this training, please send Continue reading “The (M)agic of List.Generate | Business Intelligence Summit Session 11” →

Developing Data Models In The Real World | Business Intelligence Summit Session 12

Posted on by Annie D

Session 12: Developing Data Models In The Real World

When is it?
August 24th – 11am Los Angeles (PDT), 2pm New York (EDT), 7pm London (BST)
August 25th – 4am Sydney (AEST), 6am 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 James Andrew, Founder of Matador Software

During This Free Event, You Will Learn:

• Discover the foundations of Data Modelling in Power BI and Power Query as well as the benefits by referring to techniques such as the Kimball methodology
• Understand how to prepare your Data in Power Continue reading “Developing Data Models In The Real World | Business Intelligence Summit Session 12” →

Let’s Merge Queries To Improve The Tabular Model | Business Intelligence Summit Session 14

Posted on by Annie D

Session 14: Let’s Merge Queries To Improve The Tabular Model

When is it?
August 24th – 1pm Los Angeles (PDT), 4pm New York (EDT), 9pm London (BST)
August 25th – 6am Sydney (AEST), 8am 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 Ana María Bisbé York (MVP), Business Intelligence Consultant

During This Free Event, You Will Learn:

• This session will demo several scenarios in which Combining queries could be the perfect solution for the optimal tabular model
• Learn how to combine queries to protect the fact tables in Continue reading “Let’s Merge Queries To Improve The Tabular Model | Business Intelligence Summit Session 14” →

Power Query: Refencing Vs. Duplicating Queries | Business Intelligence Summit Session 3

Posted on by Annie D

Session 3: Power Query: Refencing Vs. Duplicating Queries

When is it?
August 23rd – 6pm Los Angeles (PDT), 9pm New York (EDT)
August 24th – 2am London (BST), 11am Sydney (AEST), 1pm 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 Oz Du Soleil (MVP), Founder of Excel on Fire

During This Free Event, You Will Learn:

• Showcase the importance of referencing a query
• Learn and understand how to duplicate a query effectively
• Discuss the difference between referencing vs. duplicating
• Know the techniques how to be strategic in your Continue reading “Power Query: Refencing Vs. Duplicating Queries | Business Intelligence Summit Session 3” →

Next Level Field Parameters | Business Intelligence Summit Session 4

Posted on by Annie D

Session 4: Next Level Field Parameters

When is it?
August 23rd – 8pm Los Angeles (PDT), 11pm New York (EDT)
August 24th – 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 Kane Snyder, Principal Consultant at Agile Analytics

During This Free Event, You Will Learn:

• Use field parameters to implement complex slicer interactions
• Filter your model with field parameters to restrict the data visible with different columns used in visuals
• Calculation Groups and Field Parameters: When to use each and where Continue reading “Next Level Field Parameters | Business Intelligence Summit Session 4” →

How To Use Excel To Build & Validate Complex DAX | Business Intelligence Summit Session 5

Posted on by Annie D

Session 5: How To Use Excel To Build & Validate Complex DAX

When is it?
August 23rd – 10pm Los Angeles (PDT)
August 24th – 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 Chandeep Chhabra, Founder of Goodly

During This Free Event, You Will Learn:

• Know how to form DAX logic by creating Excel rough work
• Discover how to visualize and solve complex DAX problems using Excel
• Learn to debug and validate calculations using Excel

If you have Continue reading “How To Use Excel To Build & Validate Complex DAX | Business Intelligence Summit Session 5” →

KEYNOTE: eDNA’s New Framework For Power BI | Business Intelligence Summit Session 1

Posted on by Annie D

Session 1: KEYNOTE: eDNA’s New Framework For Power BI

When is it?
August 23rd – 2pm Los Angeles (PDT), 5pm New York (EDT), 10pm London (BST)
August 24th – 7am Sydney (AEST), 9am 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:

• Discover how eDNA has updated our Power BI development and implementation frameworks
• Learn how our new platform and tools empower fast and effective development
• Review all new features from new empowerment Continue reading “KEYNOTE: eDNA’s New Framework For Power BI | Business Intelligence Summit Session 1” →