Vidas Matelis Analysis Services Blog http://www.ssas-info.com/VidasMatelisBlog My work with Microsoft BI, SQL Server Analysis Services 2005, 2008 Tue, 02 Jun 2015 00:08:38 +0000 en-US hourly 1 https://wordpress.org/?v=5.6.17 PowerPivot Tips and Tricks for IT Pros http://www.ssas-info.com/VidasMatelisBlog/258_powerpivot-tips-and-tricks-for-it-pros Sat, 26 Oct 2013 18:55:18 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=258 On Oct 26, 2013 I presented at "Big Data Saturday" event in Toronto, Canada. Here I am posting my session key points and notes.

The post PowerPivot Tips and Tricks for IT Pros first appeared on Vidas Matelis Analysis Services Blog.

]]> Portfolio Slicer – free BI application to track your investments in Excel with PowerPivot http://www.ssas-info.com/VidasMatelisBlog/253_portfolio-slicer-free-bi-application-to-track-your-investments-in-excel-with-powerpivot Wed, 30 May 2012 23:41:49 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=253 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

The post Portfolio Slicer – free BI application to track your investments in Excel with PowerPivot first appeared on Vidas Matelis Analysis Services Blog.

]]> Videos from SQL Server 2012 Launch event http://www.ssas-info.com/VidasMatelisBlog/248_videos-from-sql-server-2012-launch-event Thu, 08 Mar 2012 01:13:55 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=248 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 […]

The post Videos from SQL Server 2012 Launch event first appeared on Vidas Matelis Analysis Services Blog.

]]> SQL Server 2012 RTM http://www.ssas-info.com/VidasMatelisBlog/242_sql-server-2012-rtm Tue, 06 Mar 2012 20:14:33 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=242 Great news - Microsoft just announced SQL Server 2012 RTM.
You can already download SQL Server 2012 Data Mining Add-in for Microsoft Office 2010. Other download will appear shortly.

The post SQL Server 2012 RTM first appeared on Vidas Matelis Analysis Services Blog.

]]> Computer Power Plan impact on PowerPivot DAX query performance http://www.ssas-info.com/VidasMatelisBlog/235_computer-power-plan-impact-on-powerpivot-dax-query-performance http://www.ssas-info.com/VidasMatelisBlog/235_computer-power-plan-impact-on-powerpivot-dax-query-performance#comments Mon, 20 Feb 2012 17:50:40 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=235 I was working recently with PowerPivot 1.0 workbook and was using it on my desktop and on my laptop. I noticed that there was big performance difference when I was refreshing my PivotTables between these 2 machines so I did more tests to figure out why this is happening. I established that performance difference was related to Power Plan settings.

The post Computer Power Plan impact on PowerPivot DAX query performance first appeared on Vidas Matelis Analysis Services Blog.

]]> http://www.ssas-info.com/VidasMatelisBlog/235_computer-power-plan-impact-on-powerpivot-dax-query-performance/feed 1 I will be at SQLPASS 2011 http://www.ssas-info.com/VidasMatelisBlog/232_i-will-be-at-sqlpass-2011 Fri, 07 Oct 2011 20:35:40 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=232 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.

The post I will be at SQLPASS 2011 first appeared on Vidas Matelis Analysis Services Blog.

]]> I am a SSAS Maestro! http://www.ssas-info.com/VidasMatelisBlog/227_i-am-a-ssas-maestro http://www.ssas-info.com/VidasMatelisBlog/227_i-am-a-ssas-maestro#comments Mon, 19 Sep 2011 23:59:20 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=227 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 […]

The post I am a SSAS Maestro! first appeared on Vidas Matelis Analysis Services Blog.

]]> http://www.ssas-info.com/VidasMatelisBlog/227_i-am-a-ssas-maestro/feed 5 SSAS Maestro program – my experience so far http://www.ssas-info.com/VidasMatelisBlog/213_ssas-maestro-program-my-experience-so-far http://www.ssas-info.com/VidasMatelisBlog/213_ssas-maestro-program-my-experience-so-far#comments Mon, 02 May 2011 19:38:35 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=213 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.

The post SSAS Maestro program – my experience so far first appeared on Vidas Matelis Analysis Services Blog.

]]> http://www.ssas-info.com/VidasMatelisBlog/213_ssas-maestro-program-my-experience-so-far/feed 14 SSAS White Paper list http://www.ssas-info.com/VidasMatelisBlog/208_ssas-white-paper-list http://www.ssas-info.com/VidasMatelisBlog/208_ssas-white-paper-list#comments Thu, 27 Jan 2011 04:07:14 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=208 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:

The post SSAS White Paper list first appeared on Vidas Matelis Analysis Services Blog.

]]> http://www.ssas-info.com/VidasMatelisBlog/208_ssas-white-paper-list/feed 11 My tweets from SQL PASS Summit 2009 – SSAS, PowerPivot, DAX and more http://www.ssas-info.com/VidasMatelisBlog/195_my-tweets-from-sql-pass-summit-2009-ssas-powerpivot-dax-and-more http://www.ssas-info.com/VidasMatelisBlog/195_my-tweets-from-sql-pass-summit-2009-ssas-powerpivot-dax-and-more#comments Sun, 08 Nov 2009 03:17:52 +0000 http://www.ssas-info.com/VidasMatelisBlog/?p=195 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.

The post My tweets from SQL PASS Summit 2009 – SSAS, PowerPivot, DAX and more first appeared on Vidas Matelis Analysis Services Blog.

]]> http://www.ssas-info.com/VidasMatelisBlog/195_my-tweets-from-sql-pass-summit-2009-ssas-powerpivot-dax-and-more/feed 3