Videos
Address Insights Reimagined
In today’s dynamic business environment, particularly within the retail, real estate, and service sectors, leveraging precise location data has become indispensable.
Stop Scraping Open Data!
Looking back into the deep dark days of the early web Before the advent of open Apis Schema.org and RDF, and definitely, well before Artificial intelligence, visual web scraping was one of the very few ways to get structured data out of the web.
Using INNER JOIN versus CROSS JOIN in SQL
Using the right JOIN statement in your SQL code is critical for accurate results. While it might be easy to identify a bad data set when only a few results are returned, it’s not so easy when you have thousands of results.
Should You Use NULL values in Your SQL Database?
If you search for NULL standards in Google, the first page shows you answers from both sides of the debate. Using NULL values in your database is a permanent choice. Once you choose to allow them, you need to allow NULLs in all SQL database tables.
Government and Open Data for AI Start Ups
AI and machine learning start-ups are some of the most exciting and interesting businesses out there today. They are curing diseases, trading trillions of pounds of stock, and making sure your home assistant can understand what you want when you say “OK Google”.
4 Useful Tips for Working with R and RStudio
Working with R and RStudio can be very rewarding as R is one of the most powerful data processing and data visualization programming languages available.
Smoking rates across the UK
Whilst smoking rates are trending downwards nationally there are still pockets where smoking greatly exceeds expected averages. In 2018, 14.7% of people aged 18 years and above smoked cigarettes.
Life expectancy, who wants to live forever?
Life expectancy is a statistical measure that estimates the average number of years a person is expected to live based on various factors such as their birth year, gender, and the overall health and living conditions of a population.
4 easy ways to Optimize SQL Queries and Enhance Security
The fastest way of improving response times is to Optimize your SQL Queries. Your backend SQL server be it MYSQL or Microsoft is the powerhouse of application performance.
Identify the best locations for new stores using data
Data is a cornerstone of effective location analysis, providing critical insights for businesses aiming to make informed decisions about where to establish their presence.