Vidas Matelis Analysis Services Blog

I will be at SQLPASS 2011

Vidas Matelis — Fri, 07 Oct 2011 20:35:40 +0000

This year I'll be attending SQLPASS 2011 in Seattle. I am scheduled to volunteer at Expert Pods on Wednesday, October 12th between 10am and 12pm.

I am a SSAS Maestro!

Vidas Matelis — Mon, 19 Sep 2011 23:59:20 +0000

I already wrote about my experience in the SSAS maestro program and today I can share with you that I am one of the first 11 SSAS Maestros! The official announcement on the first wave of SSAS Maestros was posted on the SQLCat.com website today. I am very happy to have received this award as [...]

SSAS Maestro program – my experience so far

Vidas Matelis — Mon, 02 May 2011 19:38:35 +0000

This blog post is about my experience in SSAS Maestro program. As I am writing this post, I still don’t know if I did pass all necessary requirements to become SSAS Maestro, and it will take few more weeks or even months till lab, exam and case study results will be available.

SSAS White Paper list

Vidas Matelis — Thu, 27 Jan 2011 04:07:14 +0000

In a few weeks I am planning to go to Redmond for "SSAS Maestro" training. I am very excited that I was accepted for this training and I want to prepare for it as much as I can. As I was going through available SSAS papers, I realized that quick list of SSAS white papers could be useful for other SSAS developers, so I am posting it here:

My tweets from SQL PASS Summit 2009 – SSAS, PowerPivot, DAX and more

Vidas Matelis — Sun, 08 Nov 2009 03:17:52 +0000

I just came back from SQL PASS Summit 2009. About a week before that I started to use Twitter and I tried to "tweet" during the conference as much as I can. My Twitter ID is: http://twitter.com/VidasM. I decided that some of my posts could be interesting to people who do not use Twitter, so I cleaned them up a bit and posted them here.

PASS Community Summit 2009

Vidas Matelis — Mon, 19 Oct 2009 02:05:57 +0000

For the last 2 years I attended the Microsoft BI conference which I enjoyed very much. This year I'll be going to Seattle to attend the PASS Community Summit 2009. Although the PASS Community Summit is not a BI specific conference, I am quite surprised that there will be so many BI sessions. In my event planner I added 3-4 sessions that I would love to attend for almost each time slot . The good news is that all of the sessions will be recorded and attendees have a choice - watch them for free later online, or just buy the DVD.

Part 2 – Gemini – how it performs with bigger tables

Vidas Matelis — Thu, 20 Aug 2009 02:40:34 +0000

Yesterday I posted about my tests working with Gemini and bigger tables. I realized myself and Chris Webb also suggested that my method of generating new records by simply duplicating them probably affected my results. So I ran more tests with different data.

SQL Server 2008R2 Self Service BI – Gemini – how it performs with bigger tables

Vidas Matelis — Wed, 19 Aug 2009 01:53:24 +0000

Gemini was released about a week ago and I was playing with it almost every evening. I am still trying to understand what it is, how it works, what are limitations, how to use DAX, etc. And I can say that I like what I see so far. Kasper de Jonge and Chris Webb already posted their initial Gemini reviews. In this post I will share my experience with Gemini so far.

Script to automate SSAS partition management (SQL + SSIS)

Vidas Matelis — Mon, 06 Jul 2009 01:13:26 +0000

Few years ago on my blog I posted scripts "SSIS Package to drop/create partitions based on partition list in the SQL Server table" and "SSIS package that process all partitions/measure groups/cubes in one database". Here are step by step instructions that I adjusted and tested on Adventure Works database. Most of the code comes from my earlier published posts, here I just added information how everything works together.

Using SSRS to report SSAS 2008 database structure using DMVs

Vidas Matelis — Sun, 01 Mar 2009 23:54:07 +0000

New SSAS 2008 DMVs allows you to easily access Microsoft SQL Server Analysis Services (SSAS) metadata - information about cubes, dimensions, measure groups, measures, etc. As with DMVs metadata information is returned in the data set format, it is very easy to build Reporting Services reports to generate documentation about your database.