Advanced Microsoft Interactive and Dynamic Excel Dashboard

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size7.6 GB
  • Uploaded Bytutsnode
  • Downloads94
  • Last checkedMar. 25th '23
  • Date uploadedMar. 24th '23
  • Seeders 59
  • Leechers89

Infohash : 013BB8F71CEA1E7A98D00825D4BF9235E7400245


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

Files:

Advanced Microsoft Interactive and Dynamic Excel Dashboard [TutsNode.net] - Advanced Microsoft Interactive and Dynamic Excel Dashboard 7 - Full Dynamic HR Human Resources Dashboard
  • 95 - How to format Excel Slicers.mp4 (228.5 MB)
  • 77 - Transforming Hr data in Excel Power Query.mp4 (201.3 MB)
  • 74 - HR-Dataset.zip (523.6 KB)
  • 93 - Custom chart for Gender.mp4 (192.3 MB)
  • 91 - How to create a custom chart in Microsoft Excel.mp4 (161.0 MB)
  • 75 - Importing data into Excel Power Query.mp4 (142.7 MB)
  • 87 - Attrition by job role visual.mp4 (131.8 MB)
  • 84 - Employees by performance Status.mp4 (105.4 MB)
  • 79 - Formatting your DataTable.mp4 (99.3 MB)
  • 85 - How to create an icon slicer in Excel.mp4 (93.8 MB)
  • 76 - Removing unwanted columns in Power Query.mp4 (93.2 MB)
  • 86 - Attrition by distance from work with dynamic legend.mp4 (84.7 MB)
  • 83 - Creating chart for attrition and current employees.mp4 (78.1 MB)
  • 92 - Attrition by age Bucket and Gender.mp4 (70.2 MB)
  • 82 - How to download Gif animated images to Excel.mp4 (69.8 MB)
  • 80 - 06 Employees KPI.mp4 (69.7 MB)
  • 90 - Attrition by Education types.mp4 (56.0 MB)
  • 96 - Final formatting.mp4 (48.8 MB)
  • 94 - Average Age for employees.mp4 (47.6 MB)
  • 88 - Formatting legends.mp4 (30.9 MB)
  • 81 - Adding shapes to the dashboard environment.mp4 (29.1 MB)
  • 89 - Job role average Attrition.mp4 (24.8 MB)
  • 74 - Dashboard Overview.mp4 (22.4 MB)
  • 78 - Cleaning the Dashboard area Canvas.mp4 (19.4 MB)
  • 74 - Complet-HR-Dashboard.zip (2.6 MB)
  • 74 - Animated-Images.zip (1.6 MB)
6 - Adidas Sales Dashboard
  • 58 - Adidas-Dataset.zip (458.4 KB)
  • 65 - Which State should we push more Products to.mp4 (201.2 MB)
  • 66 - What is the peak month for 2020 and 2021.mp4 (176.1 MB)
  • 64 - Which Product contributed more to Revenue.mp4 (175.6 MB)
  • 62 - Dynamic way to show previous Month revenue with Percentage Change.mp4 (170.6 MB)
  • 72 - Formatting Slicers.mp4 (160.7 MB)
  • 59 - Transforming and Cleaning data with Power Query.mp4 (153.0 MB)
  • 68 - Revenue trend by Weekday.mp4 (110.0 MB)
  • 73 - Cleaning up your dashboard.mp4 (106.2 MB)
  • 67 - Whats our top Region Sales Channel.mp4 (102.9 MB)
  • 61 - Adding Month Filter.mp4 (83.2 MB)
  • 60 - Inserting PivotTable and Advanced Number formatting.mp4 (72.4 MB)
  • 69 - Connecting Slicers to PivotTables.mp4 (68.0 MB)
  • 58 - Dashboard Overview.mp4 (55.4 MB)
  • 70 - How to create a Single Button that clear all filters.mp4 (54.4 MB)
  • 63 - Quantity Ordered and Transaction Cards.mp4 (21.6 MB)
  • 71 - New way to save your work.mp4 (15.4 MB)
  • 58 - Adidas-dashboard.zip (1.7 MB)
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.8 MB)
  • 26 - How to add DAX Calculated Column.mp4 (133.2 MB)
  • 29 - Total Revenue with Calculated Column.mp4 (67.8 MB)
  • 27 - Calculated Column with Dax If function.mp4 (63.8 MB)
  • 32 - Implicit vs Explicit Measures.mp4 (52.5 MB)
  • 28 - Calculated Column with Dax Switch function.mp4 (48.6 MB)
  • 31 - How to write DAX using the Measure BOX.mp4 (45.1 MB)
  • 25 - Introduction to DAX in Excel Power Pivot.mp4 (6.5 MB)
