Category: Power BI

Using Power Automate To Email Power BI Data As A CSV File

Posted on by Annie D

Session 23: Using Power Automate To Email Power BI Data As A CSV File

When is it?
February 23rd – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
February 24th – 8am Sydney (AEDT), 10am Auckland (NZDT)

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 Jarrett Moore – Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to setup and schedule a Power Automate flow using data from your Power BI Reports
• Know how to get DAX Query data from Power BI Desktop without Continue reading “Using Power Automate To Email Power BI Data As A CSV File” →

Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22

Posted on by Annie D

Session 22: Advanced SQL Skills For Data Analysts

When is it?
February 23rd – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
February 24th – 6am Sydney (AEDT), 8am Auckland (NZDT)

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 Kedeisha Bryan – Co-founder & Community Leader at Data in Motion LLC

During This Free Event, You Will:

• Simplify complex queries, break down complex calculations, or perform recursive queries using Common Table Expressions (CTEs)
• Perform calculations across a set of rows in a query result, without Continue reading “Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22” →

Harnessing The Power Of Dataverse – A Practical CRM Example

Posted on by Annie D

Session 15: Harnessing The Power Of Dataverse – A Practical CRM Example

When is it?
February 22nd – 8pm Los Angeles (PST), 11pm New York (EST)
February 23rd – 4am London (GMT), 3pm Sydney (AEDT), 5pm Auckland (NZDT)

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 Ben Clist – Business Analytics and Applications Manager, Napier Port

During This Free Event, You Will:

• Learn how you can utilise out of the box Dataverse functionality to quickly develop a CRM solution
• Ideal for small teams without the budget for Dynamics 365, Continue reading “Harnessing The Power Of Dataverse – A Practical CRM Example” →

How to get a CLOCK in your Power BI Report

Posted on by Annie D

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen!

Vega Clock Sample
https://vega.github.io/vega/examples/clock/

HTML Content Custom Visual Limitations
https://www.html-content.com/reference/limitations

Kerry Kolosko
https://kerrykolosko.com/exploring-deneb-for-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
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— <a Continue reading “How to get a CLOCK in your Power BI Report” →

Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX

Posted on by Annie D

Session 11: Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX

When is it?
February 22nd – 7am Los Angeles (PST), 10am New York (EST), 3pm London (GMT)
February 23rd – 2am Sydney (AEDT), 4am Auckland (NZDT)

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:

• Implement selected design techniques and chat formatting options to enhance overall user experience (UX)
• Choose strategic DAX applications to effectively communicate data insights through compelling data storytelling

If Continue reading “Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX” →

5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

Posted on by Annie D

Session 12: 5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

When is it?
February 22nd – 8am Los Angeles (PST), 11am New York (EST), 4pm London (GMT)
February 23rd – 3am Sydney (AEDT), 5am Auckland (NZDT)

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 Mara Periera – Founder & Principal Power BI Architect, Data Pears

During This Free Event, You Will:

• Understand the main factors that can influence the design and user experience of your Power BI reports
• Learn how Data Visualization techniques Continue reading “5 Report Design Tricks That Will Make Any Power BI Report Look Awesome” →

Collection Of Custom Visuals & Niche Techniques In Power BI

Posted on by Annie D

Session 16: Collection Of Custom Visuals & Niche Techniques In Power BI

When is it?
February 23rd – 12am Los Angeles (PST), 3am New York (EST), 8am London (GMT), 7pm Sydney (AEDT), 9pm Auckland (NZDT)

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 Injae Park – Senior Business Intelligence Developer, Objectivity

During This Free Event, You Will:

• Embed HTML, CSS, and JavaScript code directly into your report using HTML visuals
• Explore a wide range of options for customizing the appearance of your data visualizations with 1400+ Fonts Continue reading “Collection Of Custom Visuals & Niche Techniques In Power BI” →

What’s New & What’s Coming For Power BI | Innovations In Power BI & Power Platform Summit Session 14

Posted on by Annie D

Session 14: What’s New & What’s Coming For Power BI

When is it?
February 22nd – 10am Los Angeles (PST), 1pm New York (EST), 6pm London (GMT)
February 23rd – 5am Sydney (AEDT), 7am Auckland (NZDT)

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 Jay ter Heerdt – Microsoft, Senior Program Manager for Power BI

During This Free Event, You Will:

• Learn how the improved user experience in Power BI has made it easier to create and manage complex calculations
• Discover new and enhanced visualization options, improved collaboration Continue reading “What’s New & What’s Coming For Power BI | Innovations In Power BI & Power Platform Summit Session 14” →

Increase The Adoption Of Reports w/ Dynamic Commenting

Posted on by Annie D

Session 8: Increase The Adoption Of Reports w/ Dynamic Commenting

When is it?
February 22nd – 3am Los Angeles (PST), 6am New York (EST), 11am London (GMT), 10pm Sydney (AEDT)
February 23rd – 12am Auckland (NZDT)

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 Wilco Nagtzaam & Pieter Jan de Vries, KPN

During This Free Event, You Will:

• Learn to integrate a Power App with Power BI to create a user-friendly dynamic commenting system for your reports
• Allow real-time collaboration and commenting on reports and enable users to add, Continue reading “Increase The Adoption Of Reports w/ Dynamic Commenting” →

The A to Z Of Data Visualization | Innovations In Power BI & Power Platform Summit Session 9

Posted on by Annie D

Session 9: The A to Z Of Data Visualization

When is it?
February 22nd – 4am Los Angeles (PST), 7am New York (EST), 12pm London (GMT), 11pm Sydney (AEDT)
February 23rd – 1am Auckland (NZDT)

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 Juan-Pierre Louw – Microsoft Power Platform & Data Visualization Enthusiast

During This Free Event, You Will:

• The A to Z framework provides a step-by-step approach for beginners to implement data visualization effectively
• Enhance Power BI Visualization with easy techniques
• Get a clear understanding of the data that Continue reading “The A to Z Of Data Visualization | Innovations In Power BI & Power Platform Summit Session 9” →

Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI

Posted on by Annie D

Session 10: Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI

When is it?
February 22nd – 5am Los Angeles (PST), 8am New York (EST), 1pm London (GMT)
February 23rd – 12am Sydney (AEDT), 2am Auckland (NZDT)

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 Kenny Geyskens – Creator of 3DBI, The 3D Visual For Power BI

During This Free Event, You Will:

• Create 3D models suitable for visualizing them in the custom 3DBI visual for Power BI
• Bring derived data from 3D Continue reading “Bring Spatial Insight To Your Data By Combining It w/ 3D Models In Power BI” →

Checking out the Window Clause in Azure SQL and SQL Server 2022

Posted on by Annie D

Partitioning is nice in SQL, but how about using the WINDOW clause to make it more efficient? Patrick looks at how to use this function with Azure SQL and SQL Server 2022!

SELECT – WINDOW – (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16

📢 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/
— <a href="https://guyinacube.com" Continue reading “Checking out the Window Clause in Azure SQL and SQL Server 2022” →