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

Advanced Microsoft Interactive and Dynamic Excel Dashboard

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

2023 (Edition) Start an Advanced Excel Dashboard Today using Power Pivot, DAX, Power Query and Advanced Excel Functions


1 - Getting Started
  • 1 - Why do we need to use Power Query Power Pivot
  • 2 - Advanced Process to a Better Dashboard Creation
  • 3 - All-Resources.zip
  • 3 - Course Materials

  • 2 - Advanced Power Query In Excel for Data Cleaning and Transformation
  • 4 - All-Resources.zip
  • 4 - Complet-Dashboard.zip
  • 4 - Complet-Dataset-for-practice.zip
  • 4 - Customer-Dashboard-and-dataset.zip
  • 4 - Project Overview
  • 5 - How to Activate Microsoft Excel Power Pivot
  • 6 - Importing data into Power Query
  • 7 - Power Query Transform vs Add Columns explained
  • 8 - Importing Multiple tables into Power Query
  • 9 - Updating your current Workbook Settings to get proper Dates and Time
  • 10 - Checking errors and remove columns and rows in Power Query
  • 11 - How to add Index number in Power Query
  • 12 - Merging Queries in Power Query
  • 13 - Basic way to Append Queries
  • 14 - Best way to Append Queries using Folder with Auto Update
  • 15 - Creating a Custom Calendar Table in Power Query
  • 16 - Better way to Create a Date Table in Power Query Auto Update
  • 17 - How to Move data into Power Pivot from Worksheet
  • 18 - Important Data Source Settings in Power Query
  • 19 - Data view vs Diagram view
  • 20 - Understand Database Normalization
  • 21 - Creating Relationships in Power Pivot
  • 22 - How to Edit Relationships in Power Pivot
  • 23 - Power Pivot view vs Normal Excel Pivot Table
  • 24 - Power Query and Data Modelling conclusion

  • 3 - How to Write DAX in Excel Power Pivot to create Advanced Dashboards or Reports
  • 25 - Introduction to DAX in Excel Power Pivot
  • 26 - How to add DAX Calculated Column
  • 27 - Calculated Column with Dax If function
  • 28 - Calculated Column with Dax Switch function
  • 29 - Total Revenue with Calculated Column
  • 30 - Introduction to DAX Measures in Power Pivot
  • 31 - How to write DAX using the Measure BOX
  • 32 - Implicit vs Explicit Measures

  • 4 - DAX Pack common DAX functions
  • 33 - How to create a Separate Measures Table
  • 34 - How to calculate COGS and Gross profit
  • 35 - Calculating returned Rate using DAX
  • 36 - How to use DAX All Function
  • 37 - How to use the DAX Filter Function
  • 38 - Filtering Table with DAX Function
  • 39 - How to mark your Date Table
  • 40 - Time Intelligence YTD MTD and QTD DAX Function
  • 41 - Last month Revenue and MoM percentage Change
  • 42 - How to calculate 10Days Rolling total
  • 43 - How to calculate 10 Days Transactional Average
  • 44 - Better to Count using DAX

  • 5 - Advanced Customer Dashboard in Excel using DAX and Excel Functions
  • 45 - Dashboard overview
  • 46 - Setting Dashboard Canvas
  • 47 - How to add MCode Last Update date code
  • 48 - Adding values to cards
  • 49 - Adding Icons
  • 50 - Adding new cards with Gradient colors
  • 51 - How to create a Dynamic Top N in Excel
  • 52 - Creating a dynamic Title
  • 53 - How to create multiple Doughnut chart
  • 54 - Inserting a Bar charts
  • 55 - How to create a Map chart
  • 56 - 5 Less and Top Profitable Cities
  • 57 - How to connect Slicers to PivotTables

  • 6 - Adidas Sales Dashboard
  • 58 - Adidas-Dataset.zip
  • 58 - Adidas-dashboard.zip
  • 58 - Dashboard Overview
  • 59 - Transforming and Cleaning data with Power Query
  • 60 - Inserting PivotTable and Advanced Number formatting
  • 61 - Adding Month Filter
  • 62 - Dynamic way to show previous Month revenue with Percentage Change
  • 63 - Quantity Ordered and Transaction Cards
  • 64 - Which Product contributed more to Revenue
  • 65 - Which State should we push more Products to
  • 66 - What is the peak month for 2020 and 2021
  • 67 - Whats our top Region Sales Channel
  • 68 - Revenue trend by Weekday
  • 69 - Connecting Slicers to PivotTables
  • 70 - How to create a Single Button that clear all filters
  • 71 - New way to save your work
  • 72 - Formatting Slicers
  • 73 - Cleaning up your dashboard

  • 7 - Full Dynamic HR Human Resources Dashboard
  • 74 - Animated-Images.zip
  • 74 - Complet-HR-Dashboard.zip
  • 74 - Dashboard Overview
  • 74 - HR-Dataset.zip
  • 75 - Importing data into Excel Power Query
  • 76 - Removing unwanted columns in Power Query
  • 77 - Transforming Hr data in Excel Power Query
  • 78 - Cleaning the Dashboard area Canvas
  • 79 - Formatting your DataTable
  • 80 - 06 Employees KPI
  • 81 - Adding shapes to the dashboard environment
  • 82 - How to download Gif animated images to Excel
  • 83 - Creating chart for attrition and current employees
  • 84 - Employees by performance Status
  • 85 - How to create an icon slicer in Excel
  • 86 - Attrition by distance from work with dynamic legend
  • 87 - Attrition by job role visual
  • 88 - Formatting legends
  • 89 - Job role average Attrition
  • 90 - Attrition by Education types
  • 91 - How to create a custom chart in Microsoft Excel
  • 92 - Attrition by age Bucket and Gender
  • 93 - Custom chart for Gender
  • 94 - Average Age for employees
  • 95 - How to format Excel Slicers
  • 96 - Final formatting
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 10542
    حجم: 7757 مگابایت
    مدت زمان: 815 دقیقه
    تاریخ انتشار: 8 اردیبهشت 1402
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید