Master big data analytics in Excel with hands-on examples and real-world case studies. Learn Power Pivot and create interactive dashboards without any programming.
This course is all about mastering big data analytics with Excel! You’ll dive into Power Pivot, crunching and combining large datasets without any programming. It's super hands-on, with real examples to make learning stick. Get ready to become a data whiz in just a few days!
Don't just crunch Data - Crush it!
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.
Use excel to work with big data
Work with diverse multiple data sources
Better understand how databases works
2 Lectures
5 Lectures
1 Lectures
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...
Am New to Excel and I have found something interesting. Good one
Great course. I learnt a lot. Thank you so much.
Well structured course. Learned other useful Excel tricks not directly related to power pivot as well.
Appreciate that author uses real world examples. Good audio/video quality.
This is a really great overview of Power Pivot for newbies just getting started. However, don't take it expecting to learn how Excel interacts with big data technologies like Hadoop, or if you are already familiar with PowerPivot. You can find a lot more detailed and complex examples on YouTube by the ExcelIsFun guy.
I liked course material. But then best part are projects, where hands on experience could be gained.
this course doesnt really teach much more than obvious things
Your email address will not be published. Required fields are marked *
Rendra T. S. M.
This topics is rarely..!