Photo by Markus Spiske on Unsplash Mastering SQL ORDER BY: Sorting Data Effectively When working with relational databases, retrieving data is only half the battle. Equally important is presenting that...
read moreFoto cortesia de Markus Spiske no Unsplash Dominando o ORDER BY em SQL: Classificando Dados com Eficácia Ao trabalhar com bancos de dados relacionais, recuperar dados é apenas metade da...
read morePhoto by Bruno Wolff on Unsplash Mastering the SQL WHERE Statement: From Beginner to Advanced Structured Query Language (SQL) is the foundation of working with relational databases. Among its many...
read moreFoto cortesia de Bruno Wolff no Unsplash Dominando o comando de restrição WHERE: Do Básico ao Avançado A Linguagem de Consulta Estruturada (SQL) é a base do trabalho com bancos...
read morePhoto by Mitchel Lensink on Unsplash Understanding the SQL’s SELECT Statement: A Comprehensive Guide SQL (Structured Query Language) is the cornerstone of managing and querying data in relational databases. Among...
read moreFoto cortesia de Mitchel Lensink on Unsplash Entendendo o comando SELECT do SQL: Um Guia Abrangente SQL (Structured Query Language) é a base para gerenciar e consultar dados em bancos...
read moreMastering the Basics of SQL: A Beginner’s Guide to Structured Query Language In today’s data-driven world, understanding how to manage and retrieve data effectively is a highly valuable skill. Whether...
read moreNote: All the project’s Jupyter Notebook files, including images and my notes, can be seen here. Sources InsideAirBnb London data About the source Inside Airbnb is an independent, non-commercial set...
read moreBetter than sliced bread String slicing allows us to extract specific portions of a string by specifying a start and an end indices. We can even skip characters! How about...
read moreOne of the most common tasks we perform with Pandas is data indexing and selection. We do that pretty much daily. Let’s delve into the world of Pandas and explore...
read moreThe Numeric data type There are eight major data types in Python: Description Type Text str Numeric int, float, complex Sequence list, tuple, range Mapping dict Set set, frozenset Boolean...
read moreIntroduction to Pandas Pandas Official Documentation. What is Pandas? As per the Pandas Official Documentation website: Pandas is an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data...
read moreIntro It’s March 2024 and I have joined a Level 4 Data Analytics Bootcamp! Hurray! Technically lessons will only start at the beginning of April but I am already very...
read moreI’m happy to share that I’ve obtained a new certification: SQL for Data Analysis: Beginner MySQL Business Intelligence from Udemy (Maven Analytics). See the certificate on Udemy here. COURSE OUTLINE: SQL Intro...
read moreHave you ever needed to quickly generate mock data to exercise your data analytics skills or test your app? Try Mockaroo. It is an easy and quick way to create...
read moreIf you, like me, use Jupyter Notebook for Data Analysis, these Jupyter Notebook shortcuts might come in very handy. #jupyterNotebook #dataanalsys #python #numpy #pandas #shortcuts Jupyter Notebook tips and shortcuts...
read moreI have based my research on the UK’s Department for Transport data. I investigated and found patterns and trends in Road Safety in various Local Authorities across the country. Analysing...
read moreIf you are learning Data Analysis and have just started with Python Pandas, check this Pandas playlist from Corey M Schafer. It is truly excellent, very comprehensive, and a very...
read moreIt is finally here! My Level 3 - Data Citizen Skills Bootcamp Certificate of Completion. Level 3 - Data Citizen Skills Bootcamp I cannot express enough how much this certificate...
read moreIt is Week 10, our last week, at the Cambridge Spark Data Citizen Bootcamp. It is also project week. We are putting to practice all the new skills we have...
read moreThis week, Week 9 of our Data Citizen Bootcamp at Cambridge Spark, was a gentle intro to Python for Data Analysis, including an intro to the Pandas data analysis library....
read moreA very thorough guide on Markdown markup language. Very useful if one needs to add some markdown structure to their blog posts. Markdown Cheatsheet
read moreConfused by the difference between ETL and ELT when dealing with data? Which one is the most appropriate? Is one better than the other? Take a look at this nice...
read moreToday we started Week 8 of our Data Citizen Bootcamp at Cambridge Spark and it was all about Data Storytelling. Finally, we are wrapping up all the last 7 weeks...
read moreToday was a Visualisation/Building Power BI dashboards on our Cambridge Spark Data Citizen Bootcamp lesson. Really good fun, by the way! I am from a “less is more” school when...
read moreA very instructive Microsoft article on “Top ten ways to clean your data” found by my colleague Bryan, from our Cambridge Spark Data Citizen Bootcamp. We have just finished Week...
read more