CODE Magazine / Articles

Data Visualization

Articles filed under Data Visualization

Articles

Showing 1–6 of 6

  1. CODE Magazine: 2023 - May/Jun cover

    Using DuckDB for Data Analytics

    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.

  2. CODE Magazine: 2022 - September/October cover

    Putting Data Science into Power BI

    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.

  3. CODE Magazine: 2021 - November/December cover

    Building Dashboards Using Bokeh

    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.

  4. CODE Magazine: 2020 - July/August cover

    Power Query: Excel’s Hidden Weapon

    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

  5. CODE Magazine: 2020 - July/August cover

    Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data

    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.

  6. CODE Magazine: 2019 - November/December cover

    Best Practices for Data Visualizations: A Recipe for Success

    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.