Prologika Forums

Making sense of data

Prologika (Teo Lachev's Weblog) » All Tags » PowerPivot (RSS)

Browse by Tags

Blogs

Prologika (Teo Lachev's Weblog)

Home

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.

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!

Syndication

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

PowerPivot Data Refresh in Excel 2013

What options does a PowerPivot user have to refresh data in a PowerPivot model on the desktop, aka PowerPivot for Excel? Prior to Excel 2013, the answer was just one – manual refresh by either clicking the Refresh button in the PowerPivot window...

Published Mon, Feb 4 2013 9:00 AM by tlachev

Filed under: PowerPivot
Is Excel Calculation Services Needed on a PowerPivot for SharePoint Application Server?

Scenario: A SharePoint 2010 scale-out farm with two application servers: APP1 – Runs Excel Calculation Services (ECS) APP2 – Runs PowerPivot for SharePoint (R2 or 2010) Do you need to start ECS on APP2 in order for PowerPivot for SharePoint...

Published Sat, Jun 2 2012 11:55 AM by tlachev

Filed under: SharePoint, PowerPivot
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 data or it wasn't derived from an Excel linked table or Windows Clipboard...

Published Wed, Mar 28 2012 9:29 AM by tlachev

Filed under: PowerPivot
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 the best tool on the market when it does. The focus will be on the...

Published Thu, Feb 23 2012 12:52 PM by tlachev

Filed under: PowerPivot
Online PowerPivot Class

I am teaching my online Applied PowerPivot class for personal and team business intelligence on Jan 24 th and 25 th and there are still seats available.

Published Fri, Jan 13 2012 8:40 AM by tlachev

Filed under: Training, PowerPivot
PowerPivot 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...

Published Thu, Nov 17 2011 2:12 PM by tlachev

Filed under: Business Intelligence, PowerPivot, SQL Server 11
Handling Dates in BISM Tabular

2308.AdventureWorks.zip If you have experience with multidimensional cubes, you know that most cubes have a Date dimension grained at a day level. If the fact table has multiple date keys, you can join the Date dimension multiple times to the measure...

Published Sun, Oct 30 2011 7:41 PM by tlachev

Filed under: PowerPivot, BISM
CTP3 Issues with PowerPivot Management Dashboard

I ran into a couple of snags with the PowerPivot Management Dashboard and CTP3 of Denali. In this case, I've installed PowerPivot for SharePoint on a standalone domain controller. The Actions web part of the PowerPivot Management Dashboard refuses...

Published Mon, Aug 29 2011 1:49 PM by tlachev

Filed under: SharePoint, PowerPivot, SQL Server 11
Transactional Reporting with BISM Tabular

Continuing on BISM Tabular performance (see my Cube vs. VertiPaq Query Performance blog ), I was disappointed to find that there are no performance improvements in PowerPivot/BISM Tabular in CTP3 in the area of detailed (transactional-level) reporting...

Published Sun, Aug 7 2011 9:26 PM by tlachev

Filed under: PowerPivot, BISM
PowerPivot Configuration Tool

One great enhancement in SQL Server 11 (Denali) is the PowerPivot for SharePoint setup refactoring. Previously, the PowerPivot for SharePoint setup and configuration was included and performed at the end of the SQL Server setup. Consequently, it was very...

Published Sun, Aug 7 2011 8:37 PM by tlachev

Filed under: SharePoint, PowerPivot, SQL Server 11
PowerPivot Stories from the Trenches

Now that a snow blizzard has paralyzed Atlanta for a week, what a better way to start the new year than sharing a PowerPivot success story. A bank institution has approached Prologika to help them implement a solution to report the customer's credit...

Published Sat, Jan 15 2011 1:05 PM by tlachev

Filed under: Business Intelligence, PowerPivot
PowerPivot Time Calculations

A recommended practice for implementing time calculations in PowerPivot is to have a Data table with a datetime column. Kasper de Jonge explains in more details in this blog . This approach will probably save effort when importing data from normalized...

Published Sat, Jan 15 2011 10:55 AM by tlachev

Filed under: PowerPivot
Book Review - Microsoft PowerPivot for Excel 2010

I dare to predict that in a few years after SQL 11 ships, there will be two kinds of BI professionals – those who know the Business Intelligence Semantic Model and those who will learn it soon. By the way, the same applies to SharePoint. What can...

Published Wed, Nov 24 2010 9:59 PM by tlachev

Filed under: Books, PowerPivot
Crescent on the Horizon

Now that the official word got out during the Ted Kummert's keynote today at SQL PASS, I can open my mouth about Crescent – the code name of an ad-hoc reporting layer that will be released in the next version of SQL Server – Denali. Crescent...

Published Tue, Nov 9 2010 8:46 PM by tlachev

Filed under: Reporting Services, Analysis Services, PowerPivot, SQL Server 11
Applied PowerPivot Course Available

I am excited to announce that Prologika has added an Applied PowerPivot course to the list of our training offerings in response to the strong interest for self-service BI. The class can be delivered as two-day online class (4 hours each day) or as one...

Published Sun, Aug 22 2010 8:59 PM by tlachev

Filed under: Training, Self-service BI, PowerPivot

1 2 Next >

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

3DZL:andrewbelon.com