Data Analyst: Microsoft Power Pivot For Excel And SSAS (Tabular DAX model)
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)
Visualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool.
———-
📥 Download Practice Material from: bit.ly/3OJx3Xz
———–
VIDEO TIMESTAMPS ⏱👉
======================
00:00:00 What will we learn
00:03:09 Introduction
00:05:09 Software Requirements – PowerPivot
00:11:47 Source data
00:14:02 Activating PowerPivot on Excel E3 and E6
00:16:45 Installing PowerPivot on Excel E0
00:20:51 Creating our first model in PowerPivot
00:24:29 Using our first model in Excel
00:28:21 Creating and deploying our first model in Excel E0
00:33:02 Adding a second table – Importing Data from SQL Server
00:41:21 Importing Data from SQL Server
00:47:24 Practice Activity Number 1 – Solution
00:50:22 Introduction
00:52:23 Downloading AdventureWorksDW
00:54:23 Attaching AdventureWorksDW
00:59:03 Creating and deploying our first model in SSAS
01:04:00 Adding additional tables
01:06:29 Introduction to Practice Activity
01:08:15 Practice Activity Number 2 – Solution
01:11:58 Importing Data from Excel
01:15:09 Having problems importing from Excel
01:22:43 Filtering sorting and formatting fields
01:30:02 Hiding columns from Client Tools and other column tools
01:35:29 Refreshing (or processing) data
01:39:37 Creating quick measures
01:44:46 Perspectives
01:51:43 Hierarchies
01:58:56 PivotTable structure and non-Visual Totals
02:05:01 Show no data in rows and columns
02:07:59 Create running totals
02:10:23 Slicers and Timelines
02:13:38 Using formulas to query Data Model (Advanced)
02:17:24 DAX functions – An Introduction
02:20:19 Calculated columns – an introduction
02:23:01 Basic operators
02:27:35 IF
02:30:29 BLANK and ISBLANK
02:35:29 AND OR and NOT
02:39:16 SWITCH
02:43:25 Other functions
02:46:13 Measures – an introduction
02:50:12 Aggregation of columns
02:54:35 Aggregation of calculations
02:59:24 DISTINCTCOUNT
03:02:57 RANKG.EQ
03:04:07 Other functions
03:07:11 Rounding functions
03:13:01 Division functions – MOD and QUOTIENT
03:14:33 SIGN (and use with SWITCH) and ABS
03:18:28 Exponential functions
03:20:16 Other functions
03:24:02 Text searching
03:29:46 Text extraction and substitution
03:35:02 Text conversion
03:41:05 Other functions
03:42:27 ISERROR and LOOKUPVALUE
03:45:49 Other functions
03:47:39 RELATED
03:51:38 RELATEDTABLE and COUNTROWS
03:54:56 Context
03:58:40 FILTER
04:01:02 ALL
04:05:08 CALCULATE
04:08:04 ALLEXCEPT
04:09:13 ALLSELECTED
04:15:28 Other functions
04:18:04 Date and Time Functions
04:20:45 FIRSTDATE LASTDATE
04:23:00 Start of… and End of
04:25:04 Previous… and Next
04:30:15 DATESINPERIOD
04:32:54 DATESMTD DATESQTD DATESYTD TOTALMTD TOTALQTD TOTALYTD
04:35:42 Opening Balance and Closing Balance
04:37:02 SAMEPERIODLASTYEAR and PARALLELPERIOD
04:40:03 Other Functions
04:42:30 Downloading SQL Server back engine – the Developer edition – for free
04:50:20 Installing SQL Server back engine
05:02:25 Installing SQL Server Front Engine
05:15:00 Installing Visual Studio E9
05:19:52 Installing SSAS in Visual Studio E9
05:22:52 Is your Visual Studio a trial version No
———-
What you’ll learn
Extract data from multiple tables.
Create connections between the tables.
Develop the model using DAX functions.
Create analyses in Excel.
———-
Requirements
You need to be able to use Microsoft Excel, at least at a basic level – but the more, the better.
If you are going to use SSAS, then you need to know how to install programs.
———–
Who this course is for:
This course is for people who want to create analyses.
You either want to do this in Excel, or you want to learn about SQL Server Analytical Services (Tabular edition).
This course isn’t for you if you want to learn SSAS (MDX version) – there are other courses for this.
———-
Excel tips and tricks
Excel tutorials
Excel formulas
Excel functions
Advanced Excel techniques
Excel data analysis
Excel charts and graphs
Microsoft Excel tutorial
Excel pivot tables
Excel data visualization
Excel for beginners
Excel spreadsheet tutorial
Excel shortcuts
Excel templates
Excel formulas for data analysis
Excel macros
Excel VBA (Visual Basic for Applications)
Excel data manipulation
Excel data cleaning
Excel dashboard tutorial
Excel formulas and functions for finance
Excel for business
Excel data entry tips
Excel formatting tips
Excel tricks for productivity
———–
#excel #powerpivot #pivottableexcel #pivotchart #ssas #dax #pivottable #microsoftexcel #exceldataanalysisguide #excelformula #excelforbegginers #exceltutorial #exceltutoring #smexcel #excelformulaforjobinterview #excelforfresher #msexcelfullcourse #pivottableexcel #advanceexcel #excelformula #surfexcel #excelfullcourse #excelforbeginners #exceltutorial #msexcelfullcourse #microsoftexcel #howtouseexcel
Comments are closed.