Online PowerPivot Class
I am teaching my online Applied PowerPivot class for personal and team business intelligence on Jan 24th and 25th and there are still seats available.
Read articleSkip to articles
Making sense of data.
PROLOGIKA BLOG · IDEAS FROM THE FIELD
Making sense of data.
Sharing what we learn.
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articlesHappy New Year 2012!
As 2011 is winding down, it's time to reflect on the past and plan for the future. 2011 has been a very exciting year for Microsoft BI and me. Gartner positioned Microsoft as a leader in the 2011 Magic Quadrant for Business Intelligence Platforms. Although SQL Server 2012 will technically ship early next year, we can say it's a done deal as it's currently in…
Read articleUsing the Hash Group Hint to Speed up ColumnStore Indexes
As I mentioned in my blog post on this subject, I've found a good use of SQL Server 2012 columnstore indexes to speed up significantly ETL processes that need to aggregate large datasets. But we run into a snag, which got promoted to a bug by Microsoft Support Services. Under some conditions, SQL Server would create a plan that uses a "stream aggregate" operator instead…
Read articleUpgrade Issues with PerformancePoint 2010 Filters
Issue: Migrate a PerformancePoint dashboard from MOSS 2007 to SharePoint 2010. We used the Import PerformancePoint Content feature to import existing dashboards from the PerformancePoint database and this saved us a lot of effort. However, filters failed with this rather obscure error: After tracing with SQL Profiler and looking at the Windows Event log, we saw the following almost as useless error): Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Query (1,…
Read articleColumnstore Indexes To Speed ETL
SQL Server 2012 introduces columnstore indexes. Using the same in-memory VertiPaq engine that powers PowerPivot and Analysis Services Tabular, columnstore indexes can speed up dramatically SQL queries that aggregate large datasets. For a great introduction to columnstore indexes, see the video presentation, "Columnstore Indexes Unveiled" by Eric Hanson. I personally don't see columnstore indexes as a replacement of Analysis Services because an analytical layer has…
Read articleWhat’s New in Power View RC0
I was just about to write a blog about the new features in the Release Candidate (RC) build of Power View and I saw that Robert had written a great blog already. It's great to see the product coming along so nicely. Can't wait to be able to use multidimensional cubes as data sources! One feature that stirred a lot of excitement and deserves more…
Read articleSQL Server 2012 RC is Here
The public release of Microsoft SQL Server 2012 RC0 is now available.
Read articlePowerPivot for Excel SQL Server 2012 RC0 is Here
Microsoft just published the RC0 (release candidate) bits of PowerPivot for Excel SQL Server 2012. Kudos for Microsoft for making the RC bits public this time. Stay tuned for an announcement for the arrival of the SQL Server 2012 RC bits soon. The RC build is a feature-complete and stable build. This will be the last pre-release build until SQL Server 2012 officially ships next…
Read articleReport Server Settings in SQL Server 2012 SharePoint Integration Mode
Well, rules have changed. As Jaime Tarquino from the SSRS team explained in his blog, "SQL Server 2012 Reporting Services SharePoint Integrated Mode", there is no rsreportserver.config file anymore moving to Reporting Services 2012 in SharePoint integration mode (there are no configuration changes with native mode). Instead, the configurations sections are now saved in the SharePoint configuration database. Problem: A customer plans to upgrade to…
Read articleMDXParameter Sample
MDXParameter is a nice little utility that captures MDX queries sent from SSRS reports and replaces parameter placeholders with the actual values. I've been using the excellent Darren Gosbell's Query Capture sample which is one of the first utilities I install when starting a new project. MDXParameter has a few more features that you might find appealing, including saving the queries in a database and…
Read articleFollow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. We empower organizations to make sense of their data with effective and modern BI solutions.
