#### PostgreSQL Summary Stats and Window Functions

Learn how to create queries for *analytics* and *data* engineering with window functions, the SQL secret weapon!

138 results
for "data analytics"

Learn how to create queries for *analytics* and *data* engineering with window functions, the SQL secret weapon!

4 hours
Data Manipulation
Fernando Gonzalez Prada
Course

Learn how to prepare and organize your *data* for predictive *analytics*.

4 hours
Machine Learning
Nele Verbiest
Course

Use a rich baseball dataset from the MLB's Statcast system to practice your *data* exploration skills.

4 hours
Case Studies
Brian M. Mills
Course

Learn to predict labels of nodes in networks using network learning and by extracting descriptive features from the network

4 hours
Probability & Statistics
Bart Baesens
Course

Manipulate, visualize, and perform statistical tests on HR *data*.

5 hours
Case Studies
Ben Teusch
Course

Learn to acquire *data* from common file formats and systems such as CSV files, spreadsheets, JSON, SQL databases, and APIs.

4 hours
Importing & Cleaning Data
Amany Mahfouz
Course

Learn to manipulate and analyze flexibly structured *data* with MongoDB.

4 hours
Data Manipulation
Donny Winston
Course

Analyze text *data* in R using the tidy framework.

4 hours
Data Manipulation
Marc Dotson
Course

Leverage the power of Python and PuLP to optimize supply chains.

4 hours
Machine Learning
Aaren Stubberfield
Course

Learn how to use Python to analyze customer churn and build a model to predict it.

4 hours
Case Studies
Mark Peterson
Course

Learn how to use Python to create, run, and analyze A/B tests to make proactive business decisions.

4 hours
Probability & Statistics
Ryan Grossman
Course

Learn how to ensure clean *data* entry and build dynamic dashboards to display your marketing *data*.

4 hours
Case Studies
Luke Pajer
Course

In this course you'll learn how to apply machine learning in the HR domain.

4 hours
Machine Learning
Hrant Davtyan
Course

Learn how to analyze business processes in R and extract actionable insights from enormous sets of event *data*.

4 hours
Probability & Statistics
Gert Janssenswillen
Course

Predict employee turnover and design retention strategies.

4 hours
Case Studies
Anurag Gupta
Course

Learn all about modularity, documentation, & automated testing to help you solve *Data* Science problems quicker and more reliably.

4 hours
Programming
Adam Spannbauer
Course

In this course you'll learn how to use *data* science for several common marketing tasks.

4 hours
Machine Learning
Verena Pflieger
Course

Learn to detect fraud with *analytics* in R.

4 hours
Machine Learning
Bart Baesens
Course

Bash scripting allows you to build *analytics* pipelines in the cloud and work with *data* stored across multiple files.

4 hours
Programming
Alex Scriven
Course

Get started with Tableau, a widely used business intelligence (BI) and *analytics* software to explore, visualize, and securely share *data*.

4 hours
Data Visualization
Hadrien Lacroix
Course

Analyze time series graphs, use bipartite graphs, and gain the skills to tackle advanced problems in network *analytics*.

4 hours
Probability & Statistics
Eric Ma
Course

Learn how to segment customers in Python.

4 hours
Machine Learning
Karolis Urbonas
Course

Learn how to detect fraud using Python.

4 hours
Machine Learning
Charlotte Werger
Course

Learn how to analyze a SQL table and report insights to management.

4 hours
Case Studies
Bart Baesens
Course

Learn how to take the Python workflows you currently have and easily scale them up to large datasets without the need for distributed computing environments.

4 hours
Data Manipulation
Team Anaconda
Course

Learn how to analyze *data* in Excel.

4 hours
Data Manipulation
Jen Bricker
Course

Learn how to analyze *data* with spreadsheets using functions such as SUM(), AVERAGE(), and VLOOKUP().

3 hours
Programming
Vincent Vankrunkelsven
Course

Learn how to explore, visualize, and extract insights from *data*.

4 hours
Case Studies
Allen Downey
Course

Learn how to use graphical and numerical techniques to begin uncovering the structure of your *data*.

4 hours
Probability & Statistics
Andrew Bray
Course

Learn how to explore what's available in a database: the tables, relationships between them, and *data* stored in them.

4 hours
Data Manipulation
Christina Maimone
Course

Use *data* manipulation and visualization skills to explore the historical voting of the United Nations General Assembly.

4 hours
Case Studies
David Robinson
Course

Learn what Bayesian *data* *analysis* is, how it works, and why it is a useful tool to have in your *data* science toolbox.

4 hours
Probability & Statistics
Rasmus BÃ¥Ã¥th
Course

Master the basics of *data* *analysis* in Python. Expand your skillset by learning scientific computing with numpy.

4 hours
Programming
Hugo Bowne-Anderson
Course

Master the basics of *data* *analysis* by manipulating common *data* structures such as vectors, matrices, and *data* frames.

4 hours
Programming
Jonathan Cornelissen
Course

In this course you'll learn about basic experimental design, a crucial part of any *data* *analysis*.

4 hours
Probability & Statistics
kaelen medeiros
Course

In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for *data* *analysis*.

4 hours
Programming
Ginger Grant
Course

Learn how to describe relationships between two numerical quantities and characterize these relationships graphically.

4 hours
Probability & Statistics
Ben Baumer
Course

Learn to visualize multivariate datasets using lattice graphics.

4 hours
Data Visualization
Deepayan Sarkar
Course

