Category: Power BI

Parameterize your Notebooks in Azure Synapse

Posted on by Annie D

Using notebooks in Azure Synapse Analytics? Do you find yourself wanting to have a dynamic value for use with your pipelines? Patrick shows you how you can accomplish this!

📢 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 href=”https://guyinacube.com/tools/” Continue reading “Parameterize your Notebooks in Azure Synapse” →

How To Add A Conditional Index In Power Query

Posted on by Annie D

In this video, Melissa is going to give a walkthrough on her approach for Bhavya Gupta’s Power Query Challenge involving Conditional Indexing. The task is to add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal 90.

Link to the Power Query Challenge: https://bit.ly/3T9XBSJ

***** Video Details *****
00:00 Introduction
00:57 Group By
02:43 Table.RowCount
02:56 List.PositionOf
04:54 Generic list
06:00 List.Repeat
06:40 Restricting elements
07:50 Contstruct table
09:20 Expand nested tables

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – <a Continue reading “How To Add A Conditional Index In Power Query” →

How To Add Date To Filename In Power Automate Desktop

Posted on by Annie D

In this video, Jarrett is going to show how to use Power Automate Desktop to add a date to a filename.

Enterprise DNA Forum Post: https://forum.enterprisedna.co/t/refreshing-and-excel-file-in-sharepoint-w-power-automate/28162

***** Video Details *****
00:00 Introduction
01:35 The problem
02:20 Getting current date and time
02:58 Converting datetime to text
04:01 Renaming file
05:26 Running flow

***** 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 Continue reading “How To Add Date To Filename In Power Automate Desktop” →

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

Scale Your Power BI Reporting With Row Level Security [2022 Update]

Posted on by Annie D

In this tutorial, Sam will show how to implement a security model into your Power BI models with Row Level Security and be able to manage provision users to only see segments of analysis they are allowed to see.

***** Video Details *****
00:00 Introduction
01:11 Regional information
01:55 Creating simple visualisations
02:58 Managing roles
04:08 Viewing as roles
06:15 Publishing and managing security model

***** 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 Continue reading “Scale Your Power BI Reporting With Row Level Security [2022 Update]” →

Office 365 meet Power BI Desktop

Posted on by Annie D

Let’s talk about an upcoming change for Power BI Desktop and how it can be deployed. If you use Office 365, it may get a lot easier for you!

David Eldersveld
https://twitter.com/dataveld

Twitter Thread
https://twitter.com/dataveld/status/1576359796449902592

Power BI in Office installer
https://learn.microsoft.com/power-platform-release-plan/2022wave1/power-bi/power-bi-office-installer

📢 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
— <a Continue reading “Office 365 meet Power BI Desktop” →

Let Power Query write your SQL for you!

Posted on by Annie D

We tell you to push your transformations upstream as much as possible. But you don’t know how to write SQL. That’s ok, let Power Query do it for you to move your project forward. Patrick shows you how!

📢 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 #GuyInACube

Taking On Access Analytic’s Start Stop Challenge

Posted on by Annie D

In this video, Melissa will demonstrate an approach to Access Analytic’s Start Stop Challenge. The ask is to calculate the total number of hours member for a staff member on each month and date. See how you can solve this challenge!

Start Stop Challenge: https://accessanalytic.com.au/power-query-stop-start-challenge

***** Video Details *****
00:00 Introduction
00:55 Dataset
01:11 Filtered rows
03:10 Adding custom column
05:12 Variables
15:30 Projection
16:09 Aggregate values

***** 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 – <a Continue reading “Taking On Access Analytic’s Start Stop Challenge” →

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!” →