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

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”

Increase The Adoption Of Reports w/ Dynamic Commenting

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

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”

Excel Replace Is Breaking VLOOKUP – 2379

Rich needs to VLOOKUP into data with ” Total” after the tracking number.

When he tries to Replace ” Total” with “”, Excel converts the tracking numbers to scientific notation. When he tries to convert everything to numbers and I lose the last several digits when they change to 0000.

In today’s video, a new option in Microsoft 365 beta to prevent the conversion to scientific notation. And then a way to hack the VLOOKUP formula.

Table of Contents
(0:00) Copy subtotals in Excel
(0:36) Replace in Excel converts to Scientific Notation
(0:54) Long numbers in Excel last digits change to zero
(1:09) Beta option Continue reading “Excel Replace Is Breaking VLOOKUP – 2379”

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

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

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”

Embedding A Power App Directly Into Your Power BI Report

Session 4: Embedding A Power App Directly Into Your Power BI Report

When is it?
February 21st – 6pm Los Angeles (PST), 9pm New York (EST),
February 22nd – 2am London (GMT), 1pm Sydney (AEDT), 3pm 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 Tim Weinzapfel, Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to embed a Power App into a Power BI report and update data directly
• Create a very simple Power App automatically from a SharePoint List and add to your Continue reading “Embedding A Power App Directly Into Your Power BI Report”

Getting Started w/ Power BI Deployment Pipelines | Innovations In Power BI & Power Platform Summit

Session 3: Getting Started w/ Power BI Deployment Pipelines

When is it?
February 21st – 3pm Los Angeles (PST), 6pm New York (EST), 11pm London (GMT)
February 22nd – 10am Sydney (AEDT), 12pm 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 Akshata Revankar – Data Engineering Specialist, McKinsey & Company

During This Free Event, You Will:

• Use a CI/CD pipeline to automate the process of building, testing, and deploying the reports and dashboards
• Move content smoothly from Development/Test to QA to Production with Power BI Deployment Pipelines
• Learn Continue reading “Getting Started w/ Power BI Deployment Pipelines | Innovations In Power BI & Power Platform Summit”

Connecting The Military Community w/ Data Jobs | Innovations In Power BI & Power Platform Summit

Session 2: Connecting The Military Community w/ Data Jobs

When is it?
February 21st – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
February 22nd – 9am Sydney (AEDT), 11am 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 Chris Aragao, Certified Power BI Data Analyst Associate

During This Free Event, You Will:

• Connect to various data sources, including APIs, and retrieve, transform, and manipulate data in a variety of ways using M code
• Discover specific cleaning and modeling techniques to ensure data accuracy and reliability
Continue reading “Connecting The Military Community w/ Data Jobs | Innovations In Power BI & Power Platform Summit”

Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817

Download Excel File: https://excelisfun.net/files/EMT1817.xlsm

Learn about how take CSV Number Data like 12, 12, 12, 12 and add to get 48. See a Microsoft 365 formula and then an Excel Formula that will work in any version of Excel!
Topics:
1. (00:00) Introduction
2. (00:04) Goal of Video
3. (00:26) Microsoft 365 Formula: TEXTSPLIT and SUM
4. (01:23) Formula that works in any version: SUBSITUTUE function
5. (02:12) Excel 4.0 Macro Function and Macro Sheet
6. (03:09) EVALUATE function
7. (04:11) Relative Cell Reference in a Defined Name
8. (05:08) Closing, Video Links

#excelisfun #excel #excelformulas #freeclass #excelfunctions #addtext #freeclasses #freecourse Continue reading “Excel Formula to Add 12,12,12,12 from a cell to get 48!?!? Excel Magic Trick 1817”

Innovations At Enterprise DNA | Innovations In Power BI & Power Platform Summit

Session 1: Innovations At Enterprise DNA

When is it?
February 21st – 12pm Los Angeles (PST), 3pm New York (EST), 8pm London (GMT)
February 22nd – 7am Sydney (AEDT), 9am 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 Sam McKay, CEO & Founder of Enterprise DNA

During This Free Event, You Will:

• Learn more about eDNA will support your data skills development
• Hear about what upgrades have happened recently
• Learn what’s coming next!
• Understand how we are positioning ourselves for the future of data

If you have questions regarding Continue reading “Innovations At Enterprise DNA | Innovations In Power BI & Power Platform Summit”

Explore Joins In DAX With/Without Relationships | Innovations In Power BI & Power Platform Summit

Session 7: Explore Joins In DAX With/Without Relationships

When is it?
February 22nd – 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 Arpita Ghosh – Data Scientist

During This Free Event, You Will:

• Explore how to combine data from different tables with or without a relationship in DAX
• Use DAX to join tables that have relationships among them
• Learn the steps to join tables using DAX without a relationship
• Understand Continue reading “Explore Joins In DAX With/Without Relationships | Innovations In Power BI & Power Platform Summit”