We’ve all been there, you publish a blog, post it on social, and the likes and shares start rolling in. You lie back, admiring your lofty accomplishment, like Michelangelo in the Sistine Chapel. Checking Google Analytics a few weeks later, you are shocked to find that the flow of social media traffic has slowed, and …
How to Turn your One-trick-social Ponies into SEO Workhorses Read More »
Have you ever tried to combine 30 files in Excel & it crashed? Same. Yes, we have all been there. You open a big Excel file that you know will take at least five minutes to load. You are on the edge of your seat saying, “Don’t you dare do it”… and then bam, Excel shuts …
Combine 30 Excel Files in 1 Minute with Power BI Read More »
Wil Reynolds talked about How Power BI Can Help You Bust Silos back in 2017. He showed how Power BI is changing every part of his job. You may even remember him talking about Bubbles and boxes. But since Wil’s 2017 SearchLove presentation have you downloaded Power BI and/or another data visualization tool? Well if not, Wil’s slides …
SearchLove London 2018: 10+ New Ways to Visualize Your Search Data Read More »
Before you dive into anything too cool in Power BI, it’s necessary to have an ideal legend. When using Power BI to organize groups of data, the order of the legend is not always where you’d like it to be, especially when creating custom groups. Luckily, it’s pretty simple to create a custom sort order …
I was reviewing an analysis years ago, and I got triggered. The analyst was suggesting that we target San Antonio. Up to that point the client had only targeted major cities (think New York, Chicago, San Francisco) but now the analyst thought that San Antonio would be a great location, even ahead of Dallas. When …
Joining Google Analytics Data to Other Data for Fun & Profit Read More »
One of the greatest values of data visualization tools is being to connect different types of data tables to calculate results, illustrate trends, or discover outliers. Relationships between your tables are necessary to create these connections. Relationships in Power BI Relationships in Power BI have multiple configurations, including cardinality and cross-filter direction, which determine the …
How to Join Many to Many with a Bridge Table in Power BI Read More »
I’ve been spending a lot of my time working in Power BI lately. Power BI allows me to quickly connect data that would have taken hours of stacking vlookups in spreadsheets. I can find new opportunities looking at the same data through multiple lenses. Power BI is a great data visualization tool to spot things …
Getting into data visualization for finding new opportunities and accelerating analysis? Me too! But there’s a few best practices I’ve learned along the way when connecting datasets by URLs. When might you want to connect by URL? Here’s a few outputs I find I’m generally connecting on the URL level where I need to really …
It’s important to build a marketing strategy based on what you know about your customers and their habits. Making data-driven decisions and sending the right message at the right time will have a big impact on your marketing—and it can even save you time and money. This month, we’re highlighting some analysis and management tools to …
