Browse by Tags

• analytical applications
• business intelligence
• Community Event
• course
• data
• data analysis
• Data Mining
• Data Modeling
• data overview
• data preparation
• data profiling
• Data Quality
• data quality services
• fraud detection
• information theory
• Ljubljana
• logical model
• master data management
• master data services
• patterns
• physical model
• proof of concept
• Slovenia
• SQL PASS
• SQL Saturday
• sql server
• statistics

• SQL Saturday #274 Slovenia Recapitulation

  Pure success! I could simply stop here. However, I want to mention again everybody involved in this, and also some who were unfortunately missing. First of all, PASS is the organization that defined SQL Saturdays. And apparently the idea works I have Read More... Posted Monday, December 23, 2013 1:49 PM by Dejan Sarka | 4 Comments Filed under: sql server, Ljubljana, SQL PASS, Slovenia, SQL Saturday, training, data, Community Event

• Fraud Detection with the SQL Server Suite Part 3

  This is the third part of the fraud detection whitepaper. You can find the first part and the second part in my previous blog posts about this topic. Data Preparation The problem of credit card fraud detection is not trivial. With every transaction processed, Read More... Posted Wednesday, November 27, 2013 5:43 PM by Dejan Sarka | 4 Comments Filed under: Data Mining, statistics, sql server, patterns, fraud detection, training, data overview, data preparation, information theory

• Logical and Physical Modeling for Analytical Applications

  I am proud to announce that my first course for Pluralsight is released. The course title is Logical and Physical Modeling for Analytical Applications . Here is the description of the course. A bad data model leads to an application that does not perform Read More... Posted Friday, November 01, 2013 9:44 AM by Dejan Sarka | 2 Comments Filed under: course, training, Data Modeling, analytical applications, physical model, logical model

• Fraud Detection with the SQL Server Suite Part 2

  This is the second part of the fraud detection whitepaper. You can find the first part in my previous blog post about this topic. My Approach to Data Mining Projects It is impossible to evaluate the time and money needed for a complete fraud detection Read More... Posted Tuesday, October 29, 2013 4:42 PM by Dejan Sarka | 4 Comments Filed under: Data Mining, sql server, patterns, fraud detection, training, data overview, data preparation, proof of concept

• Data Quality and Master Data Management Resources

  Many companies or organizations do regular data cleansing. When you cleanse the data, the data quality goes up to some higher level. The data quality level is determined by the amount of work invested in the cleansing. As time passes, the data quality Read More... Posted Monday, October 14, 2013 6:52 PM by Dejan Sarka | 1 Comments Filed under: sql server, Data Quality, data quality services, master data management, master data services, data profiling, training

• Data Mining Resources

  There are many different types of analyses, each one with its own pros and cons. Relational reports have a predefined structure, and end users cannot change it. They are simple to use for end users. Reports can use real-time data and snapshots of data Read More... Posted Thursday, October 10, 2013 10:50 AM by Dejan Sarka | 2 Comments Filed under: Data Mining, business intelligence, data analysis, patterns, training