Techno Blender
Digitally Yours.
Browsing Tag

Romain

Lyon-based Dougs, an online accounting startup for SMBs that is profitable with ~€15M in ARR, raised €25M in its first VC…

Romain Dillet / TechCrunch: Lyon-based Dougs, an online accounting startup for SMBs that is profitable with ~€15M in ARR, raised €25M in its first VC round since being founded in 2015 — Dougs, a French accounting startup, has been around since 2015. It already generates $16.4 million (€15 million) in annual recurring revenue. Romain Dillet / TechCrunch: Lyon-based Dougs, an online accounting startup for SMBs that is profitable with ~€15M in ARR, raised €25M in its…

Dua Lipa Spotted Making Out With Rita Ora’s Ex Boyfriend Romain Gavras, New Couple In Town?

Dua Lipa caught making out with Rita Ora’s filmmaker ex Romain Gavras ( Photo Credit – Instagram; Wikimedia ) Singer Dua Lipa has further fueled rumours that she’s dating Romain Gavras. The ‘Levitating’ hitmaker was spotted making out with Rita Ora’s filmmaker ex-boyfriend after they’re seen hitting BAFTA Awards after-party together, reports aceshowbiz.com. In a very short video that emerged on Twitter on Tuesday, the 27-year-old pop superstar Dua Lipa and the French filmmaker Romain Gavras were seen sharing a…

Identifying New and Returning Customers in BigQuery using SQL | by Romain Granger | Jan, 2023

To better understand your customer's interests and behaviors, as well as to improve your marketing strategyPhoto by Vincent van Zalinge on UnsplashClassifying customers, both new and returning, can help in defining which marketing or sale strategy to use. Without a doubt, it will depend on the nature of your business whether you prioritize acquisition, retention, or both.Before delving into the SQL approach and steps, here is a simple definition and business example of the terms:New customer: Someone who makes their first…

Romain Gavras: ‘My dad fed me Tarkovsky from the age of seven’ | Film

Costa-Gavras’s children were his greatest production; weaned on the classics, schooled in the arthouse. The renowned Greek director forbade trash entertainment and would instead treat his offspring to the best of world cinema: Bergman and Kurosawa, masterpiece after masterpiece. Never mind that the kids were barely out of short trousers and struggled to read the subtitles that scrolled across the screen. In the end, no surprise, it became a borderline ordeal.“Kids build themselves in opposition to something,” says Romain…

Differences between Numbering Functions in BigQuery using SQL | by Romain Granger | Sep, 2022

Learn how to use rank, dense rank, row number, cumulative distribution, percentiles rank, quartiles, percentiles, and morePhoto by Austris Augusts on UnsplashNumbering functions assign a number (or decimals) to each record in a table. They are mostly used for ranking or assigning a sequential number to the data for further processing (deduplication, filtering, grouping).They are usually required to be ordered by a specific dimension (date, revenue, salary, ID, etc…).They can be used to answer the following questions:What…

How to calculate a percentage of total in BigQuery using SQL | by Romain Granger | Aug, 2022

Compare the contribution of a row to the overall sum of all rowsPhoto by Karim MANJRA on UnsplashLet’s say you have an e-commerce website that sells coffee, and you have three different categories of products: Arabica, Robusta, and Liberica.On a report, you see that for June 2022, you sold for 345k€ of Arabica, 112k€ of Robusta, and 13k€ of Liberica. In absolute terms, you notice that Arabica is your top revenue maker, but as a percentage of the total, it represents 73% of your sales for this month.The idea is to look at…

‘He was the Steve Jobs of his day’: Romain Duris takes on the towering role of Gustave Eiffel | Romain Duris

If Michael Caine is the quintessential London actor, Romain Duris could become his Paris equivalent. Born and raised in the city, he rose to international fame in 2005 playing the real-estate hustler with ambitions to be a pianist in Jacques Audiard’s The Beat That My Heart Skipped. Quick to the punch but nifty in his fingerwork, dropping rats in a sack on unwanted tenants while wearing Cuban heels, he was Parisian squalor and glamour in one snake-hipped paradox. Then he cashed in his tousle-haired bourgeois-bohème cachet…

How to use variables in BigQuery using SQL — Part 1 | by Romain Granger | Jul, 2022

A step towards flexibility and reusability using parameters and variables using a WITH clauseBlack screen by David Schultz on UnsplashWhat are variables and why can they be useful?Variables are also referred to as parameters. They can be used in SQL for setting or declaring values.Variables store one or more values you provide them and can then be used anywhere in your query.Usually set at the beginning of your code, they can be useful when:You don’t want to change the same value in several places because your query has…

How to Split and Sample a Dataset in BigQuery Using SQL | by Romain Granger | Jun, 2022

Easily segment your data into training, validation, and test sets.Photo by Zac Porter on UnsplashSplitting data means that we will divide it into subsets. For data science models, datasets are usually partitioned into two or three subsets: training, validation, and test.Each subset of data has a purpose, from creating a model to ensuring its performance.A quick definition of the different segments:Training: It is essentially the subset of data we will use to train our model.Validation: When the model is being created this…

Median, Mode, and Average Order Value in BigQuery using SQL | by Romain Granger | Jun, 2022

Learn about your customers’ ordering habits and choose the best strategy for increasing the value of your ordersPhoto by Mildlee on UnsplashThese metrics can help you in understanding how your customers purchase at an “order level”. Different dimensions, such as your product portfolio’s price range, acquisition channel, and location, can have an impact on these metrics. You can also use them as a comparison to other industries.The idea is to gain a good understanding of your customers’ purchase behavior before trying new…