PowerPivot for End Users Course

After the last two weeks of finishing this course, it is about to be published!  Here's the outline…

  • PowerPivot Introduction
    • Install PowerPivot for Excel
    • Explore new Excel 2010 Features
  • PowerPivot Data Sources
    • Load Data From SQL Server
    • Load Data From Text Files
    • Load Data via Copy and Paste
    • Load Data via Data Feeds
    • Load Data via Reporting Services
    • Cleaning data in PowerPivot
    • Create Relationship between Data Sources
  • PowerPivot Functions
    • Create a Time Table for future labs
    • Use DATE Function
    • Use DATEVALUE Function
    • Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
    • Use EDATE Function
    • Use EOMONTH Function
    • Use NOW and TODAY Functions
    • Use TIME and TIMEVALUE Functions
    • Use WEEKDAY and WEEKNUM Functions
    • Use FIRST* and LAST* Functions
    • Use DATE* Functions
    • Use STARTOF* and ENDOF* Functions
    • Use CLOSING* and OPENING* Functions
    • Use LASTOF* and FIRST* Functions
    • Use PREVIOUS* and NEXT* Functions
    • Use AVERAGE* Functions
    • Use COUNT* Functions
    • Use MAX* and MIN* Functions
    • Use ALL, ALLEXCEPT and ALLNOBLANKROW
    • Use CALCULATE, CALCULATETABLE
    • Use DISTINCT and VALUES
    • Use EARLIER and EARLIEST
    • Use FILTER
    • Use RELATED
    • Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
    • Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
    • Use TEXT Functions
  • Building Reports using PowerPivot
    • Use PivotCharts
    • Use Slicers
    • Use Sparklines
    • PivotTable Models
  • PowerPivot for SharePoint 2010
    • Install PowerPivot for SharePoint 2010
    • Configure PowerPivot for SharePoint
    • Publish to SharePoint 2010
    • Configure PowerPivot for SharePoint 2010

Chris

SharePoint 2010 – The license state for the current server doesn’t match the farm’s license state.

What the hell is this all about?  I have done the install a million times and this was the first time I found this error.  Seems Office Web Apps destroys everything…there are a couple of different google results around this, but no resolution as of yet (6/11/2010)!

The option of removing OWA from the first server IS NOT AN OPTION (it will break a ton of things).  That means I am stuck with a one server farm until Microsoft comes up with a solution for this. Can't believe this wasn't tested…

UPDATE:  You must install the latest cumulative updates and this error will be resolved.

Chris

SharePoint 2010 Business Intelligence Course

Finally!  It is about one month past due, but I finished it today!  It will be globally available in two weeks!  Here's the outline:

  • Business Intelligence
    • Answer Business Intelligence Questions
  • Business Intelligence Center
    • Explore SharePoint Business Intelligence Center
    • Understand a Key Performance Indicator
    • Explore Dashboard Designer
  • Data Mart & Data Warehouses
    • Explore Data Formats
    • Create a Simple Data Warehouse
    • Explore the Extract stage
    • Explore Transform & Load stages
    • Realize the importance of primary/unique keys
    • Create Data Warehouse Granularity Levels
    • Create a Data Mart
  • Business Connectivity Services
    • Explore External Content Types
    • Create a new External Content Type
    • Create an External List
    • Create a new External Content Type
    • Create an External List
    • Filters and External lists
    • Entity Profile Pages
    • Explore Office and BCS Integration
  • Analysis Services
    • Create Dimension and Fact tables
    • Create an Analysis Services Database
    • Create a Analysis Services Database
    • Create a Cube
    • Create Dimensions
    • Create Fact Tables
    • Create a KPI
  • Filter Web Parts
    • Use each of the Filter Web Parts
  • Excel Services
    • Create An Excel Report
    • Learn to use Excel Services
    • Create/Publish to Excel Services
    • Configure Excel Services
    • Shared Data Connections
    • Explore Excel 2010 MDX features
    • Create a Slicer
    • Create an MDX Set
    • Use Excel 2010 Sparklines
    • Explore Filter Web Parts and Excel Services
    • Explore REST features of Excel Services
    • Explore the Excel Services Web Service
  • PowerPivot
    • Install PowerPivot for Excel
    • Install PowerPivot for SharePoint 2010
    • Configure PowerPivot for SharePoint
    • Explore PowerPivot Functions
    • Use Basic PowerPivot
    • Use PowerPivot with Large DataSets
    • Create PowerPivot Linked Tables
    • Publish to SharePoint
    • Automating Data Refresh
    • Analyzing Usage Data
  • Reporting Services
    • Configure Reporting Services
    • Create a Reporting Services Report
    • Configure Reporting Services Web Part
    • Create Advanced Reporting Services report
    • Filter Web Parts and Reports
    • Create Report Part Gallery
    • Create a Report Library
    • Create Report Parts
    • Create a Report using Report Parts
    • Automated Report Delivery
  • Performance Point
    • Explore Performance Service Application
    • Explore the Dashboard Designer
    • Create A Scorecard
    • Create A PP KPI
    • Explore Time Intelligence
    • Create Performance Point Reports
    • Create Filters
    • Create A Dashboard
  • Visio & Access Services
    • Use Visio Services
    • Publish a Visio to SharePoint
    • Tie report process to Visio
    • Explore Access Services
    • Publish Access Database To SharePoint
  • GeoSpatial Data with Charts & Maps
    • Utilize the new Spatial Data Types in SQL Server
    • Explore new features of SQL Server Management Studio
    • Utilize Bing Maps API
    • Create a Simple Map With Content Editor Web Part
    • Create an Advanced Map with Data Views
    • Explore Filters, Data Views and Bing Maps integration
    • Integrate Geospatial Customer data into SharePoint Sites
    • Utilize .NET Charts