1 / 13

Microsoft Access vs. Microsoft Powerpivot

Microsoft Access vs. Microsoft Powerpivot. Kate Lynch. What Do These Have in Common. Why Do People Even Need Access or PowerPivot ?. Excel is useful to use for creating spreadsheets, formulas, and sorting through information.

nan
Download Presentation

Microsoft Access vs. Microsoft Powerpivot

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Microsoft Access vs. Microsoft Powerpivot Kate Lynch

  2. What Do These Have in Common

  3. 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.

  4. What is Microsoft Access? • Access is made up of seven major component • Tables, Relationships, Queries, Forms, Reports, Macros and Modules.

  5. 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

  6. Weakness of Access • VLOOKUP Function • Needed to join tables together in Access. • PowerPivotallows 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.

  7. 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

  8. 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

  9. Importing Data

  10. 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

  11. Questions?

  12. 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

More Related