Book Cover

Business Analytics and SQL Essentials: An Overview of Practical Skills for CRISP-DM


Data Analytics

ISBN #978-1-959142-89-8

Business Analytics and SQL Essentials: An Overview of Practical Skills for CRISP-DM

Mark Keith, PhD

Data mining techniques are changing constantly. Through practice-based video tutorials, this resource teaches the latest and most common techniques for both descriptive and predictive data analytics. Using Tableau, students learn dashboard design and data storytelling in organizational settings. Students also learn basic methods in Excel for multiple and linear regression, then turn to more advanced algorithms and techniques in Microsoft Azure Machine Learning Studio.

  • Free instructor demo access to full resource!
  • Plug-and-play solution for instant adoption
  • Lifetime access for students

Course Objective

This resource teaches students the latest data mining techniques, including descriptive and predictive analytics, dashboard design with Tableau, data storytelling, Excel regression methods, and advanced algorithms using Microsoft Azure Machine Learning Studio.

Table of Contents

Foreword: Why Data Science?
Chapter 1: Introduction to Business Analytics
Chapter 2: AI in Business
Chapter 3: Databases
Chapter 4: Data Storage (ERD)
Chapter 5: Data Retrieval (SQL)
Chapter 6: Data Project Methodology
Chapter 7: Introduction to Tableau
Chapter 8: Exploratory Data Analysis in Tableau
Chapter 9: Modeling in Excel
Chapter 10: ML Studio: Introduction to Pipelines
Chapter 11: ML Studio: Data Cleaning and Preparation
Chapter 12: ML Studio: Algorithm Selection
Chapter 13: ML Studio: Selecting the Features
Chapter 14: ML Studio: Optimizing Model Fit and Performance
Chapter 15: ML Studio: Natural Language Processing
Chapter 16: ML Studio: Recommendation Engines
Chapter 17: Project: Putting It All Together
Supplement: Datasets
Supplement: Computer Vision (in progress)

View a sample video!

REQUEST FOR ACCESS

Request free instructor access to any resource. Simply let us know who you are, what school you teach at, which resources you would like access to, and we’ll do the rest!

Not sure which resource fits best for you?

Made by professors, for professors

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.

FAQs

MyEducator was founded by university professors who were frustrated with traditional publishers. Fed up with the high cost for students, outdated content, and ineffective use of technology, they set out to create interactive smart textbooks that could be customized for each course. They knew there had to be a better way.

We understand the need for change–not just in the content students use but in how they apply their knowledge in the real world. Join our mission to make learning more accessible and relevant for every student, in every class, everywhere.

We are proud to offer some of the lowest prices in the industry, with all of our academic textbooks (for university and classroom use) priced at $89 or less. Many of our modules and supplements are even more affordable. You can choose from ready-made courseware bundles, or customize your own for additional savings for students!

Students have access for life. They can even access updates and new versions of their resource at any time for no additional cost.

Yes! You can custom-tailor any resource with your own materials, add/remove and rearrange content, and you even have access to our authors to assist in creating the perfect resource for your specific needs.

Lightning fast–once you choose to adopt, our team is ready to assist with setup and provide continuous support.

We integrate with all major LMS platforms: Canvas, Brightspace, Moodle, and Blackboard. Integration is secure and stable.

We have collaborated closely with our authors to make your adoption process as turn-key as possible! While offerings vary by resource, we generally provide a full range of materials, including syllabi, instructor guides, lesson outlines, robust auto-graded assessments, videos, current event articles, case studies, simulations, games, an AI Virtual Assistant, and more. We’re constantly adding resources to support your teaching needs!

Ready to get started?