MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Big Data in Excel - Excel 2010/2013 Power Pivot

Course Summary

Don't just crunch Data - Crush it!


  • +

    Course Syllabus

    • Introduction
      • Power Pivot overview
      • Course Logistics
      • Downloadable material
    • Installation
      • Installing Power Pivot for Excel 2010 or 2013
    • Data Import
      • Text Files
      • Excel Files
      • Access Database
      • SQL Database
      • Other Possibilities
    • Tables and Data Model
      • Introduction
      • Example
    • Relationships
      • Introduction
      • Example
      • Assignment - "Creating sample Power Pivot database"
    • Calculating Columns
      • Single Table
      • Example
      • Multiple Tables
      • Assignment - "Forest data analysis"
      • Additional material
    • Building Pivot Tables
      • Simple Tables
      • Customization
      • Slicers
      • Filters
      • Assignment - "Building dashboards!"
    • Additional material
      • N to M relationship example
    • Final Thoughts
      • Round Up


Course Fee:
USD 69

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top