|  

Advanced Microsoft Interactive and Dynamic Excel Dashboard



Size :7.6 GB
Peers : Seeders : 0      Leechers : 0
Added : 1 year ago » by tutsnode » in Other
Language : English
Last Updated :6 months ago
Info_Hash :013BB8F71CEA1E7A98D00825D4BF9235E7400245

Torrent File Contents

Advanced Microsoft Interactive and Dynamic Excel Dashboard
  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/95 - How to format Excel Slicers.mp4
  -  228.52 MB

  TutsNode.net.txt
  -  63 Bytes

  [TutsNode.net] - 6 - Adidas Sales Dashboard/58 - Adidas-Dataset.zip
  -  458.37 KB

  [TGx]Downloaded from torrentgalaxy.buzz .txt
  -  585 Bytes

  .pad/0
  -  31.29 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/77 - Transforming Hr data in Excel Power Query.mp4
  -  201.33 MB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/74 - HR-Dataset.zip
  -  523.57 KB

  .pad/1
  -  167.61 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/65 - Which State should we push more Products to.mp4
  -  201.17 MB

  .pad/2
  -  849.57 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/93 - Custom chart for Gender.mp4
  -  192.34 MB

  .pad/3
  -  673.75 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/66 - What is the peak month for 2020 and 2021.mp4
  -  176.05 MB

  .pad/4
  -  969.23 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/64 - Which Product contributed more to Revenue.mp4
  -  175.56 MB

  .pad/5
  -  448.71 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/30 - Introduction to DAX Measures in Power Pivot.mp4
  -  173.78 MB

  .pad/6
  -  221.21 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/62 - Dynamic way to show previous Month revenue with Percentage Change.mp4
  -  170.6 MB

  .pad/7
  -  406.21 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/51 - How to create a Dynamic Top N in Excel.mp4
  -  161.01 MB

  .pad/8
  -  1014.88 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/91 - How to create a custom chart in Microsoft Excel.mp4
  -  161 MB

  .pad/9
  -  1.6 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/72 - Formatting Slicers.mp4
  -  160.73 MB

  .pad/10
  -  275.62 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/59 - Transforming and Cleaning data with Power Query.mp4
  -  153.03 MB

  .pad/11
  -  990.32 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/41 - Last month Revenue and MoM percentage Change.mp4
  -  148.72 MB

  .pad/12
  -  282.77 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/75 - Importing data into Excel Power Query.mp4
  -  142.73 MB

  .pad/13
  -  279.32 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/15 - Creating a Custom Calendar Table in Power Query.mp4
  -  142 MB

  .pad/14
  -  1022.16 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/7 - Power Query Transform vs Add Columns explained.mp4
  -  138.39 MB

  .pad/15
  -  626.52 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/40 - Time Intelligence YTD MTD and QTD DAX Function.mp4
  -  137.5 MB

  .pad/16
  -  511.31 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/26 - How to add DAX Calculated Column.mp4
  -  133.22 MB

  .pad/17
  -  800.4 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/87 - Attrition by job role visual.mp4
  -  131.83 MB

  .pad/18
  -  171.45 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/53 - How to create multiple Doughnut chart.mp4
  -  131.75 MB

  .pad/19
  -  258.15 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/35 - Calculating returned Rate using DAX.mp4
  -  121.05 MB

  .pad/20
  -  969.6 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/54 - Inserting a Bar charts.mp4
  -  114.72 MB

  .pad/21
  -  283.13 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/68 - Revenue trend by Weekday.mp4
  -  109.99 MB

  .pad/22
  -  9.48 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/55 - How to create a Map chart.mp4
  -  108.57 MB

  .pad/23
  -  441.5 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/73 - Cleaning up your dashboard.mp4
  -  106.22 MB

  .pad/24
  -  798.92 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/10 - Checking errors and remove columns and rows in Power Query.mp4
  -  106.15 MB

  .pad/25
  -  873.03 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/84 - Employees by performance Status.mp4
  -  105.42 MB

  .pad/26
  -  591.99 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/67 - Whats our top Region Sales Channel.mp4
  -  102.93 MB

  .pad/27
  -  67.42 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/79 - Formatting your DataTable.mp4
  -  99.27 MB

  .pad/28
  -  751.9 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/85 - How to create an icon slicer in Excel.mp4
  -  93.8 MB

  .pad/29
  -  202.9 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/13 - Basic way to Append Queries.mp4
  -  93.52 MB

  .pad/30
  -  488.97 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/21 - Creating Relationships in Power Pivot.mp4
  -  93.38 MB

  .pad/31
  -  635.9 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/76 - Removing unwanted columns in Power Query.mp4
  -  93.25 MB

  .pad/32
  -  770.09 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/33 - How to create a Separate Measures Table.mp4
  -  89.33 MB

  .pad/33
  -  682.82 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/86 - Attrition by distance from work with dynamic legend.mp4
  -  84.69 MB

  .pad/34
  -  312.95 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/61 - Adding Month Filter.mp4
  -  83.25 MB

  .pad/35
  -  771.01 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/83 - Creating chart for attrition and current employees.mp4
  -  78.08 MB

  .pad/36
  -  938.36 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/38 - Filtering Table with DAX Function.mp4
  -  74.57 MB

  .pad/37
  -  440.2 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/12 - Merging Queries in Power Query.mp4
  -  74.15 MB

  .pad/38
  -  871.88 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/50 - Adding new cards with Gradient colors.mp4
  -  74.12 MB

  .pad/39
  -  902.77 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/44 - Better to Count using DAX.mp4
  -  73.61 MB

  .pad/40
  -  403.67 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/11 - How to add Index number in Power Query.mp4
  -  73.45 MB

  .pad/41
  -  564.07 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/60 - Inserting PivotTable and Advanced Number formatting.mp4
  -  72.39 MB

  .pad/42
  -  621.36 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/36 - How to use DAX All Function.mp4
  -  71.4 MB

  .pad/43
  -  610.2 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/14 - Best way to Append Queries using Folder with Auto Update.mp4
  -  71.27 MB

  .pad/44
  -  751.55 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/47 - How to add MCode Last Update date code.mp4
  -  70.46 MB

  .pad/45
  -  548.52 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/92 - Attrition by age Bucket and Gender.mp4
  -  70.21 MB

  .pad/46
  -  809.96 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/82 - How to download Gif animated images to Excel.mp4
  -  69.78 MB

  .pad/47
  -  220.75 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/80 - 06 Employees KPI.mp4
  -  69.73 MB

  .pad/48
  -  276.56 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/23 - Power Pivot view vs Normal Excel Pivot Table.mp4
  -  68.28 MB

  .pad/49
  -  735.18 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/69 - Connecting Slicers to PivotTables.mp4
  -  68.03 MB

  .pad/50
  -  994.69 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/29 - Total Revenue with Calculated Column.mp4
  -  67.8 MB

  .pad/51
  -  200.64 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/22 - How to Edit Relationships in Power Pivot.mp4
  -  64.99 MB

  .pad/52
  -  11.25 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/37 - How to use the DAX Filter Function.mp4
  -  63.9 MB

  .pad/53
  -  100.29 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/27 - Calculated Column with Dax If function.mp4
  -  63.78 MB

  .pad/54
  -  220.95 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/52 - Creating a dynamic Title.mp4
  -  62.7 MB

  .pad/55
  -  306.89 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/57 - How to connect Slicers to PivotTables.mp4
  -  62.45 MB

  .pad/56
  -  561.51 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/6 - Importing data into Power Query.mp4
  -  57.93 MB

  .pad/57
  -  69.31 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/90 - Attrition by Education types.mp4
  -  55.96 MB

  .pad/58
  -  41.43 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/58 - Dashboard Overview.mp4
  -  55.4 MB

  .pad/59
  -  610.99 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/70 - How to create a Single Button that clear all filters.mp4
  -  54.36 MB

  .pad/60
  -  652.33 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/48 - Adding values to cards.mp4
  -  53.3 MB

  .pad/61
  -  714.74 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/32 - Implicit vs Explicit Measures.mp4
  -  52.5 MB

  .pad/62
  -  516.82 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/8 - Importing Multiple tables into Power Query.mp4
  -  51.85 MB

  .pad/63
  -  155.16 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/16 - Better way to Create a Date Table in Power Query Auto Update.mp4
  -  50.5 MB

  .pad/64
  -  507.03 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/18 - Important Data Source Settings in Power Query.mp4
  -  50.3 MB

  .pad/65
  -  715.72 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/96 - Final formatting.mp4
  -  48.81 MB

  .pad/66
  -  195.81 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/28 - Calculated Column with Dax Switch function.mp4
  -  48.65 MB

  .pad/67
  -  362.1 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/19 - Data view vs Diagram view.mp4
  -  48.62 MB

  .pad/68
  -  389.39 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/9 - Updating your current Workbook Settings to get proper Dates and Time.mp4
  -  48 MB

  .pad/69
  -  1023.41 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/94 - Average Age for employees.mp4
  -  47.56 MB

  .pad/70
  -  455.22 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/31 - How to write DAX using the Measure BOX.mp4
  -  45.1 MB

  .pad/71
  -  918.67 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/4 - Project Overview.mp4
  -  44.9 MB

  .pad/72
  -  101.04 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/42 - How to calculate 10Days Rolling total.mp4
  -  42.62 MB

  .pad/73
  -  392.08 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/56 - 5 Less and Top Profitable Cities.mp4
  -  37.61 MB

  .pad/74
  -  398.39 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/43 - How to calculate 10 Days Transactional Average.mp4
  -  36.52 MB

  .pad/75
  -  492.81 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/17 - How to Move data into Power Pivot from Worksheet.mp4
  -  34.89 MB

  .pad/76
  -  109.36 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/46 - Setting Dashboard Canvas.mp4
  -  33.85 MB

  .pad/77
  -  155.93 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/88 - Formatting legends.mp4
  -  30.89 MB

  .pad/78
  -  111.36 KB

  [TutsNode.net] - 1 - Getting Started/3 - All-Resources.zip
  -  30.47 MB

  .pad/79
  -  546.92 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/4 - All-Resources.zip
  -  30.47 MB

  .pad/80
  -  546.92 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/20 - Understand Database Normalization.mp4
  -  30.17 MB

  .pad/81
  -  848.56 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/81 - Adding shapes to the dashboard environment.mp4
  -  29.15 MB

  .pad/82
  -  874.62 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/34 - How to calculate COGS and Gross profit.mp4
  -  27.71 MB

  .pad/83
  -  295.71 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/89 - Job role average Attrition.mp4
  -  24.8 MB

  .pad/84
  -  206.96 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/49 - Adding Icons.mp4
  -  24.51 MB

  .pad/85
  -  504.18 KB

  [TutsNode.net] - 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions/45 - Dashboard overview.mp4
  -  24.24 MB

  .pad/86
  -  776.36 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/5 - How to Activate Microsoft Excel Power Pivot.mp4
  -  22.99 MB

  .pad/87
  -  10.65 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/74 - Dashboard Overview.mp4
  -  22.41 MB

  .pad/88
  -  600.35 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/63 - Quantity Ordered and Transaction Cards.mp4
  -  21.61 MB

  .pad/89
  -  400.81 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/78 - Cleaning the Dashboard area Canvas.mp4
  -  19.36 MB

  .pad/90
  -  650.44 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/71 - New way to save your work.mp4
  -  15.39 MB

  .pad/91
  -  624.15 KB

  [TutsNode.net] - 1 - Getting Started/1 - Why do we need to use Power Query Power Pivot.mp4
  -  10.88 MB

  .pad/92
  -  121.94 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/4 - Customer-Dashboard-and-dataset.zip
  -  10.59 MB

  .pad/93
  -  418.86 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/4 - Complet-Dataset-for-practice.zip
  -  8.21 MB

  .pad/94
  -  808.09 KB

  [TutsNode.net] - 4 - DAX Pack common DAX functions/39 - How to mark your Date Table.mp4
  -  7.3 MB

  .pad/95
  -  720.88 KB

  [TutsNode.net] - 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports/25 - Introduction to DAX in Excel Power Pivot.mp4
  -  6.52 MB

  .pad/96
  -  494.93 KB

  [TutsNode.net] - 1 - Getting Started/2 - Advanced Process to a Better Dashboard Creation.mp4
  -  6.45 MB

  .pad/97
  -  566.62 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/24 - Power Query and Data Modelling conclusion.mp4
  -  5.82 MB

  .pad/98
  -  183.73 KB

  [TutsNode.net] - 2 - Advanced Power Query In Excel for Data Cleaning and Transformation/4 - Complet-Dashboard.zip
  -  4.87 MB

  .pad/99
  -  130.62 KB

  [TutsNode.net] - 1 - Getting Started/3 - Course Materials.mp4
  -  3.25 MB

  .pad/100
  -  769.05 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/74 - Complet-HR-Dashboard.zip
  -  2.57 MB

  .pad/101
  -  436.94 KB

  [TutsNode.net] - 6 - Adidas Sales Dashboard/58 - Adidas-dashboard.zip
  -  1.69 MB

  .pad/102
  -  312.65 KB

  [TutsNode.net] - 7 - Full Dynamic HR Human Resources Dashboard/74 - Animated-Images.zip
  -  1.56 MB



