KDnuggets

OCTOBER 30, 2019

Also: Highest paid positions in 2019 are DevOps, Data Scientist, Data Engineer (all over $100K) - Stack Overflow Salary Calculator, Updated; A neural net solves the three-body problem 100 million times faster; The Last SQL Guide for Data Analysis You’ll Ever Need; How YouTube is Recommending Your Next Video.

Machine Learning 132

Machine Learning Machine Learning Data Scientist SQL 132

KDnuggets

OCTOBER 9, 2019

Read a comprehensive SQL guide for data analysis; Learn how to choose the right clustering algorithm for your data; Find out how to create a viral DataViz using the data from Data Science Skills poll; Enroll in any of 10 Free Top Notch Natural Language Processing Courses; and more.

Data Analysis 143

Data Analysis Data Analysis SQL Data Science 143

KDnuggets

AUGUST 28, 2019

Most useful SQL features for Data Scientist; Excellent tutorial on creating neural nets from scratch with Numpy; TensorFlow 2.0 highlights, explained; How to sell your boss on Data Analytics; and more.

Data Scientist 129

Data Scientist SQL Analytics Analytics 129

Data Science 101

NOVEMBER 7, 2019

Azure Synapse Analytics can be seen as a merge of Azure SQL Data Warehouse and Azure Data Lake. Synapse allows one to use SQL to query petabytes of data, both relational and non-relational, with amazing speed. Azure Synapse. I think this announcement will have a very large and immediate impact. R Support for Azure Machine Learning.

Data Science 106

Data Science Azure SQL Machine Learning 106

KDnuggets

SEPTEMBER 10, 2019

Also: Top Handy SQL Features for Data Scientists; 12 NLP Researchers, Practitioners & Innovators You Should Be Following; Knowing Your Neighbours: Machine Learning on Graphs.

Data Scientist 194

Data Scientist SQL Machine Learning Machine Learning 194

Data Science Dojo

MAY 3, 2023

Most Data Science enthusiasts know how to write queries and fetch data from SQL but find they may find the concept of indexing to be intimidating. Using the “Top Spotify songs from 2010-2019” dataset on Kaggle ( [link] ), we read it into a Python – Pandas Data Frame.

Python 369

Python Clustering SQL Data Science 369

Data Science 101

NOVEMBER 11, 2019

SQL Server 2019 SQL Server 2019 went Generally Available. 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.

Cloud Data 95

Cloud Data Data Science Azure Clustering 95

KDnuggets

OCTOBER 16, 2019

Also: Kannada-MNIST: A new handwritten digits dataset in ML town; Math for Programmers; The 4 Quadrants of Data Science Skills and 7 Principles for Creating a Viral Data Visualization; The Last SQL Guide for Data Analysis You’ll Ever Need.

Natural Language Processing 157

Natural Language Processing Data Visualization SQL Data Analysis 157

AWS Machine Learning Blog

SEPTEMBER 12, 2024

From a broad perspective, the complete solution can be divided into four distinct steps: text-to-SQL generation, SQL validation, data retrieval, and data summarization. A pre-configured prompt template is used to call the LLM and generate a valid SQL query. The following diagram illustrates this workflow.

SQL 129

SQL AWS AI AI 129

KDnuggets

OCTOBER 9, 2019

Also: 12 things I wish I'd known before starting as a Data Scientist; 10 Free Top Notch Natural Language Processing Courses; The Last SQL Guide for Data Analysis; The 4 Quadrants of #DataScience Skills and 7 Principles for Creating a Viral DataViz.

Natural Language Processing 142

Natural Language Processing Data Scientist SQL Data Analysis 142

KDnuggets

NOVEMBER 8, 2019

Also A European Approach to Master's Degrees in Data Science; How YouTube is Recommending Your Next Video.

Data Scientist 174

Data Scientist Data Analysis Data Analysis Data Science 174

KDnuggets

OCTOBER 21, 2019

Also: The 5 Classification Evaluation Metrics Every Data Scientist Must Know; Artificial Intelligence: Salaries Heading Skyward; Writing Your First Neural Net in Less Than 30 Lines of Code with Keras; How to select rows and columns in Pandas using [ ],loc, iloc,at and.iat; The Last SQL Guide for Data Analysis You'll Ever Need.

Data Scientist 132

Data Scientist SQL Artificial Intelligence Artificial Intelligence 132

Smart Data Collective

APRIL 14, 2020

And that’s remained a consistent trend over the past two years (40% in 2018 and 43% in 2019). 74% of the cohort uses Python, 56% are proficient in R, and 51% have good command of SQL. In terms of popuarity, SQL has grown by 40% since 2019 (36%), thus moving closer to R. Coding Languages. Conclusion.

Data Scientist 113

Data Scientist Data Science SQL Python 113

KDnuggets

AUGUST 21, 2019

