Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Browse by Tags

Related Posts
  • Blog Post: Excel add ins for Analysis Services

    Excel and analysis services are pretty open technologies so it’s very easier for anyone to grow their own stuff in for a richer experience, and even Microsoft provide things like the data mining add-ins which follow this principle. These add-ins are not confined to Microsoft and they are not always free...
  • Blog Post: The Office Ribbon

    Why are people in this country so glued to the imperial system of measurement? are they easier to use compared to metric (SI) units? e.g. How many cubic inches/ pints quarts does the engine in your car have? How heavy is a gallon of water? How many cubic yards of gravel do I need for my drive...
  • Blog Post: Five New Year’s Resolutions for 2011

    I  think a lot of people, IT Professionals included are worried about the year ahead, so here are some likely problems and my new year resolutions: Energy prices are spiralling This means the cost of moving whole atoms rather than just electrons is even more pronounced than ever, so moving data...
  • Blog Post: PowerPivot Installation

    I hope my PowerPivot posts and videos are proving useful, and continuing this them I want to cover off installation. PowerPivot for Excel is a free download for Excel 2010 and simply doesn’t need any edition of SQL Server behind it. It comes in 32 bit and 64 bit depending on which variant of Excel...
  • Blog Post: Social Office

    A lot of people who use facebook also use Office so Microsoft Fuse labs have used Azure to provide Office document sharing between facebook users in much the same way as facebook users can now share pictures and videos. I Simply went to http://docs.com and signed in with my facebook account to get started...
  • Blog Post: Microsoft Free Software – a personal top ten

    You might think this will would make for a really short article post but actually  there’s a  huge amount of free tools and resource out there and I have had to restrict myself to a top ten across the server and client,  based on what Simon and I have used.  So please feel free to...
  • Blog Post: Work Experience

    A lot of teenagers are on work experience at the moment, and as I don’t have any of my own children I got to be cool uncle for a week and took my nephew Harry to spend a week inside Microsoft.  We run a full week course of lectures and practical exercises along the lines of the apprentice, to teach...
  • Blog Post: PowerPivot Cookery

    I am a pretty good cook (not as good as our chef in residence Marc ) but I don’t practice enough so I wanted to get back up to speed to help out while my wife works on her OU degree and to explain PowerPivot. I have posted this video on YouTube.. ";" mce_src="http://blogs.technet.com...
  • Blog Post: PowerPivot is Integration Services sort of

    One of the key problems in BI is getting your data together and cleaning it, and one of the best tools for doing this at scale would be integration services in SQL Server. However integration services is too complicated for the average business user but these users do need something to load and prepare...
  • Blog Post: PowerPivot is Analysis Services, sort of

    PowerPivot is essentially a way of making an analysis services cube using excel as the design tool. When you use the PowerPivot for Excel add-in, then there no backend dependency, but if you want to save a PowerPivot to SharePoint 2010, there has to be a special installation of SQL Server 2008 R2 analysis...
  • Blog Post: Education education education at BETT 2010

    I have spent the last four days on the Microsoft stand at a huge education show (BETT 2010) to field technical questions on Windows 7 and Office 2010. I take my hat off to the IT Pro’s working in schools as they have to cope with all kinds of applications and hardware and usually there are only one or...
  • Blog Post: PowerPivot management

    The most important thing about PowerPivot is the ability to share users analysis into SharePoint so that these other users can slice and data form within a browser.  As I’ve said before this uses SQL Server analysis services behind the scenes, albeit as part of a special install option.  I...
  • Blog Post: Access - Office angel or spawn of satan

    My first introduction to Access was a painful experience, not because of the product itself but the way it was used, so it was mixed feelings that I read up on the official Access blog what it will look like in Office 2010.  Yippee it’s going to be 64 bit , so it will be easy load data form it and...
  • Blog Post: Work Life Balance in Office

    For me the office is Microsoft Office as my litmus test for whether I am working or not is what I am doing not where I am.    The final bit of Office 2010 is still in beta – Office Communicator 2010 and I have been pestering the development team  to get on the internal dogfood to...