Torrent Description


Description

If you are really new to Excel dashboards or data analytics in general or you want to advance your knowledge, this is the course for you. We have provided you with the fundamentals you need to work with Excel efficiently and effectively.

This dashboard is going to take you through Power Query, Power Pivot, Modeling, and DAX (Data Analysis Expression).

Learning this advanced Excel Dashboard will make you use Power BI with ease as it uses DAX for computation and Power Query for cleaning and data transformation.

Our aim in this course is to show you how to analyze data and create a visualization from the different tables without you using Xlookup, VLOOKUP or Index and Match but just with simple data Modeling in Power Pivot.

This course is 100% practical

Microsoft Excel is the most commonly used data analysis tool available on the market today. In this course, we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)

Say no to a boring dashboard. With this course, you will start creating a very powerful interactive and dynamic Excel dashboard from day one.

If you are ready to learn with me, let’s join the class and see how creative you could be in the few days to come as you begin the class.

Remember you have life Time access to this course.

This course will be updated frequently with the new dashboard.

be free to ask questions should you got stuck in any of the steps.

I am already waiting for you in the class, nice to have you.
Who this course is for:

A data analyst
Anyone working with data
A manager
Business owners
Students

Requirements

Have Microsoft Excel installed
Excel 2016, 2019 ,2021 or Excel 365 would do. Other than this please, upgrade the version of your Excel
Analytics mind-set
Time (You need to invest time for practicing your new skill)

Last Updated 3/2023