Month: May 2022

Practical Power Query Solutions Nested Structured Values (Part 1)

Posted on by Annie D

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 2nd – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 3rd – 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 – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions Nested Structured Values (Part 1)” →

Writing your first SQL Statement!

Posted on by Annie D

New to writing T-SQL? Patrick walks you through your first SQL statement. Great foundation to have when working with SQL Server or Azure Synapse Analytics!

Download SQL Server Management Studio
https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms

Download and install Azure Data Studio
https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

Transact-SQL Reference (Database Engine)
https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

Learn how you can become an Azure Synapse Influencer: http://aka.ms/synapseinfluencers

📢 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/

#PowerBI #GuyInACube

Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1792.xlsx
Learn how to create a report that lists a unique list of case sensitive items with the frequency for each.
Learn how to create an Expandable Range in a Spilled Array Formula:
1. (00:00) Introduction
2. (00:49) Power Query Solution. Learn that Power Query is case sensitive by default and that the Group By feature makes the task easy.
3. (02:04) Dynamic Spilled Array Formula Solution. See the powerful Array Functions: BYROW, LAMBDA, LET, VSATCK, HSTACK, INDEX and more.
4. (05:45) Expandable Range in a Spilled Array Formula using BYROW, LAMBDA and INDEX functions.
5. (11:04) Test Solution with Continue reading “Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792” →

[Breakout Session 4] Member Case Studies | Reporting & Data Visualization Summit

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit/

[Breakout Session 4] Member Case Studies (Member-Only)

When is it?
May 24th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
May 25th – 5am Sydney (AEST), 7am Auckland (NZST)

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

If you have questions regarding this training, please send it to http://forum.enterprisedna.co/

#PowerBI #DataVisualization #eDNASummitMay2022 #EnterpriseDNAEvents

How To Use Power Automate To Create Adaptive Cards In Microsoft Teams

Posted on by Annie D

Adaptive cards are a great way to create shortcuts within Teams, and ask for more input. They are usually the bridge between a Teams message and an underlying Power Automate workflow. In this video, Henry shows how to use Adaptive Cards to create “add task” shortcuts within Teams. Once you have the basics down, you can use Adaptive Cards for anything! 

***** Video Details *****
00:00 Introduction
00:33 What is an Adaptive Card
01:12 Test card
02:55 New flow
03:38 Creating an Adaptive Card
05:11 Adding a task
06:57 Test run

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>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://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerAutomate #PowerAutomateTutorial #AdaptiveCards #MicrosoftTeams #PowerBI #PowerBIDesktop #PowerBITutorial

REPLAY Power BI tips from the Pros – LIVE (Mar 19, 2022)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 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

📢 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (Mar 19, 2022)” →

Excel To Schedule Prison Haircuts Only On Saturday – 2484

Posted on by Annie D

This video is all about the Excel function for WORKDAY.INTL. It allows you to make sure that you are always scheduling an event to occur on a Saturday, or Tues/Thurs or Friday.
The secret here is the alternate syntax for the Weekend argument.
Table of Contents
(0:00) Find a particular Saturday in Excel
(0:25) WORKDAY introduction
(1:37) Find a particular Saturday in Excel
(2:32) Find the next Tuesday
(5:02) Find next Tuesday or Thursday
(5:46) Handling holidays
(6:58) Wrap-up

[Breakout Session 9] Build Your Power BI Portfolio | Reporting & Data Visualization Summit

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit/

[Breakout Session 9] Build Your Power BI Portfolio (Member-Only)

When is it?
May 26th – 6pm Los Angeles (PDT), 9pm New York (EDT)
May 27th – 2am London (BST), 11am Sydney (AEST), 1pm Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Ahmed Khodir – Founder of novyPro

If you have questions regarding this training, please send it to http://forum.enterprisedna.co/

#PowerBI #DataVisualization #eDNASummitMay2022 #EnterpriseDNAEvents

Reduce the queries being sent with Incremental Refresh in Power BI!

Posted on by Annie D

Have you noticed some extra queries being sent when using Incremental Refresh in Power BI? Patrick explains why this could happen and a potential workaround.

Privacy Levels:
https://docs.microsoft.com/power-bi/enterprise/desktop-privacy-levels

📢 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/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – <a Continue reading “Reduce the queries being sent with Incremental Refresh in Power BI!” →

Beyond Buttons: More Than Meets The Eye | Reporting & Data Visualization Summit

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit-free/

Session 28: Beyond Buttons: More Than Meets The Eye

When is it?
May 26th – 3pm Los Angeles (PDT), 6pm New York (EDT), 11pm London (BST)
May 27th – 8am Sydney (AEST), 10am Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Reid Havens (MVP), BI Evangelist & Instructor

During This Free Training, You Will Learn:

• Inventive Hover Effects
• Creating Sliding Toggle Buttons
• Using Buttons as Visualizations
• Adding Button Animations
• Designing an (Always Visible) Focus Mode Button

If you have questions regarding this training, please send it Continue reading “Beyond Buttons: More Than Meets The Eye | Reporting & Data Visualization Summit” →

Marketing Your Data Analytics Skills As An Analytics Architect with Reid Havens

Posted on by Annie D

Data analytics skills are in high demand. Increasingly, companies are hiring data analytics skills not just to conduct research and generate reports, but also to act as thought leaders who will help companies gain a competitive edge by leveraging their skills strategically. No matter how experienced you are in data analytics, there are many marketing strategies you can implement as a data architect. You can demonstrate your value to employers by staying up-to-date on the latest technological innovations.

Sam McKay interviews Reid Havens, the founder of Havens Consulting Inc. and a Microsoft Most Valuable Professional (MVP). You can learn about his Continue reading “Marketing Your Data Analytics Skills As An Analytics Architect with Reid Havens” →