Automated Sales Forecasting with Azure Machine Learning

Today I want to demo something new. Most of my posts thus far have been about Power BI, but since I started working at Best Buy Canada several months ago, I’ve been able to work more on analytics projects versus pure BI (dashboards/reports) development. These experiences have allowed me to branch out to more data science and analytics work streams, and along the way I’ve…
Azure Logic App

Getting and Storing Data from APIs with Azure Logic Apps

In this article I will demonstrate how you can quickly set up a simple ETL process to get data from an API and store it in Azure Blob storage. When it’s all done, the data will be saved as text files in our Azure Cloud Blob storage: SimilarWeb is the API I will be sourcing my data from today. This organization crawls the web to…
Azure Data Studio Logo

Data Analysis with Azure Data Studio SQL Notebooks

Markdown notebooks like Jupyter are all the rage for data science applications, especially given R and Python’s widespread use in advanced analytics. But what about good ole’ SQL? Let’s not forget about our basic SQL abilities to extract and analyze data. Thankfully, Microsoft now supports creating SQL notebooks in Azure Data studio. Notebooks are a great way to create a repeatable data analysis report and…
PDF Title

Importing Data From PDFs in Power BI

Wouldn’t it be great if you could import data directly from PDFs? Well actually, with Power BI you already can! Power BI natively supports importing data from PDF files. Follow along and I’ll show how you can easily create a simple report from data stored in a PDF file.  For today’s post, I’ve sourced Nestle Groups 2017/2018 financials, which are stored in PDF format. Why did…
Azure Search

Unlocking Data Stored in Images, PDFs and Documents

“An estimated 80% of corporate data is unstructured” Because I work with SQL Server and BI tools, a lot of the time when I think of data, I immediately think of tables and records stored in databases. But when we look at an organization’s entire data store, most of it likely isn’t nicely organized and normalized here. No, it’s likely tied up in servers, in…
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…
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: https://simpleanalytical.com/analysts-assemble-qa-zach-renwick #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…