The GfK Insights Calendar – Crambed full of Insights, Infographics, Animations and Research Findings

GfK Insights Calendar

This year we have produced calendar review of the last year. It’s packed full of all the Infographics, Animated Videos and Charts we have been producing to support our PR and blog outputs. Have a browse and feel share the Insights.

We now have expanded the in house video production team with the addition of a motion graphics and 3D specialist so there’s some really exciting visuals and client deliverables just around the corner, all in a whole new league than any of our competitors.

There will be plenty more to come next year so watch this space.

 

How data visualisation techniques like Infographics, video, audio can help make sense of Information

For those who regularly visit my blog you will know that I run a small in house video production service for a very large research company. We have been using Infographics and illustration for some time in order to make better sense of information for client deliverables. It is clear that data and information can be simplified but often it still requires a degree of deciphering in order to fully consume. In the past the use of video has brought to life a simple verbatim or a timed reveal of a chart with a voice over lead the viewers eye around the visual. We now look to combining these techniques in order to produce the most powerful client deliverables through illustration, animation, audio and video.

On the GfK TechTalk blog we have begun a series of posts in order to show off these approaches, starting with an Information Overload graphic. Watch this space to find out what we are up to.

Creating a Mac for Video production – Your software requirements

I’ll quickly touch on Hardware as i have had various builds with quite different results. I have 3 different builds on 4 machines, 2 MacPros with 1TB hard drives and 2 x Quad-Core Intel Xeon 2.8 GHz, 10 GB of RAM. Another MacPro with a HD and a 1TB raided, this is an extremely efficient machine as the software is running on the system drive and the video projects running from from the raid. Then 4th and currently my edit suite is a 2.26 GHz, Dual Quad-Core Intel Xeon, 16 GB of RAM with a 500GB hard drive, faster access speed to the drive and I have never had any issues while editing, although the sometimes windows in the VMware runs a bit slow and the HD sounds like its going wild but that could be the configuration.

Adobe Premiere Pro or Final Cut pro? That is the question. I shall be honest, I was always a Final Cut person up until my latest role. The main reason we switched to Adobe was for better integration with the designer who already existed in the company. In the early stages there were problems, mainly with the quality of exports but that has greatly improved. If you could export to WMV on the Mac version that would be great! The workflow of Premiere is very efficient but I have not used Final Cut Pro for a while. You decide!

First things first, get Firefox web browser installed. I’ve not had too much experience with other browsers and video but firefox plugins seem to be a bit more readily available. Once installed and you’ve punched through your proxy (if you have one) install Video DownloadHelper. I’m often asked to download videos from various site such as YouTube for use in presentations and this plugin makes it real simple! If there’s something on the page that you can download the icon lights up and its a couple of clips to download.

Upgrade your QuickTime to QuickTime Pro, it’s essential and despite my opinion that it is not as good as it used to be, you won’t get away without it.

Get some codecs installed, Perian is my first choice and makes sure you can open many awkward video files. If your source files come from all over the place then get the MPEG-2 plugin for QuickTime installed, people still bring me mpg files and it’s not worth the time or effort sourcing another software (should come as standard) Get Flip4Mac on there, go all out and get the HD version you’re only going to upgrade it later otherwise. I’ve never had any playback issues in QuickTime and the output options are very flexible and unlike a few years ago WMVs are pretty good quality and a small file size.

I always have VLC installed, it allows us to view back .mts files shot on our camera kits without the need to bring them ink the edit, great for logging and an area QuickTime falls short. Get to grips with the export options, sometimes gets you out of a scrape when files don’t play on other players.

I use Handbrake for ripping DVDs into an editable format, despite trying to single handily educate the world of focus group facilities with the understanding that DVD recordings are output and they should get up to speed with recording techniques, I still get footage from all over the world as a DVD. We have however built our own viewing facility that can record direct to drive with VoIP access to the respondent area.

I also install DivX and DivX converter for playback and conversion, some recorders record in divx so it’s quite handy. Also allows you to open in QuickTime, do a quick save as and drag and drop the file into your edit.

I recently added the free Mpeg Streamclip when I had some files from Japan that I could not open in QuickTime this saved my bacon, there’s loads of nifty little programs like this and the recent addition of the Apple App store for your desktop makes it a lot easier to browse apps that the old website.

