Decoding Data Mining and ETL techniques with MS Excel 2013

Rapid Skillz

Price on request

Important information

  • Short course
  • Beginner
  • Online
  • Duration:
    1 Year
  • When:

Power BI is a suite of business analytics tools to analyze data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all of their devices. This course is intended for the data analysts and end users who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

Important information
What are the course objectives?

The Objective of this course is to enable understudies to understand and 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.

Requirements: Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.


Where and when

Starts Location

What you'll learn on the course

Data Mining
MS Excel

Course programme

This Course Consists of the following contents- 1.Importing data present in other formats, 2.Intro to Power Query for Excel 2013 - loading big datasets into spreadsheets, 3.Using ETL techniques to gather data from multiple sources - Wikipedia, Oracle MySQL DB & others, 4.Formatting columns and modifying data types dynamically ; using simple DAX commands, 5.Linking Excel to external data sources / websites, 6.Exploring new components of Charts in MS Excel, 7.Introduction to Power Pivot tool to create instant Data Models and link tables, 8.Overview of visualization of geographical data. With these topics and subjects and our delivery method, you will be able to understand and fulfil your position’s responsibilities. We deliver our courses with an online methodology in order to adapt ourselves to busy and professional lifestyles. Combine your professional life, your work, your personal time with this distance-learning course. If you have any doubts, do not hesitate to ask for more information through Emagister’s website.

Additional information

This Course is made for Students and they are Able to create accurate, complete and timely reports from your enterprise system, Better career enhancement.