Data Mining - Using MS SQL Server 2012

• Dauer:
  3 Tage
• Zeit:
  10:00 - 16:00
• Lieferart:
  Online
• Zielgruppe:
  Business Intelligence Developer
• Vorkenntnisse:
  Bases MS SQL Server
• Methode:
  Lecture with examples and exercises.
• Erfahren Sie in der Demo mehr darüber, wie Online-Kurse durchgeführt werden.
• Kursnummer:
  2023658
• 
  Themen:
  Microsoft SQL Server Business Intelligence delivers a comprehensive platform empowering organizations to build and deploy secure, scalable, and manageable BI solutions. The Data Mining module provides new business insights, a reliable basis for forecasting and a comprehensive data-mining development environment. The Data Mining Add-ins allow you to harness the power of SQL Server predictive analytics in Excel and Visio. Use Table Analysis Tools to get insight with a couple of clicks. Use the Data Mining tab for full-lifecycle data mining, and build models which can be exported to a production server. Visualize your models in Visio. Microsoft SQL Server Analysis Services provides multiple algorithms for use in your data mining solutions. These algorithms are implementations of some of the most popular methodologies used in data mining. This training covers both the functions of the Data Mining Add-ins and the functions of SQL Server Data Tools. While getting to know the various software modules you will also get familiar with algorithms like Decision Trees, Naive Bayes, Clustering, Neural Networks, or Linear and Logistic Regression.

Business Intelligence and Data Mining - Usage Scenarios for Data Mining - Data Mining Techniques in Microsoft SQL Server and MS Excel - Server and Client Components: MS SQL Server Analysis Services and Data Mining Add-Ins for MS Excel and MS Visio - Data Mining Life Cycle and Tasks - Data Mining Techniques in MS SQL Server - Project Cycle (Data Collection, Processing and Cleaning of Data, Modeling, Model Evaluation, Reporting, Forecasting, Integration into Applications, Model Management and Maintenance)

Introduction to the Algorithm - Parameters - Building a Model and Using the Model - DMX Queries - Classification Model, Regression Model, Relationship Model

Introduction to the Algorithm - Parameters - Building a Model and Using the Model - DMX Queries - Dependency Network, Attribute Profiles, Attribute Characteristics, Attribute Discrimination

Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Auto Regression, Multiple Time Series, Seasonality, Historic Predictions, Caching Predictions - DMX Queries

Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Clustering Types, Scalable Clustering, Predictions and Cluster Assignment - DMX Queries: Cluster, Probability, Histograms, CaseLikelihood

Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Markov Chains, Transition Matrix, Clustering and Markov Chains, Decomposition - DMX Queries

Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Itemset, Support, Probability and Confidence, Interestingness and Importance - DMX Queries

Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Combination and Activation, Normalization and Mapping, Topology of a Neural Network , Model Training - DMX Queries

XML/A (XML for Analysis): Generating and Using Scripts, Building, Managing and Training Data Mining Models - DMX (Data Mining Extensions): Building Data Mining Models, Managing, Training, and Querying Data Mining Models

Using Data Mining-Models in Integration Services – Using Data Mining Results in Reporting Services

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.

Veröffentlichungen

• "MS SQL Server - XML und SOAP-Webservices" (Comelio Medien, ISBN 978-3-939701-03-3)
• "MS SQL Server - T-SQL Programmierung und Abfragen" (Comelio Medien, ISBN 978-3-939701-02-6)
• "SQL und relationale Datenbanken" (Comelio Medien, ISBN 978-3-939701-52-1)
• "Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen" (Comelio Medien, ISBN 978-3-939701-23-1)
• "System und Systematik von Fragebögen" (Comelio Medien, ISBN 978-3-939701-26-2)
• "MS SQL Server - XML und SOAP-Webservices" (Comelio Medien, ISBN 978-3-939701-03-3)
• "MS SQL Server - T-SQL Programmierung und Abfragen" (Comelio Medien, ISBN 978-3-939701-02-6)
• "SQL und relationale Datenbanken" (Comelio Medien, ISBN 978-3-939701-52-1)
• "Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen" (Comelio Medien, ISBN 978-3-939701-23-1)
• "System und Systematik von Fragebögen" (Comelio Medien, ISBN 978-3-939701-26-2)

Erfahrung: He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Projekte: He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.

Forschung: He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Zertifizierung: Marco Skulschus is "Microsoft Certified Trainer" and passed the ComptiaCTT+ examination.

Bei der Anmeldung von mehreren Teilnehmern bieten wir Ihnen attraktive Rabatte an. Ab drei Teilnehmern kann sich ein Inhouse-Seminar bei Ihnen lohnen. Gern erstellen wir Ihnen ein individuelles Angebot.
Alle Preise zuzüglich der gesetzlichen Mehrwertsteuer.