Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Big Data in Excel - Excel 2010/2013 Power Pivot
Rating: 3.7 out of 5(10 ratings)
485 students
Created byMangirdas Adomaitis
Last updated 5/2014
English

What you'll learn

  • Use excel to work with big data
  • Work with diverse multiple data sources
  • Better understand how databases works
  • Creation of pivot tables and pivot charts
  • Build custom dashboards to answer business questions

Course content

9 sections • 26 lectures • 1h 23m total length

  • Power Pivot overview3:48

    Introduction to the course. How and what we will learn!

  • Course Logistics1:56

    Let's talk a bit about how the learning will take place. Some tips to even better understand the topics.

  • Downloadable material0:15

    Here are the data used later in the course. If you consider recreating example yourself or just trying things out - please download these files and find file you are interested in.

    Good luck crunching big data!

Requirements

  • Computer with excel version 2010 or higher
  • Introductory knowledge of excel would be good to have, but not required

Description

Learn big data analytics directly in Excel 2010 or 2013.

Power Pivot is free Excel add-in developed by Microsoft. It is designed to deal with large complex data sets. No programming required!

Always working on real examples - the course is specifically based on real world use cases. No long slides, but rather hands on examples. All material used in lectures is available for download. Students are highly encouraged to experiment with data themselves.

Comprehensive assignments will be available after each section. These will let you check newly acquired knowledge in practice.

At any time I will be available to answer questions or simply discuss some interesting topic.

At the end of the course you will feel comfortable in multiple areas:

  1. Working with large datasets
  2. Combine data from totally different data sources much more effectively
  3. Best practices on working with pivot tables and pivot charts
  4. Creating interactive dashboards to answer business questions
  5. Better understanding how databases are designed

Taking into account exercises and assignment, course could be completed in a ~4 days 2-3 hours per day.

Let's get ready for era of big data.

Who this course is for:

  • Ones interested in better ways to extract value from the data
  • Excel practitioners looking for ways to leverage Excel more effectively
  • Anyone who would like to sharpen their analytical skills

Report abuse