-
Using DuckDB for Data Analytics
By:
Wei-Meng Lee
Last updated: Monday, December 8, 2025
Published in: CODE Magazine: 2023 - May/Jun
In this article by Wei-Meng Lee, the author introduces DuckDB, a Relational Database Management System (RDBMS) that supports Structured Query Language (SQL) and is designed for data analytics. Unlike traditional database systems, DuckDB does not require installation and can run queries directly on Pandas data. The article provides examples and demonstrations of how to use DuckDB for data analytics tasks, including loading datasets, querying data using SQL, and performing analytics on the data. The author also discusses the recently added support for JSON ingestion in DuckDB. Overall, the article highlights the convenience and efficiency of using DuckDB for data analytics tasks.
-
Putting Data Science into Power BI
By:
Helen Wall
Last updated: Thursday, January 9, 2025
Published in: CODE Magazine: 2022 - September/October
Power BI seems to have everything you need for data analytics. Helen shows you how to get the most out of it and how to make some cool charts, too.
-
Building Dashboards Using Bokeh
By:
Last updated: Thursday, January 16, 2025
Published in: CODE Magazine: 2021 - November/December
Wei-Meng shows you how to use charts and graphs to both display data and to let users interact with data. It’s all done with a Python library called Bokeh.
-
Power Query: Excel’s Hidden Weapon
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - July/August
Helen talks about how to use Power Query, a tool that's part of Excel and Power BI that enables you to automate the ETL process of bringing data into Excel. Learn to create an elegant ETL process in Power Query to first bring in the data, then later refresh it with a single button
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data
By:
Kevin Goff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - July/August
Kevin uses Power BI mapping to track a constantly changing array of data about the COVID-19 pandemic. Learn how pick the right data; it doesn't all come from just a few sources.
-
Best Practices for Data Visualizations: A Recipe for Success
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2019 - November/December
Helen shows you the ins and outs of creating really useful charts and graphs with Tableau. You’ll never make a boring old pie chart again.
- Home
Articles filed in category 'Data Visualization'