Power Pivot Basics

This tutorial walks you through working with PowerPivot for Excel.

Note: Click on the respective links in the Index Section to refer to any of the topics listed below.

Topics Covered

  • Introduction
    • What is PowerPivot (Refer PowerPivot-01)
    • Different Flavors of PowerPivot (Refer PowerPivot-01)
    • Salient Features (Refer PowerPivot-01)
  • Installing PowerPivot Add-In for Excel (Refer PowerPivot-02)
  • Importing Data Into PowerPivot
    • List of Data Sources Supported by PowerPivot (Refer PowerPivot-03)
    • Importing data from SQL Server directly from Table (Refer PowerPivot-03)
    • Importing data from SQL Server using SQL Query (Refer PowerPivot-03)
    • Importing data from CSV (Excel) file (Refer PowerPivot-03)
    • Using Existing Connection (s) to import data into PowerPivot (Refer PowerPivot-03)
  • Creating Linked Tables in PowerPivot
    • Maintain live connection between a PowerPivot Table and an Excel Sheet (Refer PowerPivot-04)
  • Consolidating the Data into Single PowerPivot Table
    • Combine the data from two or more relational sources into a single table in PowerPivot (Refer PowerPivot-05)
  • Working with Column Properties
    • How to set Description for Columns in PowerPivot (Refer PowerPivot-06)
    • How to set and modify Column Data Types in PowerPivot (Refer PowerPivot-06)
    • How to apply formatting to Column Data in PowerPivot (Refer PowerPivot-06)
    • How to Show or Hide the Columns in PowerPivot (Refer PowerPivot-06)
    • How to Sort Data in one Column with Data in another Column in PowerPivot (Refer PowerPivot-06)
  • Creating Hierarchies
    • Creating Hierarchies in PowerPivot for Excel (Refer PowerPivot-07)

URL Index

Advertisements

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: