Rookie Numbers Wolf of Wall Street

Report Commenting in Power BI

Power BI Report Commenting in Web Service Here’s a quick tip to improve collaboration and encourage more discussion around the results shown in your Power BI reports. Microsoft recently added report commenting functionality to the PBI web service, and it couldn’t be easier to start using it. Just head to the header bar of the Power BI web service and click on “Comments”. This will…

Simple Analytical

Twitter Sentiment in Power BI: Who is Vancouver’s Favorite Car Share?

Voice of the Customer Series – Part 3 Who is Vancouver’s favorite car sharing company? That’s the question I set out to answer in today’s blog post – at least according to what people are saying about them on Twitter. In part 1 of my Voice of the Customer series, I demonstrated how you can set up an automated process to collect tweets that mention…

Q&A

Q&A with Simple Analytical

I recently did a Q&A with Simple Analytical. We talk about how I got started in the world of Business Intelligence and Analytics, and include tips for people trying to get in the industry. You can check it out here: #businessintelligence #analytics

Azure Cognitive Services

Twitter Sentiment Analysis with Azure Cognitive Services

Voice of the Customer Series – Part 2 In part 1 of my voice of the customer series blog post, I demoed how Twitter data can automatically be saved in Google Sheets using Microsoft flow. In this post, I’ll show how you can leverage the technology from Microsoft Azure Cognitive Services to perform sentiment analysis on the tweets. This will allow you to determine how positively or negatively a brand…

Save Tweets to Google Sheets using Microsoft Flow

Automatically Save Twitter Data to Google Sheets with Microsoft Flow

Voice of the Customer Series – Part 1 In this tutorial I’ll demonstrate how to set up a Microsoft Flow to automatically save tweets that mention your brand, product or service to a Google Sheet. In a future post I’ll show how you can then explore this Twitter data and perform sentiment analysis on the tweets. This will allow you to evaluate how positively or negatively users…

SQL Query to Find Database Columns and Data Types

Have you ever found yourself searching through database tables trying to find a specific column? Many databases have hundreds (or maybe even thousands), of tables within them, so searching through these in SSMS can be a slow process. If you recently started at a new company and you are trying to learn the database structures, it could take some to memorize things. One of the challenges I…