PowerPivot Posts
Filter     Display # 
# Article Title Date Author
1 Comparing Analysis Services and PowerPivot 2010-03-13 Ashvini Sharma
2 Building Data Relationships in PowerPivot 2010-03-12 Artemakis Artemiou
3 Using PowerPivot’s Copy-Paste Support for Importing Data from Word 2010-03-12 Artemakis Artemiou
4 Q: I have a field in the pivot that shows duration on some event in seconds. How can I create calculated measure using DAX that would convert numeric result (seconds) to string in the format hh:mm:ss? 2010-03-10 Vidas Matelis
5 Writing a RANK measure (and living to tell the tale) 2010-03-10 Rob Collie
6 A Peek Inside: Unloading PowerPivot data 2010-03-06 Dave Wickert
7 Installing the right version of SharePoint 2010-03-06 Dave Wickert
8 Thoughts on how PowerPivot and SSAS could work together 2010-03-06 Chris Webb
9 Make your PowerPivot on SharePoint “view only” 2010-03-04 Kasper de Jonge
10 Keeping a workbook ‘pinned’ in memory 2010-03-04 Dave Wickert
11 Video - Microsoft PowerPivot DataFeed Source 2010-03-02 Nico Verbaenen
12 Video - Microsoft PowerPivot Loading Data 2010-03-02 Nico Verbaenen
13 Video - Microsoft PowerPivot Creating Reports 2010-03-02 Nico Verbaenen
14 Video - Microsoft BI PowerPivot DAX Time calculations : YTD 2010-02-26 Nico Verbaenen
15 Create simple and effective reports for Commerce Server with PowerPivot (aka Gemini) 2010-02-25 Gael Duhamel
16 Revisiting ALL() 2010-02-25 Rob Collie
17 Diagnostic Guide for Usage and the PowerPivot Management Dashboard 2010-02-25 Ankur Goyal
18 Why you may want to use RBS for your #PowerPivot for #SharePoint Farm 2010-02-24 Denny Lee
19 When is null not a null? 2010-02-24 Dave Wickert
20 SUMX() – The 5-point palm, exploding fxn technique 2010-02-24 Rob Collie
21 Screencast: Using datamining with PowerPivot in Excel 2010-02-23 Kasper de Jonge
22 Screencast: Using datamining with PowerPivot in Excel 2010-02-13 Kasper de Jonge
23 Cannot add the specified assembly to the global assembly cache 2010-02-13 Lee Graber
24 Rob Collie PowerPivot video (from Swedish UG meeting) 2010-02-11 Rob Collie
25 Jewelry Mashup for Alpha Geek Challenge 2010-02-11 Bill Jelen
26 Granting Excel Services access rights to your #PowerPivot for SharePoint Farm 2010-02-11 Denny Lee
27 Producing and consuming OData feeds: An end-to-end example 2010-02-10 Jon Udell
28 Using Time intelligent PowerPivot functions with fiscal year 2010-02-09 Kasper de Jonge
29 How to relate tables in DAX without using relationships 2010-02-09 Marco Russo
30 Surprising Example of PowerPivot Compression 2010-02-09 Rob Collie
31 The data connection uses Windows Authentication and user credentials could not be delegated 2010-02-09 Lee Graber
32 Dashboard Bubble Chart Shows a Red X (fails to load) 2010-02-09 Lee Graber
33 PowerPivot Retail Analysis Example 2010-02-09 Rob Kerr
34 A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook 2010-02-09 Lee Graber
35 Troubleshooting PowerPivot Relationships 2010-02-08 Kasper de Jonge
36 Avoiding calculated column in DAX 2010-02-06 Marco Russo
37 PowerPivot Data in Scatter Charts, etc. 2010-02-06 Rob Collie
38 Table Denormalization Study in PowerPivot 2010-02-05 Marco Russo
39 Pivots, Cube Formulas, Named Sets … Oh my! 2010-02-05 Denny Lee
40 Pivots, I have not forgotten ye! 2010-02-05 Rob Collie
41 Hands-on-Labs - PowerPivot in SQL Server 2008 R2 (Part of the SQL Server training kit) 2010-02-04 Microsoft
42 Video - PowerPivot for Excel/SharePoint 2010 - Interview with T.K. Anand 2010-02-04 T.K. Anand
43 Creating a SharePoint 2010 Business Intelligence VM Image (using SQL Server 2008 R2 CTP) 2010-02-03 Steve Mann
44 Introducing CUBESET() and CUBERANKEDMEMBER() 2010-02-03 Rob Collie
45 PowerPivot and BI architecture 2010-02-02 Thomas Ivarsson
46 Hands-on PowerPivot: To the Cloud 2010-02-02 David Ramel
47 Management Features of PowerPivot for SharePoint 2010-02-02 John Hancock
48 Parameterizing the report 2010-02-01 Rob Collie
49 SQLBits Video - Self Service Business Intelligence- Project Gemini 2010-02-01 Bob Duffy
50 Video - SharePoint 2010 BI Overview 2010-01-31 Mike Fitzmaurice
51 Reading your #PowerPivot Profiler trace 2010-01-30 Denny Lee
52 QlikView from a PowerPivot standpoint 2010-01-30 Donald Farmer
53 What database support is needed 2010-01-30 Dave Wickert
54 OData: There’s a feed for that 2010-01-30 Douglas Purdy
55 PowerPivot for SharePoint Video 2010-01-29 Rob Collie
56 Create a #PowerPivot report filtered by the Top X Users by "Logic" 2010-01-28 Denny Lee
57 Rob Collie (PowerPivotPro) videos on YouTube 2010-01-27 Rob Collie
58 Sales Forecasting with Excel 2010 (and PowerPivot) 2010-01-27 Microsoft
59 Memory Considerations about PowerPivot for Excel 2010-01-26 Marco Russo
60 Powerpivot - Installation, first report, dax 2010-01-25 Yaniv Mor
61 PowerPivot Cookery - video that explains what PowerPivot is through cooking example 2010-01-25 Andrew Fryer
62 How to start debugging a PowerPivot for SharePoint installation issue 2010-01-24 Lee Graber
63 Self-Service BI with PowerPivot for Excel 2010 2010-01-23 Thiago Zavaschi
64 PowerPivot, DAX and Semi-additive measures 2010-01-21 Russell Christopher
65 Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ 2010-01-21 Lee Graber
66 PowerPivot introduction videos - load, analyse and use in SharePoint 2010-01-19 Andrew Fryer
67 #PowerPivot Data Refresh SSRS Report 2010-01-19 Denny Lee
68 How to manually update your PowerPivot Management Dashboard 2010-01-19 Dave Wickert
69 Why you shouldn’t stop / start Analysis Services from SCM when running in SharePoint Integration Mode 2010-01-19 Lee Graber
70 ABC Analysis in PowerPivot 2010-01-19 Marco Russo
71 Not your average PowerPivot report 2010-01-19 Rob Collie
72 Screencast: Import data from reporting services into PowerPivot 2010-01-19 Kasper de Jonge
73 Enable PerformancePoint on SharePoint 2010 2010-01-15 Kasper de Jonge
74 How do I get the menu options for individual reports within the #PowerPivot Gallery? 2010-01-15 Denny Lee
75 How to PowerPivot outlook data (*.ost or *.pst) data in Microsoft Office Excel 2010 2010-01-13 Roel van Lisdonk
76 Solving the 'Events in Progress' Problem in DAX, Part Two: Aggregating Dates and Multiselect 2010-01-13 Chris Webb
77 The MIE Podcasts – Rob Collie 2010-01-13 Rob Collie
78 Screencast: Introduction to time intelligent functions in PowerPivot 2010-01-13 Kasper de Jonge
79 Q: How can I create Fiscal Date/Time table for PowerPivot if I do not have any source for that? 2010-01-12 Vidas Matelis
80 So i requested a PowerPivot workbook from SharePoint, what happens? 2010-01-10 Kasper de Jonge
81 Manage the sort order of your PowerPivot sheets in the SharePoint Gallery 2010-01-10 Kasper de Jonge
82 Q: How can I create Calendar Date/Time table for PowerPivot if I do not have any source for that? 2010-01-09 Vidas Matelis
83 Touchdown Problem Solved, and COUNTROWS 2010-01-09 Rob Collie
84 Excel PowerPivot Review - Video 2010-01-08 Chandoo
85 Solving the 'Events in Progress' Problem in DAX 2010-01-07 Chris Webb
86 Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI 2010-01-06 Denny Lee
87 Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows? 2010-01-05 Vidas Matelis
88 The PowerPivot Experiment 2010-01-05 Artemakis Artemiou
89 Q: How can I change maximum PowerPIvot file size that can be uploaded to SharePoint 2010? 2010-01-05 Vidas Matelis
90 Q: Where PowerPivot for SharePoint logs are located and how to read them? 2010-01-05 Vidas Matelis
91 Creating a PerformancePoint 2010 dashboard on a published SharePoint PowerPivot app 2010-01-04 Kasper de Jonge
92 How CALCULATE works in DAX 2010-01-03 Marco Russo
93 Creating a SSRS report on a published SharePoint PowerPivot app 2009-12-31 Kasper de Jonge
94 Solving a business problem with Powerpivot CTP3 using DAX Timefunctions 2009-12-31 Kasper de Jonge
95 Instructions for the installation and configuration of Reporting Services in SharePoint Integration Mode 2009-12-30 Dave Wickert
96 PowerPivot for SharePoint Single Server Install with Dedicated SQL Server 2009-12-30 Dave Wickert
97 Distinct Count Measure in PowerPivot using DAX 2009-12-26 Marco Russo
98 How to add DAX calculations to the PowerPivot workbooks 2009-12-18 Vidas Matelis
99 Recorded webcast - A Preview to PowerPivot Server Best Practices 2009-12-17 Microsoft
100 Monitor your SSIS Package execution with PowerPivot 2009-12-17 Kasper de Jonge
101 DAX CALCULATE, and Rapid Iteration 2009-12-17 Rob Collie
102 Step by Step guide for creating demo PowerPivot workbook from AdventureWorksDW SQL tables 2009-12-17 Vidas Matelis
103 Using PowerPivot with SQL Azure 2009-12-16 Stephen Forte
104 PowerPivot DAX: CALCULATE is a supercharged SUMIF 2009-12-15 Rob Collie
105 Recorded webcast: "Introduction to PowerPivot or How I Learned to Stop Worrying and Love Excel" 2009-12-13 Chris Webb
106 Excel Services delegation 2009-12-12 Dave Wickert
107 PowerPivot 101 – an Introduction 2009-12-11 Andrew Fryer
108 PowerPivot online demos 2009-12-11 Microsoft
109 Refreshing PowerPivot Data 2009-12-10 Robert C. Cain
110 Reported problems installing PowerPivot for SharePoint 2009-12-10 Dave Wickert
111 DAX's CALCULATE() function - Pivots will never be the same 2009-12-09 Rob Collie
112 Putting the "Intelligence" in "Business Intelligence" 2009-12-07 Rob Collie
113 PowerPivot - Data Import In November CTP 2009-12-07 Ashvini Sharma
114 Many-to-Many relationships in PowerPivot 2009-12-07 Marco Russo
115 Lookups in PowerPivot Calculated Columns - Using the RELATED Function 2009-12-07 Robert C. Cain
116 Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months) 2009-12-05 Vidas Matelis
117 Getting difference of two dates in seconds with PowerPivot DAX 2009-12-05 Kasper de Jonge
118 DAX: Running Totals 2009-12-05 Chris Webb
119 Visualizing SQL Indices with PowerPivot 2009-12-05 Rob Collie
120 Calculated Columns in PowerPivot 2009-12-04 Robert C. Cain
121 Why PowerPivot for SharePoint? 2009-12-02 Dave Wickert
122 Create simple and effective reports through PowerPivot (aka Gemini) 2009-12-02 Gaël Duhamel
123 Combining Data from Multiple Data Sources in PowerPivot 2009-12-02 Robert C. Cain
124 Calling your PowerPivot workbook on SharePoint 2010 remotely 2009-12-02 Kasper de Jonge
125 Creating Tables in PowerPivot 2009-12-02 Robert C. Cain
126 Make your PowerPivot sheet look great in SharePoint 2010 2009-12-01 Kasper de Jonge
127 First steps in DAX: Year-To-Date 2009-12-01 Chris Webb
128 Q: Where in SharePoint can I define "Business Hours" for PowerPivot data refresh? 2009-12-01 Vidas Matelis
129 Q: In my source data I have daily balance values. How in PowerPivot for Excel can I create calculation that shows correct closing balance for year, quarter and month? 2009-11-29 Vidas Matelis
130 SQL Server Reporting Services Reports in the PowerPivot Gallery 2009-11-29 Russell Christopher
131 Understanding DAX - Context (Row) 2009-11-28 Shaun Ryan
132 CTP3 Setup Error: Could not load file or assembly "Microsoft.AnalysisServices.SharePoint.Integration" 2009-11-28 Russell Christopher
133 A Peek Inside: Why no cross-farm support (PowerPivot for SharePoint)? 2009-11-28 Dave Wickert
134 Q: How can I see Analysis Services database structure that is stored within PowerPivot ? 2009-11-27 Vidas Matelis
135 Creating useful PowerPivot data models for public consumption via Reporting Services 2009-11-26 Russell Christopher
136 Q: How can I delete PowerPivot report published into SharePoint PowerPivot gallery? 2009-11-26 Vidas Matelis
137 Q: How can I check what version of PowerPivot for Excel is installed on my machine? 2009-11-25 Vidas Matelis
138 Combine data from the cloud with local data using PowerPivot and Dallas 2009-11-25 Kasper de Jonge
139 Using PowerPivot to combine cube (SSAS) data with manual data, the movie 2009-11-24 Kasper de Jonge
140 Import Filters in PowerPivot 2009-11-24 Robert C. Cain
141 Using PowerPivot to combine cube (SSAS) data with manual data 2009-11-23 Kasper de Jonge
142 Video: SharePoint 2010 and PowerPivot 2009-11-22 Michael Gannotti
143 How to install PowerPivot for Excel and list of know issues 2009-11-21 Vidas Matelis
144 When is a refresh not a refresh? 2009-11-21 Dave Wickert
145 Sharing workbooks using PowerPivot Gallery 2009-11-21 John C. Hancock
146 PowerPivot Data Refresh 2009-11-21 Dave Wickert
147 Introducing Microsoft PowerPivot 2009-11-20 Robert C. Cain
148 Video: Custom Theming A SharePoint 2010 Site Using PowerPoint 2010 2009-11-20 Michael Gannotti
149 PowerPivot for SharePoint existing farm installation guide (draft paper by Microsoft) 2009-11-20 Microsoft
150 PowerPivot for SharePoint single server install guide (draft paper by Microsoft) 2009-11-20 Microsoft
151 Step by step guide on installing PowerPivot for SharePoint on a single machine 2009-11-20 Vidas Matelis
152 Data Connection Libraries missing in SharePoint 2010 2009-11-19 Bob Duffy
153 A Peek Inside: Why are domain accounts needed? 2009-11-19 Dave Wickert
154 Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction 2009-11-19 Microsoft
155 Installing PowerPivot for SharePoint on a domain controller 2009-11-18 Dave Wickert
156 Troubleshooting #PowerPivot Excel Services connectivity 2009-11-18 Denny Lee
157 PowerPivot overview and How To videos 2009-11-18 Microsoft
158 Introducing PowerPivot DAX Measures 2009-11-16 Rob Collie
159 Steps taken during a PowerPivot data refresh 2009-11-13 Dave Wickert
160 Temperature Mashup Example 2009-11-13 Rob Collie
161 List of PowerPivot DAX functions (short) 2009-11-13 Vidas Matelis
162 List of PowerPivot DAX functions with description 2009-11-13 Vidas Matelis
163 A Peek Inside: The client architecture 2009-11-12 Dave Wickert
164 List of suggested datasets to test PowerPivot 2009-11-11 Vidas Matelis
165 SharePoint Prerequisite Lab Installation Tip (#PowerPivot CTP3 Install) 2009-11-11 Denny Lee
166 Geminute - short videos that shows what you can do with PowerPivot 2009-11-11 Donald Farmer
167 DAX: The =RELATED() Function 2009-11-10 Rob Collie
168 A 48 hour case study from Bing - Zero to Sixty :) 2009-11-10 Rob Collie
169 What happens when you run a Data Refresh within PowerPivot for SharePoint? 2009-11-09 Denny Lee, Dave Wickert
170 PowerPivot's impact on BI pros? 2009-11-09 Rob Collie
171 My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more 2009-11-09 Vidas Matelis
172 PowerPivot Linked tables 2009-11-08 T.K. Anand
173 PowerPivot Data Feeds 2009-11-08 John C. Hancock
174 Understanding why an Excel PowerPivot workbook is so large 2009-11-07 Denny Lee, Dave Wickert
175 For Excel PowerPivot, the database is IN the workbook 2009-11-07 Denny Lee, Dave Wickert
176 PowerPivot for SharePoint 2010 - The Business User’s Perspective 2009-10-29 Joseph Chirilov
177 Project BI bloggers – Analysis in PowerPivot (ex-Gemini) 2009-10-28 Tomislav Piasevoli
178 What is PowerPivot? 2009-10-28 Rob Collie
179 Gemini (PowerPivot) Does Cloud! 2009-10-28 Andrew Brust
180 Announcing the Great Football Project (PowerPivot) 2009-10-27 Rob Collie
181 Trying to solve a business problem with Powerpivot, Gemini CTP2 2009-10-26 Kasper de Jonge
182 Using PowerPivot with Excel 2010 2009-10-24 Joseph Chirilov
183 Introducing PowerPivot 2009-10-23 Ashvini Sharma
184 Donald Farmer on Gemini (PowerPivot) - audio interview 2009-10-23 Donald Farmer
185 Creating a Custom Gemini/PowerPivot Data Feed - Method 1 - ADO.NET Data Services 2009-10-20 Sacha Tomey
186 Gemini (PowerPivot)- Copy/Paste 2009-10-14 T.K. Anand
187 PowerPivot DAX function list with samples 2009-10-08 Vidas Matelis
188 Introduction to Data Analysis Expressions (DAX) in Gemini (PowerPivot) 2009-10-01 Howie Dickerman
189 Leaf level queries in Gemini (PowerPivot) and SSAS 2008 2009-09-19 Thomas Ivarsson
190 Importing data into Gemini (PowerPivot) 2009-09-09 Edward Melomed
191 Channel 9 - Donald Farmer and Julie Strauss: Inside Project Gemini (PowerPivot) 2009-09-01 Donald Farmer
192 Gemini (PowerPivot) CTP2 Install Experience and Overview 2009-08-29 Dan English
193 Overview of Gemini (PowerPivot) features 2009-08-25 Ashvini Sharma
194 Soccer statistics in Gemini (PowerPivot) and Excel 2010 2009-08-23 Thomas Ivarsson
195 SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables 2009-08-19 Vidas Matelis
196 Gemini (PowerPivot) First Thoughts 2009-08-17 Chris Webb
197 Working with Gemini (PowerPivot) and Excel 2010 to make a pivot table 2009-08-17 Kasper de Jonge
198 BI Power Hour demo - Sneak Preview of Gemini (PowerPivot) 2009-05-21 Donald Farmer
199 Microsoft Project Gemini (PowerPivot) links 2009-04-29 Donald Farmer