Category: Power BI

Overcoming a concatenation challenge in Azure Synapse

Posted on by Annie D

Using PySpark in Azure Synapse Analytics and found that my regular way of concatenating two strings in T-SQL didn’t work. I figured out what you need to do to make this work.

📢 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 “Overcoming a concatenation challenge in Azure Synapse” →

Getting Started With ‘What If’ Parameters – Scenario Analysis Techniques [2022 Update]

Posted on by Annie D

In this tutorial, Sam deep dives onto the key things to think about and implement when using ‘what if’ parameters in Power BI. There are certain tips and techniques you can utilize that will enable a prediction type analysis with Power BI. You’ll be amazed at what you can achieve when you set up your models and calculations correctly for this type of analysis.

***** Video Details *****
00:00 Introduction
03:05 Creating a sample Demand Scenario
03:30 Creating a sample Pricing Scenario
05:01 Using Iterating functions in What If analysis
07:25 Bookmarking scenarios

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI Continue reading “Getting Started With ‘What If’ Parameters – Scenario Analysis Techniques [2022 Update]” →

How To Easily Decompose Time Series Data In Power BI And Python

Posted on by Annie D

In this tutorial, Gaelim is going to show how you can break down time series data into essential components. Using a time series decomposition method will help you find a better way to describe data when you try to describe trends, seasonality or unexpected events, and is a great stepping stone for forecasting.

***** Video Details *****
00:00 Introduction
00:45 Types of graphs
02:50 Dataset
03:15 Python script
05:30 Seasonal decompose
05:54 Creating visual within data
06:40 Seasonality
08:46 Residual
09:14 Not resetting index
10:08 Trend

***** 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 Continue reading “How To Easily Decompose Time Series Data In Power BI And Python” →

Microsoft PL-300 Certification – New Course!

Posted on by Annie D

Being an effective Power BI data analyst involves supporting different functions within organizations. Learn vital technical skills that a Power BI data analyst should have and ace the Microsoft Power BI Data Analyst PL-300 exam with a complete training guide in our newest course!

Watch as Brian introduces this new course developed by long-time Microsoft certified trainer and recently awarded Microsoft Innovative Educator, Ilgar Zarbaliyev. Learn what are the benefits in getting certified, how the course is structured, and what you can take away from this new course.

Know more here: https://www.enterprisedna.co/upcoming-courses/

***** Video Details *****
00:00 Introduction
01:24 Igar’s background
03:29 Benefits of certification
06:25 Continue reading “Microsoft PL-300 Certification – New Course!” →

‘What If’ Sensitivity Analysis In Power BI Using DAX – Advanced Technique [2022 Update]

Posted on by Annie D

In this video, Sam how you can runs a scenario analysis not just to find binary outcomes, but running advanced sensitivity analysis across all potential ’What If’ outcomes. There are seriously so many ways this can be implemented and execute across a range of data scenarios. Watch and learn to see how you can apply this.

***** Video Details *****
00:00 Introduction
01:22 Optimising Scenarios
04:01 Running Sensitivity Analysis
06:46 Other Elements For Further Analysis
07:48 Conclusion

***** 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 – Continue reading “‘What If’ Sensitivity Analysis In Power BI Using DAX – Advanced Technique [2022 Update]” →

A Power Query feature you may not know about!

Posted on by Annie D

We thought everyone knew about this Power Query capability! At the Power Platform Conference, we found that many did not. Well, we want to help make sure everyone is aware so that you can reuse your awesome Power Query work in Power BI or Excel!

📢 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 “A Power Query feature you may not know about!” →

How To Use COALESCE In Power Query / M

Posted on by Annie D

In this video, Melissa will demonstrate how to implement the Power Query/M Language operator, COALESCE, by examining two practical problems. The goal is to filter our all strings that don’t consist of two words.

***** Video Details *****
00:00 Introduction
01:27 Example 1
04:00 Example 2

***** 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
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – Continue reading “How To Use COALESCE In Power Query / M” →

Where do you add that new column in any analytics tool?

Posted on by Annie D

You need to add a new column in Power BI – or any business analytics tool. Where do you add the column? Is there a cost to that? Matthew Roche explains his thoughts on his maxim that has everyone talking!

Connect with Matthew Roche
Twitter: https://twitter.com/SQLAllFather
LinkedIn: https://www.linkedin.com/in/matthewroche/
Blog: https://ssbipolar.com/

Roche’s Maxim of Data Transformation
https://ssbipolar.com/2021/05/31/roches-maxim/

Matthew’s career journey:
The Unplanned Career – 25 years in tech without a 3-year plan
https://www.youtube.com/watch?v=CKOAIp9TTvQ

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses Continue reading “Where do you add that new column in any analytics tool?” →

Enterprise DNA Challenge Speed Build | Power Platform Innovation Labs Session 8

Posted on by Annie D

Session 8: Enterprise DNA Challenge Speed Build

When is it?
October 5th – 7pm Los Angeles (PDT), 10pm New York (EDT)
October 6th – 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 Sam McKay, CEO & Founder of Enterprise DNA

During This Free Training, You Will Learn:

• Watch live as we work through a real world challenge submission
• Learn speed techniques for Power BI development
• Learn how to use templates for every part of your Power BI report building workflow
• Create compelling Power BI Continue reading “Enterprise DNA Challenge Speed Build | Power Platform Innovation Labs Session 8” →

The Oft-Overlooked Pillar Of Effective Power BI Reporting | Power Platform Innovation Labs Session 7

Posted on by Annie D

Session 7: The Oft-Overlooked Pillar Of Effective Power BI Reporting

When is it?
October 5th – 2pm Los Angeles (PDT), 5pm New York (EDT),
10pm London (BST)
October 6th – 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 Brian Julius – Chief Content Officer, Enterprise DNA

During This Free Training, You Will Learn:

• What is a Data Analysis Plan?

• Where does it fit in the Power BI development framework?

• What are the benefits of Exploratory Data Analysis and Analysis Planning?

• How do we effectively Continue reading “The Oft-Overlooked Pillar Of Effective Power BI Reporting | Power Platform Innovation Labs Session 7” →

Report Winners – Tips & Tricks | Power Platform Innovation Labs Session 6

Posted on by Annie D

Session 6: Report Winners – Tips & Tricks

When is it?
October 5th – 11am Los Angeles (PDT), 2pm New York (EDT), 7pm London (BST)
October 6th – 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 Federico Pastor – Head of Data Challenges, Enterprise DNA and the Challenge 22 Winners

During This Free Training, You Will Learn:

• Real-world focused techniques will be showcased by the best talents in eDNA Challenges
• Learn the core areas of the winning entries around the Power BI report development
• Continue reading “Report Winners – Tips & Tricks | Power Platform Innovation Labs Session 6” →

Save early, save often in Azure Synapse Studio

Posted on by Annie D

We’ve all been there. You are in your zone and working hard. Then something happens and you lose everything! Patrick talks about ways to maintain your hard work in Azure Synapse Studio.

📢 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 “Save early, save often in Azure Synapse Studio” →