The Inside Story: Self-Service-BI in MS Excel 2013

Rapid Skillz
Online

Precio a consultar

Información importante

  • Short course
  • Beginner
  • Online
  • Duración:
    1 Year
  • Cuándo:
    A definir
Descripción

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features. Microsoft Excel still remains the top Business Intelligence tool in use today, and it will continue its reign despite marketing efforts of other BI technology vendors. Since most of the organizations already have highly skilled Excel users, they migrate swiftly to a self-service BI capability and tend to create their own BI solution intuitively without much dependence on IT. 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.

Información importante
¿Qué objetivos tiene esta formación?

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.

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

Sedes

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Online

¿Qué aprendes en este curso?

Excel
IT
Microsoft Excel
Project
Business Intelligence
Microsoft excel training
MS Excel

Programa académico

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 ¡n MS Excel, 7.Introduction to Power Pivot tool to create instant Data Models and link tables, 8.Overview of visualization of geographical data. Through these subjects skills are developed and knowledge is acquired in order to fulfil a position or job efficiently and with confidence. Our online methodology makes it easier to combine your professional and personal life. Even you have a busy day to day live, this course adapts itself to your routine. Should you have any doubts, please do not hesitate to ask for more information through Emagister, leading educational portal.

Información adicional

This Course is made for Students and the Self-service business intelligence tools are becoming more and more desirable, and robust, as companies look for ways to enable all types of users, including casual users, power users, and executives to independently perform new queries, reports, analytics, and dashboards. Self-service BI has been a hot topic for the last several years because of the potential benefits it can offer organizations.