2 powerpivot aurélien koppel manager bios consulting nadia ben el kadi technology specialist...
TRANSCRIPT
![Page 1: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/1.jpg)
![Page 2: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/2.jpg)
2
PowerPivot
Aurélien KoppelManagerBios Consulting
Nadia Ben El KadiTechnology SpecialistMicrosoft France
10/02/2011
![Page 3: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/3.jpg)
3
Powerpivot : définition
![Page 4: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/4.jpg)
4
DémoAnalyse de grands volumes de données
![Page 5: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/5.jpg)
5
Architecture
Sources de données
Relational
AS
Excel, Text, …
Excel 2010
PowerPivot Add-in
VertiPaq Engine
PowerPivot Data
Chargement
![Page 6: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/6.jpg)
6
Configuration des postesLes créateurs de rapports
Excel 2010 & Addin PowerPivot32 bit Vs 64 bitMémoire RAMCitrix
Les consommateurs des rapportsL’architecture SharePoint prend le relais
![Page 7: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/7.jpg)
7
Les bons « profils »Pas de connaissances techniques classiques
Pas besoin de savoir écrire une requête SQLPas besoin de connaître un langage de programmation (Vb, C#, Java ou autre)
Connaissance fonctionnelles et théoriquesConnaître les données Avoir l’habitude des fonctions Excel -> DAXModélisation en étoilePrincipe des relations 1 à N
![Page 8: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/8.jpg)
8
Les relations 1:NVentes
• Mois• Produit• CA Réel
Budget• Mois• Produit• CA Budget
Ventes• Mois• Produit• CA Réel
Budget• Mois• Produit• CA Budget
Temps• Mois
Produits• Produit
![Page 9: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/9.jpg)
9
Les clés de jointures
Ventes• AnnéeMois• Année• Mois• Produit• CA Réel
Temps• AnnéeMois• Année• Mois
=‘Temps'[Année] & ‘Temps'[Mois] =‘Ventes'[Année] & ‘Ventes'[Mois]
![Page 10: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/10.jpg)
10
DémoCréation d’un rapport Multi Source
![Page 11: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/11.jpg)
11
Démo PowerPivot Excel
Flight Data & AirlinesAirport Geography
ApplicationPowerPivot.XLSX
![Page 12: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/12.jpg)
12
DémoCréation d’un rapport Multi Source
![Page 13: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/13.jpg)
13
PowerPivot pour Sharepoint 2010
![Page 14: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/14.jpg)
14
PowerPivot pour Sharepoint• Utilise:
• Excel Services 2010• SQL Server 2008 R2: Analysis Services
• Permet:• Partage des applications PowerPivot• Pas besoin d’Excel 2010 sur tous les postes• Montée en charge• Sécurité gérée par Sharepoint• Rafraîchissements automatiques (programmés)• Administrable par l’IT (Tableau de bord dédié)
![Page 15: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/15.jpg)
15
Dashboard IT
![Page 16: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/16.jpg)
16
Architecture
Sources de données
RelationalPublication
http://...xlsx
AS
Excel, Text, …
Excel
PowerPivot Add-in
VertiPaq Engine
VertiPaq Server
Excel Services
PowerPivot Data
PowerPivot Data
Rafraîchissement programmé des données
Chargement
![Page 17: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/17.jpg)
17
ArchitectureNombre de serveurs RAM: 64 GBVirtualisation?
MOSSSQL ServerAD
![Page 18: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/18.jpg)
18
SécuritéSécurité d’accès aux rapports
Basée sur l’Active DirectoryDéfinie dans SharepointSécurité:
Contrôle total ConceptionCollaborationLectureVue seule: Pas de téléchargement des rapports
![Page 19: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/19.jpg)
19
DémoPublication d’un rapport PowerPivot dans Sharepoint
![Page 20: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/20.jpg)
20
RécapitulatifPowerPivot add-in
for Excel PowerPivot add-in
for SharePoint
![Page 21: 2 PowerPivot Aurélien Koppel Manager Bios Consulting Nadia Ben El Kadi Technology Specialist Microsoft France 10/02/2011](https://reader036.vdocuments.us/reader036/viewer/2022062417/551d9da4497959293b8d499d/html5/thumbnails/21.jpg)