Decoding Data Mining and ETL techniques with MS Excel 2013

Course details

This course enables you to know more details about the data mining and ETL techniques. Whether you are new to Excel or an advanced user, Grey Campus Power BI course will cover what you need to know to become a Power BI User and how to gather and decode the data from multiple sources using advanced Ms Excel tools.

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

Each and every topic mentioned above are explained in the Hands-on videos. Exercises and datasets included in this course are useful to practice and implement the concepts learned in this course. For your reference,additional material is also provided.

This are course components included in the course:

• Hands-on videos.
• Mock Exams
• Datasets
• Additional Material
• Exercises

This course is is intended for the analysts and business users who are willing to explore the Power BI tools present in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers. This course is best apt to enhance your decoding skills in excel using various tools and techniques.