PowerPivot & Power BI

Network Academy Eğitimlerini İnceleyin!

PowerPivot & Power BI

PowerPivot & Power BI

Overview
A simple introduction module.

PowerPivot Introduction
PowerPivot Data Sources

Supported Data Sources

o Load Data From SQL Server
o Load Data From Text Files
o Load Data via Copy and Paste
o Cleaning Data
o Creating Relationships

PowerPivot Functions

o Create a Time Table for future labs
o Use DATE Function
o Use DATEVALUE Function
o Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
o Use EDATE Function
o Use EOMONTH Function
o Use NOW and TODAY Functions
o Use TIME and TIMEVALUE Functions
o Use WEEKDAY and WEEKNUM Functions
o Use FIRST* and LAST* Functions
o Use DATE* Functions
o Use STARTOF* and ENDOF* Functions
o Use CLOSING* and OPENING* Functions
o Use LASTOF* and FIRST* Functions
o Use PREVIOUS* and NEXT* Functions
o Use AVERAGE* Functions
o Use COUNT* Functions
o Use MAX* and MIN* Functions
o Use ALL, ALLEXCEPT and ALLNOBLANKROW
o Use CALCULATE, CALCULATETABLE
o Use DISTINCT
o Use EARLIER and EARLIEST
o Use FILTER
o Use REALTED, RELATEDTABLE
o Use VALUES
o Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
o Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
o Use TEXT Functions

Building Reports using PowerPivot

o Use PivotCharts
o Use Slicers
o Use Sparklines

Search and Combine data Power Query
Explore and Visualize with Power View
Explore and Visualize with Power Map

EĞİTİM BİLGİ TALEP FORMU

Mesajınız