OfficeWriter v8 for SSRS

Wednesday, April 4, 2012

SoftArtisans have approached me to write a review about OfficeWriter v8 integration with SSRS. Your first question would be: what's OfficeWriter? :) OfficeWriter is an application that works with Reporting Services in two ways: 1. It Allows you to design a report in Word or Excel and render it to an RDL 2. It allows you to take data from an RDL report and use it in a Word or Excel document I believe just those two point hold within them quite a lot, but we'll get to that shortly. I decided to try my hand at creating a report on Adventure Works data: I...

Data mining in Excel 2007

Tuesday, June 1, 2010

Mr. Donald Farmer gave a lecture yesterday, May 31st 2010, at the Israeli BI User Group. This is what I summed up from the session. Predictive AnalyticsA good predictive analytics project would have:Actionable - you get useful information from itInnovative - gives something new, new insight from the modelTrustworthy - the model makes senseSeamless - part of your everyday operations, so that it will get used more easily by the users "All models are wrong, but some are useful" George BoxNo model is perfect, you can't predict everything, but even then the model is useful. Don't expect to build a perfect...

Using the Dallas Project in Excel and an SSRS Report

Monday, December 7, 2009

I read a while ago in Chris Webb's blog about project Dallas which really got me interested. Quoting from the site itself: "Microsoft® Codename "Dallas" is a new service allowing developers and information workers to easily discover, purchase and manage premium data subscriptions in the Windows Azure platform." So what does it mean? Basically that you have a public data source in the cloud that you can connect to and use for your own applications. And why am I so psyched about this? I have to admit that I am constantly looking for data I can use for demos....

Flexible grouping on data from your DW in Excel 2007

Friday, May 15, 2009

I have recently built a data mart containing all the data of budgeting and accounting in SQL Server 2005 and created a Report Model in Report Builder for it. My users were looking for a flexible way to define different grouping on the data, without having to ask for my assistance. Defining new formulas in Report Builder isn't the most comfortable thing to do (specifically if they get complex and long), so we had to find another way.   There was a suggestion of creating a view in the database with their definitions for the grouping straight to SQL, but I...