CODE Magazine / Articles
Data Science
Articles filed under Data Science
Articles
Showing 1–15 of 15
-
Using DuckDB for Data Analytics
Updated
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.
-
Introduction to Snowflake
Updated
In this article, author Rod Paddock introduces Snowflake, a cloud-based SQL database that offers a range of capabilities for developers. Paddock discusses the features of Snowflake, such as its cloud-agnostic nature, support for querying JSON data, and secure data sharing capabilities. He explains how Snowflake's unique architecture allows for "infinite" computing through its warehouse concept and provides insights into using Snowsight, the web-based application for managing Snowflake infrastructure. Rod also discusses building a data loading pipeline, securing data with masking, and sharing data with other Snowflake users. He concludes by highlighting the power and user-friendly nature of Snowflake as a game-changing product.
-
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.
-
The Secrets of Manipulating CSV Files
Rod shows you how CSV is anything but old news.
-
Data Structures and Algorithms
Sahil collects his favorite tools and tells you why they should be your favorites too.
-
Power BI and R: A Visual Power Punch
Updated
Data Visualization can be the best way to get your message across. Helen shows you how, using Power BI and R.
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data, Part 2
Developers should know their data before they spend a lot of effort analyzing it. For example, at face value, you should know if your data is in the millions or billions, and know "that's what the data said" is not the right answer if the data is bizarre. This article in Kevin Goff's Stages of Data series using PowerBI introduces a new state profile page with ranking formulas, new trend-based measures, defining custom filter groups, and more.
-
Power Query: Excel’s Hidden Weapon
Updated
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
Updated
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.
-
Azure Machine Learning Workspace and MLOps
It’s when you’re working with lots of data that you start looking around for an easier way to keep track of it all. Machine learning and artificial intelligence seem like the obvious answers, and Sahil shows you why.
-
Identify Faces with Microsoft Cognitive Services
Updated
In this article, Sahil Malik demonstrates how to use Microsoft Cognitive Services' Face API to build an application that can detect, identify, and recognize human faces by creating and training a person group with associated images. He explains the API’s capabilities, the process of adding persons and faces, training the model, and performing identification via simple REST calls, highlighting its ease of use and scalability. Sahil emphasizes the practical potential of this technology for real-world applications, from personalized user experiences to security, while showcasing how accessible AI has become for developers.
-
Introduction to the R Programming Language
Updated
Learning R sets you up for creating machine learning projects. Wei-Meng takes a close look at the language, which can implement a wide variety of statistical techniques, tests, analysis, classification, clustering, and can help you produce publication-quality graphs.
-
Azure Skyline: Data in Cloud Applications
Updated
Mike looks at the technology that allows multiple teams to connect and scale their data despite disparate data storage methods.
-
Using F# Type Providers for Data Science
You know that F# is the Next Big Thing, but did you know that it uses type providers? Rachel shows you how to use them to access data in no time.
-
Introduction to Data Science using Python
If you’re curious about Data Science or Python—and if you’re interested in the Internet of Things, you should be—you’ll find this introduction both important and exciting. Wei-Meng makes it all clear for us by explaining the basics.