Analyzing Data with Excel [20779]

Beskrivelse

Lær at bruge Excels datamodel til avanceret dataanalyse med BI-teknikker. Kurset omhandler bl.a. pivottabeller og -diagrammer, Excels datamodel, import af data fra forskellige kilder, DAX, oprettelse af BI dashboard med Excel og en kort introduktion til Power BI.

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of relational databases
Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals
Basic knowledge of data analytics

This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

After completing this course, students will be able to:

Explore and extend a classic Excel dashboard
Explore and extend an Excel data model
Pre-format and import a .CSV file
Import data from a SQL Server database
Import data from a report
Create measures using advanced DAX functions
Create data visualizations in Excel
Create a Power BI dashboard with Excel

Module 1: Data Analysis in Excel

Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis

Module 2: The Excel Data Model

Using an Excel Data Model
DAX

Module 3: Importing Data from Files

Importing Data into Excel
Shaping and Transforming Data
Loading Data

Module 4: Importing Data from Databases

Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data

Module 5: Importing Data from Excel Reports

Importing Data from Excel Reports
Transforming Excel report Data

Module 6: Creating and Formatting Measures

DAX
Measures
Advanced DAX Functions

Module 7: Visualizing Data in Excel

Pivot Charts
Cube Functions
Charts for Cube Functions

Module 8: Using Excel with Power BI

Power BI
Uploading Excel Data to Power BI
Power BI Mobile App

Kurset kan betales med 3 SA vouchere.

Kurset leder hen mod eksamen 70-779 Analyzing Data With Excel. Eksamen bestilles og betales særskilt. Eksamen 70-779 og 70-778 er en del af certificeringen MCSA BI Reporting.

Læs mere om IT Certificering her.

Undervisningen varetages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.