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! PowerBI is Microsoft's flagship tool for making big data analysis accessible to the average Office Power User. Always working on real examples - the course is specifically based on real world use cases. No long slides, but rather hands on examples. Learn how to work with large datasets, combining data from totally different data sources, use effective best practices on working with pivot tables and pivot charts Using Power Pivot and PowerBI. Learn how create interactive dashboards, and build custom dashboards to answer business questions. All material used in lectures is available for download. Students are highly encouraged to experiment with data themselves.
Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work.