About me

I work as SQL Server DBA / Developer and BI Consultant in Toronto, Canada.Canada Flag More...
Vidas Matelis picture


Report Portal

Portfolio Slicer – free BI application to track your investments in Excel with PowerPivot

May 30th, 2012 by Vidas Matelis

Yesterday I published Portfolio Slicer application that lets you track financial investments (stocks, ETFs, mutual funds) in Excel. I used Excel 2010 with PowerPivot 2012 to create PowerPivot database with over 90 DAX calculations and I could not be more happier with results. In the past I tried to use existing online services to track my investment accounts, but none of them would completely do what I wanted. So I decided to build investment tracking BI application using PowerPivot. Read the rest of this entry »

Posted in SSAS | Comments Off on Portfolio Slicer – free BI application to track your investments in Excel with PowerPivot

Videos from SQL Server 2012 Launch event

March 7th, 2012 by Vidas Matelis

Today SQL Server 2012 was launched and Microsoft posted on their website set of videos that would help you to understand what is new or improved in this release. For my blog readers I would recommend watching at least following videos (all under “Breakthrough Insights” tab):

  • “Rapid Data Exploration: Empowering End User Insight Through Rapid Data Exploration and Visualization with Power View” by Carolyn Chau, Lead Program Manager
  • “Managed Self-Service BI: End User Created, IT Managed” by John Hancock, Principal Program Manager Lead
  • “Credible, Consistent Data: Going Under the Hood with the New BI Semantic Model” by Ashvini Sharma, Principal Program Manager Lead
  • “Big Data Analytics with Apache Hadoop and SQL Server 2012” by Saptak Sen, Senior Product Technical Manager
  • “Breakthrough Insights with Microsoft Big Data” by Dave Campbell, Microsoft Technical Fellow

These are short presentations (about 20min each), you can watch them here.

Posted in SSAS | Comments Off on Videos from SQL Server 2012 Launch event

SQL Server 2012 RTM

March 6th, 2012 by Vidas Matelis

Great news – Microsoft just announced SQL Server 2012 RTM.

You can already download SQL Server 2012 Data Mining Add-in for Microsoft Office 2010, SQL Server 2012 RTM Evaluation and Microsoft SQL Server 2012 PowerPivot for Excel 2010 . Other download will appear shortly.

Also, for more information make sure to attend SQL Server Virtual Launch event – should be very interesting.

I am especially excited for new SSAS Tabular release. For past few months I started to use DAX more and more and with every day I like it more – it is very powerful and flexible!

Posted in SSAS | Comments Off on SQL Server 2012 RTM

I am a SSAS Maestro!

September 19th, 2011 by Vidas Matelis

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 it was a very challenging but worthwhile experience .

A big congratulations to all of the SSAS Maestro recipients: Ulf Ackerman, Alberto Ferrari, Greg Galloway, Darren Gosbell, Dirk Gubbels, Michael Horne, Marco Russo, Harlan Smith, Chris Webb and John Welch.

Posted in SSAS, SSAS Maestro | 5 Comments »

SSAS Maestro program – my experience so far

May 2nd, 2011 by Vidas Matelis

This blog post is about my experience in the SSAS Maestro program. As I am writing this post (May 1st, 2011), I still don’t know if I passed all of the necessary requirements to become a SSAS Maestro, and it will take a few more weeks or even months till the lab, exam and case study results will be available. There is a very good chance that I have not achieved the SSAS Maestro requirements, as this course and the tests were very difficult. However, I still want to share my experience, as I strongly believe that this was by far the best training on SSAS that I have ever participated in. Read the rest of this entry »

Posted in SSAS, SSAS Maestro | 14 Comments »

SSAS White Paper list

January 26th, 2011 by Vidas Matelis

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:

Posted in SSAS, SSAS Maestro | 11 Comments »

Script to automate SSAS partition management (SQL + SSIS)

July 5th, 2009 by Vidas Matelis

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“. These posts contained partial scripts that I developed for company “Insight Decision Solutions Inc.” to maintain partitions in the Microsoft SQL Server Analysis Services. This company sells, customizes and implements pre-packaged data warehouse solution (using SQL Server, SSAS, SSIS, SSRS, SharePoint and Excel 2007) for “Life” and “Health” insurance companies. Recently “Insight Decision Solutions Inc.” owners let me post full script on how to automate SSAS partition management . 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.

Read more and download code here…

Posted in SSAS, SSAS 2008 - Katmai, SSIS | 3 Comments »

Powershell script to process SSAS database objects

December 14th, 2008 by Vidas Matelis

I recently posted a new PowerShell script to process all dimensions and cubes in the specified Analysis Services database. This script has a few additional parameters that give you more control for your SSAS DB processing. First of all, you can specify the MaxParallel processing parameter to control the level of parallelism. You can also specify how many processing commands you want to execute per batch.  Read the rest of this entry »

Posted in PowerShell, SSAS | Comments Off on Powershell script to process SSAS database objects

« Previous Entries