charla excel y power pivot
TRANSCRIPT
![Page 1: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/1.jpg)
RaonaBusiness Intelligence
Microsoft BI con Excel & PowerPivot
![Page 2: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/2.jpg)
14/04/2023Evento business intelligence for Dummies 2
Microsoft Strategy & VisionTo improve organizations by
providing business insights to all employees, leading to better, faster, more relevant decisions
• Microsoft has a long-term commitment to delivering a complete and integrated BI offering
• SQL Server has led innovation in the BI space for more than a decade
• There is widespread delivery of intelligence through Microsoft Office
• The platforms are enterprise-grade and affordable
![Page 3: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/3.jpg)
14/04/2023Evento business intelligence for Dummies 3
The Plataform
S E R V I C E SS E R V E R
Operating System
Relational Database
C L I E N T
Developer Tools
Programming Model
Application Services
Systems Management
Applications Web Apps
![Page 4: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/4.jpg)
14/04/2023Evento business intelligence for Dummies 4
Microsoft Excel 2010
Las capacidades nativas de Excel han sido mejoradas drásticamente para permitir el
análisis, comunicación y gestión de la información por parte de los usuarios.
Soporte total para Microsoft SQL Server 2008 R2 Analysis Services
SQL Server PowerPivot for Excel add-in habilita amplía las capacidades de almacenamiento de
grandes volúmenes de datos en un simple workbook
![Page 5: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/5.jpg)
DEMO
![Page 6: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/6.jpg)
14/04/2023Evento business intelligence for Dummies 6
Conclusiones
Excel 2010• El mejor cliente para SQL Server • 0% administración• 0% aprendizaje• 0% adaptación del usuario
PowerPivot • Aumento drástico de las capacidades analíticas de
Excel• Velocidad• On the fly
SU
CC
ES
S
![Page 7: Charla Excel y Power Pivot](https://reader031.vdocuments.us/reader031/viewer/2022032011/55b39aafbb61eb8b3d8b462e/html5/thumbnails/7.jpg)
14/04/2023Evento business intelligence for Dummies 7
Gracias
Javier MenendezPhd / Team Leader