|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of the early leaders in the Microsoft Business Intelligence community. Somewhere around 2004-2008 I worked with Reed at Hitachi Consulting in Seattle where we travelled, taught classes and worked on client… Read more
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is the organization of a functional BI team? How do the individual roles and disciplines contribute to a successful outcome? How is team composition different for self-service and business-owned BI projects?… Read more
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you to navigate through the metadata for a tabular model and select from measures and table attributes to build a simple query which is executed and timed. The query can be… Read more
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This is a big question that can’t easily be answered without understanding the variables of scale, complexity, user and business requirements. My knee jerk reaction to a question like this is… Read more
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week in San Jose. I’ll be blogging from the conference as announcements are made and as the rest of the community buzzes about new developments in the community and here at… Read more
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value and simplify user experiences. In this post, I will demonstrate how to use slicers to pass values into a calculated measure in an SSAS Tabular model to dynamically change the… Read more
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The use of rectangles is very much a core part of Reporting Services report design and a difference in behavior is expected. Cells in a tablix will grow vertically to accommodate… Read more
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. That was easy …now that I see how to do it.” Power View sets the maximum value for a chart series based on the maximum unfiltered axis value; pretty simple… Read more
A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that I hadn’t solved before using a tabular model and DAX. She had cost information for several hospitals in a PowerPivot model. Using an Excel pivot table published to a SharePoint… Read more
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several new Business Intelligence tools available for preview; some only privately and some to the public. The entire suite will soon be available for either public preview or release under the… Read more
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance SSRS Reports; How to write a custom assembly and use it to build a dynamic report dataset. The article was posted online in April and featured in the July printed… Read more
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot How-to” by Leo Taehyung Lee, published by Packt Publishing. This is a short, concise book; only 46 pages long. Quite honestly, if I had picked up this book for myself,… Read more
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take the annual BI Survey! The survey is an annual report conducted by Business Application Research Center (BARC), an independent software industry analyst, comparing the industry BI tools rated by thousands… Read more
A Getting-Started and Survival Guide for planning, designing and building Tabular Semantic Models with Microsoft SQL Server 2012 Analysis Services. by Paul Turley This post will be unique in that it will be a living document that will be updated and expanded over time. I will also post-as-I-go on the… Read more
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using Expressions to enhance report capabilities. The sessions are online with live chat from 11:00 to 4:30 Eastern Time. Register today to get in on the early-bird discount. the cost for… Read more
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo. In the past, if you wanted to develop and maintain BI projects in the same development environment as other Visual Studio projects, you had to install multiple versions of Visual Studio. This may… Read more
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This is a short world tour with visits to a few SQL Server community members and leaders around the globe talking about their SQL Server communities. GeoFlow is a new BI… Read more
The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please do not share your schedule until that time.” Well, what does that mean, exactly? It means that it’s midnight right now and time to tell the world…. We are going… Read more
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created a few databases and then quickly left it behind but in the last few months I’ve found some really good uses for “Microsoft Windows Azure SQL Database”. I just wish… Read more
Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert training on SQL Server 2012 Reporting Services? SolidQ now offers a SSRS training course with focus on designing report solutions for Business Intelligence and SharePoint integration. Not using SharePoint? Private… Read more
Older posts
|
Subscribe to this blog