5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions
  • 51 - How to create a Dynamic Top N in Excel.mp4 (161.0 MB)
  • 53 - How to create multiple Doughnut chart.mp4 (131.7 MB)
  • 54 - Inserting a Bar charts.mp4 (114.7 MB)
  • 55 - How to create a Map chart.mp4 (108.6 MB)
  • 50 - Adding new cards with Gradient colors.mp4 (74.1 MB)
  • 47 - How to add MCode Last Update date code.mp4 (70.5 MB)
  • 52 - Creating a dynamic Title.mp4 (62.7 MB)
  • 57 - How to connect Slicers to PivotTables.mp4 (62.5 MB)
  • 48 - Adding values to cards.mp4 (53.3 MB)
  • 56 - 5 Less and Top Profitable Cities.mp4 (37.6 MB)
  • 46 - Setting Dashboard Canvas.mp4 (33.8 MB)
  • 49 - Adding Icons.mp4 (24.5 MB)
  • 45 - Dashboard overview.mp4 (24.2 MB)
4 - DAX Pack common DAX functions
  • 41 - Last month Revenue and MoM percentage Change.mp4 (148.7 MB)
  • 40 - Time Intelligence YTD MTD and QTD DAX Function.mp4 (137.5 MB)
  • 35 - Calculating returned Rate using DAX.mp4 (121.1 MB)
  • 33 - How to create a Separate Measures Table.mp4 (89.3 MB)
  • 38 - Filtering Table with DAX Function.mp4 (74.6 MB)
  • 44 - Better to Count using DAX.mp4 (73.6 MB)
  • 36 - How to use DAX All Function.mp4 (71.4 MB)
  • 37 - How to use the DAX Filter Function.mp4 (63.9 MB)
  • 42 - How to calculate 10Days Rolling total.mp4 (42.6 MB)
  • 43 - How to calculate 10 Days Transactional Average.mp4 (36.5 MB)
  • 34 - How to calculate COGS and Gross profit.mp4 (27.7 MB)
  • 39 - How to mark your Date Table.mp4 (7.3 MB)
2 - Advanced Power Query In Excel for Data Cleaning and Transformation
  • 15 - Creating a Custom Calendar Table in Power Query.mp4 (142.0 MB)
  • 7 - Power Query Transform vs Add Columns explained.mp4 (138.4 MB)
  • 10 - Checking errors and remove columns and rows in Power Query.mp4 (106.1 MB)
  • 13 - Basic way to Append Queries.mp4 (93.5 MB)
  • 21 - Creating Relationships in Power Pivot.mp4 (93.4 MB)
  • 12 - Merging Queries in Power Query.mp4 (74.1 MB)
  • 11 - How to add Index number in Power Query.mp4 (73.4 MB)
  • 14 - Best way to Append Queries using Folder with Auto Update.mp4 (71.3 MB)
  • 23 - Power Pivot view vs Normal Excel Pivot Table.mp4 (68.3 MB)
  • 22 - How to Edit Relationships in Power Pivot.mp4 (65.0 MB)
  • 6 - Importing data into Power Query.mp4 (57.9 MB)
  • 8 - Importing Multiple tables into Power Query.mp4 (51.8 MB)
  • 16 - Better way to Create a Date Table in Power Query Auto Update.mp4 (50.5 MB)
  • 18 - Important Data Source Settings in Power Query.mp4 (50.3 MB)
  • 19 - Data view vs Diagram view.mp4 (48.6 MB)
  • 9 - Updating your current Workbook Settings to get proper Dates and Time.mp4 (48.0 MB)
  • 4 - Project Overview.mp4 (44.9 MB)
  • 17 - How to Move data into Power Pivot f

Code:

  • udp://open.stealth.si:80/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://fasttracker.foreverpirates.co:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://tracker.uw0.xyz:6969/announce
  • udp://opentracker.i2p.rocks:6969/announce
  • udp://tracker.birkenwald.de:6969/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.moeking.me:6969/announce
  • udp://tracker.dler.org:6969/announce
  • udp://9.rarbg.me:2970/announce