Power Query

Wow 2021 PBI Week 30 Power BI report

2021 Week 30 | Power BI: Remove Punctuation and Count Words With Power Query

Introduction To celebrate our fourth week of Power Query month, we are going to use Power Query to analyze text data. Inspired by Chris Webb’s blog post, we are going to analyze word usage in Mary Wollstonecraft Shelley’s Frankenstein; Or, The Modern Prometheus. The Power Query techniques used in this week’s challenge are a bit …

2021 Week 30 | Power BI: Remove Punctuation and Count Words With Power Query Read More

2021 Week 27 | Power BI: Data Transformation with Power Query

Introduction July is “Power Query Month”, where the theme is focused less on visualization and more on data preparation. Every Power BI challenge requires Power Query to get and transform data, but now we’re going deeper in July! Starting off the month, you’ll use Power Query to perform preliminary cleanup and filtering of data exported …

2021 Week 27 | Power BI: Data Transformation with Power Query Read More

Scroll to Top