Also: For data pros only - An SQL Query walks into a bar and sees two tables; Deep Learning for NLP: Creating a Chatbot with Keras!; 12 NLP Researchers, Practitioners & Innovators You Should Be Following; Wanting to be even more marketable as a data scientist? Check out these trends in the skills employers are looking for today.

Deep Learning 129

Deep Learning Deep Learning Data Scientist SQL 129

KDnuggets

OCTOBER 7, 2019

Also: How AI will transform healthcare (and can it fix the US healthcare system?); Choosing the Right Clustering Algorithm for your Dataset; DeepMind Has Quietly Open Sourced Three New Impressive Reinforcement Learning Frameworks; A European Approach to Masters Degrees in Data Science; The Future of Analytics and Data Science.

Data Analysis 144

Data Analysis Data Analysis Data Science Clustering 144

AWS Machine Learning Blog

MARCH 14, 2024

We formulated a text-to-SQL approach where by a user’s natural language query is converted to a SQL statement using an LLM. The SQL is run by Amazon Athena to return the relevant data. Our final solution is a combination of these text-to-SQL and text-RAG approaches. The following table contains some example responses.

SQL 133

SQL AWS AI AI 133

Data Science 101

MAY 6, 2019

He asks, “How important is SQL in comparison to Python in 2019?”. That’s an interesting question because I think people love putting SQL on this mega pedestal as like a core thing that all data scientists have to use. However, you have to know SQL. So, the question is: what’s important in 2019?

Data Wrangling 98

Data Wrangling Data Scientist SQL Data Science 98

KDnuggets

OCTOBER 14, 2019

Also: Activation maps for deep learning models in a few lines of code; The 4 Quadrants of Data Science Skills and 7 Principles for Creating a Viral Data Visualization; OpenAI Tried to Train AI Agents to Play Hide-And-Seek but Instead They Were Shocked by What They Learned; 10 Great Python Resources for Aspiring Data Scientists.

Natural Language Processing 137

Natural Language Processing Deep Learning Deep Learning Data Analysis 137

ML Review

DECEMBER 16, 2019

Let’s check out the goodies brought by NeurIPS 2019 and co-located events! Balažević et al (creators of TuckER model from EMNLP 2019 ) apply hyperbolic geometry to knowledge graph embeddings in their Multi-Relational Poincaré model ( MuRP ). Graphs were well represented at the conference. Thank you for reading!

Machine Learning 52

Machine Learning Machine Learning Algorithm Database 52

Data Science Blog

NOVEMBER 15, 2023

Example Event Log for Process Mining The following example SQL-query is inserting Event-Activities from a SAP ERP System into an existing event log database table. van der Aalst 2019 and as a product feature term by Celonis in 2022 and is used extensively in marketing, this concept is far from new in its implementation.

Data Modeling 245

Data Modeling Data Models Business Intelligence Business Intelligence 245

KDnuggets

AUGUST 26, 2019

Also: Deep Learning for NLP: Creating a Chatbot with Keras!; Understanding Decision Trees for Classification in Python; How to Become More Marketable as a Data Scientist; Is Kaggle Learn a Faster Data Science Education?

Data Scientist 130

Data Scientist Decision Trees Deep Learning Deep Learning 130

Smart Data Collective

JULY 24, 2019

Now more than ever, cases of cross-site scripting, SQL injection attacks, and Distributed Denial-of-Service attacks are prevalent. However, these tools won’t be able to prevent SQL injection, XSS attacks, or web session hijacking if the web apps are susceptible to these kinds of attacks. They can use big data for better security.

Big Data 92

Big Data Big Data SQL AI 92

Tableau

DECEMBER 1, 2021

The Salesforce purchase in 2019. The Salesforce acquisition in August 2019 ended the Tableau board and the last formal Tableau roles for Chris, Pat, and Christian. Query allowed customers from a broad range of industries to connect to clean useful data found in SQL and Cube databases. Feb 2019) and Explain Data in Tableau 2019.3

Tableau 145

Tableau ML ML Database 145

IBM Journey to AI blog

JANUARY 10, 2023

This data will be analyzed using Netezza SQL and Python code to determine if the flight delays for the first half of 2022 have increased over flight delays compared to earlier periods of time within the current data (January 2019 – December 2021). Figure 5 – Bar graph of current flight delay data (2019 – June 2022).

Data Warehouse 52

Data Warehouse Data Analysis Data Analysis SQL 52

IBM Journey to AI blog

APRIL 13, 2023

Someone with the knowledge of SQL and access to a Db2 instance, where the in-database ML feature is enabled, can easily learn to build and use a machine learning model in the database. Creating a Db2 table I use the following SQL for creating a table for storing the dataset. In the enterprise, SQL is a more common skill than ML.

Decision Trees 105

Decision Trees ML ML Database 105

