Data Science 101

NOVEMBER 11, 2019

Azure Synapse Analytics This is the future of data warehousing. It combines data warehousing and data lakes into a simple query interface for a simple and fast analytics service. SQL Server 2019 SQL Server 2019 went Generally Available. Amazon Web Services.

Cloud Data 95

Cloud Data Data Science Azure Clustering 95

Flipboard

DECEMBER 18, 2023

He highlights innovations in data, infrastructure, and artificial intelligence and machine learning that are helping AWS customers achieve their goals faster, mine untapped potential, and create a better future. Learn more about the AWS zero-ETL future with newly launched AWS databases integrations with Amazon Redshift.

AWS 135

AWS Data Warehouse ETL SQL 135

ODSC - Open Data Science

SEPTEMBER 29, 2023

Data management problems can also lead to data silos; disparate collections of databases that don’t communicate with each other, leading to flawed analysis based on incomplete or incorrect datasets. One way to address this is to implement a data lake: a large and complex database of diverse datasets all stored in their original format.

Data Lakes 52

Data Lakes Clustering Big Data Big Data 52

Flipboard

DECEMBER 6, 2023

In this post, we discuss a Q&A bot use case that Q4 has implemented, the challenges that numerical and structured datasets presented, and how Q4 concluded that using SQL may be a viable solution. RAG with semantic search – Conventional RAG with semantic search was the last step before moving to SQL generation.

SQL 166

SQL Database AWS Machine Learning 166

ODSC - Open Data Science

OCTOBER 13, 2024

Be sure to check out her talk, “ Don’t Go Over the Deep End: Building an Effective OSS Management Layer for Your Data Lake ,” there! Managing a data lake can often feel like being lost at sea — especially when dealing with both structured and unstructured data.

Data Lakes 40

Data Lakes Database Data Pipeline SQL 40

IBM Journey to AI blog

APRIL 24, 2023

By running reports on historical data, a data warehouse can clarify what systems and processes are working and what methods need improvement. Data warehouse is the base architecture for artificial intelligence and machine learning (AI/ML) solutions as well.

Data Warehouse 112

Data Warehouse Data Lakes Database Big Data 112

AWS Machine Learning Blog

SEPTEMBER 27, 2024

Specifically, we cover the computer vision and artificial intelligence (AI) techniques used to combine datasets into a list of prioritized tasks for field teams to investigate and mitigate. The resulting dashboard highlighted that 141 power pole assets required action, out of a network of 57,230 poles.

AWS 122

AWS Data Lakes ML ML 122

AWS Machine Learning Blog

DECEMBER 11, 2024

With an Amazon Q custom plugin that uses an internal library used for natural language to SQL (NL2SQL), the same that powers generative SQL capabilities across some AWS database services like Amazon Redshift, we will provide the ability to aggregate and slice-and-dice the opportunity pipeline and trends in product consumption conversationally.

AWS 103

AWS Database AI AI 103

ODSC - Open Data Science

SEPTEMBER 12, 2023

Although setting up a database to run your analyses may seem like an arduous task, modern open-source time series databases can provide significant benefits to any scientist running time series analysis on a large data set — and with much less effort than you might imagine.

Data Scientist 97

Data Scientist Database Data Lakes Data Science 97

IBM Journey to AI blog

SEPTEMBER 25, 2023

Every day, millions of riders use the Uber app, unwittingly contributing to a complex web of data-driven decisions. This blog takes you on a journey into the world of Uber’s analytics and the critical role that Presto, the open source SQL query engine, plays in driving their success. What is Presto?

Data Lakes 102

Data Lakes Analytics Analytics Clustering 102

AWS Machine Learning Blog

JUNE 13, 2023

The natural language capabilities allow non-technical users to query data through conversational English rather than complex SQL. The AI and language models must identify the appropriate data sources, generate effective SQL queries, and produce coherent responses with embedded results at scale.

Database 93

Database SQL AWS AI 93

ODSC - Open Data Science

JULY 27, 2023

Choosing a Data Lake Format: What to Actually Look For The differences between many data lake products today might not matter as much as you think. When choosing a data lake, here’s something else to consider. When choosing a data lake, here’s something else to consider.

Data Lakes 52

Data Lakes SQL AI AI 52

Snorkel AI

MAY 26, 2023

[link] Ahmad Khan, head of artificial intelligence and machine learning strategy at Snowflake gave a presentation entitled “Scalable SQL + Python ML Pipelines in the Cloud” about his company’s Snowpark service at Snorkel AI’s Future of Data-Centric AI virtual conference in August 2022. Welcome everybody.

