Creating a Python Forecasting App with Streamlit and Prophet

I recently cobbled together a data web app using the Streamlit open-source framework. Users can upload their own data, visualize trends and features, and finally download the newly created forecast back to their computer. If you want to try it out yourself, you can see it in action here, assuming I have not gone over 25 hours of free app time on Heroku 😂 Streamlit…

Why You Should Choose Power BI Pro or Premium over Power BI Report Server

Introduction In this article I’ll share the top issues and missing features of Power BI Report Server (PBIRS), and explain why I think organizations should choose cloud versions of Power BI over the on-premises PBIRS. *as of May 2020 – features may change over time. To begin with, what is PowerBI.com vs. Power BI Report Server? Microsoft offers free, Pro, and Premium licensing options for…
Q&A in Power BI

Enabling Self-Serve Analytics with Q&A in Power BI

Hey everyone, Today I want to talk about Q&A in Power BI. Imagine typing a question like “what were sales in 2019?” and instantly getting an answer. This is actually already possible to implement in Power BI, and in this video I’ll show you how to set it up yourself. This seems to be a lesser known feature of Power BI, but it’s incredibly powerful…

Creating Interactive Python Visualizations With Plotly and Pandas

Jupyter notebooks make it incredibly easy to rapidly prototype vizualizations and work with data. In this example I wanted to show how you can also make interactive data vizualizations with the Plotly Python library. For the data sourcing and transformations I will use pandas library. I was absolutely blown away with how little code it took for me to set up some more advanced interactive…
Create Power BI Data Alerts

Creating Data Alerts in Power BI

Hey everyone, another quick video today! This time I wanted to showcase how you can set up automated data alerts in Power BI. Once you set these up, you will be notified by email and through the notification center on PowerBI.com when a KPI goes above or below a specific threshold. If you’d like more documentation on how to do this, please see the Microsoft…

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…