Decoding Data Mining and ETL techniques with MS Excel 2013

Rapid Skillz

Preis auf Anfrage

Wichtige informationen

  • Short course
  • Beginner
  • Online
  • Dauer:
    1 Year
  • Wann:
    Freie Auswahl

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.

Wichtige informationen
Welche Ziele verfolgt der Kurs?

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.

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


Wo und wann

Beginn Lage
Freie Auswahl

Was lernen Sie in diesem Kurs?

Data Mining
MS Excel


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.

Zusätzliche Informationen

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