Browse by Tags
All Tags »
SQL Server 2008 R2 (
RSS)
Yesterday I presented at the Israeli BI User Group at Microsoft Headquarters in Raanana. I gave a presentation on the Data Profiling Task in SSIS and how to dynamically configure it and use it to be a part of your ETL workflow logic. I hope the crowd enjoyed it and that I was able to add value to at least some of the attendants. Meir Dudai from “ Valinor ” also gave a presentation about SQL Azure and the Cloud Computing concepts. Cloud computing is definitely one of the coolest buzzwords at the moment...
In this 4’th instalment of the PowerPivot blog posts series we’ll take a quick look at PowerPivot internals. Firstly, what you need to understand is that a PowerPivot database is similar to an Analysis Services cube, but it is not exactly the same, certainly not in the way it stores data internally within the Excel file. There is an easy way to see what is inside an Excel file (thanks to the crowd at the recent Israeli BI User Group meeting…): simply change the Excel file extension from xlsx to zip...
PowerPivot is a combination of Excel and Analysis Services, enabling users to create complex and high-data-volume reports and enjoy the flexibility and usability of Excel alongside the high-performing SSAS engine. In this post I’ll be taking a closer look at a couple of DAX expressions. The DAX expression language is a special expression language which was added to the PowerPivot the Excel 2010 products, and enables the user to query multiple tables (as opposed to the traditional Excel expression...
Continuing the PowerPivot series, I’ll now attempt at creating my first PowerPivot report. After opening Excel, first thing we need to do is getting ourselves a data set to work with. To do so, I’ll click on the “data” tab and choose “From Other Sources” button and connect to my local SQL Server instance, to the “AdventureWorksDW2008” database. Running through a familiar set of wizard screens (similar to the Excel 2007 wizard), where I’m prompted to choose a database, and get the option to choose...
With so much talk about PowerPivot , “BI for the masses”, collaboration and, of course, world peace, I decided I’ll finally give PowerPivot a test run and see what the hype is all about. Attending the PASS summit a couple of months ago, this was by far the most talked about feature in the upcoming SQL Server 2008 R2 and Office 2010 products and it seems Microsoft is really excited with this new add-in. So, in the coming 2-3 blog posts I’ll try to describe how this tool works, and no better place...
Technorati Tags: SSRS , Report Builder , SQL Server 2008 R2 I’ve been trying the new Report Builder 3.0, which ships with the SQL Server 2008 R2 November CTP and among the various new features, I want to write a bit about the Shared Data Sets feature. Up until this version, report authors could create a data source, and when deploying the report could make the decision whether the data source for this report is shared among other users/authors or be linked only to the individual report they...