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.
Forudsætninger
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
Deltagerprofil
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
Indhold
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
Software Assurance Vouchere Kurset kan betales med 3 SA vouchere.
Certificering 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.
Underviser Undervisningen varetages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.
