Recent Posts

1
Comments

Advanced Record-Level Business Intelligence with Inner Queries by gt0084e1

While business intelligence is generally applied at an aggregate level to large data sets, it's often useful to provide a more streamlined insight into an individual records or to be able to sort and rank them. For instance, a salesperson looking at a...
Filed under: , , ,
0
Comments

Izenda Reports 6.3 Top 10 Features by gt0084e1

Izenda 6.3 Top 10 New Features and Capabilities 1. Izenda Maps Add-On The Izenda Maps add-on allows rapid visualization of geographic or geo-spacial data. It is fully integrated with the the rest of Izenda report package and adds a Maps tab which allows...
3
Comments

High Performance SQL Views Using WITH(NOLOCK) by gt0084e1

Every now and then you find a simple way to make everything much faster. We often find customers creating data warehouses or OLAP cubes even though they have a relatively small amount of data (a few gigs) compared to their server memory. If you have more...
Filed under: ,
1
Comments

Interesting perspective on BI for SQL Server using an asp.net application by gt0084e1

This interview is pretty interesting, the company is seeking to replace consultants with software rather than supplement or create work for them which is not the norm in the BI software space. Worth the 10 minute listen: BI for the end-user
Filed under: , ,
0
Comments

A neat trick to report on data from SalesForce.com using SQL Server by gt0084e1

I have had to report on salesforce.com data before, and it can be a pain since their database uses strange naming conventions and composite keys. Here is a nifty article that addresses how to report on leads and their associated tasks. http://izenda.com...
0
Comments

The Hidden Costs of Free Reporting Tools - Conclusions by gt0084e1

If you haven't read the first post on this subject, please see here: http://weblogs.asp.net/brendansullivan/archive/2009/03/30/the-hidden-costs-of-free-reporting-tools.aspx After putting some more thought into it, I came to some general conclusions, and...
1
Comments

The Hidden Costs of Free Reporting Tools by gt0084e1

Being that I work in the reporting sector, I would like to offer my thoughts on the current state of providing self-service reporting to end-users. By self-service, I mean the ability for business users to create or customize their own reports without...
1
Comments

Never ending dominance of SQL? by gt0084e1

In the recent months, there had been some worry amongst developers concerning the Azure platform in light of the early comments Microsoft folks had made such as “If it works with SQL Server, it will largely work with SQL Data Services.” In fact, it based...
More Posts