Excel Building BI with PivotTables

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

1 - Intro - The Value of PivotTables

1 -Business Intelligence Lifecycle

1 -Practice-Files.zip

2 -Why You Care About PivotTables

3 -Creating Your First PivotTable

4 -DEMO - Creating Your First PivotTable

2 - Pivot Compliant Data Sets

1 -Required Data Layout

2 -Connecting to Your Source Data

3 -Issues Using Excel Ranges

4 -Using Excel Tables

5 -Building PivotTables Against Excel Tables

6 -Why Excel Tables are Better Than Ranges

7 -Using Data Direct From Databases

8 -Sourcing Data Direct From Databases to PivotTables

9 -Sourcing Data Direct From Databases to a Table

10 -Sourcing Data Direct From Databases to the Data Model

3 - Controlling PivotTable Look & Feel

1 -Value Field Formats

2 -Modifying Column Names & Number Formats

3 -Report Layouts

4 -Changing PivotTable Layouts

5 -Grouping Data

6 -Grouping Data in PivotTables

7 -PivotTable Styles

8 -Creating Custom PivotTable Styles

9 -Sorting PivotTables

10 -Sorting Methods in PivotTables

4 - Creating Compliant Data Sets

1 -Using Power Query to Get and Transform Your Data

2 -Cleaning Up A Text File With Power Query

3 -Appending Data Tables

4 -Simple Append Operations

5 -Consolidating Flat Files From Folder

6 -Consolidating A Folder of CSV Files

7 -Consolidating Excel Data

8 -Consolidating External Excel Data Files

9 -Get Data From The Active Workbook

10 -Consolidating Data From Within The Active Work File

11 -UnPivoting Data

12 -UnPivoting Simple Data Sets

13 -UnPivoting Data With Subheadings

14 -UnPivoting Subcategorized Data Sets

15 -Flattening Data Sets

16 -Flattening Tables With VLookup

17 -6 Ways To Join Foundation

18 -Flattening Tables With Power Query - The Basics

19 -Join Types

20 -6 Ways To Join With Power Query

21 -Sum Count And Others

22 -Introduction To Changing Aggregations

23 -Show Values As

24 -Running Totals

25 -Difference And % Difference From

26 -Difference From X And % Difference From X

27 -Ranking Items

28 -Ranking Items in PivotTables

29 -Showing the TopBottom X Records

30 -Displaying the TopBottom X

31 -Calculated Fields

32 -Working with Calculated Fields

33 -Calculated Items

34 -Working with Calculated Items

5 - Slicing and Filtering

1 -Filtering with Classic Controls

2 -Working with PivotTable Filter Fields

3 -Filtering With Slicers

4 -Working With Slicers

5 -Filtering The Timelines

6 -Working With The Timelines

7 -The Show Details Feature

8 -The Show Details Feature - DEMO

9 -Keep Your Pivots Looking Nice

10 -Toggling PivotTable Options

6 - Building Pivot Based Dashboard

1 -Conditional Formatting on Pivots

2 -Conditional Formatting DEMO

3 -Keeping Pivots in Sync

4 -Linking One Slicer to Multiple Pivots

5 -Tricks For Extracting Key Info

6 -Extracting Data From Pivots And Slicers

7 -Working With Pivot Charts

8 -Building Pivot Charts

7 - Data Refresh & Security

1 -Driving PivotTable Refresh

2 -Refresh Options External DataSets

3 -Refresh Options Local DataSets

4 -How Secure Is Your Data

5 -DEMO of Exposing Data

139,000 تومان

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

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

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

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