Finding Source Column Names in PowerPivot
Question: How do I find the source column name in PowerPivot if I’ve renamed and moved columns around? Answer: Assuming that the table doesn’t use a custom query to import […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
VertiPaq Rebranded as xVelocity
Apparently, the name “VertiPaq” wasn’t catchy enough so Microsoft rebranded it as xVelocity (probably got tipped by Comcast). This is just a name change, no new features. Glossary xVelocity: The […]
BIDS Helper 1.6 Beta Released
Fellow MVPs have just released the latest public beta build of BIDS Helper, which should one of the first utilities you install after you install SQL Server on your machine. […]
Hiding SQL Server 2012 Reporting Services Extensions in SharePoint
To continue my Report Server Settings in SQL Server 2012 SharePoint Integration Mode blog, here is another example of how to use the new PowerShell-based configuration mechanism to hide a […]
Can’t Activate Reporting Services Service in SharePoint
I upgraded SQL Server 2012 from RC0 to RTM today on a SharePoint application server which was configured for Reporting Services integration. The upgrade went with no errors but I […]
Presenting at SQL Server Special Ops Tour Atlanta
I’ve been honored to be selected by Microsoft to present the Self-service BI using PowerPivot and Power View session for the SQL Server Special Ops Tour in Atlanta on Monday, […]
Finding Reporting Services Service in SharePoint
SharePoint is a like an ocean – the further you go, the deeper it gets Ancient proverb Scenario: Configure SQL Server 2012 Reporting Services on a multi-server SharePoint farm with […]
Presenting Personal BI with PowerPivot v2
I’ll be presenting “Personal BI with PowerPivot v2” for the Atlanta BI Group on Monday, February 27th. Join us to learn when personal BI makes sense and why PowerPivot is […]
Announcing My New Book
My new book, Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling), will start shipping in a week with all popular resellers, such as Amazon, B&N, etc. I’ve been working […]
ProcessUpdate and Partition Scans
I’m working on minimizing the cube processing for a cube with some two billion rows in a fact table. I put together an ETL package that processes the dimensions with […]
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.
