Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Scalable Data Analytics with Azure Data Explorer

You're reading from  Scalable Data Analytics with Azure Data Explorer

Product type Book
Published in Mar 2022
Publisher Packt
ISBN-13 9781801078542
Pages 364 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Jason Myerscough Jason Myerscough
Profile icon Jason Myerscough

Table of Contents (18) Chapters

Preface 1. Section 1: Introduction to Azure Data Explorer
2. Chapter 1: Introducing Azure Data Explorer 3. Chapter 2: Building Your Azure Data Explorer Environment 4. Chapter 3: Exploring the Azure Data Explorer UI 5. Section 2: Querying and Visualizing Your Data
6. Chapter 4: Ingesting Data in Azure Data Explorer 7. Chapter 5: Introducing the Kusto Query Language 8. Chapter 6: Introducing Time Series Analysis 9. Chapter 7: Identifying Patterns, Anomalies, and Trends in your Data 10. Chapter 8: Data Visualization with Azure Data Explorer and Power BI 11. Section 3: Advanced Azure Data Explorer Topics
12. Chapter 9: Monitoring and Troubleshooting Azure Data Explorer 13. Chapter 10: Azure Data Explorer Security 14. Chapter 11: Performance Tuning in Azure Data Explorer 15. Chapter 12: Cost Management in Azure Data Explorer 16. Chapter 13: Assessment 17. Other Books You May Enjoy

Calculating statistics for time series data

Another useful function is series_stats(). The series_stats() function takes one or multiple time series as an argument and returns the following statistical information:

  • min: The minimum value in the time series.
  • min_idx: The index of the minimum value in the time series.
  • max: The maximum value in the time series.
  • max_idx: The index of the maximum value in the time series.
  • avg: The average value of the time series.
  • variance: The sample variance of the time series. The sample variance is the squared deviation of the time series's mean. The sample variance is used to calculate the standard deviation.
  • stdev: The sample standard deviation. The standard deviation is the amount of variation in the values of the time series.

The following screenshot shows the statistics for our security patching time series:

Figure 6.11 – Calculating statistics for a time series

As you...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}