Tag Archives: Excel
Power View Tip: Scatter Chart over Time on the X-Axis and Play Axis
As you have seen in many Power View demos, you can run the Scatter Chart over time by placing date/time onto the Play Axis. This is pretty cool and it … Continue reading
Office 2013 Power View, Bing Maps, Hive, and Hadoop on Azure … on my!
With all the excitement surrounding Office 2013 (here’s a nice Engadget Review) and energized by Andrew Brust’s tweets (@andrewbrust) and post Office 2013 brings BI, Big Data to Windows 8 … Continue reading
A Primer on PowerPivot Topologies and Configurations
For those who would like a quick primer on PowerPivot Topologies and Configurations, check out the SlideShare below. Enjoy!
A Primer on Hadoop (from the Microsoft SQL Community perspective)
For a quick primer on Hadoop (from the perspective of the Microsoft SQL Community), as well as Microsoft Hadoop on Azure and Windows, check out the SlideShare.NET presentation below. Above … Continue reading
BI and Big Data–the best of both worlds!
As part of the excitement of the Strata Conference this week, Microsoft has been talking about Big Data and Hadoop. It started off with Dave Campbell’s question: Do we have … Continue reading
Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
. “I caught a fish thiiiiis biiig” – On stage with Ted Kummert during the PASS 2011 Keynote on Big Data (thanks to Karen Lopez @datachick for the pic) . … Continue reading
Using SQL Server PowerPivot for Excel to Analyze SAP Data
Sorry! I’ve been offline and haven’t blogged or responded to comments for quite some time and frankly I don’t have any good excuses: I fell asleep My dog ate my … Continue reading
Can I access PowerPivot via a data access API?
I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store? I figured that a lot … Continue reading
PowerPivot, you are so insensitive! (case that is)
Working with my compatriots Ayad Shammout (@aashammout) and Peter Myers, we had found out that PowerPivot at times can be really insensitive…in terms of case that is. That is by … Continue reading
Pivots, Cube Formulas, Named Sets … Oh my!
Over the last few days, @PowerPivotPro has been calling me out for diving into the deep end into his world of Excel and getting the proverbial egg on my face … Continue reading
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 3 of 3)
Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an … Continue reading
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 2 of 3)
Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an … Continue reading
Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)
Background I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set … Continue reading
Uploading #PowerPivot for Excel workbook using "Save As" vs. SharePoint UI
When you save a PowerPivot for Excel workbook by using the “Save As” function with Excel, this will use the Office Upload Center as its mechanism to save the file. … Continue reading
