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
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
Implementing Tabular Data Models
Date: November 11, 2014
Time: 9am?5pm PST
Where: Live, online virtual classroom:
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
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
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
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
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
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
Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.
Speaker: Julie Koesmarno
Date and Time: 5/10/2013 11:30:00 AM CST
BIO: Julie Koesmarno is a consultant in SQL… Read more
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
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