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.8 (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.
653 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 15
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 1/2016 English

Course 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.

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?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
Course Introduction
Preview
02:23
Section 2: Importing data present in other formats
Importing data present in other formats
Preview
09:32
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
19:58
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 DB
Preview
11:02
Section 5: Formatting columns and modifying data types dynamically ; using simple DAX cmds
Formatting columns and modifying data types dynamically ; using simple DAX cmds
09:32
Section 6: Linking Excel to external data sources / websites
Linking Excel to external data sources / websites
11:25
Section 7: Exploring new components of Charts in MS Excel
Exploring new components of Charts in MS Excel Part 1
17:09
Exploring new components of Charts in MS Excel Part 2
Preview
11:02
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
18:01
Introduction to Power Pivot tool to create instant Data Models Part 2
08:43
Section 9: Overview of visualization of geographical data
Overview of visualization of geographical data
Preview
00:47
Section 10: Additional Material
Additional Material
Preview
10 pages
Section 11: Exercises
Exercises
Preview
Article
Section 12: Mock Test
Mock Test
20 questions
Section 13: Course Conclusion
Review Appreciated
Article
Bonus Lecture on Decoding Data Mining and ETL techniques with MS Excel 2013
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., 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.

Ready to start learning?
Take This Course