Welcome to this project-based course Introduction to SQL Window Functions. This is a hands-on project that introduces SQL users to the world of window functions. In this project, you will learn how to explore and query the project-db database extensively. We will start this hands-on project by retrieving the data in the table in the database. By the end of this … [Read more...] about Introduction to SQL Window Functions
Data Analysis
Routines in SQL: Stored procedures in SQL Server
Have you thought about creating a query that can be called several times to perform a routine task? Stored procedures offer this with a great advantage of efficiency. This project-based course, "Routines in SQL: Working with stored procedures in MS SQL Server" is intended for intermediate SQL users with some related experiences with SQL and who are willing to advance their … [Read more...] about Routines in SQL: Stored procedures in SQL Server
PySpark Foundations: Process, analyze, and summarize data
Did you know that a billion records are processed daily in PySpark by companies worldwide? As big data is on the rise, you’ll need tools like PySpark to process massive amounts of data. This guided project was designed to introduce data analysts and data science beginners to data analysis in PySpark. By the end of this 2-hour-long guided project, you’ll create a Jupyter … [Read more...] about PySpark Foundations: Process, analyze, and summarize data
Business Intelligence con la Product Suite di Tableau
Questo corso è rivolto a tutti coloro che hanno maturato una conoscenza solida di Tableau. Dopo aver imparato a analizzare dati e costruire visualizzazioni è arrivato il momento di approfondire la conoscenza della Business Intelligence (BI) e andare oltre Tableau. La week 1 è dedicata alle Dashboard e alle Story. Una volta create le visualizzazioni di dati, imparerai come … [Read more...] about Business Intelligence con la Product Suite di Tableau
Data Science Project Capstone: Predicting Bicycle Rental
This course is the seventh of eight. In this project, we will tackle a prediction problem: forecasting the number of bicycles that will be rented on a given day. Using historical data, we will consider factors such as weather conditions, the day of the week, and other relevant variables to accurately predict daily bicycle rentals. This will help ensure that our bicycle rental … [Read more...] about Data Science Project Capstone: Predicting Bicycle Rental
