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

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

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

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

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

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

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

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

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

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