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… Read more
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… Read more
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… Read more
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… Read more
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… Read more
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… Read more
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… Read more
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.
1. SQL Server Agent must be running
2 Credentials must be stored in the… Read more
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… Read more
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… Read more
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts are flying across twitter. How can you keep up? Well, if you are in Tampa, FL or Richmond, VA join me in one of these two full day sessions… Read more
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level Security (RLS) with SSRS. Detailed steps including the TSQL script and SSRS project is provided at the end of this post. To get started, you need to setup RLS.… Read more
Recently, I was working with a customer designing Power BI reports and dashboards. Everything was going great until she asked this question, “Is it possible to set the hyperlink of a tile on a dashboard to go to a specific page on a report?”. Hmmm, I thought. Is it possible?… Read more
So two new exciting capabilities were announced recently in Power BI. One involved Excel and the other SSRS, but they both involved pinning. Microsoft announced the ability to pin certain visuals from SSRS to a Power BI dashboard and also the ability to pin a range from an Excel workbook… Read more
The explosion of Business Intelligence (BI) capabilities coming from Microsoft these days have left many of us in a frenzy. We are all trying to figure out, how do you keep up? The Power BI team has released hundreds of updates since it with GA. Then there is the upcoming… Read more
I was recently asked by a customer to help them do some Text analysis of course evaluation data. They wanted to perform sentiment analysis and key phrase extraction. My first thought was to develop an Experiment using Azure Machine Learning (Azure ML). However, after doing a little research I stumbled… Read more
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturday for the first time in many years. Then this weekend, I found out that I will also be delivering a full day Pre-Conference on Friday October 9, Transforming and Visualizing Data with Power… Read more
After a few years away, the Baton Rouge SQL Saturday group has finally allowed me back at their annual event that will be held on August 1st at LSU in Baton Rouge, LA. I am excited to be back on the schedule. It’s great to see how William and the… Read more
Join me for a full day of Power BI in Baton Rouge, LA and Downers Grove, IL, where I will teach you how to use Microsoft’s self-service Business Intelligence platform, Power BI. In the first part of the session, I will lead you through a Microsoft dataset and demo… Read more