Decoding Data Mining and ETL techniques with MS Excel 2013

WEBRip | MP4/AVC, ~671 kb/s | 1280 x 720 | English: AAC, 64.5 kb/s (2 ch), 44.1 KHz | 579 MB

Genre: Office Productivity / Microsoft | Language: English | +Project Files

This course explore Data Mining techniques using Power BI tools in Microsoft Excel 2013

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.

What are the requirements?

Some knowledge of basic word processing, computing, and spreadsheets

Familiarity with the Microsoft Office work environment

What am I going to get from this course?

Over 13 lectures and 2 hours of content!

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

What is the target audience?

Anyone who uses MS Excel as part of their job or profession can choose this course

There is no eligibility Criteria