MS SQL Server 2012 - Business Intelligence - Compact

• Dauer:
  5 Tage
• Zeit:
  10:00 - 16:00
• Lieferart:
  Online
• Zielgruppe:
  Business Intelligence Developer
• Vorkenntnisse:
  Experience with Business Intelligence concepts
• Methode:
  Lecture with examples and exercises.
• Erfahren Sie in der Demo mehr darüber, wie Online-Kurse durchgeführt werden.
• Kursnummer:
  2022958
• Allgemeine Hinweise:
  Entspricht "MOC 2794 - Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005". Durchgeführt von einem Microsoft Certified Trainer (MCT)
• 
  Themen:
  Microsoft SQL Server Analysis Services is a platform for building rich and high performance analytical models (multidimensional, tabular and data mining) that can be used for interactive data analysis, reporting, visualization and predictive analysis using a number of BI tools. Integration Services helps you connect and transform disparate data sources with a scalable enterprise data integration platform with exceptional extract, transform, and load (ETL) capabilities. Reporting Services is a platform for development and deployment of professionally looking, richly formatted operational and ad-hoc reports. Power View empowers users to rapidly explore data visually and interactively, easily create a story, present, and share reports effortlessly. This training takes you on a tour through all SQL Server products which are useful and necessary for building Data Warehouse and Reporting Solutions.

Business Intelligence - Fundamentals of Data Warehousing und OLAP - Typical DW Data Models - Microsoft´s Architecture and Tools for Business Intelligence - Project Types and Project Phases for Business Intelligence - Life Cycle of BI-Solutions using MS SQL Server

Dimensions: Creation and Deployment, Hierarchies and Aggregation, Typology of Dimensions: Time, Currency, Language, Validity - Measures: Creation and Deployment, Storage Models, Calculated Measures with MDX - OLAP Cubes: Creation and Deployment, Security Model, MS Excel and Cube Access - Overview of Advanced Scenarios (Interactivity and Key Performance Indicators (KPI)

SSIS Packages - Control Flow Tasks - Precedence Constraints - Data Flow Paths - Data Viewer - Configuring Error Output - Using Variables - Processing of Excel, Text, and XML Files - MS SQL Queries - Logging - Error Handling - Package Configuration - Deployment

Interactivity: OLAP Operations - Report Elements: Table, Matrix, Chart, Subreports - Datasets: Data Sources and Queries - Parameters and Filters - Deployment: Report Portal, Report Snapshots and Caching, Subscriptions

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.