Big Data in Excel - Excel 2010/2013 Power Pivot
3.9 (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.
464 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Big Data in Excel - Excel 2010/2013 Power Pivot to your Wishlist.

Add to Wishlist

Big Data in Excel - Excel 2010/2013 Power Pivot

Don't just crunch Data - Crush it!
3.9 (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.
464 students enrolled
Last updated 5/2014
English
Current price: $10 Original price: $65 Discount: 85% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 7 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
01:23:30
+
Introduction
3 Lectures 05:58

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

Preview 03:48

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

Preview 01:56

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!

Downloadable material
00:14
+
Installation
1 Lecture 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.
Preview 04:05
+
Data Import
5 Lectures 16:11

Excel Files
03:23

Access Database
05:10

SQL Database
04:00

Other Possibilities
00:22
+
Tables and Data Model
2 Lectures 07:48
Introduction
02:37

Example
05:11
+
Relationships
3 Lectures 11:08
Introduction
05:13

Example
05:03

Assignment - "Creating sample Power Pivot database"
00:52
+
Calculating Columns
5 Lectures 14:20
Single Table
04:59

Example
04:00

Multiple Tables
04:14

Assignment - "Forest data analysis"
01:00

Additional material
00:07
+
Building Pivot Tables
5 Lectures 21:35
Simple Tables
04:31

Customization
04:06

Slicers
05:43

Filters
06:11

Assignment - "Building dashboards!"
01:04
+
Additional material
1 Lecture 00:33
N to M relationship example
00:33
+
Final Thoughts
1 Lecture 01:25
Round Up
01:25
About the Instructor
Mangirdas Adomaitis
3.5 Average rating
30 Reviews
1,503 Students
2 Courses
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.