Time Series Analysis in SQL Server
|
Explore ways to work with date and time data in SQL Server for time series analysis
SQL Server has a robust set of tools to prepare, aggregate, and query time series data. This course will show you how to build and work with dates, parse dates from strings (and deal with invalid strings), and format dates for reporting. From there, you will see how SQL Server’s built-in aggregation operators and window functions can solve important business problems like calculating running totals, finding moving averages, and displaying month-over-month differences using realistic sample data sets. You will also see how taking a different perspective on your data can solve difficult problems.
User Reviews
Be the first to review “Time Series Analysis in SQL Server”
Related Products
Intro to SQL
Use SQL to create, access, and update tables of data in a relational database.
Learn SQL: Multiple Tables
Combine data stored across multiple tables using joins, unions, and temporary tables.
Introduction to SQL Server
Learn to use SQL Server to perform common data manipulation tasks and master common data manipulation tasks using this database system.
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.
Data Analyst Interview Preparation
Prepare for data analyst interviews from job postings to technical interviews.
How to Analyze Business Metrics with SQL
Learn how to use SQL to analyze your business metrics and key performance indicators (KPIs).
There are no reviews yet.