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

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, 150 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, 958 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, 112 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

7 comments, 1,639 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,183 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, 398 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, 480 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, 431 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, 670 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, 802 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

1 comments, 243 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, 237 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,190 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,541 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, 955 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, 1,097 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, 1,391 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, 1,031 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, 737 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, 1,118 reads

Posted in SQLDownSouth on 19 March 2013

Older posts