|
|
0
|
|
31.3 KB
|
|
|
1
|
|
167.6 KB
|
|
|
1 - Why do we need to use Power Query Power Pivot.mp4
|
MP4
|
10.9 MB
|
|
|
10 - Checking errors and remove columns and rows in Power Query.mp4
|
MP4
|
106.1 MB
|
|
|
11 - How to add Index number in Power Query.mp4
|
MP4
|
73.4 MB
|
|
|
12 - Merging Queries in Power Query.mp4
|
MP4
|
74.1 MB
|
|
|
13 - Basic way to Append Queries.mp4
|
MP4
|
93.5 MB
|
|
|
14 - Best way to Append Queries using Folder with Auto Update.mp4
|
MP4
|
71.3 MB
|
|
|
15 - Creating a Custom Calendar Table in Power Query.mp4
|
MP4
|
142 MB
|
|
|
16 - Better way to Create a Date Table in Power Query Auto Update.mp4
|
MP4
|
50.5 MB
|
|
|
17 - How to Move data into Power Pivot from Worksheet.mp4
|
MP4
|
34.9 MB
|
|
|
18 - Important Data Source Settings in Power Query.mp4
|
MP4
|
50.3 MB
|
|
|
19 - Data view vs Diagram view.mp4
|
MP4
|
48.6 MB
|
|
|
2 - Advanced Process to a Better Dashboard Creation.mp4
|
MP4
|
6.4 MB
|
|
|
2
|
|
849.6 KB
|
|
|
3
|
|
673.7 KB
|
|
|
4
|
|
969.2 KB
|
|
|
20 - Understand Database Normalization.mp4
|
MP4
|
30.2 MB
|
|
|
21 - Creating Relationships in Power Pivot.mp4
|
MP4
|
93.4 MB
|
|
|
22 - How to Edit Relationships in Power Pivot.mp4
|
MP4
|
65 MB
|
|
|
23 - Power Pivot view vs Normal Excel Pivot Table.mp4
|
MP4
|
68.3 MB
|
|
|
24 - Power Query and Data Modelling conclusion.mp4
|
MP4
|
5.8 MB
|
|
|
25 - Introduction to DAX in Excel Power Pivot.mp4
|
MP4
|
6.5 MB
|
|
|
26 - How to add DAX Calculated Column.mp4
|
MP4
|
133.2 MB
|
|
|
27 - Calculated Column with Dax If function.mp4
|
MP4
|
63.8 MB
|
|
|
28 - Calculated Column with Dax Switch function.mp4
|
MP4
|
48.6 MB
|
|
|
29 - Total Revenue with Calculated Column.mp4
|
MP4
|
67.8 MB
|
|
|
3 - All-Resources.zip
|
ZIP
|
30.5 MB
|
|
|
3 - Course Materials.mp4
|
MP4
|
3.2 MB
|
|
|
30 - Introduction to DAX Measures in Power Pivot.mp4
|
MP4
|
173.8 MB
|
|
|
31 - How to write DAX using the Measure BOX.mp4
|
MP4
|
45.1 MB
|
|
|
32 - Implicit vs Explicit Measures.mp4
|
MP4
|
52.5 MB
|
|
|
33 - How to create a Separate Measures Table.mp4
|
MP4
|
89.3 MB
|
|
|
34 - How to calculate COGS and Gross profit.mp4
|
MP4
|
27.7 MB
|
|
|
35 - Calculating returned Rate using DAX.mp4
|
MP4
|
121.1 MB
|
|
|
36 - How to use DAX All Function.mp4
|
MP4
|
71.4 MB
|
|
|
37 - How to use the DAX Filter Function.mp4
|
MP4
|
63.9 MB
|
|
|
38 - Filtering Table with DAX Function.mp4
|
MP4
|
74.6 MB
|
|
|
39 - How to mark your Date Table.mp4
|
MP4
|
7.3 MB
|
|
|
4 - All-Resources.zip
|
ZIP
|
30.5 MB
|
|
|
4 - Complet-Dashboard.zip
|
ZIP
|
4.9 MB
|
|
|
4 - Complet-Dataset-for-practice.zip
|
ZIP
|
8.2 MB
|
|
|
4 - Customer-Dashboard-and-dataset.zip
|
ZIP
|
10.6 MB
|
|
|
4 - Project Overview.mp4
|
MP4
|
44.9 MB
|
|
|
5
|
|
448.7 KB
|
|
|
5 - How to Activate Microsoft Excel Power Pivot.mp4
|
MP4
|
23 MB
|
|
|
6
|
|
221.2 KB
|
|
|
7
|
|
406.2 KB
|
|
|
9
|
|
1.6 KB
|
|
|
10
|
|
275.6 KB
|
|
|
11
|
|
990.3 KB
|
|
|
12
|
|
282.8 KB
|
|
|
13
|
|
279.3 KB
|
|
|
15
|
|
626.5 KB
|
|
|
16
|
|
511.3 KB
|
|
|
17
|
|
800.4 KB
|
|
|
18
|
|
171.4 KB
|
|
|
19
|
|
258.2 KB
|
|
|
20
|
|
969.6 KB
|
|
|
21
|
|
283.1 KB
|
|
|
22
|
|
9.5 KB
|
|
|
23
|
|
441.5 KB
|
|
|
24
|
|
798.9 KB
|
|
|
25
|
|
873 KB
|
|
|
26
|
|
592 KB
|
|
|
27
|
|
67.4 KB
|
|
|
28
|
|
751.9 KB
|
|
|
29
|
|
202.9 KB
|
|
|
30
|
|
489 KB
|
|
|
31
|
|
635.9 KB
|
|
|
32
|
|
770.1 KB
|
|
|
33
|
|
682.8 KB
|
|
|
34
|
|
312.9 KB
|
|
|
35
|
|
771 KB
|
|
|
36
|
|
938.4 KB
|
|
|
37
|
|
440.2 KB
|
|
|
38
|
|
871.9 KB
|
|
|
39
|
|
902.8 KB
|
|
|
40
|
|
403.7 KB
|
|
|
40 - Time Intelligence YTD MTD and QTD DAX Function.mp4
|
MP4
|
137.5 MB
|
|
|
41 - Last month Revenue and MoM percentage Change.mp4
|
MP4
|
148.7 MB
|
|
|
41
|
|
564.1 KB
|
|
|
42
|
|
621.4 KB
|
|
|
42 - How to calculate 10Days Rolling total.mp4
|
MP4
|
42.6 MB
|
|
|
43
|
|
610.2 KB
|
|
|
43 - How to calculate 10 Days Transactional Average.mp4
|
MP4
|
36.5 MB
|
|
|
44 - Better to Count using DAX.mp4
|
MP4
|
73.6 MB
|
|
|
44
|
|
751.6 KB
|
|
|
45 - Dashboard overview.mp4
|
MP4
|
24.2 MB
|
|
|
45
|
|
548.5 KB
|
|
|
46
|
|
810 KB
|
|
|
46 - Setting Dashboard Canvas.mp4
|
MP4
|
33.8 MB
|
|
|
47
|
|
220.8 KB
|
|
|
47 - How to add MCode Last Update date code.mp4
|
MP4
|
70.5 MB
|
|
|
48
|
|
276.6 KB
|
|
|
48 - Adding values to cards.mp4
|
MP4
|
53.3 MB
|
|
|
49 - Adding Icons.mp4
|
MP4
|
24.5 MB
|
|
|
49
|
|
735.2 KB
|
|
|
50
|
|
994.7 KB
|
|
|
50 - Adding new cards with Gradient colors.mp4
|
MP4
|
74.1 MB
|
|
|
51
|
|
200.6 KB
|
|
|
51 - How to create a Dynamic Top N in Excel.mp4
|
MP4
|
161 MB
|
|
|
52
|
|
11.3 KB
|
|
|
52 - Creating a dynamic Title.mp4
|
MP4
|
62.7 MB
|
|
|
53 - How to create multiple Doughnut chart.mp4
|
MP4
|
131.7 MB
|
|
|
53
|
|
100.3 KB
|
|
|
54 - Inserting a Bar charts.mp4
|
MP4
|
114.7 MB
|
|
|
54
|
|
220.9 KB
|
|
|
55 - How to create a Map chart.mp4
|
MP4
|
108.6 MB
|
|
|
55
|
|
306.9 KB
|
|
|
56 - 5 Less and Top Profitable Cities.mp4
|
MP4
|
37.6 MB
|
|
|
56
|
|
561.5 KB
|
|
|
57 - How to connect Slicers to PivotTables.mp4
|
MP4
|
62.5 MB
|
|
|
57
|
|
69.3 KB
|
|
|
58
|
|
41.4 KB
|
|
|
58 - Adidas-Dataset.zip
|
ZIP
|
458.4 KB
|
|
|
58 - Adidas-dashboard.zip
|
ZIP
|
1.7 MB
|
|
|
58 - Dashboard Overview.mp4
|
MP4
|
55.4 MB
|
|
|
59 - Transforming and Cleaning data with Power Query.mp4
|
MP4
|
153 MB
|
|
|
6 - Importing data into Power Query.mp4
|
MP4
|
57.9 MB
|
|
|
59
|
|
611 KB
|
|
|
60 - Inserting PivotTable and Advanced Number formatting.mp4
|
MP4
|
72.4 MB
|
|
|
60
|
|
652.3 KB
|
|
|
61 - Adding Month Filter.mp4
|
MP4
|
83.2 MB
|
|
|
61
|
|
714.7 KB
|
|
|
62 - Dynamic way to show previous Month revenue with Percentage Change.mp4
|
MP4
|
170.6 MB
|
|
|
62
|
|
516.8 KB
|
|
|
63 - Quantity Ordered and Transaction Cards.mp4
|
MP4
|
21.6 MB
|
|
|
63
|
|
155.2 KB
|
|
|
64 - Which Product contributed more to Revenue.mp4
|
MP4
|
175.6 MB
|
|
|
64
|
|
507 KB
|
|
|
65 - Which State should we push more Products to.mp4
|
MP4
|
201.2 MB
|
|
|
66
|
|
195.8 KB
|
|
|
66 - What is the peak month for 2020 and 2021.mp4
|
MP4
|
176.1 MB
|
|
|
67
|
|
362.1 KB
|
|
|
68 - Revenue trend by Weekday.mp4
|
MP4
|
110 MB
|
|
|
68
|
|
389.4 KB
|
|
|
69 - Connecting Slicers to PivotTables.mp4
|
MP4
|
68 MB
|
|
|
7 - Power Query Transform vs Add Columns explained.mp4
|
MP4
|
138.4 MB
|
|
|
65
|
|
715.7 KB
|
|
|
67 - Whats our top Region Sales Channel.mp4
|
MP4
|
102.9 MB
|
|
|
70
|
|
455.2 KB
|
|
|
70 - How to create a Single Button that clear all filters.mp4
|
MP4
|
54.4 MB
|
|
|
71 - New way to save your work.mp4
|
MP4
|
15.4 MB
|
|
|
71
|
|
918.7 KB
|
|
|
72
|
|
101 KB
|
|
|
72 - Formatting Slicers.mp4
|
MP4
|
160.7 MB
|
|
|
73
|
|
392.1 KB
|
|
|
73 - Cleaning up your dashboard.mp4
|
MP4
|
106.2 MB
|
|
|
74
|
|
398.4 KB
|
|
|
74 - Animated-Images.zip
|
ZIP
|
1.6 MB
|
|
|
74 - Complet-HR-Dashboard.zip
|
ZIP
|
2.6 MB
|
|
|
74 - Dashboard Overview.mp4
|
MP4
|
22.4 MB
|
|
|
74 - HR-Dataset.zip
|
ZIP
|
523.6 KB
|
|
|
75 - Importing data into Excel Power Query.mp4
|
MP4
|
142.7 MB
|
|
|
76 - Removing unwanted columns in Power Query.mp4
|
MP4
|
93.2 MB
|
|
|
77
|
|
155.9 KB
|
|
|
78 - Cleaning the Dashboard area Canvas.mp4
|
MP4
|
19.4 MB
|
|
|
8 - Importing Multiple tables into Power Query.mp4
|
MP4
|
51.8 MB
|
|
|
9 - Updating your current Workbook Settings to get proper Dates and Time.mp4
|
MP4
|
48 MB
|
|
|
75
|
|
492.8 KB
|
|
|
76
|
|
109.4 KB
|
|
|
77 - Transforming Hr data in Excel Power Query.mp4
|
MP4
|
201.3 MB
|
|
|
78
|
|
111.4 KB
|
|
|
79
|
|
546.9 KB
|
|
|
79 - Formatting your DataTable.mp4
|
MP4
|
99.3 MB
|
|
|
80
|
|
546.9 KB
|
|
|
80 - 06 Employees KPI.mp4
|
MP4
|
69.7 MB
|
|
|
81 - Adding shapes to the dashboard environment.mp4
|
MP4
|
29.1 MB
|
|
|
81
|
|
848.6 KB
|
|
|
82
|
|
874.6 KB
|
|
|
82 - How to download Gif animated images to Excel.mp4
|
MP4
|
69.8 MB
|
|
|
83
|
|
295.7 KB
|
|
|
83 - Creating chart for attrition and current employees.mp4
|
MP4
|
78.1 MB
|
|
|
84
|
|
207 KB
|
|
|
84 - Employees by performance Status.mp4
|
MP4
|
105.4 MB
|
|
|
85
|
|
504.2 KB
|
|
|
85 - How to create an icon slicer in Excel.mp4
|
MP4
|
93.8 MB
|
|
|
86
|
|
776.4 KB
|
|
|
86 - Attrition by distance from work with dynamic legend.mp4
|
MP4
|
84.7 MB
|
|
|
87 - Attrition by job role visual.mp4
|
MP4
|
131.8 MB
|
|
|
87
|
|
10.7 KB
|
|
|
88
|
|
600.3 KB
|
|
|
88 - Formatting legends.mp4
|
MP4
|
30.9 MB
|
|
|
89 - Job role average Attrition.mp4
|
MP4
|
24.8 MB
|
|
|
89
|
|
400.8 KB
|
|
|
90 - Attrition by Education types.mp4
|
MP4
|
56 MB
|
|
|
90
|
|
650.4 KB
|
|
|
91
|
|
624.1 KB
|
|
|
91 - How to create a custom chart in Microsoft Excel.mp4
|
MP4
|
161 MB
|
|
|
92
|
|
121.9 KB
|
|
|
92 - Attrition by age Bucket and Gender.mp4
|
MP4
|
70.2 MB
|
|
|
93
|
|
418.9 KB
|
|
|
93 - Custom chart for Gender.mp4
|
MP4
|
192.3 MB
|
|
|
94 - Average Age for employees.mp4
|
MP4
|
47.6 MB
|
|
|
94
|
|
808.1 KB
|
|
|
95
|
|
720.9 KB
|
|
|
95 - How to format Excel Slicers.mp4
|
MP4
|
228.5 MB
|
|
|
96 - Final formatting.mp4
|
MP4
|
48.8 MB
|
|
|
TutsNode.net.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
96
|
|
494.9 KB
|
|
|
97
|
|
566.6 KB
|
|
|
98
|
|
183.7 KB
|
|
|
99
|
|
130.6 KB
|
|
|
100
|
|
769.1 KB
|
|
|
101
|
|
436.9 KB
|
|
|
102
|
|
312.6 KB
|