Instant Creating Data Models with PowerPivot How-to

Build better business intelligence with this practical guide to creating Excel data models with PowerPivot.

Key Features

• Learn something new in an Instant! A short, fast, focused guide delivering immediate results
• Detailed, step-by-step interactive tutorial guide to learning PowerPivot
• Carefully organized topics for users of all levels
• Learn how to make your data accessible and attractive

Book Description

What you will learn

• Install a database and import/export data freely
• Collect and combine data across various sources and formats
• Understand relationships between various data
• Develop complex tables and models for future analysis
• Design meaningful charts and tables easy for everyone to understand
• Write custom codes to modify data to a required form
• Extend PowerPivot with external programs for further collaboration

Who this book is for

This is an introductory book on PowerPivot for basic Excel users who handle lots of data and are willing to go beyond the limitations of Excel without the need to learn a new language from scratch.