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.

01 - Welcome

001 Welcome

002 Welcome to Udemy.html

003 Introduction to Udemy

004 Do you want auto-translated subtitles in more languages.html

005 What will we learn

006 Software Requirements - PowerPivot

007 AdventureWorksDW2012.csv

007 AdventureWorksDW2012.xlsx

007 AdventureWorksDW2012Exercise.xlsx

007 Source data

008 Activating PowerPivot on Excel 2013 and 2016

009 Installing PowerPivot on Excel 2010

02 - Creating our first model using PowerPivot (Excel)

001 Creating our first model in PowerPivot

002 Using our first model in Excel

003 Creating and deploying our first model in Excel 2010

004 Adding a second table - Importing Data from SQL Server

005 Importing Data from SQL Server

006 AdventureWorksDW2012.csv

006 Practice Activity Number 1.html

007 Practice Activity Number 1 - Solution

03 - Installing SQL Server 2019 Developer and Visual Studio 2019

001 Installing SQL Server 2019 Developer and Visual Studio 2019.html

002 Downloading SQL Server Developer 2019

003 Installing SQL Server Developer 2019

004 Installing SQL Server Management Studio (SSMS)

005 Installing Visual Studio 2022

006 Installing SSAS in Visual Studio 2022

007 Is your Visual Studio a trial version No!

04 - Using the Tabular Model (SSAS in SQL Server)

001 Introduction

002 AdventureWorksDW2014.zip

002 Downloading AdventureWorksDW

003 Attaching AdventureWorksDW

004 Creating and deploying our first model in SSAS

005 Adding additional tables

006 Introduction to Practice Activity

007 AdventureWorksDW2012.csv

007 Practice Activity Number 2.html

008 Practice Activity Number 2 - Solution

009 Importing Data from Excel

010 Having problems importing from Excel

05 - Developing the Data Model

001 AdventureWorksDW2012Exercise.xlsx

001 Practice Activity Number 3.html

002 Filtering, sorting and formatting fields

002 SSRS-Number-And-Date-Formats-150812.xlsx

003 Hiding columns from Client Tools, and other column tools

004 Refreshing (or processing) data

005 Creating quick measures

006 Perspectives

007 Hierarchies

008 Practice Activity Number 4.html

009 Do you want more practice setting your data model.html

06 - Pivot Tables functionality

001 PivotTable structure, and non-Visual Totals

002 Show no data in rows and columns

003 Create running totals

004 Slicers and Timelines

005 Using formulas to query Data Model (Advanced)

07 - An introduction to DAX functions, including Logical functions

001 DAX functions - An Introduction

001 daxfunctions170320.zip

002 Calculated columns - an introduction

003 Basic operators

004 IF

005 BLANK and ISBLANK

006 AND, OR and NOT

007 SWITCH

008 Other functions

08 - Statistical functions

001 Measures - an introduction

002 Aggregation of columns

003 Aggregation of calculations

004 DISTINCTCOUNT

005 RANKG.EQ

006 Other functions

09 - Mathematical functions

001 Rounding functions

002 Division functions - MOD and QUOTIENT

003 SIGN (and use with SWITCH) and ABS

004 Exponential functions

005 Other functions

10 - Text functions

001 Text searching

002 Text extraction and substitution

003 Text conversion

004 Other functions

11 - Information Functions

001 ISERROR and LOOKUPVALUE

002 Other functions

12 - Filter and Value Functions

001 RELATED

002 RELATEDTABLE and COUNTROWS

003 Context

004 FILTER

005 ALL

006 CALCULATE

007 ALLEXCEPT

008 ALLSELECTED

009 Other functions

13 - Time Intelligence Functions

001 Date and Time Functions

002 FIRSTDATE, LASTDATE

003 Start of... and End of

004 Previous... and Next

005 DATESINPERIOD

006 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD

007 Opening Balance and Closing Balance

008 SAMEPERIODLASTYEAR and PARALLELPERIOD

009 Other Functions

14 - Conclusion

001 Thank you for watching

002 Bonus Lecture

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training