THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Business Intelligence   (RSS)
Showing page 1 of 9 (90 total posts)
  • Presenting SSIS Data Flow Performance Patterns at Charlotte BI Group 7 Jul!

    I’m honored to present “SSIS Data Flow Performance Patterns” at the Charlotte BI Group 7 Jul 2015! In this session, I discuss Data Flow Task internals and patterns that improve SSIS 2014 Data Flow performance in your data integration enterprise: Incremental Loads, Blob Pyramid, and Type 2 New + Updated Rows. Plus, I tell funny stories (well, I ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 24, 2015
  • So Long, and Thanks for All the Scripts!

    With mixed emotions, I just read The End of an Era – SQLFool scripts are now open-sourced. After two book projects together, I admire Michelle (New Blog | @SQLFool) immensely. More than that, I consider her a friend. It’s exciting to (try to) keep up with all the cool stuff Michelle’s working on, and I am very happy for her. Thanks for all the ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 23, 2015
  • Data Mining Algorithms – Support Vector Machines

    Support vector machines are both, unsupervised and supervised learning models for classification and regression analysis (supervised) and for anomaly detection (unsupervised). Given a set of training examples, each marked as belonging to one of categories, an SVM training algorithm builds a model that assigns new examples into one category. An SVM ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on June 23, 2015
  • Data Mining Algorithms – Principal Component Analysis

    Principal component analysis (PCA) is a technique used to emphasize the majority of the variation and bring out strong patterns in a dataset. It is often used to make data easy to explore and visualize. It is closely connected to eigenvectors and eigenvalues. A short definition of the algorithm: PCA uses an orthogonal transformation to convert ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on June 2, 2015
  • 24 Hours of PASS (June 2015)

    The most important free on-line event on SQL Server and Business Intelligence is back! The 24 Hours of PASS is coming back with a great edition that will provide best practices, expert tips, and demos, from new and up-and-coming Speakers. Don't take commitments on 24 and 25 of June 2015. Register now at this link, it's free! No ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on May 27, 2015
  • Great Scott! Linchpin People is Going… Back to SQL Saturday Atlanta!

    SQL Saturday #392 is happening THIS SATURDAY! I’m looking forward to returning to Atlanta, where almost everyone speaks without an accent. The schedule looks awesome! I’m excited that several Linchpins were selected to present because this means we’ll get to hang out in person. I’m also excited to see so many friends from #SQLFamily, too, ...
    Posted to Andy Leonard (Weblog) by andyleonard on May 14, 2015
  • Data Mining Algorithms – K-Means Clustering

    Hierarchical clustering could be very useful because it is easy to see the optimal number of clusters in a dendrogram and because the dendrogram visualizes the clusters and the process of building of that clusters. However, hierarchical methods don’t scale well. Just imagine how cluttered a dendrogram would be if 10,000 cases would be shown on ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 17, 2015
  • Data Mining Algorithms – Hierarchical Clustering

    Clustering is the process of grouping the data into classes or clusters so that objects within a cluster have high similarity in comparison to one another, but are very dissimilar to objects in other clusters. Dissimilarities are assessed based on the attribute values describing the objects. There are a large number of clustering algorithms. The ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 28, 2015
  • Data Mining Algorithms – Association Rules

    The Association Rules algorithm is specifically designed for use in market basket analyses. This knowledge can additionally help in identifying cross-selling opportunities and in arranging attractive packages of products. This is the most popular algorithm used in web sales. You can even include additional discrete input variables and predict ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 10, 2015
  • Data Mining Algorithms – an Introduction

    Data mining is the most advanced part of business intelligence. With statistical and other mathematical algorithms, you can automatically discover patterns and rules in your data that are hard to notice with on-line analytical processing and reporting. However, you need to thoroughly understand how the data mining algorithms work in order to ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on February 19, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement