Tag: Power BI Tutorial

How to Use Python Script In Power BI

Power BI is hands down one of the best platforms you can use to analyze, transform and visualize data. Its power is compounded even more when you learn how to use Python script in Power BI. How does the use of Python script and Power BI together benefit data professionals? Python is one of the

Continue reading

Optimizing DAX For Power BI Using DAX Studio – Formula Engines

When you’re optimizing your data model and your DAX for Power BI, it helps to remember that there are two engines running behind the scenes — the formula engine and the storage engine. These two engines work together to return the results needed back to the user. They provide the results set in the form

Continue reading

Merge Queries Using Anti Join In Excel With Power Query

Compare And Merge Queries Using Anti Joins In Power BI

Automating your data filtering and cleaning processes can be such a huge time saver. For today’s tutorial, I’m going to demonstrate how you can compare and merge queries by using Anti Join in Excel with Power Query. You can watch the full video of this tutorial at the bottom of this blog. Let me start

Continue reading

Intro To Paginated Reports – New Course At Enterprise DNA

When it comes to report development, the way you analyze, transform and visualize your data is just one part of the process. Possibly an even more important aspect would be the way end viewers see the report. This is where paginated reports come in handy. In this new course by Sue Bayes, data professionals will

Continue reading

Query Folding And Connecting To SQL Server

Query Folding And Connecting To SQL Server

In this tutorial, we’ll learn how to connect to SQL server. We’ll also discuss how query folding works in Power Query and how we can run SQL commands in Power BI. Inside Power Query, we can extract and manipulate data from various sources. With query folding, we can offload data transformations to the source instead

Continue reading