I'm commencing a new role shortly at a fairly small company of about 10 people that uses a Mac only environment. There may be some flexibility on this, but for now let's just assume that there isn't. I know powerpivot isn't available for Mac and regardless of that I wouldn't be all that comfortable using Excel for Mac based on my limited experience anyway.
But theoretically what would be the most effective way to use powerpivot in a mac environment? It is likely that I would be the developer/user, all others would just be consuming the reports on their Macs (& occasionally ipads - though this is a separate thread already I see). Would running a virtualised windows environment via say VMWare Fusion be nearly as effective as operating a lone PC in the Mac environment for development purposes? If so, does anyone have any on the hardware specs required to keep things running quickly? I'm interested in leveraging sharepoint capabilities, be it through Office 365, Pivotstream or just a standalone office package (maybe not the last one). I assume from a user perspective, these will still work much the same on either platform given they are web based?
Any other experiences with attempting to deploy powerpivot solutions in a Mac environment, I'd love to hear about them. Mathew I am running a MacbookPro 13' as my main computer. I have to say the transition from Windows to Mac was VERY painful for me.
The biggest issue was getting used to the keyboard. Things that you just take for granted, such as having both a delete button and a backspace button just don't exist on the MBP. I am running Parallels for Mac and Bootcamp. I installed Windows 8.1 as a Bootcamp partition, and then installed Parallels.
When you install Parallels, you can specific to use the Bootcamp partition. As a result, I can boot natively into Windows, or I can run a virtualised Windows instance from OSX. I have had a few minor issues with Parallels, but it is actually quite good. I have only really had performance issues when running SQL server in Parallels. Most times it is fine, but occasionally I just reboot into native windows if I have a lot to do. I just bought the best spec device I could get, so I have got i7 2.8 GHz wiht 16GB ram. I did this mainly so I can run SQL Server, but also for PowerPivot.
You won't be able to share PowerPivot models unless the other users have the Windows version of Excel - but I think you already know that. There should be no issues with web based solutions, however SharePoint can be a bit picky when it comes to browsers. I have been able to access PivotStream reports natively in my Mac and on iPad. Hope that helps.
Generally, a download manager enables downloading of large files or multiples files in one session. Many web browsers, such as Internet Explorer 9, include a download manager.
Stand-alone download managers also are available, including the Microsoft Download Manager. If you do not have a download manager installed, and still want to download the file(s) you've chosen, please note:. You may not be able to download multiple files at the same time. In this case, you will have to download the files individually. (You would have the opportunity to download individual files on the 'Thank you for downloading' page after completing your download.). Files larger than 1 GB may take much longer to download and might not download correctly. You might not be able to pause the active downloads or resume downloads that have failed.
Powerpivot Power Bi
The Microsoft Download Manager solves these potential problems. It gives you the ability to download multiple files at one time and download large files quickly and reliably. It also allows you to suspend active downloads and resume downloads that have failed. Microsoft Download Manager is free and available for download now. There are two versions of the download file. PowerPivotExamplesExcel2010.zip – Includes samples for Microsoft SQL Server 2012 SP1 PowerPivot for Excel 2010. This version requires you have SQL Server 2012 SP1 PowerPivot for Excel 2010 Add-in installed.
PowerPivotExamplesExcel2013.zip – Includes samples for Microsoft PowerPivot in Excel 2013. If you open a sample for PowerPivot for Excel 2010 in PowerPivot in Excel 2013, you will get a notification stating you must upgrade the data model in the workbook. You cannot open a sample for PowerPivot in Excel 2013 data model in PowerPivot for Excel 2010.
Powerpivot Excel 2013 Download
Each sample file contains three Business Intelligence samples:. PowerPivot Healthcare Audit.xlsx. PowerPivot Tutorial Sample.xlsx. LCA BI - Financial Report Usage.xlsx These PowerPivot workbooks provide examples on how PowerPivot can be used to import data, create relationships, create calculated columns and measures, and add PivotTables, slicers and PivotCharts. NOTE: To fully interact with these samples, you must have Excel 2010 and the PowerPivot for Excel 2010 add-in installed and enabled, or Excel 2013 and the PowerPivot in Excel 2013 add-in enabled.