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

Rapid Skillz
Online

Chiedi il prezzo

Informazione importanti

  • Short course
  • Beginner
  • Online
  • Durata:
    1 Year
  • Quando:
    Da definire
Descrizione

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.

Informazione importanti
Quali sono gli obiettivi della formazione?

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.

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

Sedi

Dove e quando

Inizio Luogo
Da definire
Online

Cosa impari in questo corso?

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

Programma

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.

Ulteriori informazioni

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.