Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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… Read more

0 comments, 287 reads

Posted in SQLDownSouth on 14 March 2016

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… Read more

0 comments, 1,450 reads

Posted in SQLDownSouth on 23 February 2016

More SQL Saturday Precon News(Real-time Dashboards)!!!!

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

0 comments, 588 reads

Posted in SQLDownSouth on 19 February 2016

Creating KPIs in SQL Reporting Services

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

2 comments, 2,422 reads

Posted in SQLDownSouth on 17 February 2016

Upcoming SQL Saturday Precon Sessions (Update!!!!)

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

0 comments, 315 reads

Posted in SQLDownSouth on 8 February 2016

SQL Server 2016 Row-level Security and SSRS a perfect match

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

0 comments, 1,789 reads

Posted in SQLDownSouth on 8 February 2016

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?… Read more

0 comments, 407 reads

Posted in SQLDownSouth on 25 January 2016

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… Read more

0 comments, 1,183 reads

Posted in SQLDownSouth on 14 December 2015

Atlanta BI Edition SQL Saturday Precon

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

0 comments, 289 reads

Posted in SQLDownSouth on 3 December 2015

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… Read more

0 comments, 2,032 reads

Posted in SQLDownSouth on 2 December 2015

Orlando SQL Saturday Precon – Transform and Visualize Data with Power BI

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

0 comments, 1,398 reads

Posted in SQLDownSouth on 20 July 2015

I’m Speaking at the Baton Rouge SQL Saturday

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

0 comments, 639 reads

Posted in SQLDownSouth on 15 July 2015

A Full Day of Power BI with Me

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

0 comments, 678 reads

Posted in SQLDownSouth on 13 April 2015

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Read more

1 comments, 601 reads

Posted in SQLDownSouth on 10 April 2015

Join me for Dashboards in a Day

Seats are limited – act fast!

This week I will be hosting two free events at the Microsoft Office in Alpharetta, GA on Wednesday, February 25th and Friday, February 27th. Join me to learn how to use Microsoft’s self-service Business Intelligence platform, Power BI.

In the first part of… Read more

0 comments, 890 reads

Posted in SQLDownSouth on 23 February 2015

Implementing Tabular Data Models: Microsoft Virtual Academy

 

Implementing Tabular Data Models

Date: November 11, 2014
Time: 9am?5pm PST
Where: Live, online virtual classroom:
http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models
Cost: Free!

Register today! (linkto: http://www.microsoftvirtualacademy.com/liveevents/implementing-tabular-data-models)

What will you do with all that data?

What about building corporate BI solutions, creating self-service analysis, and setting up custom reporting? In “Implementing Tabular… Read more

0 comments, 1,045 reads

Posted in SQLDownSouth on 3 November 2014

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Read more

0 comments, 404 reads

Posted in SQLDownSouth on 16 April 2014

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Read more

0 comments, 403 reads

Posted in SQLDownSouth on 14 November 2013

Parameterizing an Excel Spreadsheet

I’ve had a few discussions in the past week about not only including Excel spreadsheets on PerformancePoint dashboards, but specifically about how to pass values from Filters to the spreadsheet. I did a few demonstrations to show the capability to some customers. Immediately after a few of the demonstrations I… Read more

0 comments, 2,440 reads

Posted in SQLDownSouth on 16 May 2013

The Tale of One Tabular Model and Excel 2013 with Multiple Power View Reports

SQL Server 2012 Reporting Services introduced Power View, which was initially available only in SharePoint. This limited the use of Power View only to those individuals and organizations that had SharePoint deployed in some environment. To make Power View more widely available it is now an add-in for Excel 2013.… Read more

0 comments, 2,762 reads

Posted in SQLDownSouth on 13 May 2013

Older posts