Decoding Data Mining and ETL techniques with MS Excel 2013 - Online Self Learning

This course is intended for the data analysts and end users who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

USD 199

Enroll
1 year e-learning access
Hands-on videos
Data sets and Exercises
Additional Materials

Course Objectives :

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

  • Explore and connect to data sources using Power Query

  • Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle MySQL DB & others

  • Comprehend the Power Pivot user interface

  • Extract and transform data using Power Query

  • Build a cascading relationship and manage data models

  • Build a relationship between tables from different sources

  • High impact, proven training – 30000+ professionals trained globally

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.

  • Classroom Training programs delivered across 50+ locations globally

  • Content is developed in-house in GreyCampus by highly experienced industry experts