In this blog post, we explore different techniques of splitting the values from a column in Power Query into multiple columns. This data transformation step is applicable in Microsoft Power BI and Excel.
Discover 7 Power BI hacks that transformed our dashboards in 2024! From cleaner designs to smarter filters and dynamic visuals, learn actionable strategies to elevate your reports. Plus, get a free Power BI template packed with examples to implement on your next Power BI project.
Struggling with underused Power BI reports? The #1 mistake is designing without the end user in mind. In this blog post, you will learn how to create actionable, user-friendly dashboards by avoiding common pitfalls like irrelevant data and overwhelming visuals. Also, discover strategies to boost adoption, drive decisions, and maximize ROI.
In this blog post, we provide M code to replace the values in a column in Power Query that don’t match a list of strings provided. The M code allows you to do this in one simple and efficient step. This data transformation can be performed in Power BI or Excel.
The Future of Canadian Automotive Labourforce Initiative (FOCAL), recently partnered with Go Analytics to deliver an interactive dashboard to deliver insights on their labour market forecasts for Canada’s automotive manufacturing sector. This case study highlights how we helped the FOCAL team from the initial project phases to preparing the data for analysis to creating a fully interactive dashboard that is embedded in FOCAL’s website.