OakTree Software Blog
At OakTree Software, we believe in offering our expert feedback to help information technology professionals grow their career paths successfully and thrive in the booming IT sector. Read the latest from OakTree Software’s team members to improve your career path, strengthen your work relationships, and find out what’s new in IT jobs!
OakTree Software is looking for an addition to our talented Technical Recruiting team! Do you have what it takes to join our upbeat, fast-paced and fun work environment? We are looking for aggressive, open personalities willing to go the extra mile to help find quality IT professionals great new career opportunities. Do you have a strong internal drive, a desire to be successful, and a friendly but aggressive attitude, this may be the position for you. If you have a proven track record of success and are looking for entry into the lucrative Information Technology Staffing field, please read on. (more…)
PowerPivot is an amazing tool for Data Analysis from Microsoft. It is an in-memory, compressed columnstore desktop database. With it, you can consume data from many different inputs, add additional views and aggregations of the data using the DAX (Data Analysis Expressions) language, and display the data using Excel Pivot Tables and Charts.
PowerPivot is an Excel Snapin. All of the data the analyst is manipulating resides in memory on the desktop. When the SpreadSheet is saved to disk, the compressed data is serialized into an XML blob inside the .xlsx file. The size of the files will become a very valid concern for the analyst when they store or share the files, whether in SharePoint, through network drives, or email.
So, how can we look at the size of the stored data? What expectations should we have? In this blog post, we’re going to look at a simple example of consuming a single table from SQL Server and then look at how much space it takes up in PowerPivot. (more…)