“Cargo bikes are booming”

Your cargo bikes have more designs than Thailand’s Saleng!


The director of the International Cargo Bike Festival, which was celebrated last weekend in the city of Groningen in the far north of the Netherlands, thinks “the tide is definitely turning”. The festival magazine, issued for the eight edition, has another quote from Jos Sluijsmans: “Don’t underestimate the amount of people who want their cities to be safer, cleaner and healthier”. In a better world, city logistics are no longer done by half empty trucks and vans, but by cargo bikes!

The festival area used to be a sugar factory.

The opening of the 2019 Cargo Bike Festival in Groningen.

After six editions in Nijmegen (from 2012 to 2017) last year’s edition of the International Cargo Bike Festival was held in Berlin. I had visited the festival from 2013 to 2016 (and I wrote threeblogposts about it) but I had missed the event in 2017 and…

View original post 780 more words


Internet Trends 2009 by Mary Meeker, Bond

List of Contents

Mary Meeker’s most important trends on the internet

  1. E-commerce is now 15 percent of retail sales. Its growth has slowed — up 12.4 percent in Q1 compared with a year earlier — but still towers over growth in regular retail, which was just 2 percent in Q1.
  2. Internet ad spending accelerated in the US, up 22 percent in 2018. Most of the spending is still on Google and Facebook, but companies like Amazon and Twitter are getting a growing share. Some 62 percent of all digital display ad buying is for programmatic ads, which will continue to grow.
  3. Customer acquisition costs — the marketing spending necessary to attract each new customer — is going up. That’s unsustainable because in some cases it surpasses the long-term revenue those customers will bring. Meeker suggests cheaper ways to acquire customers, like free trials and unpaid tiers.
  4. There are a number of problems ahead for targeted advertising, including GDPR impact and other regulation, as well as pushes for more privacy from hardware and software companies like Apple and Facebook.
  5. Americans are spending more time with digital media than ever: 6.3 hours a day in 2018, up 7 percent from the year before. Most of that growth is coming from mobile and other connected devices, while time spent on computers declines. People are also getting more concerned about time spent online, as more than a quarter of US adults say they’re “almost constantly online.”
  6. Innovation at tech companies outside the US has remained robust. Popular areas include fulfillment, delivery, and payments.
  7. Images are increasingly the means by which people communicate, as technology developments like faster wifi and better phone cameras have encouraged a surge in image taking. More than 50 percent of Twitter impressions now involve posts with images, video or other media; Twitter used to be text-only.
  8. The number of interactive gamers worldwide grew 6 percent to 2.4 billion people last year, as interactive games like Fortnite become the new social media for certain people. The number of people who watch those games — rather than participate — is swelling, too.
  9. As privacy becomes a bigger selling point, expect more options to make your online communications safe. In Q1, 87 percent of global web traffic was encrypted, up from 53 percent three years ago.
  10. The internet will become more of a cesspool: Getting rid of problematic content becomes more difficult on a large scale, and the very nature of internet communication allows that content to be amplified much more than before. Some issues: 42 percent of US teens have experienced offensive name-calling online, terrorists are being radicalized on sites like YouTube, and social media has encouraged increased political polarization.
  11. Of the top 25 most valuable tech companies, 60 percent were founded by first- or second-generation immigrants. They employed 1.9 million people last year. New stricter immigration laws could negatively impact the tech industry and perhaps prevent our next Elon Musk from getting to the US.
  12. Health care is steadily becoming more digitized. Expect more telemedicine and on-demand consultations.

Full slide deck  https://www.bondcap.com/report/itr19

Source: recode by Vox

rPod Coworking Space Daily

Coworking, Digital Nomad, Startup, Business, and STREAM Newsfeed by Peerasak Chanchaiwittaya
— Read on paper.li/f-1554543267

rPod Coworking Space Daily

The Rise of the Millennials: A Call to Current and Aspiring Entrepreneurs

Coworking, Digital Nomad, Startup, Business, and STREAM Newsfeed by Peerasak Chanchaiwittaya
— Read on paper.li/f-1554543267

Blogging: Fundamentals

Blogging Fundamentals is three weeks of bite-size blogging assignments that take you from “Blog?” to “Blog!”

Every weekday, you’ll get a new assignment to help you publish a post, customize your blog, or engage with the blogging community. Whether you’re just getting started or want to revive a dormant blog, we’ll help you build good blogging habits and blogger connections that will keep you going over the long haul.

I have learned so much and am very happy with the progress I’ve made on my blog. I’ve already got my first paid photo engagement as a result of my blog, and I wasn’t even trying to! Unbelievable. Thank you!
– Hurry Before It Wilts

You’ll walk away with a stronger focus for your blog, several published posts and a handful of drafts, a theme that reflects your personality, a small (but growing!) audience, a grasp of blogging etiquette — and a bunch of new friends.

As in all Blogging U. courses, you’ll also have access to a private site, The Commons, where you can connect with other participants, share your work, and get support from WordPress.com Editors and Happiness Engineers.

Sharing is caring.

Source: Blogging University WordPress .com

Dutch cycling figures

Dutch cycling figures


The Dutch cycle more. They cycle more often and they cycle longer distances. But the modal share of cycling has been more or less stable for the last three decades at 27% of all trips. How can both these facts be correct? Time to dig into some of the cycling figures in the Netherlands.

