Advanced Analytics with Transact-SQL
Exploring Hidden Patterns and Rules in Your Data
| Price | $32.55 - $35.30
|
| Rating |  |
| Author | Dejan Sarka |
| Publisher | Apress |
| Published | 2021 |
| Pages | 302 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484271726 |
| ISBN-13 | 9781484271728 |
Learn about business intelligence (BI) features in T-SQL and how they can help you with data science and analytics efforts without the need to bring in other languages such as R and Python. This book shows you how to compute statistical measures using your existing skills in T-SQL. You will learn how to calculate descriptive statistics, including centers, spreads, skewness, and kurtosis of distributions. You will also learn to find associations between pairs of variables, including calculating linear regression formulas and confidence levels with definite integration.
No analysis is good without data quality. Advanced Analytics with Transact-SQL introduces data quality issues and shows you how to check for completeness and accuracy, and measure improvements in data quality over time. The book also explains how to optimize queries involving temporal data, such as when you search for overlapping intervals. More advanced time-oriented information in the book includes hazard and survival analysis. Forecasting with exponential moving averages and autoregression is covered as well.
Every web/retail shop wants to know the products customers tend to buy together. Trying to predict the target discrete or continuous variable with few input variables is important for practically every type of business. This book helps you understand data science and the advanced algorithms use to analyze data, and terms such as data mining, machine learning, and text mining.
Key to many of the solutions in this book are T-SQL window functions. Author Dejan Sarka demonstrates efficient statistical queries that are based on window functions and optimized through algorithms built using mathematical knowledge and creativity. The formulas and usage of those statistical procedures are explained so you can understand and modify the techniques presented.
T-SQL is supported in SQL Server, Azure SQL Database, and in Azure Synapse Analytics. There are so many BI features in T-SQL that it might become your primary analytic database language. If you want to learn how to get information from your data with the T-SQL language that you already are familiar with, then this is the book for you.
- Dejan Sarka (4 books)
Similar Books
Exam Ref 70-761 Querying Data with Transact-SQL 
by Itzik Ben-Gan
Prepare for Microsoft Exam 70-761 - and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA le...
Price: $34.25 | Publisher: Microsoft Press | Release: 2017
Predictive Analytics with Microsoft Azure Machine Learning
by Roger Barga, Valentine Fontama, Wee Hyong Tok
Data Science and Machine Learning are in high demand, as customers are increasingly looking for ways to glean insights from all their data. More customers now realize that Business Intelligence is not enough as the volume, speed and complexity of data now defy traditional analytics tools. While Business Intelligence addresses descriptive ...
Price: $24.59 | Publisher: Apress | Release: 2014
by Mohammed Guller
This book is a step-by-step guide for learning how to use Spark for different types of big-data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. It covers Spark core and its add-on libraries, including Spark SQL, Spark Streaming, GraphX, MLlib, and Spark ML.Big Data Analytics w...
Price: $29.99 | Publisher: Apress | Release: 2016
SQL Server Data Automation Through Frameworks
by Andy Leonard, Kent Bradshaw
Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you've already spent...
Price: $37.99 | Publisher: Apress | Release: 2020
Advanced Data Analytics Using Python, 2nd Edition
by Sayan Mukhopadhyay, Pratip Samanta
Understand advanced data analytics concepts such as time series and principal component analysis with ETL, supervised learning, and PySpark using Python. This book covers architectural patterns in data analytics, text and image classification, optimization techniques, natural language processing, and computer vision in the cloud environme...
Price: $33.88 | Publisher: Apress | Release: 2023
by James Miller
Splunk is the definitive technology solution used to manage the ever-growing volumes of machine-generated data. This technology is indispensable for industries involved in big data analysis, online services, education, finance, healthcare, retail, and telecommunications. So, having Splunk experience will be relevant for a long time to com...
Price: $49.99 | Publisher: Packt Publishing | Release: 2014
In-Memory Analytics with Apache Arrow
by Matthew Topol
Apache Arrow is designed to accelerate analytics and allow the exchange of data across big data systems easily.In-Memory Analytics with Apache Arrow begins with a quick overview of the Apache Arrow format, before moving on to helping you to understand Arrow's versatility and benefits as you walk through a variety of real-world use ca...
Price: $44.99 | Publisher: Packt Publishing | Release: 2022
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
by Paul Turley, Dan Wood
Transact-SQL, or T-SQL, is Microsoft Corporation's powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems (RDBMS).You may already have a basic idea of what SQL is used for, but you may not have a good understanding of...
Price: $21.96 | Publisher: Wrox | Release: 2008