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 […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
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 […]
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 […]
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 […]
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 installations, my personal record for configuring Kerberos for SharePoint, SSAS, SSRS, SQL Server, […]
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 […]
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 […]
Presenting at SQL Saturday in Atlanta
I’ll present at SQL Saturday in Atlanta on May 18th. Initially, I was planning to talk about dashboard options with the Microsoft BI stack but the organizers had a call […]
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 […]
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 […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
