-
SharePoint 2013 and SQL Server 2012
October 26, 2012 / No Comments »
As I mentioned before, Microsoft released SharePoint 2013 and Office 2013 and the bits are now available on MSDN Subscriber Downloads. I am sure you are eager to try the new BI features. One thing that you need to be aware of though is that you need SQL Server 2012 Service Pack 1 in order to integrate the BI features (PowerPivot for SharePoint and SSRS) with SharePoint 2013. If you run the RTM version of SQL Server 2012 setup, you won't get too far because it will fail the installation rule that SharePoint 2010 is required. That's because the setup doesn't know anything about SharePoint 2013 and the latest release includes major architectural changes. Then the logical question is where is SQL Server 2012 SP1 now that is a prerequisite for SharePoint 2013 BI? As far as I know there isn't a confirmed ship date yet but it should arrive...
-
Business Intelligence on Surface
October 26, 2012 / No Comments »
Microsoft has started shipping the cool Surface RT tablets this week with Surface Pro to follow in January. Naturally, a BI person would attempt BI in Excel only to find that BI and Power View (no Silverlight support) are not there as Kasper explains. It's important to know that the RT version of Surface is limited to native Windows 8 applications only, it comes preinstalled with Office 2013, and you can't install non-Windows 8 applications. If you are interested in BI or running non-Windows 8 apps, you need the Pro version. This means that you and I need to wait until January next year so no Surface for Christmas.
-
Windows 8 Hyper-V Support
October 13, 2012 / No Comments »
I installed Windows 8 shortly it was released and I've been running it for almost two months now. I'm still in a learning mode to teach old dog new tricks. I have a few gripes here and there, such as the need for two screens (start screen and desktop), the absence of the start button and its search, the quest for dumbing down the OS, and the fact that my Quickbooks PDF converter doesn't work anymore. However, I do like the performance boost (Windows 8 really flies on a solid state disk). I also discover gems here and there and one of them is the Hyper-V support. For those of you who need to run virtual machines, such as to test prerelease bits or run other guest operating systems, you know that in the pre-Windows 8 era you had to rely on either VirtualBox or VMWare because Virtual PC wasn't...
-
Office 2013 and SharePoint 2013 Go Live
October 12, 2012 / No Comments »
I have to admit this came as a surprise to me as I expected them to go live next year. Microsoft just announced that Office 2013 and SharePoint 2013 went live. Time for celebrating, learning, and adopting these great technologies! Check my coverage about what's new in Office and SharePoint 2013 BI.
-
Prologika Newsletter Fall 2012
October 12, 2012 / No Comments »
I started a newsletter and I plan to update it on a quarterly basis. The topic of the first issue is Big Data. If you like the newsletter, you're welcome to subscribe and forward.
-
Your Data Warehouse in the Cloud?
October 11, 2012 / No Comments »
I spoke with a customer today that has implemented Salesforce.com. For those who are not familiar with Salesforce, it's a popular cloud-based, customer relationship management (CRM) product. As it usually happens, just when you're done with the Salesforce implementation, you're immediately faced with the challenge of consolidated reporting. It won't be long before the Vice President of Sales asks you to integrate sales data residing in Salesforce.com and your on-premise data sources. In this case, the customer went to Dreamforce (the Salesforce premier conference) in search for integration options and was advised to solve the report consolidation issue by … migrating their multi-terabyte data warehouse to Salesforce.com! I'm sure that this approach makes perfect sense to Salesforce.com, but it's hardly in the customer's best interest. First, although Salesforce is extensible and you can add custom objects (tables), Salesforce.com is not designed to host relational databases. As far as I know,...
-
MVP for Eight Years!
October 1, 2012 / No Comments »
Just got the news that my MVP (SQL Server) award got extended for another year! This is my eight renewal.
-
Fix for “Wide” MDX Query Performance Degradation
September 16, 2012 / No Comments »
We ran into a situation where a wide MDX query requesting many regular and semi-additive measures side by side can degrade the Analysis Services server performance. As I explained in this connect bug report, the customer had a Reporting Services report that includes many measures (close to a hundred). Users insisted on having this report to be able to export all results in Excel and pivot on them. Of course, one of the advantages of having a cube is to make this exact requirement unnecessary but old habits die hard. We've noticed that when the report includes 75 measures from a single measure group, the query executes within 20 seconds. However, when adding more measures from the same measure group, the query performance degrades to minutes. The measures are either regular (persisted) measures or simple calculated member wrappers and don't use any intensive formulas or scope assignments. The important point...
-
SQL Server 2012 CU3 Available
September 4, 2012 / No Comments »
Microsoft just released Cumulative Update 3 of SQL Server 2012. Among other bug fixes, this CU includes critical fixes for columnstore indexes that we've reported to Microsoft. If you use SQL Server 2012 columnstore, you must install CU3. The important columnstore-related fixes are: http://support.microsoft.com/kb/2703193 http://support.microsoft.com/kb/2708786
-
Prologika is Microsoft Gold Business Intelligence Partner
August 17, 2012 / No Comments »
I'm excited to announce that Prologika is now a Microsoft Gold Business Intelligence Partner. This reconfirms our reputation as a premier BI consulting and training company in Atlanta. According to Microsoft, only top 5% of the Microsoft partners worldwide have Silver or Gold competency, and only 1% with Gold competency. Kudos to all Prologika consultants on the team who helped us to achieve this major accomplishment!
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 Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.
