The Resource Data modelling and analysis with Excel Power Pivot, Ian Littlejohn

Data modelling and analysis with Excel Power Pivot, Ian Littlejohn

Label
Data modelling and analysis with Excel Power Pivot
Title
Data modelling and analysis with Excel Power Pivot
Statement of responsibility
Ian Littlejohn
Title variation
Overview of Power Pivot for Excel
Creator
Speaker
Subject
Language
eng
Summary
"Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis. Power Pivot will improve your time to create reports, develop data analysis and gain insight into your data by at least 80%. Create relationships between tables of data without Vlookups Create powerful Key Metric and Key Performance Indicator calculations Manage and work with data models of millions of records of data Create powerful new dashboards and reports Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years. Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data. Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user."--Resource description page
Cataloging source
UMI
Characteristic
videorecording
http://library.link/vocab/creatorName
Littlejohn, Ian
LC call number
HF5548.4.M523
PerformerNote
Presenter, Ian Littlejohn
Runtime
162
http://library.link/vocab/subjectName
  • Business intelligence
  • Information visualization
  • Business
  • Information visualization
Technique
live action
Label
Data modelling and analysis with Excel Power Pivot, Ian Littlejohn
Link
http://databases.mvlc.org/connect/safari?uiCode=&xmlId=200000006A0432
Instantiates
Publication
Note
Title from resource description page (Safari, viewed June 28, 2019)
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Configuration of playback channels
unknown
Content category
two-dimensional moving image
Content type code
  • tdi
Content type MARC source
rdacontent
Control code
on1107052675
Dimensions
unknown
Extent
1 online resource
Form of item
online
Media category
  • computer
  • video
Media MARC source
  • rdamedia
  • rdamedia
Media type code
  • c
  • v
Medium for sound
other
Sound
sound
Sound on medium or separate
sound on medium
Specific material designation
  • remote
  • other
Stock number
CL0501000057
System control number
(OCoLC)1107052675
Video recording format
other
Label
Data modelling and analysis with Excel Power Pivot, Ian Littlejohn
Link
http://databases.mvlc.org/connect/safari?uiCode=&xmlId=200000006A0432
Publication
Note
Title from resource description page (Safari, viewed June 28, 2019)
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Configuration of playback channels
unknown
Content category
two-dimensional moving image
Content type code
  • tdi
Content type MARC source
rdacontent
Control code
on1107052675
Dimensions
unknown
Extent
1 online resource
Form of item
online
Media category
  • computer
  • video
Media MARC source
  • rdamedia
  • rdamedia
Media type code
  • c
  • v
Medium for sound
other
Sound
sound
Sound on medium or separate
sound on medium
Specific material designation
  • remote
  • other
Stock number
CL0501000057
System control number
(OCoLC)1107052675
Video recording format
other

Library Locations

    • Merrimack Valley Library ConsortiumBorrow it
      4 High Street, Suite 175, North Andover, MA, 01845, US
      42.7009413 -71.1255084
Processing Feedback ...