pLearn foundational concepts through a cookbook-style approach, beginning with an introduction to the SQL Server functions used for data mining, data analysis, and business intelligence. Each function is described in detail, accompanied by simple coding examples designed to familiarize you with the application of the functions. All code used in the technical chapters is available as a download so you can practice what you have learned.p pThis book goes beyond just showing how each function works by presenting four unique use-case scenarios sales, financial, engineering, and inventory control related to statistical analysis, data analysis, and BI. Each section is covered in two chapters, one for introducing the data model and the second for applying the various data processing recipes and functions discussed. You will wrap up your learning with next steps related to business intelligence and its relevance to other Microsoft Tools such as Power BI and Analysis Services.p pAll code exampl