1 / 4

• SQL Server Integration Services SSIS

• SQL Server Integration Services SSIS. Practica calificada sobre Integration Services. End-to-End BI Offering. DELIVERY. COLLABORATION. CONTENT MANAGEMENT. SharePoint Server. SEARCH. END USER TOOLS AND PERFORMANCE MANAGEMENT APPS. Reports. Dashboards. Excel Workbooks. Analytic

hank
Download Presentation

• SQL Server Integration Services SSIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. • SQL Server IntegrationServices SSIS Practicacalificadasobre Integration Services

  2. End-to-End BI Offering DELIVERY COLLABORATION CONTENT MANAGEMENT SharePoint Server SEARCH END USER TOOLS AND PERFORMANCE MANAGEMENT APPS Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans Excel PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Server DBMS Heterogeneous data sources SQL Server Integration Services

  3. Ejercicio • En base a la DB AdventureWorks y las tablas de «Producto», «cabecera de ventas», «detalle de ventas» y «territorio», con la ayuda de una cadena de integración obtener el análisis de ventas por territorio y por año para los 3 productos mas vendidos de la empresa. Considerar el uso de Excel y tablas dinámicas para emitir la información bajo el formato del gráfico inferior. • Considerar las siguientes condiciones: • El nombre de las regiones debe estar en mayúsculas. • Extraer en un área de datos separada los Productos cuyas ventas sean superiores a S/.600,000

  4. Ejercicio El resultado del análisis debe estar en un formato similar al mostrado, donde se observe por año, y región las ventas de los primeros 3 productos en función de los montos de venta. El análisis debe ser grafico según se muestra:

More Related