|
|
-
|
|
At PASS, Microsoft announced that SQL 11 (codenamed Denali) will support columnar storage. This announcement is incredible news for SQL developers wanting a simple solution to enabling rapid data analysis on their existing infrastructure. For some analytical workloads, columnar storage enables an or......
|
|
-
|
|
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 specific customer cou......
|
|
-
|
|
The Need for Date-Based Reports
One of the most effective ways to better understand an organization to visualize events over time to see how they are trending and how they compare to one another. Here’s an example that illustrates a multi-year comparison. This could be used to tell a story of......
|
|
-
|
|
The holly grail of business intelligence is to have “one version of the truth” by integrating all systems within an organization and it’s ecosystem into a single, unified database. One of the great obstacles to doing this is the lack of common foreign key relationships like the one......
|
|
-
|
|
The term “data warehouse” may have originated because it once took a literal warehouse to hold all the servers you needed to store a few gigabytes of information. We now live in extraordinary times where usb drives given away as promotional items can store the equivalent. The approaches......
|
|
-
|
|
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 server memory than the size of your databas......
|
|
-
|
|
We often see situations where different members of the user community will need different ways to do the same thing. One example is generating an Excel file (or CSV). While it would initially see that this is a single feature, there are a myriad of different reason for someone to do this. Salesfo......
|
|
-
|
|
Sometimes implementing relatively simple ideas requires a surprising amount of creativity. The pie chart in Izenda reports has a simple option to combine smaller pie slices into a single slice. If you have 20 Countries, but many are very small, the chart will look a bit cluttered. The tiny slices di......
|
|
-
|
|
In part 1 we used UNION to combine multiple queries in order to create a view for a Executive Dashboards. It displayed the top 5 Countries as well as an additional row which give you some context by adding up the rest of the Countries. In part 2 of the article, we will use a CASE statement to do a l......
|
|
-
|
|
This article shows a simple way to give applications with multi-tenant architectures the ability to add custom fields while keeping the performance, type safety and reporting capabilities of the relational model and SQL language.
SaaS Takes Over the ASP Model
In the late 90′s application s......
|
|