Let me start by thanking Adam Saxton aka Guy in a Cube and Hope Foley for helping me with this post. Power BI has made sharing dashboards and reports inside and outside of an organization relatively simple. All you really need is an email address. Now, whether or not the person will be able to […]
Well today marks the one year anniversary since the initial release of Power BI. We all have watched this product mature from a small infant to what we see today in an amazing Business Intelligence solution. To the Power BI product team and those that support the product keep up the good work. As a […]
So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday 531 Louisville, KY, but also a pre-con. The pre-con Power BI: Beginning to End, is a full day of Power BI including hands-on labs. An overview of the main topics can be seen below: Preparing […]
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the web. I pointed them to the Features Supported by the Editions of SQL Server web page and thought I was done. He stated that this site was good, but did not provide a simple list […]
Over the past couple of weeks I have been asked several times about the KPI Visual that is native to Power BI. Each time the same, “it does not appear to work properly.” Well, I wasn’t sure what all the confusion about. So, I decided to spend some time working with the visual. To start, […]
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This solution shows student persistence, retention, and graduation patterns, leveraging a Student Information System (SIS) as the data source. Year-over-over retention and graduation rates can be filtered to allow deeper examination of trends at the college […]
Thursday afternoon I am flying to Richmond, VA to deliver my full day Power BI Beginning to End and attend SQL Saturday #486. The session will be held on Friday March 18. If you haven’t registered, there are still seats available. If you want to learn how to build a Power BI solution for your organization […]
Continuing my blog from last week, Creating KPIs in SQL Reporting Services, I am now going to explain how to configure scheduled data refresh for the KPI that was created in that blog post. Prerequisites 1. SQL Server Agent must be running 2 Credentials must be stored in the Data Source 3. Caching must be […]
As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. Well, I just found out that I will be delivering the same session in Houston, TX at their SQL Saturday. Bring your laptop, grab a cup of coffee and get ready to learn. You can […]
In this blog I will explain how to create a Key Performance Indicatory (KPI) in SQL Reporting Services 2016. Let’s get started. The first step is ensuring that you install the latest CTP for SQL Server 2016. After that, you need to create a dataset. Datasets can be created using Report Builder or SQL Server […]