big data excel alternative – Excel 2010/2013 Power Pivot Online Course Review

Don’t just crunch Data – Crush it!

big data excel alternative – Excel 2010/2013 Power Pivot Online Course Review

big data excel alternative – Excel 2010/2013 Power Pivot

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?

  • Over 26 lectures and 1.5 hours of content!
  • 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

big data excel alternative – Excel 2010/2013 Power Pivot course is Very good course that step by step explains in a high definition recording of a presentation. if you want to better understand, develop your skills, you will greatly benefit from this online course.

Start Free Preview big data excel alternative – Excel 2010/2013 Power Pivot Online Course:

Don’t just crunch Data – Crush it!

h3>Curriculum

Section 1: Introduction
Lecture 1 03:48

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

Lecture 2 01:56

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

Lecture 3 Text

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
Lecture 4 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
Lecture 5
Text Files
03:16
Lecture 6
Excel Files
03:23
Lecture 7
Access Database
05:10
Lecture 8
SQL Database
04:00
Lecture 9
Other Possibilities
Text
Section 4: Tables and Data Model
Lecture 10
Introduction
02:37
Lecture 11
Example
05:11
Section 5: Relationships
Lecture 12
Introduction
05:13
Lecture 13
Example
05:03
Lecture 14
Assignment – “Creating sample Power Pivot database”
Text
Section 6: Calculating Columns
Lecture 15
Single Table
04:59
Lecture 16
Example
04:00
Lecture 17
Multiple Tables
04:14
Lecture 18
Assignment – “Forest data analysis”
Text
Lecture 19
Additional material
Text
Section 7: Building Pivot Tables
Lecture 20
Simple Tables
04:31
Lecture 21
Customization
04:06
Lecture 22
Slicers
05:43
Lecture 23
Filters
06:11
Lecture 24
Assignment – “Building dashboards!”
Text
Section 8: Additional material
Lecture 25
N to M relationship example
Text
Section 9: Final Thoughts
Lecture 26
Round Up
01:25

big data excel alternative – Excel 2010/2013 Power Pivot is full of helpful insights, creative strategies, and much more to help you prepare yourself effectively. big data excel alternative – Excel 2010/2013 Power Pivot is a huge time saver for your skill upgrading. This is a new course that integrates succesfuly other courses. Every section is in fact a course on its own. Interesting, practical and informative, the course responds to my needs and the instructor makes it engaging.

big data excel alternative – Excel 2010/2013 Power Pivot Student Reviews

  • Well structured

    Well structured course. Learned other useful Excel tricks not directly related to power pivot as well. – Trev84

  • Nice course

    Appreciate that author uses real world examples. Good audio/video quality. – Anna Scott

big data excel alternative – Excel 2010/2013 Power Pivot Instructor Biography
big data excel alternative - Excel 2010/2013 Power Pivot instructor
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.


Take This Course big data excel alternative – Excel 2010/2013 Power Pivot :

download big data excel alternative - Excel 2010/2013 Power Pivot

related big data excel alternative – Excel 2010/2013 Power Pivot

easiest way big data excel alternative – Excel 2010/2013 Power Pivot, How to big data excel alternative – Excel 2010/2013 Power Pivot, easy and simple big data excel alternative – Excel 2010/2013 Power Pivot, best big data excel alternative – Excel 2010/2013 Power Pivot, big data excel alternative – Excel 2010/2013 Power Pivot course, big data excel alternative – Excel 2010/2013 Power Pivot ebook

Leave a Reply

Your email address will not be published. Required fields are marked *