Analyzing Data With Excel

Cena

390.00

Lokacija

Beograd,
Online,
In-house

Trajanje kursa

3 dana / 21 sat

Datum

Po dogovoru

Prijava

Plan obuke:

Module 1: Data Analysis in Excel

  • This module looks at the classic Excel dashboard and at ways to extend it.
    • Classic Data Analysis with Excel
    • Excel Pivot Tables
    • Limitations of Classic Data Analysis

Module 2: The Excel Data Model

  • This module looks at the classic Excel data model and at ways to extend it.
    • Using an Excel Data Model
    • DAX

Module 3: Importing Data from Files

  • This module looks at pre-formatting and importing CSV files.
    • Importing Data into Excel
    • Shaping and Transforming Data
    • Loading Data

Module 4: Importing Data from Databases

  • This module looks at how to import data into Excel from a SQL Server database.
    • Available Data Sources
    • Previewing, Shaping, and Transforming Data
    • Table Relationships and Hierarchies
    • Loading Data

Module 5: Importing Data from Excel Reports

  • This module describes how to import data from a report.
    • Importing Data from Excel Reports
    • Transforming Excel report Data

Module 6: Creating and Formatting Measures

  • This module describes how to create and format measures.
    • DAX
    • Measures
    • Advanced DAX Functions

Module 7: Visualizing Data in Excel

  • This module describes how to visualize data in Excel.
    • Pivot Charts
    • Cube Functions
    • Charts for Cube Functions

Module 8: Using Excel with Power BI

  • This module describes how to use Excel with Power BI.
    • Power BI
    • Uploading Excel Data to Power BI
    • Power BI Mobile App

Benefiti:

  • Video snimak predavanja u periodu od 365 dana posle kraja obuke
  • Pristup laboratorijama putem Interneta 180 dana od kraja obuke
  • Materijal u elektronskom obliku
  • Zvaničan Microsoft sertifikat o pohađanju kursa
  • Mogućnost korišćenja Microsoft SA vaučera za plaćanje ove obuke

Poželjno predznanje:

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Good Knowledge of Excel spreadsheets, functions, and charts.
  • Working knowledge of relational databases.

Dalje usavršavanje:

Master Data Services, Data Quality Services with SQL 2012 -2014 and Excel
Analyzing Data with Power BI