Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 1,303 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, 1,823 reads

Posted in SQLDownSouth on 13 May 2013

SSRS 101 – Your First Report

I know that it has been a while, and I apologize. I have been traveling around the U.S. evangelizing SQL Server to public schools, colleges and universities. Now that does not excuse my time away from the blog, but that is my excuse and I am sticking to it. Anyway,… Read more

0 comments, 475 reads

Posted in SQLDownSouth on 6 May 2013

Configuring PerformancePoint in SharePoint 2013

Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following all the steps precisely on this page:

Configure PerformancePoint Services: http://technet.microsoft.com/en-us/library/ee748644.aspx

We opened the dashboard designer. Next we started to create a Data Source to an SSAS Tabular model, but… Read more

0 comments, 565 reads

Posted in SQLDownSouth on 29 April 2013

Creating a Shared Dataset with Report Builder

I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically, can you build a Shared Dataset that combines multiple tables from the same database? To be honest, I wasn’t sure initially because I never attempted to. However, after a little… Read more

0 comments, 670 reads

Posted in SQLDownSouth on 29 April 2013

SQL Lunch – GeoFlow: 3D Geospatial Visualization

Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.

Lunch Details

#75-GeoFlow: 3D Geospatial Visualization

Speaker: Julie Koesmarno

Add To Outlook: Add To Calendar

Date and Time: 5/10/2013 11:30:00 AM CST

BIO: Julie Koesmarno is a consultant in SQL… Read more

0 comments, 529 reads

Posted in SQLDownSouth on 25 April 2013

Introduction to SQL Server 2012 – Webcast Resources

First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to apologize for not being able to show the AlwaysOn demonstration. Shortly, after the webcast I found out that we lost internet connectivity to our lab. They are currently working on… Read more

0 comments, 362 reads

Posted in SQLDownSouth on 12 April 2013

SQL Lunch – Power View Against Multidimensional Models

It has been some time since I have hosted or presented on the SQL Lunch. Work and home life is a balancing act where home typically wins. In the case of the SQL Lunch home is winning more and more every day. However, I am committed to delivering or hosting… Read more

0 comments, 639 reads

Posted in SQLDownSouth on 19 March 2013

Successful BI for Educational Institutions

Do you work for US Education? Are you interested in Learning about Microsoft BI? If so, please join me as I discuss and demonstrate how the MS BI Suite can be used in your environment to discover and uncover hidden GEMS within your existing data structures.

Everyone likes a pretty…

Read more

0 comments, 569 reads

Posted in SQLDownSouth on 15 March 2013

SSRS – Using a List Item to Display Details

How many times have you been asked to develop a report that displays the details for a specified group? For example, maybe you need to produce something like the following report:

The above image shows a report that contains three groupings: School, Location and Event Type. Two values, # of… Read more

0 comments, 1,215 reads

Posted in SQLDownSouth on 11 March 2013

SSRS 101 – Creating a Shared Dataset

Now that you have created a Share Data Source, it’s time to add some data to your project. In this post I will explain Shared Datasets and demonstrate how to add a one to your project.

As with a data source, you can create an embedded or shared dataset. The… Read more

1 comments, 774 reads

Posted in SQLDownSouth on 26 February 2013

SSRS 101 – Creating a Shared Data Source

In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project, you will now learn how to create a Shared Data Source within that project. In this post I compare and contrast Shared and Embedded Data Sources and demonstrate how to create a Share Data… Read more

0 comments, 800 reads

Posted in SQLDownSouth on 31 January 2013

SSRS 101 – Creating a SQL Server Reporting Services Project

This is the second installment in this series of SQL Server Reporting Services 2012 Beginner posts. You can read the previous post here. If you are wondering why Beginner, please read the SQL Server 2012 for Beginners post to learn more. With that, let’s get started.

Before you can… Read more

0 comments, 3,018 reads

Posted in SQLDownSouth on 29 January 2013

SSRS 101 – Prerequisites

Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things you must have installed or restored before you can begin. As mentioned in my previous post, SQL Server 2012 for Beginners, this is a journey. While the first part… Read more

0 comments, 2,496 reads

Posted in SQLDownSouth on 23 January 2013

SQL Server 2012 for Beginners

I have been working for Microsoft for the past two years. One of the most enjoyable parts of my job is the fact that I work with US Education. I get to evangelize SQL Server and Business Intelligence to Colleges, Universities and Public Schools across the country. I build Proof… Read more

0 comments, 499 reads

Posted in SQLDownSouth on 22 January 2013

Power View Matrix Drill Capabilities

The features and capabilities of Power View have definitely improved since its release. One of my favorite features is the new drill-through ability in either a Matrix or Chart. In this post I will walk you through building a drill-through Matrix. If you prefer to watch a video instead of… Read more

0 comments, 1,184 reads

Posted in SQLDownSouth on 21 January 2013

How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that is what happens when you try to write two books at the same time.  Oh well, on to the post.  Back in November of 2009 I published a blog titled,…

Read more

0 comments, 4,227 reads

Posted in SQLDownSouth on 27 June 2012

How to Create Reporting Services 2012 Report Templates

When I started writing this blog I realized it has been several months since my last post.  I guess that is what happens when you try to write two books at the same time.  Oh well, on to the post.  Back in November of 2009 I published a blog titled,… Read more

0 comments, 602 reads

Posted in SQLDownSouth on 27 June 2012

SQL Lunch - SQL Reporting Services

Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS).  If you have time, join us for some SQL Lunch.  Here are the details:

#64-Taking the Scary out of Monster Reports

Speaker: Pam Shaw

Add To Outlook: Add To Calendar

Date and Time: 3/22/2012 11:30:00 AM…

Read more

0 comments, 1,098 reads

Posted in SQLDownSouth on 21 March 2012

SQL Lunch–SQL Reporting Services

Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS).  If you have time, join us for some SQL Lunch.  Here are the details:

#64-Taking the Scary out of Monster Reports

Speaker: Pam Shaw

Add To Outlook: Add To Calendar

Date and Time: 3/22/2012 11:30:00 AM… Read more

0 comments, 479 reads

Posted in SQLDownSouth on 21 March 2012

Older posts