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…