PowerPivot Posts
Filter     Display # 
# Article Title Date Author
1 Working with PowerPivot: Roll Your Own Hierarchies 2010-09-01 Tim Knight
2 What happened to my PowerPivot Excel Data? 1904? What the? 2010-09-01 Dan English
3 O'Reilly Webcast: Self-Service Business Intelligence with Microsoft PowerPivot 2010-09-01 Andrew Brust
4 Cleaner SharePoint pages, and an offer to share 2010-09-01 Rob Collie
5 Using SSAS 2005/2008 as PowerPivot Data Source: Measures Are Imported as Text Columns 2010-08-31 Marco Russo
6 PowerPivot for SharePoint: Single Server Installation 2010-08-31 Microsoft
7 Project: Gain insight into your music taste using Last.fm, PowerPivot and the PivotViewer 2010-08-31 Kasper de Jonge
8 A few tips on maintainability 2010-08-31 Rob Collie
9 The single version of the truth in PowerPivot 2010-08-29 Thomas Ivarsson
10 Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX 2010-08-29 Marco Russo
11 Microsoft PowerPivot: Making Excel Analytics Work 2010-08-29 Andrew Brust
12 PowerPivot VBA Macro Mania! 2010-08-24 Rob Collie
13 Using SSAS 2005/2008 as PowerPivot Data Source: Calculated Members 2010-08-24 Marco Russo
14 Using SSAS 2005/2008 as PowerPivot Data Source: Query Designer 2010-08-24 Marco Russo
15 Predict the future using Predixion data mining and PowerPivot 2010-08-24 Kasper de Jonge
16 Datamining using PowerPivot and Predixion Insight 2010-08-24 Kasper de Jonge
17 Determine the min value over rows in a group using MINX in PowerPivot 2010-08-24 Kasper de Jonge
18 How much data can I load into PowerPivot? 2010-08-24 Dave Wickert
19 Micro ETL in the PowerPivot age 2010-08-24 Goban Saor
20 Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up! 2010-08-24 Denny Lee
21 Calculating Run Rate in DAX for PowerPivot 2010-08-24 Alex Whittles
22 Extranet Analytics Products Using PowerPivot! 2010-08-24 Rob Collie
23 Using SSAS 2005/2008 as PowerPivot Data Source: Calculated Members 2010-08-19 Marco Russo
24 Free chapter 4 from the book "Microsoft PowerPivot for Excel 2010 - Give your data meaning" 2010-08-18 Marco Russo
25 PowerPivot Technical Diagram: PowerPivot Security Architecture 2010-08-18 Denny Lee
26 Importing data from Analysis Services 2000 to PowerPivot 2010-08-18 Marco Russo
27 Using PowerPivot with “Dallas” CTP3 2010-08-18 Julie Strauss
28 Pivot Refresh vs. Update – is there a real difference? 2010-08-16 Rob Collie
29 Two common PowerPivot error messages 2010-08-16 Rob Collie
30 PowerPivot for SharePoint:Set of videos by Lee Graber 2010-08-16 Lee Graber
31 Amir Netz and Ariel Netz Talk on PowerPivot, DAX, Report Builder and PivotViewer 2010-08-16 Ella Maschiach
32 Using PowerPivot with “Dallas” CTP3 2010-08-15 Microsoft
33 7 reasons to choose for SSAS or PowerPivot 2010-08-12 Jan van Dijk
34 PowerPivot Data Refresh with Excel Source Data 2010-08-12 Dan English
35 Importing data from SSAS into PowerPivot when you have different regional settings 2010-08-12 Kasper de Jonge
36 PowerPivot not visibile in Excel 2010-08-12 Davide Mauri
37 Re-creating the PowerPivot Management Dashboard’s “Sliding Bubble Chart” 2010-08-11 Russell Christopher
38 Combine two sources (in our case ssas) using PowerPivot 2010-08-11 Kasper de Jonge
39 Share your PowerPivot file with Excel 2007 users 2010-08-11 Kasper de Jonge
40 Don’t forget your Central Admin when creating AAM entries 2010-08-11 Dave Wickert
41 PivotViewer Extension for Reporting Services 2010-07-25 Cristian Petculescu
42 PerformancePoint Services PowerPivot Data Sources Error 2010-07-22 Dan English
43 Median calculation in DAX 2010-07-21 Marco Russo
44 Use PowerPivot DAX to automatically report on the last month that has data 2010-07-21 Kasper de Jonge
45 Percent of Whole, DAX Style 2010-07-16 Barry Ralston
46 Using a SharePoint list as a data source 2010-07-13 Dave Wickert
47 Incoming emails to a PowerPivot Gallery 2010-07-13 Dave Wickert
48 OLAP PivotTable Extensions 2010-07-12 Greg Galloway
49 Harnessing the Power of PowerPivot in the Enterprise 2010-07-12 Patrick Bolin
50 PowerPivot Sort and Ranking 2010-07-08 Barry Ralston
51 Using the excel function SEARCH in PowerPivot DAX 2010-07-08 Kasper de Jonge
52 Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible 2010-07-07 Kasper de Jonge
53 PowerPivot for the DBA 2010-07-05 Wayne Walter Berry
54 Security Considerations with SQL Azure and PowerPivot 2010-07-05 Wayne Walter Berry
55 Slicers and pivot update performance 2010-07-05 Rob Collie
56 Attunity PowerPivot Connector for Oracle (commercial) 2010-07-01 PowerPivot-iInfo.com
57 Vizubi: the first competitor of PowerPivot 2010-07-01 Marco Russo
58 Installation error: Running the wrong version of SharePoint 2010-07-01 Dave Wickert
59 Hide the Date column whenever you define a Dates table in PowerPivot 2010-06-29 Marco Russo
60 PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables 2010-06-29 Microsoft
61 Managing Connections in PowerPivot 2010-06-29 Wayne Walter Berry
62 The analytics of the World Cup in Excel with PowerPivot 2010-06-29 Bruno Aziza
63 PowerPivot: DAX: Math and Trigonometric Functions 2010-06-29 Microsoft
64 PowerPivot: DAX: Time Intelligence Functions 2010-06-29 Microsoft
65 PowerPivot: DAX: Text Functions 2010-06-27 Microsoft
66 PowerPivot: DAX: Statistical Functions 2010-06-27 Microsoft
67 PowerPivot field list and Excel field list at same time! 2010-06-27 Rob Collie
68 Self-Service Analytics: Sales Solution 2010-06-25 Microsoft
69 Accelerating Adoption of PowerPivot: Demos, Learning, and Guidance from Internal MSIT TAP Teams 2010-06-25 Mike Reese
70 Tips and Tricks for Troubleshooting a Microsoft SQL Server PowerPivot for SharePoint Installation 2010-06-25 Dave Wickert
71 Budgeting Solution Built with PowerPivot 2010-06-25 Alberto Ferrari
72 DAX Patterns in PowerPivot 2010-06-25 Marco Russo
73 How do I - Install PowerPivot into an EXISTING SharePoint 2010 farm 2010-06-25 Cornelius J. van Dyk
74 PowerPivot: DAX: Logical Functions 2010-06-25 Microsoft
75 Sorting PowerPivot Labels Manually 2010-06-24 Dan English
76 PowerPivot Relationship Detection Experience 2010-06-24 Dan English
77 Data Access and Consumption with WCF Data Services and PowerPivot 2010-06-24 Artemakis Artemiou
78 Getting Started With PowerPivot and SQL Azure 2010-06-24 Wayne Walter Berry
79 PowerPivot: DAX: Information Functions 2010-06-24 Microsoft
80 Using the SQL Server Data Mining Add-ins with PowerPivot for Excel 2010-06-22 Nathaniel Scharer
81 Using Excel CUBE Functions with PowerPivot 2010-06-21 Dick Moffat
82 PowerPivot Memory Error – Not Enough Storage 2010-06-21 Dan English
83 Where did my PowerPivot Excel 2010 tab go? 2010-06-21 Dan English
84 What is that PowerPivot pivottable context they keep talking about? 2010-06-21 Kasper de Jonge
85 PowerPivot: DAX: Filter Functions 2010-06-21 Ed Price
86 PowerPivot: DAX: Date and Time Functions 2010-06-21 Ed Price
87 PowerPivot: DAX: Operator Reference 2010-06-21 Microsoft
88 Use Time intelligence functions to do a running sum of the last 6 months with PowerPivot 2010-06-18 Kasper de Jonge
89 PowerPivot, you are so insensitive! (case that is) 2010-06-18 Denny Lee
90 Modifying the SharePoint v4.master page for the PowerPivot Gallery 2010-06-18 Dave Wickert
91 Using PowerPivot to Analyse Windows Search Results 2010-06-17 Chris Webb
92 Deploying and Managing PowerPivot for SharePoint 2010 2010-06-17 Dave Wickert
93 Using Microsoft Office 2010 with PowerPivot to Analyze SAP BW Data 2010-06-17 Scott Cameron
94 Building Sophisticated BI Applications Using Microsoft PowerPivot for Microsoft Excel 2010-06-17 Julie Strauss
95 Enriching Microsoft PowerPivot for Microsoft Excel Applications Using DAX (Data Analysis Expressions) 2010-06-17 Ashvini Sharma
96 Deep Dive on PowerPivot Technologies 2010-06-17 Dave Wickert
97 Load data from SAP into PowerPivot for Excel 2010-06-17 Kasper de Jonge
98 DAX cheat sheet 2010-06-17 Vidas Matelis
99 Slicer impact on PowerPivot query performance 2010-06-16 Vidas Matelis
100 Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot 2010-06-15 Ella Maschiach
101 Welcome Query designers! 2010-06-15 Dany Hoter
102 Connecting Microsoft Dynamics ERP to Microsoft Excel 2010 with PowerPivot Demo 2010-06-15 Microsoft
103 Ok why should i want to load an entire time table in PowerPivot ? 2010-06-15 Kasper de Jonge
104 Doing a simple forecast with PowerPivot Time intel functions 2010-06-15 Kasper de Jonge
105 Uninstalling PowerPivot does what ?? Arg!!@@!!! 2010-06-15 Dave Wickert
106 Installation failure: “Could not load file or assembly ‘Microsoft.AnalysisServices.SharePoint.Integration.dll’ 2010-06-15 Dave Wickert
107 Why is allocation always selecting the same machine? 2010-06-15 Dave Wickert
108 PowerPivot in Microsoft Excel 2010 - interview with Julie Strauss 2010-06-12 Channel 9
109 The ‘Function XXXX only works with contiguous date selections’ Error 2010-06-04 Chris Webb
110 PowerPivot time intelligent functions: why use ALL() and how to work around it 2010-06-04 Kasper de Jonge
111 "DAX Reference" - free online chapter from the book "Professional Microsoft PowerPivot for Excel and SharePoint" 2010-06-04 Denny Lee
112 Business Intelligence Indexing Connector “breaks” PowerPivot Gallery on “All in One” machine 2010-06-03 Russell Christopher
113 Use slicer values in a calculation with PowerPivot DAX 2010-06-03 Kasper de Jonge
114 Time Intelligence Without Date Columns in DAX 2010-06-01 Chris Webb
115 PowerPivot for SharePoint - Transitioning from a Single Server to SharePoint Farm 2010-06-01 Dave Wickert
116 Calling a Stored procedure in PowerPivot to populate your date table 2010-06-01 Kasper de Jonge
117 Where to create PowerPivot calculations and why 2010-06-01 Kasper de Jonge
118 Knowledge base articles related to PowerPivot for Excel and SharePoint 2010-05-27 Microsoft
119 Changing how PowerPivot handles DAX errors 2010-05-27 Vidas Matelis
120 Where to create PowerPivot calculations and why 2010-05-27 Kasper de Jonge
121 Rounding functions in DAX 2010-05-25 Marco Russo
122 Self-Service BI, PowerPivot and the future of traditional BI (DWH, OLAP, MDX) 2010-05-25 Hilmar Buchta
123 Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7 2010-05-24 Stacia Misner
124 Testing the Claims To Windows Token Service for different identities 2010-05-24 Lee Graber
125 White paper - PerformancePoint 2010 and PowerPivot 2010-05-20 Ali Kazazi
126 “Unsupported features” in CTP3 workbooks (RTM fixed) 2010-05-20 Ankur Goyal
127 Hierarchies in PowerPivot 2010-05-19 Dan English
128 PowerPivot workbook with Contoso BI database data 2010-05-18 Microsoft
129 Data Analysis Expressions (DAX) In PowerPivot for Excel 2010 2010-05-18 Howie Dickerman
130 Microsoft PowerPivot for Excel 2010 Samples 2010-05-18 Microsoft
131 Business Intelligence Demo at Office 2010 Launch Event 2010-05-18 Chris Capossela
132 PowerPivot for SharePoint - Gallery specific issues 2010-05-17 Dave Wickert
133 Get insight to SharePoint PowerPivot usage without Central admin rights using custom SSRS reports 2010-05-17 Kasper de Jonge
134 The making of the PowerPivot icon 2010-05-17 Bryce Johnson
135 SQL Server News Hour: Donald Farmer on Managed Self Service BI and SQL Server 2008 R2 2010-05-14 Donald Farmer
136 A Peek Inside: Updating data in your embedded PowerPivot workbook 2010-05-14 Dave Wickert
137 SharePoint Timer Service error 2010-05-14 Dave Wickert
138 Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot) 2010-05-13 Denny Lee
139 BI - PowerPivot for Excel - TechNet page 2010-05-13 Microsoft
140 PowerPivot for Excel Help - Online Documentations 2010-05-13 Microsoft
141 PowerPivot Developer’s Career Is Full of Twists and Turns 2010-05-13 Microsoft
142 Customizing the PowerPivot Management Dashboard 2010-05-11 Ankur Goyal
143 Creating Sparklines in PowerPivot 2010-05-10 Patrick LeBlanc
144 Q: How can I see what internal commands PowerPivot executes in its engine? 2010-05-09 Vidas Matelis
145 Using a PowerPivot workbook from SharePoint with a too long url in PowerPivot 2010-05-09 Kasper de Jonge
146 DAX vs. MDX vs. T-SQL 2010-05-08 Tomislav Piasevoli
147 Get the value of a measure of the last x intervals from the current datetime with PowerPivot 2010-05-08 Kasper de Jonge
148 PowerShell Script - Calculate how much space each table uses in the PowerPivot workbook 2010-05-07 Vidas Matelis
149 Free self paced course by Microsoft: "Introduction to Managed Self-Service BI with SQL Server 2008 R2" 2010-05-07 Microsoft
150 Automating the “Site Visitors” XL Report 2010-05-07 Rob Collie
151 Understand and analyze your Commerce Server data with Power Pivot 2010-05-06 Gael Duhamel
152 PowerPivot Data Refresh, what settings to use and why 2010-05-06 Kasper de Jonge
153 Counting Returning Customers in DAX 2010-05-03 Chris Webb
154 Review new PowerPivot workbooks on SharePoint using approval workflows 2010-05-03 Kasper de Jonge
155 Q: How can I find how much space each table uses in PowerPivot? 2010-04-28 Vidas Matelis
156 Bug: Management Dashboard .odc file is broken 2010-04-27 Dave Wickert
157 Building a cash flow statement in PowerPivot using dynamic measures in DAX 2010-04-27 Kasper de Jonge
158 Microsoft PowerPivot for Excel 2010 - demo 2010-04-27 Microsoft
159 PowerPivot Technical Diagram: PowerPivot Client/Server Architecture 2010-04-27 Microsoft
160 PowerPivot Self-Service BI 2010-04-27 Andrew Brust
161 Learning PowerPivot for Excel and SharePoint administration 2010-04-27 Vidas Matelis
162 Learning PowerPivot and DAX 2010-04-26 Vidas Matelis
163 Add Spark to Your OData: Consuming Data Services in Excel 2010 2010-04-26 Beth Massi
164 Why PowerPivot requires "classic-mode" web applications 2010-04-26 Dave Wickert
165 Guide for loading ContosoBI data into PowerPivot 2010-04-25 Vidas Matelis
166 Sorting month by natural sort order 2010-04-22 Julie Strauss
167 PowerPivot + Gridworks = Wow! 2010-04-21 Jon Udell
168 PowerPivot Time intelligent function and other DAX example 2010-04-21 Kasper de Jonge
169 Bring unlimited data into Excel with PowerPivot 2010-04-21 Microsoft
170 Create IPhone BI using RoamBI and data from PowerPivot 2010-04-18 Kasper de Jonge
171 Using PowerPivot to analyze MS Dynamics NAV - demo DB, SP code and Excel example 2010-04-17 Stanko Trcek
172 Creating a measure in PowerPivot that excludes values that are in a second table (like SQL Not in) 2010-04-16 Kasper de Jonge
173 Self-Service Analysis with PowerPivot - Chapter from "Introducing Microsoft SQL Server 2008 R2" book 2010-04-15 Stacia Misner
174 Microsoft SQL Server PowerPivot Planning and Deployment 2010-04-15 Kay Unkroth
175 Howto: Write to the ULS 2010-04-15 Dave Wickert
176 PowerPivot, OData, and the Democratization of Business Intelligence 2010-04-15 Jon Udell
177 Create a separate related time table for time intelligent functions in PowerPivot 2010-04-15 Kasper de Jonge
178 Dude, Where’s my PowerPivot workbook? 2010-04-14 Denny Lee
179 PowerPivot: Overview 2010-04-13 Ed Price
180 Time Intelligence Functions in DAX 2010-04-12 Howie Dickerman
181 Combine two files (or fact tables) in PowerPivot using relationships, relationships explained 2010-04-11 Kasper de Jonge
182 Configuring Excel Services & PowerPivot on multi server Topology 2010-04-11 Steve Wright
183 PowerPivot: Data Analysis Expressions (DAX) Language 2010-04-08 Ed Price
184 User credentials could not be delegated and Active Directory 2010-04-08 Denny Lee
185 Update SharePoint 2010 Farm Credentials Tips 2010-04-08 Denny Lee
186 Video - PowerPivot: Import Linked Data from Excel 2010-04-08 Michele Hart
187 A Treatise on the ALL() Function in DAX – or – ‘Is it all er nuthin’ with you?’ 2010-04-08 Erika Misner
188 Quick Tip: Don’t Over-Use FILTER() 2010-04-08 Rob Collie
189 PowerPivot for Excel Setup on Windows Vista 2010-04-07 Ron Pihlgren
190 DAX (Data Analysis Expressions) Measures in PowerPivot 2010-04-05 Howie Dickerman
191 ALL, ALLEXCEPT and VALUES in DAX 2010-04-05 Marco Russo
192 Using Notepad++ as an editor for creating, reading, and troubleshooting DAX formulas 2010-04-05 Colin Banfield
193 Working with the 2010 Office ACE provider 2010-04-03 Dave Wickert
194 Help: c2wts has fallen and it cannot get up 2010-04-03 Dave Wickert
195 A Peek Inside: Allocation. What is it? Why is it important? 2010-04-03 Dave Wickert
196 PowerPivot and Sparklines .. the easy way 2010-04-01 Kasper de Jonge
197 PowerPivot time intelligent functions revisited: why use ALL() and how to work around it 2010-03-29 Kasper de Jonge
198 Microsoft PowerPivot Vs. Tableau 2010-03-27 Derek Comingore
199 64-bit verses 32-bit . . . What's right for you? 2010-03-27 Dave Wickert
200 Collation, Localization and Globalization, oh my! 2010-03-27 Dave Wickert
201 Q: My PowerPivot table was loaded from the SQL Server table that recently was changed. How can I apply these source table changes to PowerPivot table? 2010-03-24 Vidas Matelis
202 Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table? 2010-03-24 Vidas Matelis
203 Xtract for PowerPivot - SAP and PowerPivot seamless Integration 2010-03-23 PowerPivot-info.com
204 Enabling and Using the OData Protocol with SQL Azure 2010-03-23 OakLeaf Systems
205 PowerPivot Component Architecture 2010-03-23 Microsoft
206 PowerPivot - census data 2010-03-19 Tushar Mehta
207 PowerPivot and Sparklines .. the easy way 2010-03-19 Kasper de Jonge
208 Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook 2010-03-19 Kasper de Jonge
209 SharePoint 2010 and PowerPivot Q & A by Shared Squared 2010-03-18 ShareSquared.com
210 New enhancements to the PowerPivot user experience 2010-03-18 Julie Strauss
211 Silverlight 4 + RIA Services - Ready for Business: Exposing OData Services 2010-03-18 Brad Abrams
212 Q: My DAX formula in the PowePivot returns error message: "The value for columns "ColumnName1" in table "Table1" cannot be determined in the current context. How can I fix this? 2010-03-17 Vidas Matelis
213 Comparing Analysis Services and PowerPivot 2010-03-13 Ashvini Sharma
214 Building Data Relationships in PowerPivot 2010-03-12 Artemakis Artemiou
215 Using PowerPivot’s Copy-Paste Support for Importing Data from Word 2010-03-12 Artemakis Artemiou
216 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
217 Writing a RANK measure (and living to tell the tale) 2010-03-10 Rob Collie
218 A Peek Inside: Unloading PowerPivot data 2010-03-06 Dave Wickert
219 Installing the right version of SharePoint 2010-03-06 Dave Wickert
220 Thoughts on how PowerPivot and SSAS could work together 2010-03-06 Chris Webb
221 Make your PowerPivot on SharePoint “view only” 2010-03-04 Kasper de Jonge
222 Keeping a workbook "pinned" in memory 2010-03-04 Dave Wickert
223 Video - Microsoft PowerPivot DataFeed Source 2010-03-02 Nico Verbaenen
224 Video - Microsoft PowerPivot Loading Data 2010-03-02 Nico Verbaenen
225 Video - Microsoft PowerPivot Creating Reports 2010-03-02 Nico Verbaenen
226 Video - Microsoft BI PowerPivot DAX Time calculations : YTD 2010-02-26 Nico Verbaenen
227 Create simple and effective reports for Commerce Server with PowerPivot (aka Gemini) 2010-02-25 Gael Duhamel
228 Revisiting ALL() 2010-02-25 Rob Collie
229 Diagnostic Guide for Usage and the PowerPivot Management Dashboard 2010-02-25 Ankur Goyal
230 Why you may want to use RBS for your #PowerPivot for #SharePoint Farm 2010-02-24 Denny Lee
231 When is null not a null? 2010-02-24 Dave Wickert
232 SUMX() – The 5-point palm, exploding fxn technique 2010-02-24 Rob Collie
233 Screencast: Using datamining with PowerPivot in Excel 2010-02-23 Kasper de Jonge
234 Screencast: Using datamining with PowerPivot in Excel 2010-02-13 Kasper de Jonge
235 Cannot add the specified assembly to the global assembly cache 2010-02-13 Lee Graber
236 Rob Collie PowerPivot video (from Swedish UG meeting) 2010-02-11 Rob Collie
237 Jewelry Mashup for Alpha Geek Challenge 2010-02-11 Bill Jelen
238 Granting Excel Services access rights to your #PowerPivot for SharePoint Farm 2010-02-11 Denny Lee
239 Producing and consuming OData feeds: An end-to-end example 2010-02-10 Jon Udell
240 Using Time intelligent PowerPivot functions with fiscal year 2010-02-09 Kasper de Jonge
241 How to relate tables in DAX without using relationships 2010-02-09 Marco Russo
242 Surprising Example of PowerPivot Compression 2010-02-09 Rob Collie
243 The data connection uses Windows Authentication and user credentials could not be delegated 2010-02-09 Lee Graber
244 Dashboard Bubble Chart Shows a Red X (fails to load) 2010-02-09 Lee Graber
245 PowerPivot Retail Analysis Example 2010-02-09 Rob Kerr
246 A connection corresponding to the embedded PowerPivot data was not found in the Excel workbook 2010-02-09 Lee Graber
247 Troubleshooting PowerPivot Relationships 2010-02-08 Kasper de Jonge
248 Avoiding calculated column in DAX 2010-02-06 Marco Russo
249 PowerPivot Data in Scatter Charts, etc. 2010-02-06 Rob Collie
250 Table Denormalization Study in PowerPivot 2010-02-05 Marco Russo
251 Pivots, Cube Formulas, Named Sets … Oh my! 2010-02-05 Denny Lee
252 Pivots, I have not forgotten ye! 2010-02-05 Rob Collie
253 Hands-on-Labs - PowerPivot in SQL Server 2008 R2 (Part of the SQL Server training kit) 2010-02-04 Microsoft
254 Video - PowerPivot for Excel/SharePoint 2010 - Interview with T.K. Anand 2010-02-04 T.K. Anand
255 Creating a SharePoint 2010 Business Intelligence VM Image (using SQL Server 2008 R2 CTP) 2010-02-03 Steve Mann
256 Introducing CUBESET() and CUBERANKEDMEMBER() 2010-02-03 Rob Collie
257 PowerPivot and BI architecture 2010-02-02 Thomas Ivarsson
258 Hands-on PowerPivot: To the Cloud 2010-02-02 David Ramel
259 Management Features of PowerPivot for SharePoint 2010-02-02 John Hancock
260 Parameterizing the report 2010-02-01 Rob Collie
261 SQLBits Video - Self Service Business Intelligence- Project Gemini 2010-02-01 Bob Duffy
262 Video - SharePoint 2010 BI Overview 2010-01-31 Mike Fitzmaurice
263 Reading your #PowerPivot Profiler trace 2010-01-30 Denny Lee
264 QlikView from a PowerPivot standpoint 2010-01-30 Donald Farmer
265 What database support is needed 2010-01-30 Dave Wickert
266 OData: There’s a feed for that 2010-01-30 Douglas Purdy
267 PowerPivot for SharePoint Video 2010-01-29 Rob Collie
268 Create a #PowerPivot report filtered by the Top X Users by "Logic" 2010-01-28 Denny Lee
269 Rob Collie (PowerPivotPro) videos on YouTube 2010-01-27 Rob Collie
270 Sales Forecasting with Excel 2010 (and PowerPivot) 2010-01-27 Microsoft
271 Memory Considerations about PowerPivot for Excel 2010-01-26 Marco Russo
272 Powerpivot - Installation, first report, dax 2010-01-25 Yaniv Mor
273 PowerPivot Cookery - video that explains what PowerPivot is through cooking example 2010-01-25 Andrew Fryer
274 How to start debugging a PowerPivot for SharePoint installation issue 2010-01-24 Lee Graber
275 Self-Service BI with PowerPivot for Excel 2010 2010-01-23 Thiago Zavaschi
276 PowerPivot, DAX and Semi-additive measures 2010-01-21 Russell Christopher
277 Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ 2010-01-21 Lee Graber
278 PowerPivot introduction videos - load, analyse and use in SharePoint 2010-01-19 Andrew Fryer
279 #PowerPivot Data Refresh SSRS Report 2010-01-19 Denny Lee
280 How to manually update your PowerPivot Management Dashboard 2010-01-19 Dave Wickert
281 Why you shouldn’t stop / start Analysis Services from SCM when running in SharePoint Integration Mode 2010-01-19 Lee Graber
282 ABC Analysis in PowerPivot 2010-01-19 Marco Russo
283 Not your average PowerPivot report 2010-01-19 Rob Collie
284 Screencast: Import data from reporting services into PowerPivot 2010-01-19 Kasper de Jonge
285 Enable PerformancePoint on SharePoint 2010 2010-01-15 Kasper de Jonge
286 How do I get the menu options for individual reports within the #PowerPivot Gallery? 2010-01-15 Denny Lee
287 How to PowerPivot outlook data (*.ost or *.pst) data in Microsoft Office Excel 2010 2010-01-13 Roel van Lisdonk
288 Solving the 'Events in Progress' Problem in DAX, Part Two: Aggregating Dates and Multiselect 2010-01-13 Chris Webb
289 The MIE Podcasts – Rob Collie 2010-01-13 Rob Collie
290 Screencast: Introduction to time intelligent functions in PowerPivot 2010-01-13 Kasper de Jonge
291 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
292 So i requested a PowerPivot workbook from SharePoint, what happens? 2010-01-10 Kasper de Jonge
293 Manage the sort order of your PowerPivot sheets in the SharePoint Gallery 2010-01-10 Kasper de Jonge
294 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
295 Touchdown Problem Solved, and COUNTROWS 2010-01-09 Rob Collie
296 Excel PowerPivot Review - Video 2010-01-08 Chandoo
297 Solving the 'Events in Progress' Problem in DAX 2010-01-07 Chris Webb
298 Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI 2010-01-06 Denny Lee
299 Q: How do I hide "Grand Total" calculation for PowerPivot columns and/or rows? 2010-01-05 Vidas Matelis
300 The PowerPivot Experiment 2010-01-05 Artemakis Artemiou
301 Q: How can I change maximum PowerPIvot file size that can be uploaded to SharePoint 2010? 2010-01-05 Vidas Matelis
302 Q: Where PowerPivot for SharePoint logs are located and how to read them? 2010-01-05 Vidas Matelis
303 Creating a PerformancePoint 2010 dashboard on a published SharePoint PowerPivot app 2010-01-04 Kasper de Jonge
304 How CALCULATE works in DAX 2010-01-03 Marco Russo
305 Creating a SSRS report on a published SharePoint PowerPivot app 2009-12-31 Kasper de Jonge
306 Solving a business problem with Powerpivot CTP3 using DAX Timefunctions 2009-12-31 Kasper de Jonge
307 Instructions for the installation and configuration of Reporting Services in SharePoint Integration Mode 2009-12-30 Dave Wickert
308 PowerPivot for SharePoint Single Server Install with Dedicated SQL Server 2009-12-30 Dave Wickert
309 Distinct Count Measure in PowerPivot using DAX 2009-12-26 Marco Russo
310 How to add DAX calculations to the PowerPivot workbooks 2009-12-18 Vidas Matelis
311 Recorded webcast - A Preview to PowerPivot Server Best Practices 2009-12-17 Microsoft
312 Monitor your SSIS Package execution with PowerPivot 2009-12-17 Kasper de Jonge
313 DAX CALCULATE, and Rapid Iteration 2009-12-17 Rob Collie
314 Step by Step guide for creating demo PowerPivot workbook from AdventureWorksDW SQL tables 2009-12-17 Vidas Matelis
315 Using PowerPivot with SQL Azure 2009-12-16 Stephen Forte
316 PowerPivot DAX: CALCULATE is a supercharged SUMIF 2009-12-15 Rob Collie
317 Recorded webcast: "Introduction to PowerPivot or How I Learned to Stop Worrying and Love Excel" 2009-12-13 Chris Webb
318 Excel Services delegation 2009-12-12 Dave Wickert
319 PowerPivot 101 – an Introduction 2009-12-11 Andrew Fryer
320 PowerPivot online demos 2009-12-11 Microsoft
321 Refreshing PowerPivot Data 2009-12-10 Robert C. Cain
322 Reported problems installing PowerPivot for SharePoint 2009-12-10 Dave Wickert
323 DAX's CALCULATE() function - Pivots will never be the same 2009-12-09 Rob Collie
324 Putting the "Intelligence" in "Business Intelligence" 2009-12-07 Rob Collie
325 PowerPivot - Data Import In November CTP 2009-12-07 Ashvini Sharma
326 Many-to-Many relationships in PowerPivot 2009-12-07 Marco Russo
327 Lookups in PowerPivot Calculated Columns - Using the RELATED Function 2009-12-07 Robert C. Cain
328 Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months) 2009-12-05 Vidas Matelis
329 Getting difference of two dates in seconds with PowerPivot DAX 2009-12-05 Kasper de Jonge
330 DAX: Running Totals 2009-12-05 Chris Webb
331 Visualizing SQL Indices with PowerPivot 2009-12-05 Rob Collie
332 Calculated Columns in PowerPivot 2009-12-04 Robert C. Cain
333 Why PowerPivot for SharePoint? 2009-12-02 Dave Wickert
334 Create simple and effective reports through PowerPivot (aka Gemini) 2009-12-02 Gaël Duhamel
335 Combining Data from Multiple Data Sources in PowerPivot 2009-12-02 Robert C. Cain
336 Calling your PowerPivot workbook on SharePoint 2010 remotely 2009-12-02 Kasper de Jonge
337 Creating Tables in PowerPivot 2009-12-02 Robert C. Cain
338 Make your PowerPivot sheet look great in SharePoint 2010 2009-12-01 Kasper de Jonge
339 First steps in DAX: Year-To-Date 2009-12-01 Chris Webb
340 Q: Where in SharePoint can I define "Business Hours" for PowerPivot data refresh? 2009-12-01 Vidas Matelis
341 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
342 SQL Server Reporting Services Reports in the PowerPivot Gallery 2009-11-29 Russell Christopher
343 Understanding DAX - Context (Row) 2009-11-28 Shaun Ryan
344 CTP3 Setup Error: Could not load file or assembly "Microsoft.AnalysisServices.SharePoint.Integration" 2009-11-28 Russell Christopher
345 A Peek Inside: Why no cross-farm support (PowerPivot for SharePoint)? 2009-11-28 Dave Wickert
346 Q: How can I see Analysis Services database structure that is stored within PowerPivot ? 2009-11-27 Vidas Matelis
347 Creating useful PowerPivot data models for public consumption via Reporting Services 2009-11-26 Russell Christopher
348 Q: How can I delete PowerPivot report published into SharePoint PowerPivot gallery? 2009-11-26 Vidas Matelis
349 Q: How can I check what version of PowerPivot for Excel is installed on my machine? 2009-11-25 Vidas Matelis
350 Combine data from the cloud with local data using PowerPivot and Dallas 2009-11-25 Kasper de Jonge
351 Using PowerPivot to combine cube (SSAS) data with manual data, the movie 2009-11-24 Kasper de Jonge
352 Import Filters in PowerPivot 2009-11-24 Robert C. Cain
353 Using PowerPivot to combine cube (SSAS) data with manual data 2009-11-23 Kasper de Jonge
354 Video: SharePoint 2010 and PowerPivot 2009-11-22 Michael Gannotti
355 How to install PowerPivot for Excel and list of know issues 2009-11-21 Vidas Matelis
356 When is a refresh not a refresh? 2009-11-21 Dave Wickert
357 Sharing workbooks using PowerPivot Gallery 2009-11-21 John C. Hancock
358 PowerPivot Data Refresh 2009-11-21 Dave Wickert
359 Introducing Microsoft PowerPivot 2009-11-20 Robert C. Cain
360 Video: Custom Theming A SharePoint 2010 Site Using PowerPoint 2010 2009-11-20 Michael Gannotti
361 PowerPivot for SharePoint existing farm installation guide (draft paper by Microsoft) 2009-11-20 Microsoft
362 PowerPivot for SharePoint single server install guide (draft paper by Microsoft) 2009-11-20 Microsoft
363 Step by step guide on installing PowerPivot for SharePoint on a single machine 2009-11-20 Vidas Matelis
364 Data Connection Libraries missing in SharePoint 2010 2009-11-19 Bob Duffy
365 A Peek Inside: Why are domain accounts needed? 2009-11-19 Dave Wickert
366 Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction 2009-11-19 Microsoft
367 Installing PowerPivot for SharePoint on a domain controller 2009-11-18 Dave Wickert
368 Troubleshooting #PowerPivot Excel Services connectivity 2009-11-18 Denny Lee
369 PowerPivot overview and How To videos 2009-11-18 Microsoft
370 Introducing PowerPivot DAX Measures 2009-11-16 Rob Collie
371 Steps taken during a PowerPivot data refresh 2009-11-13 Dave Wickert
372 Temperature Mashup Example 2009-11-13 Rob Collie
373 List of PowerPivot DAX functions (short) 2009-11-13 Vidas Matelis
374 List of PowerPivot DAX functions with description 2009-11-13 Vidas Matelis
375 A Peek Inside: The client architecture 2009-11-12 Dave Wickert
376 List of suggested datasets to test PowerPivot 2009-11-11 Vidas Matelis
377 SharePoint Prerequisite Lab Installation Tip (#PowerPivot CTP3 Install) 2009-11-11 Denny Lee
378 Geminute - short videos that shows what you can do with PowerPivot 2009-11-11 Donald Farmer
379 DAX: The =RELATED() Function 2009-11-10 Rob Collie
380 A 48 hour case study from Bing - Zero to Sixty :) 2009-11-10 Rob Collie
381 What happens when you run a Data Refresh within PowerPivot for SharePoint? 2009-11-09 Denny Lee, Dave Wickert
382 PowerPivot's impact on BI pros? 2009-11-09 Rob Collie
383 My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more 2009-11-09 Vidas Matelis
384 PowerPivot Linked tables 2009-11-08 T.K. Anand
385 PowerPivot Data Feeds 2009-11-08 John C. Hancock
386 Understanding why an Excel PowerPivot workbook is so large 2009-11-07 Denny Lee, Dave Wickert
387 For Excel PowerPivot, the database is IN the workbook 2009-11-07 Denny Lee, Dave Wickert
388 PowerPivot for SharePoint 2010 - The Business User’s Perspective 2009-10-29 Joseph Chirilov
389 Project BI bloggers – Analysis in PowerPivot (ex-Gemini) 2009-10-28 Tomislav Piasevoli
390 What is PowerPivot? 2009-10-28 Rob Collie
391 Gemini (PowerPivot) Does Cloud! 2009-10-28 Andrew Brust
392 Announcing the Great Football Project (PowerPivot) 2009-10-27 Rob Collie
393 Trying to solve a business problem with Powerpivot, Gemini CTP2 2009-10-26 Kasper de Jonge
394 Using PowerPivot with Excel 2010 2009-10-24 Joseph Chirilov
395 Introducing PowerPivot 2009-10-23 Ashvini Sharma
396 Donald Farmer on Gemini (PowerPivot) - audio interview 2009-10-23 Donald Farmer
397 Creating a Custom Gemini/PowerPivot Data Feed - Method 1 - ADO.NET Data Services 2009-10-20 Sacha Tomey
398 Gemini (PowerPivot)- Copy/Paste 2009-10-14 T.K. Anand
399 PowerPivot DAX function list with samples 2009-10-08 Vidas Matelis
400 Introduction to Data Analysis Expressions (DAX) in Gemini (PowerPivot) 2009-10-01 Howie Dickerman
401 Leaf level queries in Gemini (PowerPivot) and SSAS 2008 2009-09-19 Thomas Ivarsson
402 Importing data into Gemini (PowerPivot) 2009-09-09 Edward Melomed
403 Channel 9 - Donald Farmer and Julie Strauss: Inside Project Gemini (PowerPivot) 2009-09-01 Donald Farmer
404 Gemini (PowerPivot) CTP2 Install Experience and Overview 2009-08-29 Dan English
405 Overview of Gemini (PowerPivot) features 2009-08-25 Ashvini Sharma
406 Soccer statistics in Gemini (PowerPivot) and Excel 2010 2009-08-23 Thomas Ivarsson
407 SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables 2009-08-19 Vidas Matelis
408 Gemini (PowerPivot) First Thoughts 2009-08-17 Chris Webb
409 Working with Gemini (PowerPivot) and Excel 2010 to make a pivot table 2009-08-17 Kasper de Jonge
410 BI Power Hour demo - Sneak Preview of Gemini (PowerPivot) 2009-05-21 Donald Farmer
411 Microsoft Project Gemini (PowerPivot) links 2009-04-29 Donald Farmer