E-book details

Instant Creating Data Models with PowerPivot How-to. Build better business intelligence with this practical guide to creating Excel data models with PowerPivot

Instant Creating Data Models with PowerPivot How-to. Build better business intelligence with this practical guide to creating Excel data models with PowerPivot

Leo Taehyung Lee, Taehyung Lee

Ebook
Microsoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computer's powers to draw data from various sources, do analysis across millions of rows of data, and present results in a very unique format.

Instant Creating Data Models with PowerPivot How-to is a concise and to-the-point guide that helps you get a jump start on using this strong business intelligence tool, while still working in an environment similar to Excel. You will begin with data generation and manipulation, learning a new feature at each step by building onto the old file, and ultimately creating a comprehensive file.

Instant Creating Data Models with PowerPivot How-to will guide the user through database installation, importing data from various sources, creating pivot charts and tables, utilizing a unique feature of PowerPivot called slicers,adding custom columns, and setting custom relationships between data to generate the ultimate customized dataset for analysis. By the end of the book and all the sections of Microsoft PowerPivot for Excel, the reader will be fully experienced and ready to utilize this powerful software.
  • Instant Creating Data Models with PowerPivot How-to
    • Instant Creating Data Models with PowerPivot How-to
    • Credits
    • About the Author
    • About the Reviewer
    • www.PacktPub.com
      • Support files, eBooks, discount offers and more
        • Why Subscribe?
        • Free Access for Packt account holders
    • Preface
      • What this book covers
      • What you need for this book
      • Who this book is for
      • Conventions
      • Reader feedback
      • Customer support
        • Downloading the sample files
        • Errata
        • Piracy
        • Questions
    • 1. Instant Creating Data Models with PowerPivot How-to
      • Installation (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • Theres more...
      • Importing data from the database (Advanced)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Excel 2013
      • Importing data from other files (Simple)
        • How to do it...
        • How it works...
        • There's more...
      • Filtering the data to be imported (Intermediate)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
      • Creating a pivot table (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
      • Creating a pivot chart (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
      • Managing data relationships (Simple)
        • How to do it...
        • How it works...
        • There's more...
          • Creating custom tables instead of connecting relationships
      • Adding new custom columns (Intermediate)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
      • Making the data look presentable (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
      • Publishing as Excel (Simple)
        • Getting ready
        • How to do it...
        • How it works...
        • There's more...
          • Version compatibility issue
  • Title: Instant Creating Data Models with PowerPivot How-to. Build better business intelligence with this practical guide to creating Excel data models with PowerPivot
  • Author: Leo Taehyung Lee, Taehyung Lee
  • Original title: Instant Creating Data Models with PowerPivot How-to. Build better business intelligence with this practical guide to creating Excel data models with PowerPivot.
  • ISBN: 9781849689571, 9781849689571
  • Date of issue: 2013-04-25
  • Format: Ebook
  • Item ID: e_2x68
  • Publisher: Packt Publishing