Advanced Analytics with Transact-SQL

Exploring Hidden Patterns and Rules in Your Data



Bookstore > Books > Advanced Analytics with Transact-SQL

Price$32.55 - $35.30
Rating
AuthorDejan Sarka
PublisherApress
Published2021
Pages302
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484271726
ISBN-139781484271728
EBook Hardcover Paperback

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.


  1. (4 books)



Similar Books


Exam Ref 70-761 Querying Data with Transact-SQL

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:  $31.99  |  Publisher:  Microsoft Press  |  Release:  2017

Big Data Analytics with Spark

Big Data Analytics with Spark

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

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:  $31.40  |  Publisher:  Apress  |  Release:  2020

Mastering Splunk

Mastering Splunk

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:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2014

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

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

Derivatives Analytics with Python

Derivatives Analytics with Python

by Yves Hilpisch

Derivatives Analytics with Python shows you how to implement market-consistent valuation and hedging approaches using advanced financial models, efficient numerical techniques, and the powerful capabilities of the Python programming language. This unique guide offers detailed explanations of all theory, methods, and processes, giving you ...

Price:  $65.85  |  Publisher:  Wiley  |  Release:  2015

Text Analytics with Python

Text Analytics with Python

by Dipanjan Sarkar

Derive useful insights from your data using Python. You will learn both basic and advanced concepts, including text and language syntax, structure, and semantics. You will focus on algorithms and techniques, such as text classification, clustering, topic modeling, and text summarization.Text Analytics with Python teaches you the technique...

Price:  $18.99  |  Publisher:  Apress  |  Release:  2016

Understanding Azure Data Factory

Understanding Azure Data Factory

by Sudhir Rawat, Abhishek Narain

Improve your analytics and data platform to solve major challenges, including operationalizing big data and advanced analytics workloads on Azure. You will learn how to monitor complex pipelines, set alerts, and extend your organization's custom monitoring requirements.This book starts with an overview of the Azure Data Factory as a ...

Price:  $30.09  |  Publisher:  Apress  |  Release:  2019