Category: Power BI

A new way to manage gateways in Power BI!!!

Posted on by Annie D

We now have a new way to manage gateways within Power BI and it is a much-welcomed update! Adam walks you through the experience to get you ready for it!

New data source and gateway management experience
https://powerbi.microsoft.com/blog/new-data-source-and-gateway-management-experience/

📢 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 “A new way to manage gateways in Power BI!!!” →

The Importance Of Utilizing Unstructured Data With Kirk Marple

Posted on by Annie D

Data are not all created equal. There are structured (machine-generated) and unstructured (human-generated) data, and each requires a different approach. As a result of the increased use of digital applications and services, unstructured information is growing rapidly. It is estimated that 80-90% of company data is unstructured, and the amount of unstructured data continues to grow at an alarming rate per year.

In this episode of The Analytic Mind Podcast, Sam McKay speaks with Kirk Marple, the founder, and CEO of Unstruk Data. Hear about the hidden value in unstructured data and how it impacts the future of data and analytics.

The Continue reading “The Importance Of Utilizing Unstructured Data With Kirk Marple” →

Another 30-Day Query Folding challenge!!!

Posted on by Annie D

Here is another 30-day Query Folding challenge video for you. Patrick takes on Day 7 and ramps up his Power Query knowledge! Will Power BI Desktop get the best of him???

GitHub Repot: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY

📢 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 Continue reading “Another 30-Day Query Folding challenge!!!” →

What Visual Filter Type To Use In Your Power BI Report

Posted on by Annie D

In this video, Reid talks about the types of interactions that visuals and other objects in a Power BI report page can have between each other, and the ways that they can cross-filter each other. He’ll also share some use cases as to why you might want to apply one type vs another, or even disable it entirely.

***** Video Details *****
00:00 Introduction
00:33 Default interactions
01:18 Cross-highlighting
01:42 Disabling
02:00 Cross-filtering
03:01 Report settings

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – 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 Continue reading “What Visual Filter Type To Use In Your Power BI Report” →

Are you following best practices with Azure Synapse Analytics?

Posted on by Annie D

How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It’s a great way to get an understanding where your database is at!

Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-analyzer-report-to-monitor-and-improve-azure/ba-p/3276960

Download Location:
https://github.com/microsoft/synapse-analyzer/tree/main/Synapse%20BPA%20Report

Maximizing rowgroup quality for columnstore indexes in dedicated SQL pool
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression

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

🎓 Continue reading “Are you following best practices with Azure Synapse Analytics?” →

Enterprise DNA Challenge 19 Judging Of Entries – Winners Announcement

Posted on by Annie D

In this video, we’re revealing the winners of Enterprise DNA Challenge 19 and show how the judging process to our Data Challenges typically goes. Brian, Federico, Alex and Sam give a walkthrough of the five winning entries for Challenge 19 where they share the criteria they apply when judging, their thoughts on what they liked about the reports and what they think it can still improve on.

Check out the rest of Challenge 19 entries in the Enterprise DNA Forum: https://forum.enterprisedna.co/t/challenge-19-call-centres-data-reporting/23987/

***** Video Details *****
00:00 Introduction
04:10 Categories
05:41 Report #1
13:18 Report #2
19:27 Report #3
31:52 Report #4
35:00 Report #5

***** Learning Continue reading “Enterprise DNA Challenge 19 Judging Of Entries – Winners Announcement” →

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

DAX Editor Pro – NEW Addition To Enterprise DNA Power Tools!

Posted on by Annie D

We’re ecstatic to announce the release of a new addition to Enterprise DNA Power tools — the DAX Editor Pro! DAX Editor Pro is a full-featured, lightweight replacement for the featureless native Power BI DAX editor.

In line with this, Brian is initiating a new weekly series that will go in-depth into each of the five tools within this suite, demonstrating how he uses them in his real-world report and Data Challenge entry development to show how it can dramatically speed up the report development process and add key functionality that Power BI has been missing for years.

The Enterprise DNA Power Continue reading “DAX Editor Pro – NEW Addition To Enterprise DNA Power Tools!” →

How do you share your Power BI Dataset for someone to review?

Posted on by Annie D

Need to have someone review your Power BI dataset for best practices and approval? Don’t want to send them the full Power BI Desktop file and risk sharing data? Patrick walks you through some options that you have.

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

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Dataset #GuyInACube

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