Smart Data Collective

OCTOBER 14, 2019

In September 2019, Google decided to make it’s Differential Privacy Library available as an open-source tool. Users only need to include the respective path in the SQL query to get to work. It allows secure and interactive SQL analytics at the petabyte scale.

Data Science 93

Data Science SQL Big Data Big Data 93

Towards AI

APRIL 19, 2024

PwC 👉Industry domain: AI, Professional services, Business intelligence, Consulting, Cybersecurity, Generative AI 👉Location: 73 offices 👉Year founded: 1998 👉Programming Languages Deployed: Java, Google Cloud, Microsoft SQL, jQuery, Pandas, R, Oracle 👉Benefits: Hybrid workspace, Child care and parental leave, flexible (..)

AI 110

AI AI Artificial Intelligence Artificial Intelligence 110

Data Science Dojo

OCTOBER 10, 2023

Building bridges : Think of a young developer who attended an AI conference back in 2019. 360 Topics: The event will delve into a wide range of topics including SQL Server, Visual Studio, Artificial Intelligence, DevOps,NET, and more, providing insights into Microsoft Tech and IT. Link to event -> Live!

AI 243

AI AI Data Observability Artificial Intelligence 243

phData

JUNE 8, 2023

Enter Power BI Report Builder, a tool that was released by Microsoft in 2019 that enables users to design and create paginated reports and then share them via Power BI service. The data sources with a “*” indicate that they require a Power BI gateway in order to access and share reports on the Power BI service.

Power BI 90

Power BI SQL Azure Database 90

Smart Data Collective

JANUARY 24, 2020

The most vital aspect of automating power bi DevOps is to understand the main pillars in the SQL DevOps cycle. In 2019, expect a seismic shift from CI pipelines to DevOps assembly lines. Better inventory management with tracking and logging systems would be other instances of automation in action.

Power BI 120

Power BI Business Intelligence SQL Business Intelligence 120

ODSC - Open Data Science

FEBRUARY 17, 2023

BERT is still very popular over the past few years and even though the last update from Google was in late 2019 it is still widely deployed. Knowing some SQL is also essential. NLP Programming Languages It shouldn’t be a surprise that Python has a strong lead as a programming language of choice for NLP.

Deep Learning 111

Deep Learning Deep Learning Data Science Natural Language Processing 111

Tableau

DECEMBER 1, 2021

The Salesforce purchase in 2019. The Salesforce acquisition in August 2019 ended the Tableau board and the last formal Tableau roles for Chris, Pat, and Christian. Query allowed customers from a broad range of industries to connect to clean useful data found in SQL and Cube databases. Feb 2019) and Explain Data in Tableau 2019.3

Tableau 98

Tableau ML ML Database 98

AWS Machine Learning Blog

NOVEMBER 1, 2024

These tasks include summarization, classification, information retrieval, open-book Q&A, and custom language generation such as SQL. Fine-tuning Anthropic’s Claude 3 Haiku has demonstrated superior performance compared to few-shot prompt engineering on base Anthropic’s Claude 3 Haiku, Anthropic’s Claude 3 Sonnet, and Anthropic’s Claude 3.5

Data Preparation 98

Data Preparation Machine Learning Machine Learning ML 98

DagsHub

DECEMBER 11, 2023

Dolt Created in 2019, Dolt is an open-source tool for managing SQL databases that uses version control similar to Git. It versions tables instead of files and has a SQL query interface for those tables. DVC lacks crucial relational database features, making it an unsuitable choice for those familiar with relational databases.

Machine Learning 98

Machine Learning Machine Learning Data Lakes Data Science 98

Dataconomy

SEPTEMBER 27, 2024

This experience has led to my first real IT job ― an internship at Renault in 2019. It helped me to become familiar with popular tools such as Excel and SQL and to develop my analytical thinking. It was my first job as a data analyst.

Analytics 113

Analytics Analytics Big Data Big Data 113

AWS Machine Learning Blog

SEPTEMBER 19, 2023

2019| Used| 32675 |40990.00| NA| 1686627154| | 5| Acura TLX A-Spec| 2023| New| NA|50195.00|50195| Define the aggregate() function to aggregate the data using PySpark SQL and user-defined functions (UDFs). 50195| 1686627154| | 6| Acura TLX A-Spec| 2023| New| NA|50195.00|50195| 2023| New| NA|36895.00|36895| Group by model_year_status.

ML 126

ML ML AWS SQL 126

phData

MAY 25, 2023

The December 2019 release of Power BI Desktop introduced a native Snowflake connector that supported SSO and did not require driver installation. The June 2021 release of Power BI Desktop introduced Custom SQL queries to Snowflake in DirectQuery mode. In late 2021, Power BI introduced custom SQL queries to Snowflake using DirectQuery.

Power BI 84

Power BI Analytics Analytics Azure 84