Category: Power BI

🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)

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 “🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)” →

Building an Automated Machine Learning Platform For Better Data Culture With Shashank Kalanithi

Posted on by Annie D

Data is among the most valuable resources in an organization, and data analysts extract insights from said data to make smart business decisions. Analysts, however, can only work so fast. To extend the capabilities of Shashank’s team of data analysts, they developed a proof-of-concept based on machine learning to automate the analytics process and significantly accelerate the generation of actionable insights.

Shashank Kalanithi is a Senior Data Analyst at Nordstrom in Seattle, Washington, United States. In this episode, you’ll hear about his journey to becoming a Data Analyst despite having a Chemistry degree, his role on the Nordstrom Strategic Analytics Continue reading “Building an Automated Machine Learning Platform For Better Data Culture With Shashank Kalanithi” →

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Posted on by Annie D

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion!

DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/

Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

📢 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
— Continue reading “Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???” →

How To User Chat Functions In Power Automate

Posted on by Annie D

Did you know you can use Power Automate to create chat functions and bots within Teams? In this video, Henry shows you how you can mix Power Automate with Teams to create workflows that trigger every time a message is sent. If the message asks for specific information (like customer details), Power Automate returns those details for you – talk about Automation!  

***** Video Details *****
00:00 Introduction
00:42 Use case
03:35 Trigger
04:15 Message details
05:06 Parsing JSON object
09:12 Condition statement
09:33 Setting a variable

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Continue reading “How To User Chat Functions In Power Automate” →

How to make SQL Pools even faster in Azure Synapse Analytics

Posted on by Annie D

There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools.

Performance tuning with materialized views using dedicated SQL pool in Azure Synapse Analytics
https://docs.microsoft.com/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning

📢 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!
*******************

— <a Continue reading “How to make SQL Pools even faster in Azure Synapse Analytics” →

A Visual Revolution Building a Scorecard Instantly w/ InfoRiver

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/a-visual-revolution-building-a-scorecard-instantly-with-inforiver-may-2022-registration/

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

When is it?
May 12th – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (BST)
May 13th – 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:

• Create everything from custom P&L reports to advanced scorecard dashboards with in-line visualizations in a matter of minutes using InfoRiver
• Discover the key points how to reduce development time from hours or days to minutes
• Showcase the newly Continue reading “A Visual Revolution Building a Scorecard Instantly w/ InfoRiver” →

How To Use MultiIndex In Pandas For Hierarchical Data

Posted on by Annie D

MultiIndex is a multi-level or hierarchical object for Pandas that allows you to select more than one row and column in your index. It also enables you to create sophisticated data analysis and manipulation, especially for working with higher dimensional data. In this video, George is going to explore the MultiIndex feature of Pandas.

***** Video Details *****
00:00 Introduction
00:22 Index hierarchy
00:46 Data set
01:44 Index 1
01:57 Index 2
02:34 Index 3
03:05 Index 4-5
03:43 Index 6
04:10 Index 7
04:50 Index 8
05:15 Index 9
05:46 Recap

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Continue reading “How To Use MultiIndex In Pandas For Hierarchical Data” →

REPLAY Power BI tips from the Pros – LIVE (May 7, 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 (May 7, 2022)” →

How To Correctly Count Slicer Selections In Power BI

Posted on by Annie D

In today’s tutorial, Brian works through a subtle issue with slicers that can trip you up if you’re not careful. As an added bonus, he has also included a sneak preview of a fantastic new external tool created exclusively for Enterprise DNA members by Microsoft MVP, Greg Deckler, that we will be rolling out next week.

***** Video Details *****
00:00 Introduction
01:44 DAX Editor Pro
02:00 Basic Count
03:20 The problem
04:45 Correct Count
05:06 ISFILTERED
12:50 Test run

***** Related Links *****
eDNA Power Tools – https://enterprisedna.co/tech/power-tools/

***** 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 #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #DaxEditorPro

How to Create the Perfect Mobile Report Using HTML Custom Visuals

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/how-to-create-the-perfect-mobile-report-using-html-custom-visuals-may-2022-registration/

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

When is it?
May 5th – 2pm Los Angeles (PDT), 5pm New York (EDT), 10pm London (BST)
May 6th – 7am Sydney (AEST), 9am Auckland (NZST)

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

Who’s doing it?
Presented by Pascal Kiefer – CEO & BI Consultant, K Team Solutions

During This Free Training, You Will Learn:

• Know the basics and considerations in creating mobile report
• Discover the key points how to scale the elements so they fit perfectly on a mobile screen
• Learn tips and tricks to design your very Continue reading “How to Create the Perfect Mobile Report Using HTML Custom Visuals” →

EFFICIENT approach in Microsoft Teams for Power BI questions!

Posted on by Annie D

Using Microsoft Teams? Have a central place for your Power BI folks in your organization? This efficient approach will help you to get your question to the right people! At the same time cutting down the noise for other folks.

Steve Campbell
https://twitter.com/PowerBISteve
https://www.linkedin.com/in/powerbisteve/

Power BI Support Channel: Microsoft Teams Tips
https://powerbi.tips/2022/04/power-bi-support-channel-in-teams/

Power BI adoption roadmap
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-overview

Power BI implementation planning
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-introduction

Manage tags in Microsoft Teams
https://docs.microsoft.com/en-us/microsoftteams/manage-tags

📢 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 Continue reading “EFFICIENT approach in Microsoft Teams for Power BI questions!” →

My Excel file is in the cloud! Why isn’t refresh working in Power BI???

Posted on by Annie D

Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get it working.

📢 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 – Continue reading “My Excel file is in the cloud! Why isn’t refresh working in Power BI???” →