Trialling component parts of the MS BI Stack

Question

Post reply

Trialling component parts of the MS BI Stack

DamianC

SSCrazy Eights

Points: 8015
More actions
April 19, 2015 at 2:36 pm

#303052

Hello
I have a Cognos background and I'm looking to understand more about the MS BI stack.
I've used MS SQL (T-SQL, DTS, SSIS and a little SSRS)
I've have also used Excel pretty extensively although I haven't really used Power Pivot, View or Map
I'm looking to set all this up on my machine at home so I can play around and familiarise myself with MS BI
At the moment I have Home Office 365 - although I can't seem to get Power View or Power Pivot?
I have a 180 day trial of MS SQL Server 2014 up and running (SSAS, SSIS and SSRS work)
2 questions:
1. Is there a way to get Powerview and Powerpivot on home O365?
2. If I install a trial version of sharepoint, is there anything else that I am missing?
I think if I refer to something like this, I've pretty much got it covered: http://jaliyaudagedara.blogspot.co.uk/2012/02/microsoft-business-intelligencebi-stack.html
Thanks
Damian.
- Damian
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 1

PowerQuery: https://www.microsoft.com/en-us/download/details.aspx?id=39379

PowerPivot/PowerView: Should be Built in - go to Options/addins/manage com addins and select the addins to enable them

Power BI is the next big thing - there is a preview here : https://www.powerbi.com/dashboards/downloads/designer/[/url]

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

DamianC SSCrazy Eights Points: 8015 More actions · Answer 2

Thanks for the response

Unfortunately, it seems as though the home version does not get Powerpivot or view

I would have to buy the full blown Excel product

Would have thought MS would at least have a developer license here!

- Damian

mister.magoo SSC-Forever Points: 47068 More actions · Answer 3

DamianC (5/26/2015)
Thanks for the response
Unfortunately, it seems as though the home version does not get Powerpivot or view
I would have to buy the full blown Excel product
Would have thought MS would at least have a developer license here!

I would be interested to hear why you say that? I have the Home edition at home ( 😛 ) and have these tools installed and working.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

DamianC SSCrazy Eights Points: 8015 More actions · Answer 4

My version is Office 365 which provides 2013 for local use

I've done a bit of digging (including ringing MS) and found that its available on earlier versions but not this

What version do you have?

Thanks

- Damian

mister.magoo SSC-Forever Points: 47068 More actions · Answer 5

DamianC (5/26/2015)
My version is Office 365 which provides 2013 for local use
I've done a bit of digging (including ringing MS) and found that its available on earlier versions but not this
What version do you have?
Thanks

It turns out I have Office 365 Home Premium, which has Excel 2013 version 15.0.4719.1000.

I don't know if the "premium" tag is what makes the difference here?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

DamianC SSCrazy Eights Points: 8015 More actions · Answer 6

I'll investigate a bit further re the version.

Thanks for letting me know.

Damian.

- Damian