Decoding Data Mining and ETL techniques with MS Excel 2013
3.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
668 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Decoding Data Mining and ETL techniques with MS Excel 2013 to your Wishlist.

Add to Wishlist

Decoding Data Mining and ETL techniques with MS Excel 2013

This course explore Data Mining techniques using Power BI tools in Microsoft Excel 2013
3.5 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
668 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 3 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Some knowledge of basic word processing, computing, and spreadsheets
  • Familiarity with the Microsoft Office work environment
Description

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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 02:10:45
+
Course Introduction
1 Lecture 02:23
+
Importing data present in other formats
1 Lecture 09:32
+
Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets
1 Lecture 19:58
Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets
19:58
+
Using ETL techniques to gather data from multiple sources - Oracle MySQL DB
1 Lecture 11:02
+
Formatting columns and modifying data types dynamically ; using simple DAX cmds
1 Lecture 09:32
Formatting columns and modifying data types dynamically ; using simple DAX cmds
09:32
+
Linking Excel to external data sources / websites
1 Lecture 11:25
Linking Excel to external data sources / websites
11:25
+
Exploring new components of Charts in MS Excel
2 Lectures 28:11
Exploring new components of Charts in MS Excel Part 1
17:09

+
Introduction to Power Pivot tool to create instant Data Models and link tables
2 Lectures 26:44
Introduction to Power Pivot tool to create instant Data Models Part 1
18:01

Introduction to Power Pivot tool to create instant Data Models Part 2
08:43
+
Overview of visualization of geographical data
1 Lecture 00:47
+
Additional Material
1 Lecture 00:00
3 More Sections
About the Instructor
GreyCampus Inc.
4.1 Average rating
1,625 Reviews
19,352 Students
37 Courses
Professional Certification and Competitive Exam Trainings

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.