Big Data in Excel - Excel 2010/2013 Power Pivot
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
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:
- Working with large datasets
- Combine data from totally different data sources much more effectively
- Best practices on working with pivot tables and pivot charts
- Creating interactive dashboards to answer business questions
- 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
Instructor
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.