The previous chapters in this book taught us how to use particular technologies or features within or outside of SQL Server, but this chapter is going to be different. We will use some of the technologies and features described earlier, and we will also build an entire predictive solution. This chapter will guide us through the following sections:
- Assignment and preparation: First of all, we need to know the topic of our real-world example. We also need to prepare the environment for further work. This section is all about the assignment of the project and its preparation tasks.
- Data exploration: Our projects already have data saved into a relational database. In this section, we will explore what the data contains, how reliable the data quality is, and we'll develop a statistical summary of the data
- Data transformation: Based...