-
Introduction to Snowflake
By:
Rod Paddock
Last updated: Wednesday, November 22, 2023
Published in: CODE Magazine: 2023 - March/April
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
By:
Helen Wall
Last updated: Wednesday, August 31, 2022
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.
-
The Secrets of Manipulating CSV Files
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2022 - January/February
Rod shows you how CSV is anything but old news.
-
Data Structures and Algorithms
By:
Sahil Malik
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - November/December
Sahil collects his favorite tools and tells you why they should be your favorites too.
-
Power BI and R: A Visual Power Punch
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - July/August
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
By:
Kevin Goff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - September/October
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
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:
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.
-
Azure Machine Learning Workspace and MLOps
By:
Last updated: Wednesday, March 17, 2021
Published in: CODE Magazine: 2019 - September/October
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
By:
Last updated: Friday, April 23, 2021
Published in: CODE Magazine: 2018 - May/June
When it’s time to wire your house to precipitate your every whim or need, you want to be sure that your robot doesn’t mistake “catsup” for “catnip.” Sahil talks about facial recognition and how it’s connected to speech and understanding.
-
Introduction to the R Programming Language
By:
Wei-Meng Lee
Last updated: Friday, April 30, 2021
Published in: CODE Magazine: 2018 - March/April
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
By:
Mike Yeager
Last updated: Tuesday, May 18, 2021
Published in: CODE Magazine: 2017 - July/August
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
By:
Rachel Reese
Last updated: Thursday, May 27, 2021
Published in: CODE Magazine: 2017 - January/February
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2016 - November/December
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.
- Home
Articles filed in category 'Data Science'