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