Viewing 15 posts - 1 through 15 (of 17 total)
I wanted to highlight the 2 GB limit with 32-bit as it can be a source of frustration. Office 64-bit has its issues as we discussed. Using summarized data may...
February 11, 2015 at 8:36 am
IT Managers and admins are certainly not open to installing 64-bit version of Office. This is especially true since you cannot just have Excel 64-bit and your entire Office suite...
February 10, 2015 at 9:10 am
You can use any criteria to reduce the number of rows. Here is what I used:
CREATE VIEW [dbo].[VwFactSales]
AS
SELECT F.*
FROM dbo.FactSales F
INNER JOIN dbo.DimProduct P ON P.ProductKey = F.ProductKey
WHERE YEAR(DateKey) IN...
February 10, 2015 at 8:59 am
You need to download the add-in. Try this link: http://www.microsoft.com/en-us/download/details.aspx?id=7609
February 10, 2015 at 6:39 am
That is so, true. Well said jennym!
January 15, 2015 at 8:36 am
That is correct. It is not available with all excel versions. However, it is now included with the standalone version which anyone can buy from Amazon. Thanks for clarifying.
January 13, 2015 at 8:39 am
Currently, the only way to accomplish this in PowerPivot is by creating a separate model for each user group. If security is a concern then you should look into SSAS...
January 12, 2015 at 2:57 pm
The google search data was obtained from Google adwords. It is available free of cost to anyone with a Adwords account. I'm sure you could do some scraping and automate...
January 12, 2015 at 2:23 pm
When you get the PowerPivot add-in, the Tabular engine comes inside it. You do not need to install Analysis Services or SQL Server. That is the beauty of it. You...
January 12, 2015 at 7:10 am
Thanks!
January 2, 2015 at 12:21 pm
Steve, I submitted the PowerPivot article through the website. I added a couple more links. Let me know if that is approved for publication.
Thanks,
Amir
December 15, 2014 at 2:55 pm
Steve, hope you had a good time off! Let me know if you have had a chance to look at the Power View article and also your thoughts on the...
December 8, 2014 at 2:51 pm
Not a problem. I would like to start working on my next article! If you can take a cursory look and let me know if you see any thing glaringly...
December 1, 2014 at 7:38 pm
Steve, I submitted the article. Take a look. This is my first time; I'm sure there will be technical glitches that I may have to correct, especially with the screen...
December 1, 2014 at 3:16 pm
Steve, I am still working on this article. Got busy for some time and was not able to work on it. But I should have something in the next few...
November 25, 2014 at 11:08 am
Viewing 15 posts - 1 through 15 (of 17 total)