Month: March 2022

How To Build a Marketing Dashboard

Companies spend on average ~12% of revenue on marketing. In today’s digital world, measuring effectiveness of marketing data is easier than ever. We can now track how many people are seeing or clicking on our ads. There are many digital channels companies will use to market: Google, Facebook, Twitter, Spotify,Bing, etc. These major social media companies…
Read more

Quickly Find Duplicates in a Column

Sometimes a duplicate value can cause problems in Power BI/Excel. This is the fastest way I’ve learned to find a duplicate value in a column.  Begin by bringing the column into Excel. Turn on the Filter for the column with duplicates. (From Home Tab, select ‘Sort & Filter’, then ‘Filter’ (Cntl-Shift-L if you want to…
Read more