Incremental Refresh in Power BI
What is incremental refresh in Power BI? Behind every Power BI dataset is a SQL Server Analysis Services (SSAS) tabular data model. This underlying technology has built-in partition support for larger datasets. Partitions divide tables into logical parts, which can then be refreshed independently. Incremental refresh brings that same partition support to the forefront in Power BI, enabling business users and IT professionals to refresh sections of a dataset. Why would you use incremental refresh in Power BI?
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 is an awesome tool for quickly creating front ends to consume you data and analytics products.
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 – these 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 Power BI in the cloud.
Twitter Sentiment Analysis with Azure Cognitive Services and Power BI
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 or topic is being mentioned on Twitter.
Automatically Save Twitter Data to Google Sheets with Microsoft Power Automate
Voice of the Customer Series - Part 1 In this tutorial I’ll demonstrate how to set up a Microsoft Power Automate 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 are tweeting about your brand.
Working with JSON Data in Power BI
In this article I’ll give a brief overview of how you can easily work with JSON formatted data in Power BI. To keep things interesting, we’ll create a simple listening history report from our JSON formatted Spotify data. The first step in our example will source your personal data from Spotify. To do this, log onto www.spotify.com, click on “Account”, and then go to your privacy settings: Next, scroll down to your personal data.