Study from a 30+ 12 months Information Knowledgeable

What you’ll be taught

  • Learn how to use PowerPivot from a 30+ 12 months Information Evaluation skilled. You’ll go from Newbie to Superior
  • Get accustomed to the Excel Information Mannequin and be taught elementary Information Modelling ideas
  • Perceive the right way to load information into the Information Mannequin from a wide range of sources, comparable to Excel Tables, Exterior Databases and way more
  • Discover ways to use Pivot Tables along side PowerPivot together with arrange of Relationships
  • What are measures and why they’re so elementary to PowerPivot and the right way to add implicit or specific measures comparable to Autosum
  • Working with Iterator capabilities comparable to TOPN and REATEDTABLE
  • The significance of Hierarchies in a Pivot Desk: Drill paths, Associated columns and greatest practices with Hierarchies
  • Learn how to greatest leverage PowerPivot’s Calculation Engine utilizing Information Analytics Expressions (DAX)
  • Superior information manipulation with using Context and Filter capabilities
  • Use Time-Intelligence capabilities to control information utilizing time durations, comparable to days, months, quarters and years examine calculations over these durations


  • A duplicate of Excel 365,2019, 2016, 2013 or for 2010 you have to the PowerPivot Add in
  • An intermediate talent degree with Excel, be capable to do Evaluation with VLOOKUP, IF, SUMIF/COUNTIF and an excellent understanding of Pivot Tables

Who this course is for:

  • The extra Superior Excel person, Analyst and even Accountant who wants to have the ability to cope with many sources of information or excessive volumes of information with out resorting to a database

Enroll Now

Leave a Comment

Your email address will not be published.