Browse by Tags
All Tags » SQL Server » BI ( RSS)
-
|
If you glance to the side of this post you will see that one of the few books on my bookshelf is the Microsoft Data Warehouse Toolkit , and so I am annoyed that I can’t make the course of the book, presented by the authors, Joy Mundy and Warren Thornthwaite...
|
-
|
Working for Microsoft is strangely like working for the government, yu are essentially trying to please everyone, but there are significant minorities on any given issue who aren’t that satisfied. Let me explain with a real world example.. The lack of...
|
-
|
I have put Business Intelligence into a number of small businesses and these guys typically have one server set a side for BI, so how do you cram the database and the cubes into one box to get the best performance? SQL Server databases and Analysis Services...
|
-
|
My first experience of ‘proper’ databases was using Ingres back in 1994 while working for an obscure part of Customs & Excise (as it was). We could get a soundex person search from Inverness to return probable matches in under 8 secs from the...
|
-
|
One of the limitations of Analysis Services in SQL Server 2000 (AS 2000) was that a member in a dimension could only have 64,000 children, which was removed in SQL Server 2005 (SSAS 2005). So now you can create a customer hierarchy for your 1 million...
|
-
|
Before I joined Microsoft, I was working on a large project to build SQL Server 2005 analysis services cubes from data in Oracle 10g. The fun we had trying to get the data out and setup the servers! Getting the OLEDB drivers and the Oracle...
|
-
|
Nachstehend wieder einen Überblick über die TechNet Webcasts welche wir in den nächsten Wochen durchführen. Zu den Highlights in unserem dicht gepackten Webcast-Programm im April/Mai zählt mit Sicherheit der bereits auf die deutschsprachige Version ausgelegte...
|
-
|
Excel is the number one business intelligence tool; It fronts Hyperion, Cognos Financial Planning, and of course SQL Server Analysis Services and Performance Point Server Planning. In Office 2007 there is now excel services so that information workers...
|
-
|
One of the many cool things that's already in Analysis Services in SQL Server 2005 (SSAS) is the concept of many to many dimensions. Suppose I have 3 bank accounts and one of those I share with my wife, and on another I am co-signatory for a local charity...
|
-
|
Nearly everything Microsoft brings out these days has a SQL Server back-end, except Exchange as Eileen will tell you. I got asked about cubes in Project Enterprise server recently and managed to resolve an issue with the data not being updated due...
|
-
|
Data Mining like every other term in business intelligence seams to mean different things to different people. For me the key things that data mining does are: Assist in discovering relationships in data sets that were previously unknown. An example...
|
-
|
Passend zum BI-Event in Wien wurde auch für dieses Publikum die zukünftige Version des SQL Servers kurz vorgestellt. SQL Server 2008 ist eine solide Weiterentwicklung von SQL Server 2005 und geht bereits weit über reine Datenhaltung hinaus. Die Highlights...
|
-
|
If you call your flagship business intelligence product Performance Point then it might be a good idea to make sure it performs! Because the product is essentially a suite of front end applications (which is why it's under the office umbrella) it is only...
|
-
|
In my opinion the weak link in reporting services is that there is no tool for information workers to design their own reports and so IT professioanls have to spend a lot of time doing it for them. I can see there is a place for these reports: They will...
|
-
|
If like me, you are trying out the new stuff in SQL server 2008 you might need some data to work with. The standard Adventure Works sample databases for OLTP and data warehousing are not in the CTP nor is the the analysis services project. So you'll need...
|
-
|
Technorati Tags: BI , Business Intelligence , OLAP , SQL server 2008 Business Intelligence is just like digital photography, the more detail you want the more space you are going to use and in both cases we talk about grain and granularity. If you have...
|
-
|
Just in case you don't get the technet flash from Georgina , SQL server 2008 CTP4 is out there for you to enjoy. Community Technology Previews (CTP) for SQL server 2008 are different from the previews released for 2005 in that if a feature is in a 2008...
|
-
|
Also during the Dev & IT Pro days we had the opportunity to host the Business Intelligence Tour 2007. And again this tour has been recorded onto ITs Showtime . Not that this has not been recorded during our event but somewhere else. Nevertheless it...
|
-
|
Today Gunter Staes delivered the first part of the BI Funcasts: BI: The Mac-Guyver Techniques : SQL Server Integration Services. This session has been recorded. View Session Recording Next Session - 28/02/2007 The next session will be held on February...
|
-
|
Eileen is looking to extend her team and is looking for two new IT Pro Evangelists to join us in the UK. One of these will be a SQL Server/Business Intelligence person. The details for the job are here . What we are looking for is someone who is technical...
|
|
|