microsoft access vs. microsoft powerpivot kate lynch
TRANSCRIPT
![Page 1: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/1.jpg)
MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT
Kate Lynch
![Page 2: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/2.jpg)
What Do These Have in Common
![Page 3: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/3.jpg)
![Page 4: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/4.jpg)
Why Do People Even Need Access or PowerPivot?
Excel is useful to use for creating spreadsheets, formulas, and sorting through information.
When dealing with large amounts of information Excel is no longer the best resource to use.
Excel can only handle small data sets of information.
![Page 5: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/5.jpg)
What is Microsoft Access?
Access is made up of seven major component Tables, Relationships, Queries, Forms,
Reports, Macros and Modules.
![Page 6: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/6.jpg)
Tables and Relationships
Tables Store data entered into the database. If not entered properly, the database may
not act correctly. Relationships
Are the bonds you build between the tables They join tables that have associated
elements
![Page 7: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/7.jpg)
Weakness of Access
VLOOKUP Function Needed to join tables together in Access.
PowerPivot allows the user to define a relationship between two or more items
Once a relationship is defined a user only has to relate the columns together in order obtain the information needed.
![Page 8: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/8.jpg)
What is PowerPivot and how is it Different?
Built in to Excel
Process massive amounts of data in seconds Load data sets from any source Contains a powerful new formula language, Data
Analysis Expressions (DAX), which includes 60 new functions.
http://www.youtube.com/watch?v=ms149Qi2PVA
![Page 9: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/9.jpg)
Access Compared to PowerPivot
ACCESS
POWERPIVOT
• Maximum Number of Rows• 64,000
• Maximum Storage Capability • 2 GB
• Number of Formulas• 80
• Maximum Number of Rows• Unlimited
• Maximum Storage Capability • 4 GB
• Number of Formulas• 160
![Page 10: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/10.jpg)
Importing Data
![Page 11: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/11.jpg)
Why PowerPivot is Better
It is not a new program that needs to be learned.
Uses PivotTables and Excel Functions.
Information can be organized and sorted faster.
Enhanced user features have been and will continue converting Access users over to PowerPivot.
http://www.microsoft.com/en-us/bi/powerpivot.aspx
![Page 12: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/12.jpg)
Questions?
![Page 13: MICROSOFT ACCESS VS. MICROSOFT POWERPIVOT Kate Lynch](https://reader036.vdocuments.us/reader036/viewer/2022062308/56649d215503460f949f60dc/html5/thumbnails/13.jpg)
Sources http://cdn.iphonehacks.com/wp-content/uploads/2012/09/iphone5-front-back.jpg
http://xghuang.blogspot.com/2012/08/a-simple-tutorial-on-powerpivot-2.html
http://www.asia.ru/images/target/photo/50071127/MP3_CD_Player.jpg
http://images.apple.com/ipod-touch/images/overview_hero.png
http://i.msdn.microsoft.com/dynimg/IC296664.bmp
http://www.dotnetjohn.com/Images/ECL_Excel.JPG