Best of Data Analysis — January 2024

1. 1
   Article

   MotherDuck·2y

   Why you should learn SQL in 2024

   SQL is a valuable and marketable skill that every organization needs. It is essential for manipulating and analyzing data stored in databases. SQL is a portable skill that can be used across different databases and data tools. Learning SQL is made easier with DuckDB and MotherDuck.

   62

   1
2. 2
   Article

   freeCodeCamp·2y

   Learn Data Analysis and Visualization with Python Using Astronomical Data

   Learn how to use Python to analyze and visualize astronomical data in a course on the freeCodeCamp.org YouTube channel. The course covers Python programming basics, tabular data visualization, image data visualization, and image processing techniques.

   17
3. 3
   Article

   freeCodeCamp·2y

   Learn Data Analysis with Comprehensive 19-Hour Bootcamp

   A comprehensive 19-hour data analysis bootcamp has been published on the freeCodeCamp.org YouTube channel. It covers topics such as SQL, Excel, Tableau, Power BI, and Python for data analysis. The bootcamp includes hands-on projects and career guidance. It is developed by Alex Freberg.

   17
4. 4
   Article

   Streamlit·2y

   Building a dashboard in Python using Streamlit

   Learn how to build a dashboard in Python using Streamlit. Define key metrics, perform EDA analysis, and build the dashboard app with Streamlit.

   14
5. 5
   Article

   Medium·2y

   Important Python Topics for Data Engineering

   Learn the important Python topics for data engineering, including variables, data types, operators, if statements, loops, functions, modules, exception handling, lists, tuples, sets, dictionaries, strings, arrays, file handling, and working with different file formats.

   12

   1
6. 6
   Article

   KDnuggets·2y

   A Step by Step Guide to Reading and Understanding SQL Queries

   Learn how to read and understand complex SQL queries with a step-by-step guide. Understand the general SQL query structure, the final SELECT, the final conditions clause, the final join, and practice reverse order reading.

   11
7. 7
   Article

   Awesome Go·2y

   Awesome Go Weekly - Issue 399, Jan 11, 2024

   This post provides an overview of popular Go news, articles, and packages, including discussions about error handling in Go web apps and the Awesome Go Weekly newsletter.

   11
8. 8
   Article

   KDnuggets·2y

   SQL Group By and Partition By Scenarios: When and How to Combine Data in Data Science

   Learn about the scenarios and techniques of grouping and aggregating data, as well as partitioning and ranking data in SQL.

   10