I have put together a list of resources that
can be used to get up to speed with PowerPivot. Hope this is helpful.
MSDN Virtual Lab: Building and Sharing
Your First SQL Server 2008 R2 PowerPivot for Excel Workbook - https://cmg.vlabcenter.com/default.aspx?moduleid=94c5a946-aab0-4dc0-a143-b507fe799504
Description: After completing
this lab, you will be better able to import data into PowerPivot, create table
relationships, create calculated columns, create a PivotTable report, create
measures, format the PivotTable report, and publish the PowerPivot workbook to
SharePoint.
MSDN Virtual Lab: PowerPivot in
SQL Server 2008 R2 - https://cmg.vlabcenter.com/default.aspx?moduleid=ee755517-6658-4f86-b24d-a42ab3f9169a
MSDN Virtual Lab: Loading and
Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010 - https://cmg.vlabcenter.com/default.aspx?moduleid=35f7087d-5f43-4c5e-acb1-da9679a5969c
Description: After completing
this lab, you will be better able to create a PowerPivot model, load data from
different data sources into PowerPivot tables, and create relationships between
PowerPivot tables.
BI PowerPivot "How Do I?" Videos - http://technet.microsoft.com/en-us/bi/ff966490
Description: Includes
several PowerPivot videos such as Introduction to PowerPivot Relationships,
Overview of Importing Data into PowerPivot, Import SQL Server Data into a
PowerPivot Workbook, Add a Calculated Column to a PowerPivot Workbook, Using
Slicers with PowerPivot PivotTables/Charts, PowerPivot for Excel and SharePoint
and a lot more.
MSDN Virtual Lab: Creating
Reports with SQL Server PowerPivot for Excel 2010 - https://cmg.vlabcenter.com/default.aspx?moduleid=82873ec9-8de5-4eed-a23f-a1ba11cc576e
Description: After completing
this lab, you will be better able to create a PivotTable report based on a
PowerPivot model, format the report using conditional formatting, enhance the
report with Slicers, and refine the PowerPivot model.
MSDN Virtual Lab: Building and Sharing
Your First SQL Server 2008 R2 PowerPivot for Excel Workbook - https://cmg.vlabcenter.com/default.aspx?moduleid=94c5a946-aab0-4dc0-a143-b507fe799504
Description: After completing
this lab, you will be better able to import data into PowerPivot, create table
relationships, create calculated columns, create a PivotTable report, create
measures, format the PivotTable report, and publish the PowerPivot workbook to
SharePoint.
MSDN Virtual Lab: PowerPivot in
SQL Server 2008 R2 - https://cmg.vlabcenter.com/default.aspx?moduleid=ee755517-6658-4f86-b24d-a42ab3f9169a
Description: After completing
this lab you will be better able to use various methods of loading data into
PowerPivot for Excel and structuring it for analysis, create and use
PivotTables against PowerPivot data, understand DAX concepts and several basic
DAX functions, and publish PowerPivot workbooks to Excel Services and
understand their server-based structure.
MSDN Virtual Lab: Loading and
Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010 - https://cmg.vlabcenter.com/default.aspx?moduleid=35f7087d-5f43-4c5e-acb1-da9679a5969c
Description: After completing
this lab, you will be better able to create a PowerPivot model, load data from
different data sources into PowerPivot tables, and create relationships between
PowerPivot tables.
TechNet Virtual Lab: Power
Pivot - https://cmg.vlabcenter.com/default.aspx?moduleid=dbe037bc-9004-4a38-883f-696d507a1b66
Description: After
completing this lab, you will be better able to import SQL Server data into
PowerPivot, create a sales report using PowerPivot data, and import data from a
web site into PowerPivot.
Deep
Dive on PowerPivot Technologies - http://channel9.msdn.com/Events/TechEd/NorthAmerica/2010/BIE401
I have seen the excel pivot table but was unknown to power point pivot table. I am confuse with the task and usage of it in power point, in excel it is used to measure and calculate different department expenses and financial work etc. What type of work it in power point.
ReplyDeletehow much does data recovery cost