SQL 52

SQL ML ML Python 52

Snorkel AI

MAY 26, 2023

[link] Ahmad Khan, head of artificial intelligence and machine learning strategy at Snowflake gave a presentation entitled “Scalable SQL + Python ML Pipelines in the Cloud” about his company’s Snowpark service at Snorkel AI’s Future of Data-Centric AI virtual conference in August 2022. Welcome everybody.

SQL 52

SQL ML ML Python 52

AWS Machine Learning Blog

AUGUST 21, 2023

You can streamline the process of feature engineering and data preparation with SageMaker Data Wrangler and finish each stage of the data preparation workflow (including data selection, purification, exploration, visualization, and processing at scale) within a single visual interface.

AWS 97

AWS Data Lakes Clustering Data Preparation 97

AWS Machine Learning Blog

FEBRUARY 21, 2025

Data exploration and model development were conducted using well-known machine learning (ML) tools such as Jupyter or Apache Zeppelin notebooks. Apache Hive was used to provide a tabular interface to data stored in HDFS, and to integrate with Apache Spark SQL. This also led to a backlog of data that needed to be ingested.

Data Science 74

Data Science AWS Hadoop Data Scientist 74

Flipboard

JUNE 26, 2023

Companies are faced with the daunting task of ingesting all this data, cleansing it, and using it to provide outstanding customer experience. Typically, companies ingest data from multiple sources into their data lake to derive valuable insights from the data.

AWS 123

AWS ML ML ETL 123

ODSC - Open Data Science

FEBRUARY 2, 2023

Computer Science and Computer Engineering Similar to knowing statistics and math, a data scientist should know the fundamentals of computer science as well. While knowing Python, R, and SQL are expected, you’ll need to go beyond that. Big Data As datasets become larger and more complex, knowing how to work with them will be key.

Data Science 98

Data Science Data Scientist Computer Science Computer Science 98

ODSC - Open Data Science

FEBRUARY 24, 2023

With Great Expectations , data teams can express what they “expect” from their data using simple assertions. Great Expectations provides support for different data backends such as flat file formats, SQL databases, Pandas dataframes and Sparks, and comes with built-in notification and data documentation functionality.

Exploratory Data Analysis 126

Exploratory Data Analysis Data Visualization Data Analysis Data Analysis 126

IBM Journey to AI blog

AUGUST 4, 2023

It’s distributed both in the cloud and on-premises, allowing extensive use and movement across clouds, apps and networks, as well as stores of data at rest. An architecture designed for data democratization aims to be flexible, integrated, agile and secure to enable the use of data and artificial intelligence (AI) at scale.

Data Lakes 73

Data Lakes AI AI Data Governance 73

IBM Journey to AI blog

SEPTEMBER 19, 2023

Overview: Data science vs data analytics Think of data science as the overarching umbrella that covers a wide range of tasks performed to find patterns in large datasets, structure data for use, train machine learning models and develop artificial intelligence (AI) applications.

Data Science 94

Data Science Analytics Analytics Data Scientist 94

IBM Journey to AI blog

JANUARY 18, 2023

In another decade, the internet and mobile started the generate data of unforeseen volume, variety and velocity. It required a different data platform solution. Hence, Data Lake emerged, which handles unstructured and structured data with huge volume. All phases of the data-information lifecycle.

Data Lakes 52

Data Lakes Data Warehouse Azure Apache Hadoop 52

ODSC - Open Data Science

AUGUST 24, 2023

Start Learning AI With the ODSC West Data Primer Series In this six-part series as part of the ODSC West mini-bootcamp, you’ll learn everything you need to know to get started with AI, including SQL, machine learning, and even LLMs. In addition, we’ll discuss a variety of tools that form the modern LLM application development stack.

Data Lakes 52

Data Lakes Data Science Machine Learning Machine Learning 52

ODSC - Open Data Science

MARCH 30, 2023

5 Reasons Why SQL is Still the Most Accessible Language for New Data Scientists Between its ability to perform data analysis and ease-of-use, here are 5 reasons why SQL is still ideal for new data scientists to get into the field. Check a few of them out here.

Azure 52

Azure ML ML Data Modeling 52

AWS Machine Learning Blog

NOVEMBER 27, 2023

Configure the following scopes on your connected app: Manage user data via APIs ( api ). Perform ANSI SQL queries on Salesforce Data Cloud data (Data Cloud_query_api ). Manage Data Cloud profile data ( Data Cloud_profile_api ). Drag and drop the file, then choose Edit in SQL.

