Data Corner – Page 4 of 11

Avoid the #1 Mistake That Leads to Ineffective Reports in Power BI

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.

Comments Off

December 5, 2024

Data Transformation / Power BI

Replacing Column Values That Don’t Match a String in Power Query

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.

Comments Off

September 9, 2024

Case Study

Success Story: FOCAL Partners with Go Analytics to deliver interactive dashboard on auto labour market

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.

Comments Off

April 19, 2024

Data Transformation / Power BI

Merging Queries in Power Query

In this blog post, we explain what is involved in merging queries in Power Query - in Power BI or Excel - and provide a step-by-step guide.

Comments Off

March 26, 2024

Data Transformation / How To / Power BI

[How To] Replace Column Values in Power Query

In this blog post, we provide a step-by-step guide on how to replace column values in Power Query. Whether you are performing data transformations in Power BI or Excel, this blog post will teach you how to replace column values.

Comments Off

March 9, 2024