As I mentioned, I have had 2 edit suites hard drives die beyond recovery recently which resulted in a loss of work despite having Back up solution. Make sure you have a good backup solution in place, preferably with support.

Digitizing your DVD / Film collection, software, settings, exports, codecs, file size etc

The other day a colleague, Ryan Garner! you may have heard him on Simon Mayos drive talking about iPad sales (tech expert) no big deal! said he was thinking about digitizing his DVD collection. It got me thinking, it’s about that time that hard drives are so big and compression routines so efficient that we all should start to think about having our films as files. I have a few DVDs as digital downloads and a few I have converted for my iPhone but with 160gb of ps3 hard drive sitting there doing nothing why haven’t I taken the iPod mentality with my DVDs and got them all on a hard drive. So it’s testing time.

I started by looking at the old iPod exports I had done a few years ago but I was after something that wouldn’t look to degraded on a 40″ TV. I remembered having a download available with my x-men origins DVD I bought recently and so download it to look at the file. It was slightly bigger at 8 x but still what would this look like on a 1080 tv, I was optimistic as it looked pretty good in full screen on the MacBook. So the next step was to play it from the PlayStation. No transfer need, see Media Streaming from an Apple computer to a PS3 using MediaLink….  No worries, here to help!

So, next to look at some software, exports settings and codecs. My preferred DVD ripping software is Handbrake on the mac but have a search on Softpedia or Download.com if you are using a PC for alternatives. Handbrake has a few export presets so I tried a few to compare results. When these exports are played back on laptop there isn’t much in the quality although the files sizes can differ dramatically. I exported another targeting the file size to around 700 mb, this produces a very low bitrate and a noticeable reduction in quality. I next produced an export with a targeted bitrate. Many video files on my laptop had a bitrate of around 1500 so I thought it would be interesting to see what file size this produced. The results were a medium size file, approximate 2 gig and a good quality. The test would be though which files I could play through the TV and still be happy with the quality. My opinion is that if you are after DVD quality videos you need to target the 4 to 5 gig file size with minimum compression. If you are happy to notice slight pixelation in your image and funnily enough this occurs on the flat chunks of colour then go-ahead and start reducing the bitrate.

There Is other software and codecs that do the same sort of job, DIVX has a very good compression routine and produces small file sizes in high quality, just make sure you check what file extensions your devices can playback before you compress your entire collection.

Should we be filming in HD for corporate / presentation video output?

The time has come to make the decision. HD or not to HD? And for those still getting mixed up, HD is High Definition and HDD is Hard Disc Drive, be sure you know the difference when you are purchasing you video camera! For a few reasons I have still been shooting in SD (Standard Definition) for corporate and by corporate I mean presentation video output (video for PowerPoint etc) File size being one, especially as I have footage backed up from my edit suite to a server daily and then an off site tape backup. Also, shooting to DV tapes provided a simple short term backup solution. Many of the videos produced are also not to be viewed on a television but accompanying information on a PowerPoint slide, so is often shown at in smaller dimension.

The thing is, more and more, stand alone presentation pieces are played on the desktop or from an online portal with the ability to display at full screen, now obviously standard definition is 720 x 576 against most monitor screen dimensions being at least 1024 px wide, in which case a SD is stretched to fit the screen causing massive pixelation.

A point to note that file compression is much better than it used to be so producing HD videos as mpeg4 with a h.264 codec has less file size implications and doesn’t cause your machine to grind to a halt when you try and play it back on desktop software.

My final point in my HD or not to HD argument that is fast leaning toward A HD win is that of Hardware. Even prosumer HDD cameras like the Everio have moved away from mere TV playback through your AV cables but not record in edit suite friendly formats. This means, drag and drop functionality that saves hours on your production work flow and produces better output.

The 3 causes of the white square during video playback in powerpoint

Probably the most common problem I am faced with week in week out is video failing to play in a PowerPoint presentation. Here are a few of the checks to perform to get things working.