ML 95

ML ML AWS SQL 95

AWS Machine Learning Blog

MAY 31, 2024

This means that individuals can ask companies to erase their personal data from their systems and from the systems of any third parties with whom the data was shared. Select the uploaded file and from Actions dropdown and choose the Query with S3 Select option to query the.csv data using SQL if the data was loaded correctly.

AWS 132

AWS Machine Learning Machine Learning Database 132

Alation

JULY 18, 2022

A simple model to control access to data via a UI or SQL. Automatically tracking data lineage across queries executed in any language. To ensure you can deliver on this world-changing vision of data, Alation helps you maximize the value of your data lake with integrations to the Unity catalog. and much more!

AI 52

AI AI Data Lakes Azure 52

AWS Machine Learning Blog

APRIL 18, 2023

With the recently launched Amazon Monitron Kinesis data export v2 feature , your OT team can stream incoming measurement data and inference results from Amazon Monitron via Amazon Kinesis to AWS Simple Storage Service (Amazon S3) to build an Internet of Things (IoT) data lake. The latest version of Firefox or Chrome.

AWS 85

AWS ML ML Database 85

ODSC - Open Data Science

APRIL 3, 2023

Data analysts often must go out and find their data, process it, clean it, and get it ready for analysis. This pushes into Big Data as well, as many companies now have significant amounts of data and large data lakes that need analyzing. Cloud Services: Google Cloud Platform, AWS, Azure.

Analytics 52

Analytics Analytics Data Analyst Data Science 52

AWS Machine Learning Blog

JUNE 25, 2024

Amazon Bedrock , a fully managed service designed to facilitate the integration of LLMs into enterprise applications, offers a choice of high-performing LLMs from leading artificial intelligence (AI) companies like Anthropic, Mistral AI, Meta, and Amazon through a single API. The Step Functions workflow starts.

AWS 127

AWS Natural Language Processing Machine Learning Machine Learning 127

IBM Journey to AI blog

JULY 17, 2023

Watsonx.data is built on 3 core integrated components: multiple query engines, a catalog that keeps track of metadata, and storage and relational data sources which the query engines directly access.

AI 74

AI AI Machine Learning Machine Learning 74

IBM Journey to AI blog

OCTOBER 15, 2024

IBM watsonx.data is a hybrid, governed data lake house optimized for data, analytics and AI workloads. Additionally, watsonx.data provides a flexible approach and a unified view of your data across hybrid cloud environments. Key highlights include driving business analytics with engines like Presto and Spark.

AWS 45

AWS EDA Data Lakes Database 45

IBM Journey to AI blog

JUNE 11, 2024

and IBM AIOps (artificial intelligence for IT operations) solutions to plan, design and execute end-to-end migration and modernization journey. Generative AI-powered discovery as a service : Helps extracting key data elements from client data repositories and fast-track the application discovery process.

AWS 85

AWS AI AI Data Lakes 85

ODSC - Open Data Science

APRIL 24, 2023

To cluster the data we have to calculate distances between IPs — The number of all possible IP pairs is very large, and we had to solve the scale problem. Data Processing and Clustering Our data is stored in a Data Lake and we used PrestoDB as a query engine. AS ip_1, r.ip AND l.ip < r.ip

Clustering 52

Clustering SQL Algorithm Data Science 52

IBM Journey to AI blog

MARCH 14, 2024

Businesses face significant hurdles when preparing data for artificial intelligence (AI) applications. The existence of data silos and duplication, alongside apprehensions regarding data quality, presents a multifaceted environment for organizations to manage.

AWS 93

AWS Database ETL AI 93

ODSC - Open Data Science

JULY 22, 2023

We had bigger sessions on getting started with machine learning or SQL, up to advanced topics in NLP, and how to make deepfakes. Here are some highlights from ODSC Europe 2023, including some pictures of speakers and attendees, popular talks, and a summary of what kept people busy.

Apache Kafka 52

Apache Kafka Machine Learning Machine Learning Data Science 52

ODSC - Open Data Science

JUNE 12, 2023

Power BI Datamarts provide no-code/low-code datamart capabilities using Azure SQL Database technology in the background. The Power BI Datamarts support sensitivity labels, endorsement, discovery, and Row-Level Security ( RLS ), which help protect and manage the data according to the business requirements and compliance needs.

Power BI 52

Power BI Data Warehouse ETL Data Preparation 52