Cycling in the cities increased with 12% from 2005 to 2016.

Before we get to the story for this post I’d first like to wish you all a very happy new year. May 2018 bring you good things and fulfil wishes and expectations. I will continue to try to bring you information about cycling in the Netherlands, the good and the bad, but always in a positive tone. This is the beginning of the tenth year that I will be making videos for you. When I published the first video, in January 2009, I never expected…

View original post 1,199 more words

2019 Pattaya City

🇨🇳2019 Patty’s City (Chinese Ver)🇨🇳 https://youtu.be/exUtkuqveZg

🇬🇧2019 Pattaya City (English Ver)🇬🇧 https://youtu.be/9o2wnJKnDfM

2019 International Innovation Scorecard

What did Thailand do right?

Thailand has relatively low corporate and individual marginal tax rates and ranks well above similarly-sized countries in the ease of starting a business. Also, the nation boasts access to improved drinking water sources for the vast majority of its population.

What can Thailand do better?

Thailand could lay legal groundwork and support self-driving vehicle development, an area where the country currently lags behind almost every other nation on the Scorecard. The country can increase its proportion of highly-skilled workers and dramatically increase its R&D spending, which is currently just 0.60 percent of its GDP.

Source: Consumer Technology Association

Facebook Page Scraping Using Excel 2016

ดึงข้อมูลจาก facebook page แค่ไม่กี่คลิกด้วย Microsoft Excel 2016 ไม่ต้องเขียนโค้ดซักแอะ !!


สำหรับเพื่อนๆที่อยากลองดึงข้อมูลจาก Facebook page ของตัวเองมาลองทำ data analysis ง่ายๆ วันนี้เรามี tutorial สอนทำบน Excel 2016 ได้เลย (แบบไม่ต้องเขียนโค้ด !!)

  • ตัวอย่างวันนี้เราลองทำด้วย Excel 2016 หรือเวอร์ชั่น 365
  • ถ้าใครเขียน R เป็นแล้ว ลองดู tutorial เก่าของเราได้ที่นี่
ตัวอย่างวันนี้สามารถทำตามได้บน Excel 2016 / Excel 365

เปิดโปรแกรม Excel ขึ้นมาไปที่

  • Data > Get Data > From Online Services > From Facebook
  • กดปุ่ม continue ทำตามขั้นตอนบนหน้าจอ Excel จะขอให้เราล๊อกอินด้วย Facebook account (email, password) ของเรา
  • ใส่ชื่อ Facebook page ที่เราต้องการดึงข้อมูล และเลือก Connection เป็น Posts ตามรูปด้านล่าง
เสร็จแล้วกด OK

Importing …

Excel จะทำการดึงข้อมูล posts ทั้งหมดในเพจเรา ถ้าเพจเรา posts เยอะ จะรอนานนิดนึง เสร็จแล้วกด Editเพื่อเข้าไปปรับหน้าตาข้อมูล เช่น เลือก columns หรือเลือก rows ที่เราต้องการ ฯลฯ

ตอนนี้ Excel จะเปิดหน้าต่างใหม่ขึ้นมา เราเรียกหน้าต่างนี้ว่า Power Query ให้เราใช้จัดการข้อมูลก่อนโหลดเข้า Excel เป็น table

Power Query ที่เราใช้ในการทำความสะอาดข้อมูลก่อนโหลดเข้า Excel เป็น Table

Keep Top Rows

ถ้าเราต้องการ filter เฉพาะ 10 posts ล่าสุดของ Facebook page เรา ให้เรากดที่มุมซ้ายบนของตารางตามรูปด้านล่าง แล้วเลือก Keep Top Rowsใส่ number of rows = 10 แล้วกด OK

Get Comments

เราสามารถเรียกดู comments ในแต่ละ post ของเราได้ด้วย แค่เอาเมาส์ไปคลิกที่คอลั่ม object_linkตามรูปด้านล่าง และเลือก connectionsเสร็จแล้วกด OK

ใกล้เสร็จแล้ว !

กดซ้ำที่คอลั่ม object_link.connectionsอีกครั้งหนึ่ง เลือก commentsแล้วกด…

View original post 85 more words

Andreessen Horowitz leads $154 million investment in business travel start-up TripActions, at over $1 billion evaluation

Business 365

Corporate travel management business TripActionshas raised a massive $154 million in a series C round of financing led by Andreessen Horowitz, with involvement from Lightspeed Endeavor Partners, Zeev Ventures, and SGVC.This takes

the business’s overall financing to $236 million and bestows upon it an evaluation of more than $1 billion, according to a business spokesperson.Founded in 2015, Palo Alto-based TripActions pitches itself as an end-to-tend travel-management business, providing access to a greater choice of hotels, flights, automobile hire services, and associated travel services, all with the promise of” unique”prices.Tying into this, the TripActions app provides a direct

artery to round-the-clock assistance personnel in case of flight delays or other problems– basically conserving employee the inconvenience of having to manage such incidents themselves. If a flight is cancelled, for example, TripActions can instantly sort things out and keep you notified. Above: TripActions: In-app messaging In its 3 years so far, TripActions…

View original post 390 more words