Firstly, PowerPoint does not physically bring the video file into your presentation as it does an image. Hit save after embedding and notice the PowerPoint file does not grow in memory size. Therefore the presentation always needs to know where the video is relative to the document. Always keep the video file in the same place as the PowerPoint file and get into the habit of moving the parent folder around as you move the presentation from computer to computer.

Secondly, there is a bug in PowerPoint, if you see the white square when you play the video there is a good chance this is caused by there being too many characters in the video file name, I did read somewhere that over 128 characters but I find this differs from machine to machine. If you ate one of those people who put your videos in a folder named movies or something then include this parent folder in this rule.

Lastly, I sometimes get problems when a presentation is built on a company network and again this differs from machine to machine. If the above doesn’t work try moving the presentation to your desktop or local folder and re embedding the video.

That should do it!

Also see Creating Video for Powerpoint and inserting video into Microsoft Powerpoint

Record / Screen Capture what you do on your XBox or PS3 as video footage

Ok, I’ve been doing a bit of usability testing recently and thought I’d push the boundaries of what I can record and offer as video output. In theory anything with a video out I can record, so there was no problem with most mobile phone devices so I thought i’d rig up and record my gaming.

Here’s the xBox and ps3 setup. I used an Apple MacBook Pro to record the video with a Formac Studio analogue to digital converter. It meant that I could take a digital signal to the computer and still run the xBox into the TV and keep playing a game.

Couple of things about the ps3, sometimes, on some tv’s you’ll have trouble with the analogue inputs so you have to go into the playstation menu while you are in your usual setup and then select analogue and restart. Not going to talk you through the setup it’s pretty self explainitory although here it is

And here is some sample footage.

Adobe Premiere Pro – The difference between Track Volume and Clip Volume

If you are used to using Final Cut Pro you will no doubt prefer to control your audio channels in the timeline rather than on the effects tab. At first this appear difficult if you use the button to the left of the timeline depicted here you shall reveal further controls in Adobe Premiere Pro.

This will allow you to control the levels from the timeline over time which is very handy if you have a soundtrack or voice over that needs to be taken in and out during your edit. Often these level changes will be clip dependent, meaning that if you move the clip around the point at which the levels need to change will remain the same. Sometime these changes in sound level will be relevant to the edit and if you move certain clips you will still require the levels to change at that point. Using the drop down here you have access to show clip toggles or show timeline toggles. Remember that clip levels works on that clips audio independent of the timeline and the timeline audio works on the timeline audio independently of the clips.

Add keyframes at the playhead using the black diamond next to the track or by using the Pen Tool.

AVCHD Video Recording Time / File Size testing

AVCHD – MPEG4 – AVC/H.264

XP AVC – High Quality
VBR, avaerage of 17Mbps
The manual says,
Approximate recording time 900 minutes on a 120GB HD
My test 10 minute file = 1.28 GB on disk

SP AVC – Normal Quality
VBR, avaerage of 12Mbps
The manual says,
Approximate recording time 1260 minutes on a 120GB HD
My test 10 minute file = 892.1 MB on disk

EP AVC – Long Recording
VBR, avaerage of 5Mbps
The manual says,
Approximate recording time 3000 minutes on a 120GB HD
My test 10 minute file = 348.8 MB on disk

Using Camtasia to Screen Capture / Record Video Tutorials

Despite pushing for Adobe Captivate we have installed Camtasia on the edit suites at work for screen capture and tutorial recording. I’m not disappointed though it does the job!

Firstly, the majority of recording the company will need to shoot will be on PC based software so we have bought the PC version and installed VMWare on the Macs. This should improve the workflow from recording to edit. The software is easy to set up and get started with, like most programs.

Load up Camtasia Studio and you will first be faced with an option screen. Choose screen recording.

A small window in the bottom right hand corner of the page will load. In this window you have options for Camera, Audio and Select Area.

Once you hit the record button the window is minimized to the tray and everything you do on screen or within your assigned area is recorded.

When you are done hit the Esc key or go down to the icon in the tray and click to reveal the stop option.

The recording is now in a ‘cache’ state and you now need to decide how you will save the file down.

Click the Save button in the bottom right corner of the window.

Save the files down as an AVI as we will not be editing the video in Camtasia Studio. Organise your clips well so you can quickly identify them and their order later.