Learn how to analyze huge datasets using Apache Spark and R using the sparklyr package.

4 hours
Programming
Richie Cotton
Course

Make it easy to visualise, explore, and impute missing *data* with naniar, a tidyverse friendly approach to missing *data*.

4 hours
Importing & Cleaning Data
Nicholas Tierney
Course

Learn rbokeh: a visualization library for interactive web-based plots.

4 hours
Data Visualization
Omayma Said
Course

Learn to write faster R code, discover benchmarking and profiling, and unlock the secrets of parallel programming.

4 hours
Programming
Colin Gillespie
Course

Learn the basics of spreadsheets by working with rows, columns, addresses, and ranges.

2 hours
Programming
Vincent Vankrunkelsven
Course

Leverage the power of tidyverse tools to create publication-quality graphics and custom-styled reports that communicate your results.

4 hours
Data Visualization
Timo Grossenbacher
Course

This course will show you how to combine and merge datasets with *data*.table.

4 hours
Data Manipulation
Scott Ritchie
Course

Use the worldâ€™s most popular Python *data* science package to manipulate *data* and calculate summary statistics.

4 hours
Data Manipulation
Richie Cotton
Course

Learn R for *data* science by wrangling, visualizing, and modeling political *data* like polls and election results.

4 hours
Case Studies
G Elliott Morris
Course

Master SQL Server programming by learning to create, update, and execute functions and stored procedures.

4 hours
Programming
Meghan Kwartler
Course

Learn powerful command-line skills to download, process, and transform *data*, including machine learning pipeline.

4 hours
Data Manipulation
Susan Sun
Course

Build the foundation you need to think statistically and to speak the language of your *data*.

3 hours
Probability & Statistics
Justin Bois
Course

Build a binary classifier to predict if a blood donor is likely to donate again.

45 minutes
Data Manipulation, Machine Learning...
Dimitri Denisjonok
Project

Analyze health survey *data* to determine how BMI is associated with physical activity and smoking.

45 minutes
Data Manipulation, Probability & Statistics...
Jessica Minnier
Project

Use MLB's Statcast *data* to compare New York Yankees sluggers Aaron Judge and Giancarlo Stanton.

45 minutes
Data Manipulation, Data Visualization...
David Venturi
Project

Use R to make art and create imaginary flowers inspired by nature.

45 minutes
Data Visualization, Case Studies
Antonio SÃ¡nchez ChinchÃ³n
Project

If you've never done a DataCamp project, this is the place to start!

45 minutes
Data Manipulation, Data Visualization...
David Venturi
Project

If you've never done a DataCamp project, this is the place to start!

30 minutes
Data Visualization, Case Studies
Rasmus BÃ¥Ã¥th
Project

If you have never done a DataCamp project, this is the place to start!

30 minutes
Data Visualization, Case Studies
Rasmus BÃ¥Ã¥th
Project

Use your logistic regression skills to protect people from becoming zombies!

45 minutes
Data Manipulation, Data Visualization...
Jenine Harris
Project

Use pandas and Bayesian statistics to see if left-handed people actually die earlier than righties.

45 minutes
Data Manipulation, Data Visualization...
Madeleine Bonsma-Fisher
Project

Use cluster *analysis* to glean insights into cryptocurrency gambling behavior.

45 minutes
Data Manipulation, Data Visualization...
Eric Hare
Project

Apply hierarchical and mixed-effect models to analyze Maryland crime rates.

45 minutes
Data Manipulation, Data Visualization...
Richard Erickson
Project

Apply text mining to Donald Trump's tweets to confirm if he writes the (angrier) Android half.

45 minutes
Data Manipulation, Data Visualization...
David Robinson
Project

Learn to analyze Twitter *data* and do a deep dive into a hot trend.

45 minutes
Data Manipulation, Data Visualization...
Samia Khalid
Project

Analyze the dialog and IMDB ratings of 287 South Park episodes. Warning: contains explicit language.

45 minutes
Data Manipulation, Data Visualization...
Patrik DrhlÃk
Project

Play bank *data* scientist and use regression discontinuity to see which debts are worth collecting.

45 minutes
Data Manipulation, Data Visualization...
Howard Friedman
Project

Load, clean, and visualize scraped Google Play Store *data* to understand the Android app market.

45 minutes
Data Manipulation, Data Visualization...
Lavanya Gupta
Project

Scrape news headlines for FB and TSLA then apply sentiment *analysis* to generate investment insight.

45 minutes
Data Manipulation, Data Visualization...
Juan GonzÃ¡lez-Vallinas
Project

Explore the salary potential of college majors with a k-means cluster *analysis*.

45 minutes
Data Manipulation, Data Visualization...
Jaclyn Burge
Project

Discover how the US bond yields behave using descriptive statistics and advanced modeling.

45 minutes
Data Visualization, Applied Finance
JÃ³zsef SoltÃ©sz
Project

Apply unsupervised learning techniques to help plan an education program in Argentina.

45 minutes
Data Manipulation, Data Visualization...
Rafael La Buonora
Project

Write functions to forecast time series of food prices in Rwanda.

45 minutes
Data Manipulation, Data Visualization...
Richie Cotton
Project

Examine the network of connections among local health departments in the United States.

60 minutes
Data Manipulation, Data Visualization...
Jenine Harris
Project

Recreate John Snow's famous map of the 1854 cholera outbreak in London.

60 minutes
Data Manipulation, Data Visualization...
Radovan Kavicky
Project