Complete Introduction to Excel Power Pivot [2022 Edition]

سرفصل های دوره

Concise, yet effective course on Excel DAX, Data Models & Relationships and working with enormous data volumes

1 - Introduction

1 - Introduction to the Course

2 - About the Course

3 - Data.xlsx

3 - DateMaster.xlsx

3 - Download the Course Training Files.html

2 - Power Pivot and the Data Model

4 - Overview of Excel Power Pivot

5 - Understanding Power Pivot

6 - Activating Excel Power Pivot

7 - Loading Data into the Data Model

8 - Browse Filter and Sort

9 - Practical Activity Load Data.html

3 - Power Pivot and Pivot Tables

10 - Introduction to Analyzing Data with Pivot Tables

11 - Creating Pivot Tables

12 - Methods of Aggregation

13 - Slicers and Filtering Data with Pivot Tables

14 - Two Pivot Table and Chart

15 - Practical Activity Create Pivot Tables.html

16 - Completed Practical Activity

4 - Calculated Columns

17 - Introduction to Calculated Columns

18 - Creating a Calculated Column

19 - Year Month Day

20 - Weeknum and WeekDay

21 - Formatting Month and Week Day Names

22 - Practical Activity Calculated Columns.html

23 - Creating a Date Table

24 - IF Function

25 - SWITCH Function

5 - Measures in the Data Model

26 - Introduction to Measures

27 - Explanation of Measures

28 - Aggregations

29 - Practical Activity Add Measures to the Data Model.html

30 - Completed Practical Activity Measures

31 - The Calculate Formula

32 - Practical Activity Calculate.html

33 - Practical Activity Calculate

34 - The ALL and ALLEXCEPT Formulas

6 - Time Intelligence Measures

35 - Time Intelligence Calculations Part 1

36 - Time Intelligence Calculations Part 2

37 - Time Intelligence Calculations Part 3

7 - Additional Measures

38 - Using SUMX Functions

39 - Practical Activity X Functions.html

40 - Practical Activity SUMX

41 - RankX Function Ranking Customers

42 - Customer Segmentation The Switch Function

8 - Case Studies

43 - Introduction to Case Studies

44 - Download Training Data Files.html

44 - Storemaster.csv

44 - storesample1.zip

45 - Case Study Loading Data from Power Query

46 - Creating Summary Tables

9 - Relationships

47 - Introduction to Relationships

48 - Download Training Data Files.html

48 - EmployeeMaster.xlsx

49 - Creating Relationships

50 - Relationship Calculations

51 - Practical Activity Employee Master 4 Chart Dashboard.html

52 - Four Chart Dashboard Practical Activity

10 - Sets and KPIs

53 - Introduction to KPIs and Sets

54 - Creating Sets

55 - Creating Hierarchies

56 - Creating KPIs

11 - Course Conclusion

57 - Course Conclusion

139,000 تومان

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

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

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

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