Category Archives: data mining

What to expect in a day of Predictive Analytics

SQL Saturday is coming this weekend in Baton Rouge, LA and I’m presenting a full day pre-con on Friday on Predictive Analytics.  It’s a full day deep dive on how to start using Predictive Analytics in your organization, and ideal for people who are brand new to the field.

What should you expect in a full day session like this, besides singing, dancing and a few jokes?

To give you an idea as to what’s covered, here’s an outline of the agenda for the day.  I hope you can make it, and there is still time to register by clicking on this link:

Predictive Analytics in the Enterprise

Early Morning

  • Predictive Modeling Overview
  • SQL Server Data Mining, Analysis Service and Excel
  • Predictive Model by Class

Late Morning

  • Case Studies
  • Tools and Algorithms
  • Demo\Lab 1 – Develop Hiring Model

After Lunch

  • Use Models with DMX – C#, SSIS, SSRS
  • Demo\Lab 2 – Develop College Model

Mid Afternoon

  • Demo – Neural Network Code
  • Exercise 1 – Develop Churn Model
  • Demo 3 – Discuss alternative tools such as R, WEKA, RapidMiner

Late Afternoon

  • Deployment and Monitoring
  • Exercise 2 – Develop Movie Recommendation Model
  • Exercise 3 – Develop Stock Price Prediction Model

Predictive Analytics Pre-con at SQL Saturday #324 in Baton Rouge

I’m presenting a full day pre-con on Friday, August 1 in Baton Rouge, LA on titled Predictive Analytics in the Enterprise and there is still time to register!  You may have heard about predictive analytics and are wondering what it is all about, and this session will answer all your questions.  But it will also get you thinking about what you could be doing with your data, and it will get the juices in your brain flowing about the amazing things that can be done with predictive modeling.  People that come to this session usually leave excited and are hungry to try out the new concepts they just learned.

In the session, I’ll show you how to start and be successful with a predictive modeling project in your organization.  I’ll provide an overview of predictive analytics, discuss the concepts and ideas behind the subject, use case studies to review successful projects I’ve worked on, and demonstrate how predictive models are built.   I’ll also have a number of labs for the class to use as exercises so you can leave the session having built your own predictive models.  To participate, bring your laptop or plan to share with someone.  I have a lot of material to go through in just one day.

In addition to my pre-con, Ryan Adams will also be doing a pre-con the same day and location called A Day of High Availability and Disaster Recovery.

Also, don’t forget Saturday, a full day of free training.  It’s always top-notch gathering of SQL Professionals and I expect it to be this year also.

Click here to register:  Predictive Analytics in the Enterprise

A full day of Predictive Analytics

The annual SQL Saturday event in Denver is scheduled for this Saturday, September 28, but you may not know that there is also a full day of training just one day earlier.  There are a total of three sessions scheduled for Friday and I have the privilege of presenting one of them, Predictive Analytics in the Enterprise.  If you’ve been reading the tech news and paying attention to where analytics is headed, predictive analytics is a great topic to dive into, especially for BI developers, analysts, architects, and DBAs.  Here’s a look at the session abstract:

Data Science is a red-hot subject, but what does that mean for SQL Server DBAs and developers?  The Data Mining algorithms in Analysis Services provide capabilities to achieve predictive analytics and modeling with your SQL Server data and any other data you have access to.  In this session you’ll get the chance to cover the data mining process from start to end.  By the end of the day, you’ll have a practical understanding of how to develop predictive models for your data.  The session includes a brief overview of data mining followed by an opportunity to complete actual predictive modeling exercises.  You’ll see how to fine-tune and compare the results using various algorithms, and how to make the best use of the models in your enterprise.   With Predictive Analytics having achieved the Plateau of Productivity in Gartner’s Hype Cycle for Emerging Technologies, now is a good time to learn what these powerful tools can do for you.

Like the abstract says, the session will cover the concepts and terminology in the predictive analytics world and will include case studies to review.  It will also include instructor-led labs so you can create your own predictive models.  Bring a laptop with SQL Server Analysis Services (multi-dimensional),  Business Intelligence Development Studio (or SQL Server Data Tools), Excel and the Data Mining add-in for Excel.  If you don’t have a laptop with these tools readily available, we can pair you up with a partner who has the tools ready to go.  Working in pairs will also be a good way to learn the topic better.

If you’re looking for training in other areas, Tim Mitchell will have a full day session for ETL developers on Real World SSIS: A Survival Guide, and Dmitri Korotkevitch will target DBAs with a session titled SQL Server Internals from the Practical Angle

See you Friday!