Blogs

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.

For more information or to register click here!

Books

Learn PowerPivot and Analysis Services-Tabular at your own pace with our latest book Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling). It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Blogs

Sort By: Most Recent | Most Viewed | Most Commented

SSAS Instance Not Starting

Issue: A customer reports an issue with a production SSAS Tabular instance not starting after reboot. The server has also an SSAS Multidimensional instance which starts just fine. There are no interesting messages in the Event Viewer. Resolution : During...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Mon, Jun 17 2013

Filed under: Analysis Services
Smart Date Keys Got Smarter

Using "smart" date surrogate integer keys in the format YYYYMMDD is a dimensional modeling best practice and venerable design technique. To make them smarter though, consider using the Date data type which was introduced in SQL Server 2008....

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Wed, Jun 12 2013

Filed under: Data Warehousing
What’s New for BI in SQL Server 2014?

The short answer is nothing much, which is probably good so we can catch our breath after the SQL Server 2012 and Office 2013 waves. As you've probably heard, Microsoft announced SQL Server 2014 at TechEd. SQL Server 2014 will be a database-focused...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Wed, Jun 5 2013

Filed under: SQL Server 2014
Configuring Power View Connectivity to Multidimensional

As I mentioned in my previous blog , CU4 for SQL Server 2012 SP1 includes the release bits of Power View Connectivity for Multidimensional (DAXMD). It allows you to create Power View reports from Multidimensional cubes. In this blog, I'll show you...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Sun, Jun 2 2013
Power View Connectivity to Multidimensional (DAXMD) Released

Microsoft released Cumulative Update 4 for SQL Server 2012 Service Pack 1. This is more than a regular cumulative update as it includes enhancements to both Power View and Analysis Services to support connecting Power View to OLAP cubes, aka as DAXMD...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Fri, May 31 2013

Filed under: Analysis Services
Microsoft Kerberos Configuration Manager for SQL Server

Anyone who has gone through configuring Kerberos knows that it's not fun. After having done a few installation, my personal record for configuring Kerberos for SharePoint, SSAS, SSRS, SQL Server, and PerformancePoint was 4 hours but I had all parties...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Fri, May 24 2013

Filed under: General
Best Practices for Implementing Enterprise BI Solution at SQL Saturday 2013

SQL Saturday 2013 in Atlanta was a raging success. Some 555 people attended which made it the most attended SQL Saturday even ever. I've uploaded the slides from my presentation "Best Practices for Implementing Enterprise BI Solution" to...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Sat, May 18 2013

Filed under: Events
Leveraging Data to Revolutionize a Mature Business by Bijal Patel at Atlanta BI Group on May 20th

Due to Memorial Day, we'll move our next Atlanta BI Group meeting to May 20th. The meeting will be sponsored by Strategy Analyzer. Our speaker will be Bijal Patel (Director of Data and Integration Services at Cox Media Group) and the topic is "Leveraging...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Mon, May 13 2013

Filed under: Events
Presenting at SQL Saturday in Atlanta

I'll present at SQL Saturday in Atlanta on May 18 th . Initially, I was planning to talk about dashboard options with the Microsoft BI stack but the organizers had a call for more advanced content. To accommodate this request, I'll present Best...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Sun, May 5 2013

Filed under: Events
Default Parameters in Power View

Scenario: You need to configure a Power View report to show data for a dynamic date, such as the current date or the last date with data. However, as it stands Power View doesn't support expressions. Workaround: Add a Boolean calculated column to...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Sat, May 4 2013

Filed under: Reporting Services
Best Practice and Creative Data Visualization by Jen Underwood for Atlanta BI

It looks like Atlanta BI Group will have a record attendance tonight with 74 people registered! Jen Underwood will present Best Practice and Creative Data Visualization. This fun, informative, and inspirational session covers both best practices and creative...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Mon, Apr 29 2013

Filed under: Events
Windows Azure Infrastructure Services

Microsoft announced today the availability of Windows Azure Infrastructure Services which is a collective name for running Virtual Machines and Virtual Networks in the cloud. Scott Guthrie's blog on this subject is very informative. Pricing get slashed...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Tue, Apr 16 2013

Filed under: Business Intelligence, Cloud
About Tableau 8

Jen Underwood highly recommended I attend the Tableau 8 tour on Tuesday to witness firsthand its new features. Naturally, I couldn't resist of comparing everything I saw with Microsoft BI. I took some time after the pretention to take 8.0 for a spin...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Fri, Apr 5 2013

Filed under: Business Intelligence, Events
Data Warehouse Physical Design Best Practices Session by Carlos Rodrigues at Atlanta BI Tonight

It looks like Carlos will deliver another slam tonight with a record number of some 63 people registered and counting… Join our Atlanta BI meeting at 6:30 to see his Data Warehouse Physical Design Best Practices presentation.

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Mon, Mar 25 2013

Filed under: Events
Query Options for Analytical Models and Transactional Reporting

Requesting both historical and transactional reports is a very common requirement. As they stand, neither Multidimensional nor Tabular are designed to support well transactional (detail-level) reporting with large datasets, as I discussed in my Transactional...

Posted to Prologika (Teo Lachev's Weblog) by tlachev on Sun, Mar 24 2013

Filed under: Analysis Services

1 2 3 4 5 Next > ... Last »

Powered by Community Server (Commercial Edition), by Telligent Systems

3DZL:andrewbelon.com

Blogs

Training

Books

Tags

Blogs