Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
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:
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
|Section 2: Importing data present in other formats|
Importing data present in other formatsPreview
|Section 3: Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets|
Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets
|Section 4: Using ETL techniques to gather data from multiple sources - Oracle MySQL DB|
Using ETL techniques to gather data from multiple sources - Oracle MySQL DBPreview
|Section 5: Formatting columns and modifying data types dynamically ; using simple DAX cmds|
Formatting columns and modifying data types dynamically ; using simple DAX cmds
|Section 6: Linking Excel to external data sources / websites|
Linking Excel to external data sources / websites
|Section 7: Exploring new components of Charts in MS Excel|
Exploring new components of Charts in MS Excel Part 1
Exploring new components of Charts in MS Excel Part 2Preview
|Section 8: Introduction to Power Pivot tool to create instant Data Models and link tables|
Introduction to Power Pivot tool to create instant Data Models Part 1
Introduction to Power Pivot tool to create instant Data Models Part 2
|Section 9: Overview of visualization of geographical data|
Overview of visualization of geographical dataPreview
|Section 10: Additional Material|
|Section 11: Exercises|
|Section 12: Mock Test|
|Section 13: Course Conclusion|
Bonus Lecture on Decoding Data Mining and ETL techniques with MS Excel 2013
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.