I've been doing a bunch of night skyline time lapse clips myself and I can only imagine how much work that was put into this... But it was a lot!
As with everything that stands out from the crowd, you can tell if somebody poured their heart and soul into it...
Some clips are made from HDR photos no doubt.
The news story I read about this clip was that it was done by a Russian who illegally went onto rooftops in Dubai to get some of the shots but was never charged with anything. No idea how he pulled that one off...

But of course it does help filming/shooting from hundreds off feet high up in the air down into the city. Those are views that are spectacular without a doubt.
Some of the zooms are 99.9% post processing and not very hard to achieve once you know how to work a graphic editor with ease ins and outs but it was very nicely used in this example. It made me jealous too and I'm sure I will work on that for my clips as well

The only thing I'm having a hard time understanding are some of the actual, physical camera movements (sideways). Twice it looked like he was moving the camera sideways for more than 30 feet. No idea how he set this up. Either he used a (self made) dolly and then ligned up all the shots in post again so it looks like a smooth ride. Really nicely done. Maybe some of you know how he might have done it...

Regarding the time spent, I'm not sure if he really shot this all by himself as supposedly he was on vacation there (according to the news article). He shot from many different locations and there is only so much you can shoot while having all factors working in your favor (dusk, dawn, traffic, water fountains, illumination of the buildings). You can only shoot that between roughly 8pm and maybe 2am. That's not a lot of time for time lapse recording... You have to do that night after night after night. And once he was on the rooftop of one skyscraper I doubt that he only shot a couple clips and left again. He probably spend an entire evening up there to get as many shots as possible from that location.
I would say it took him a month or two to shoot the stuff (wouldn't be surprised if more even). Post production is a nightmare too and takes a long time but that's ok because you can enjoy the pretty pictures you took. The computer is the one doing the hard work.
Anyway. Nice stuff.