sqlsat531_web

Join me at SQL Saturday 531, Louisville, KY

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 […]

PBIKPI

What’s wrong with the Power BI KPI Visual?

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, […]

Power BI

Higher Education Retention Analytics using Power BI

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 […]

sqlsatkey

SQL Saturday 486: Richmond, VA Precon

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 […]

image_thumb.png

Refreshing KPI Data in SSRS 2016

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 […]

Power BI

From the Power BI dashboard to a specific page in a Report

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?  I dug around the Power […]

Excel

Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?

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 to a dashboard.  A blog […]

Power BI

Sentiment Analysis with Power BI

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 upon a Text Analytics API […]