Business Intelligence

CURSOS DE BUSINESS INTELLIGENCE

INTRODUCCIÓN A LA INTELIGENCIA DE NEGOCIO (BI)

Módulo 1: Introducción a la inteligencia de negocio

Módulo 2: Áreas de una solución BI

Módule 3: Ejemplos de Herramientas BI

Módulo 4: Proyecto BI

Módulo 5: Modelización información BI

POWER PIVOT, POWER VIEW Y SHAREPOINT 2013 BUSINESS INTELLIGENCE CENTER PARA ANALISTAS

Module 1: Course Overview

Module 2: Power Pivot

• Lab : Power Pivot

Module 3: Power View

• Lab : Power View

Module 4: SharePoint 2013 Business Intelligence Center

• Lab : SharePoint 2013 Business Intelligence Center

MICROSOFT END TO END BUSINESS INTELLIGENCE BOOT CAMP

Module 1: Course Overview

Module 2: The Business Intelligence Stack

• Lab : The Business Intelligence Stack

Module 3: SQL Server Integration Services (SSIS) 2012

• Lab : SQL Server Integration Services (SSIS) 2012

Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)

• Lab : SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode)

Module 5: Microsoft Multidimensional Expressions

• Lab : Microsoft Multidimensional Expressions

Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode)

• Lab : SQL 2012 Business Intelligence Semantic Model (Tabular Mode)

Module 7: SQL Server 2012 Reporting Services

• Lab : SQL Server 2012 Reporting Services

Module 8: Master Data Services

• Lab : Master Data Services

Module 9: Data Mining/Predictive Analytics

• Lab : Data Mining/Predictive Analytics

Module 10: SharePoint 2013 Business Intelligence Center

• Lab : SharePoint 2013 Business Intelligence Center

Module 11: SharePoint 2013 Excel Services

• Lab : SharePoint 2013 Excel Services

Module 12: SharePoint 2013 PerformancePoint 2013

• Lab : SharePoint 2013 PerformancePoint 2013

Module 13: SharePoint 2013 Visio Services

• Lab : SharePoint 2013 Visio Services

Module 14: PowerPivot

• Lab : PowerPivot

Module 15: SharePoint 2013 Business Connectivity Services

• Lab : SharePoint 2013 Business Connectivity Services

Module 16: Dashboards

• Lab : Dashboards

SHAREPOINT 2013 BUSINESS INTELLIGENCE

Module 1: Course Overview

Module 2: The Business Intelligence Stack

• Lab : The Business Intelligence Stack

Module 3: SharePoint 2013 Business Intelligence Center

• Lab : SharePoint 2013 Business Intelligence Center

Module 4: SharePoint 2013 Excel Services

• Lab : SharePoint 2013 Excel Services

Module 5: SharePoint 2013 PerformancePoint 2013

• Lab : SharePoint 2013 PerformancePoint 2013

Module 6: SharePoint 2013 Visio Services

• Lab : SharePoint 2013 Visio Services

Module 7: Power Pivot

• Lab : Power Pivot

Module 8: SharePoint 2013 Business Connectivity Services

• Lab : SharePoint 2013 Business Connectivity Services

Module 9: Dashboards

• Lab : Dashboards

IMPLEMENTANDO MODELOS DE DATOS E INFORMES CON MICROSOFT SQL SERVER 2012

Module 1: Introduction to Business Intelligence and Data Modeling

• Lab : Reporting and Analyzing Data

Module 2: Implementing Reports with SQL Server Reporting Services

• Lab : Creating a Report with Report Designer

• Lab : Enhancing and Publishing a Report

Module 3: Supporting Self Service Reporting

• Lab : Implementing Self Service Reporting

Module 4: Managing Report Execution and Delivery

• Lab : Configuring Report Execution and Delivery

Module 5: Creating Multidimensional Databases

• Lab : Creating a Multidimensional Database

Module 6: Working with Dimensions

• Lab : Defining Dimensions

Module 7: Working with Measures and Measure Groups

• Lab : Configuring Measures and Measure Groups

Module 8: Introduction to MDX

• Lab : Using MDX

Module 9: Customizing Cube Functionality

• Lab : Customizing a Cube

Module 10: Implementing a Tabular Data Model with Microsoft PowerPivot

• Lab : Using PowerPivot for Excel

Module 11: Introduction to DAX

• Lab : Creating Calculated Columns and Measures by Using DAX

Module 12: Implementing an Analysis Services Tabular Data Model

• Lab : Working with an Analysis Services Tabular Data Model

Module 13: Creating Data Visualizations with Power View

• Lab : Creating Data Visualizations with Power View

Module 14: Performing Predictive Analysis with Data Mining

• Lab : Using Data Mining to Support a Marketing Campaign

IMPLEMENTANDO UN DATAWAREHOUSE CON MICROSOFT SQL SERVER 2012

Module 1: Introduction to Data Warehousing

• Lab : Exploring a Data Warehousing Solution

Module 2: Data Warehouse Hardware

Module 3: Designing and Implementing a Data Warehouse

• Lab : Implementing a Data Warehouse Schema

Module 4: Creating an ETL Solution with SSIS

• Lab : Implementing Data Flow in a SSIS Package

Module 5: Implementing Control Flow in an SSIS Package

• Lab : Implementing Control Flow in an SSIS Package

• Lab : Using Transactions and Checkpoints

Module 6: Debugging and Troubleshooting SSIS Packages

• Lab : Debugging and Troubleshooting an SSIS Package

Module 7: Implementing an Incremental ETL Process

• Lab : Extracting Modified Data

• Lab : Loading Incremental Changes

Module 8: Incorporating Data from the Cloud into a Data Warehouse

• Lab : Using Cloud Data in a Data Warehouse Solution

Module 9: Enforcing Data Quality

• Lab : Cleansing Data

• Lab : Deduplicating Data

Module 10: Using Master Data Services

• Lab : Implementing Master Data Services

Module 11: Extending SQL Server Integration Services

• Lab : Using Custom Components and Scripts

Module 12: Deploying and Configuring SSIS Packages

• Lab : Deploying and Configuring SSIS Packages

Module 13: Consuming Data in a Data Warehouse

• Lab : Using Business Intelligence Tools