Big Data in Excel - Excel 2010/2013 Power Pivot

Don't just crunch Data - Crush it!
4.0 (8 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
458 students enrolled
$19
$65
71% off
Take This Course
  • Lectures 26
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2014 English

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

What are the requirements?

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

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
03:48

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

01:56

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

Article

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!

Section 2: Installation
04:05

Installing Power Pivot is a breeze:

Excel 2010:

  1. Go here.
  2. Press download and select "1033\x64\PowerPivot_for_Excel_amd64.msi" for 64 bit machine or "1033\x86\PowerPivot_for_Excel_x86.msi" for 32 bit machine.
  3. After downloaded open the install file.
  4. Use default settings for installation.
  5. After installation is completed - open excel and Power Pivot ribbon will be available.

Excel 2013:

Power Pivot comes pre-installed with Office Professional Plus or Office 365. However, it should be still enabled:

  1. Go to File > Options -> Add-Ins.
  2. In the Manage box, click COM Add-ins -> Go.
  3. Check the Microsoft Office Power Pivot in Microsoft Excel 2013 box, and then click OK.
  4. Power Pivot ribbon will be enabled.
Section 3: Data Import
Text Files
Preview
03:16
Excel Files
03:23
Access Database
05:10
SQL Database
04:00
Other Possibilities
Article
Section 4: Tables and Data Model
Introduction
02:37
Example
05:11
Section 5: Relationships
Introduction
05:13
Example
05:03
Assignment - "Creating sample Power Pivot database"
Article
Section 6: Calculating Columns
Single Table
04:59
Example
04:00
Multiple Tables
04:14
Assignment - "Forest data analysis"
Article
Additional material
Article
Section 7: Building Pivot Tables
Simple Tables
04:31
Customization
04:06
Slicers
05:43
Filters
06:11
Assignment - "Building dashboards!"
Article
Section 8: Additional material
N to M relationship example
Article
Section 9: Final Thoughts
Round Up
01:25

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mangirdas Adomaitis, Data analyst, Online Advertising specialist

Data analyst with more than 3 years of experience.

Employing various tools for data analysis. Always picking the right tool to do the job. I use R package often combining it with Excel, SQL databases and Access on daily basis.

Graduated econometrics from Vilnius University faculty of Mathematics and Informatics. Afterwards I worked as economical forecaster. Currently my position being analyst of online advertising data in leading advertising platform - focusing on insights from large datasets.

I am constantly participating in events/conferences regarding data analysis. Currently interested in open data initiatives - possibilities to open up more government data for public use. Participating in contests of predictive analytics.

Let me know if you have any questions/suggestions regarding data and analysis. You can find my on Google+ or Linkedin.

Ready to start learning?
Take This Course