Imitating QlickView through Excel 2010

Friday, May 9, 2014

I have recently started a new project for the Sanitation department in the municipality. The Local Recycling and transfer station where the sanitation truck go to dump trash or recycle has a report system that is a QlickView over their operational system. Their power user saw reports being generated by QlickView and offered we see them as well. We showed him earlier what we can do with Panorama Nova View and SSRS but he didn’t buy it. Having seen what QlickView did for the recycling center, I can see why. Though we didn’t have QlickView to offer him as...
no comments

Power View on SSAS Multidimensional

Tuesday, December 11, 2012

Microsoft recently released a CTP of Power View on SSAS Multidimensional, (and yes, I know I'm a bit late writing about this, but I still wanted to give my two cents on it). So we're edging closer towards the point where Power View and Excel will be able to cover all of your viewer needs (or at least most of them :)). Years ago when I wrote about Report Builder on a cube and all the problems that that relationship created, I wondered when that would be fixed. Now that we have Power View, I'm glad that Microsoft is...
no comments

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...

How to not add another table to your DB (by using Excel!)

Friday, May 13, 2011

Hey blog, how are you? I know I haven't been here for quite some time now... I guess I needed a break. Some time for myself. And I know you were waiting here for me all that time. Being patient and understanding. Knowing that one day, I'll come back. Thank you. I missed you. I think this time, I'm here to stay. So, the topic for today is how to not work automatically and adding a table to your database. About a year ago, I created a report in SSRS for a user of mine on the distribution of workers...
tags: , ,

Amir Netz and Ariel Netz Talk on PowerPivot, DAX, Report Builder and PivotViewer

Monday, August 16, 2010

Ok, so the unexpected happened - about a month and a half after interviewing Mr. Donald Farmer, I got to interview Mr. Amir Netz and Mr. Ariel Netz! I know!... You probably remember Mr. Amir Netz from his appearance in the recent keynote session in the BI conference in New Orleans. He spoke about what's going to be new in PowerPivot. When I heard he was coming to Israel for a conference discussing Panorama and PowerPivot, I decided I'd try to get a few more tidbits from him... In the keynote session, Mr. Netz had talked about adding the ability to...

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....

Performance Point integration in SharePoint 2010

Monday, November 2, 2009

Microsoft had released not too long ago, the last Service Pack for the standalone version of PerformancePoint Services - PerformancePoint Server 2007 SP3. From here on out, all development for PPS is going to be part of SharePoint Server. This is again part of Microsoft's strategy of empowering SharePoint as a product, as it also connects to Excel Services, Reporting Services (including Report Builder) and Visio Services.So what's new to PerformancePoint 2010? SharePoint Server 2010 as the repository - meaning PerformancePoint Services stores data sources in document libraries and all other dashboard content in lists. PerformancePoint Services uses SharePoint Server 2010...

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...

The future of SQL Server: Project Kilimanjaro, Madison and Gemini

Tuesday, October 7, 2008

The Microsoft BI Conference 2008 has been the source for quite a few announcements. First of all, now that DATAllegro was purchased by Microsoft, the talk is about SQL Server handling bigger amounts of data. There have been posts not just about terabyte projects, but also petabyte projects. The full integration of DATAllegro's technology into SQL Server is planned for the first half of calendar year 2010 and is code named Project Madison. SQL Server 2010 itself is code named Project Kilimanjaro. The real surprise? Project Gemini which sounds like Microsoft giving QlickView a run for its money... but I'm...