How to Build a Tabular Model in SSAS

In the release of SQL Server 2012, Microsoft introduced the SQL Server Analysis Services (SSAS) tabular model, a database that runs in-memory or in Direct Query mode. These databases display data with relational data sources. Allowing them to deliver a quick and powerful way of providing self-service Business Intelligence to client applications such as Microsoft Power View and Microsoft Excel.

Edwin DavisHow to Build a Tabular Model in SSAS
Read More

Can You Do Traditional BI in the Cloud?

With all the focus on cloud and Azure, have you ever wondered if you can run your traditional BI workloads within Azure? You may ask, should we be putting our traditional BI workloads that we’ve been using like the SQL Stack, SSIS, SSAS and relational databases in Azure; can we even do that?

3CloudCan You Do Traditional BI in the Cloud?
Read More

Three SSAS Dimension Design Best Practices

Are you having issues with the performance and usability of your solution’s dimensions? In this blog, Pragmatic Works’ Senior Business Intelligence Consultant Dustin Ryan covers three best practices that for improving performance of SSAS dimensions as well as common mistakes in dimension design. Additionally, he’s discussing some common mistakes he sees users making with dimension design.

Tom WardThree SSAS Dimension Design Best Practices
Read More

Performance Tuning SSAS Best Practices

Looking to improve the performance of your SSAS solution? Dustin Ryan has you covered. In this post, he will discuss three best practices that you can follow to improve performance and management. Following these best practices will make a huge difference when dealing with large SSAS solutions.

Tom WardPerformance Tuning SSAS Best Practices
Read More

Exploring Excel 2013 for BI: Show Explore


Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature. In this post, Steve will delve into the Show Explore feature. Join Steve as he shows you how you can drill into details using the Show Explore feature once you’ve connected your SSAS cube to Excel.

Tom WardExploring Excel 2013 for BI: Show Explore
Read More

Exploring Excel 2013 for BI: Quick Explore


Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel has many functions that can often be confusing to users. In this new blog series Our resident expert, Steve Hughes, will cover a wide variety of Excel topics ranging from easy to complex. Steve will provide you tips and tricks he has discovered in his journey through Excel.

Quick Explore

So, you have connected Excel to your SSAS cube. You really wish you could cross drill easily in the product. If you have used PerformancePoint Services you know the process. Right click on the bar or cell and then choose the dimension to drill to using the information you clicked on as a starting point. You can now do this in Excel 2013 using Quick Explore. Here’s how to do it:

Tom WardExploring Excel 2013 for BI: Quick Explore
Read More