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

Microsoft Power BI Advanced Dashboard Full Practical Course

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

We will help you learn how to create Clean DASHOARDS (2023 Edition) Advanced Power BI analysis & data visualization


1 - Watch me First
  • 1 - How to access the downloaded files

  • 2 - Build your Portfolio for free
  • 2 - Learn how to build your portfolio site for free with spending any money

  • 3 - Picking the Right charts for your project
  • 3 - Learn the functions of charts before you use them

  • 4 - Banex Cycles Sales Dashboard
  • 4 - All-Resources-in-one-Pack.zip
  • 4 - Banex-Cycles-Dashboard-Files.zip
  • 4 - Project brief
  • 5 - Dashboard overview
  • 6 - Loading and Transforming Data
  • 7 - Correcting Relationships in Model view
  • 8 - Creating a Date Table
  • 9 - How to change Folder Path and clear Errors in Power BI and Power Query
  • 10 - How to use Sumx Related and DateAdd for aggrigation
  • 11 - Creating KPI Cards
  • 12 - Formatting KPI Cards
  • 13 - How to create Power BI Custom Chart 01
  • 14 - How to create Power BI Custom Chart 02
  • 15 - How to create Power BI Custom Chart 03
  • 16 - Fix Error in the Custom BlankSpace
  • 17 - Custom chart Color formatting and Resizing
  • 18 - Custom Chart formatting and Titles
  • 19 - Custom Value formatting
  • 20 - How to insert up and down Arrow for conditional formatting
  • 21 - How to create a Folder inside a Measure Table
  • 22 - How to create Product Ranking 01
  • 23 - Using Whatif Parameter to control Top N
  • 24 - Dynamic Titles and chart formatting
  • 25 - Creating a Custom Template

  • 5 - Banex Cycles Sales Dashboard Part 2
  • 26 - Project Brief
  • 27 - Dashboard overview
  • 28 - Profit details
  • 29 - Creating a custom Template

  • 6 - Store Sales Detailed Dashboard
  • 30 - Project Brief
  • 30 - Store-Sales-Dashboard-files.zip
  • 31 - Dashboard overview
  • 32 - Importing data to Power Query for cleaning and transformation
  • 33 - Table arrangement for Relationships
  • 34 - Understanding Relationships
  • 35 - Creating a Date or Calendar Table
  • 36 - Creating Relationships between Dates and sorting
  • 37 - How to hide Tables in Power BI
  • 38 - Dashboard development process
  • 39 - Creating a measure Table
  • 40 - Custom visual Variance calculations
  • 41 - Daily Revenue vs Target
  • 42 - Gross Profit and of Margin
  • 43 - Line chart for Gross profit Margin
  • 44 - Top selling Products and Brands
  • 45 - How to use a Bullet Chart by OKVIZ
  • 46 - Dashboard Formatting
  • 47 - Creating a Custom Template 01
  • 48 - Creating a Custom Template 02
  • 49 - Dashboard colors formatting 01
  • 50 - Dashboard color Formatting 02

  • 7 - Employees Detailed Dashboard
  • 51 - Project Brief
  • 52 - Employees Dashboard overview
  • 53 - Step development
  • 54 - How to calculate Salary till date
  • 55 - Edit Relationships
  • 56 - How to use Variable to create a Dynamic Title
  • 57 - Top Paid Employees
  • 58 - Employees by Work Distance
  • 59 - Employees by Absence Reasons
  • 60 - Work Absence and Employees by Roles
  • 61 - Dashboard arrangement
  • 62 - Creating a custom Template 01
  • 63 - Creating a custom Template 02
  • 64 - Formatting and getting Icons

  • 8 - Store Sales Customer Dashboard
  • 65 - Project Brief
  • 66 - Project Overview
  • 67 - Total Customers Average Revenue Per Customers
  • 68 - Importing a Sparkline from the market place
  • 69 - Sales by Age Range
  • 70 - Sales by weekdays
  • 71 - Customer Spending Range 01
  • 72 - Customer Spending Range 02
  • 73 - Customers by Temperature of the moment
  • 74 - Creating a custom Template
  • 75 - Dashboard Formatting

  • 9 - Bike Accident Dashboard
  • 76 - Accident-Dashboard-Files.zip
  • 76 - Project Brief
  • 77 - Dashboard Tasks
  • 78 - Loading and Cleaning data
  • 79 - How to split table in Dimension in Power Query
  • 80 - Linking FactTable to the Lookup Tables
  • 81 - Connecting Tables
  • 82 - Custom Date Table 01
  • 83 - Custom Date Table 02
  • 84 - Aggregation using Sum and Countrows
  • 85 - How to create a switchable measure
  • 86 - Creating visual with our Switchable measure
  • 87 - How to Split Column in Power Query
  • 88 - How to categorize column
  • 89 - Using VAR to create Percentages
  • 90 - Organizing Visual on the Dashboard
  • 91 - Dynamic Title 01
  • 92 - Dynamic Title 02
  • 93 - Dynamic Title 03
  • 94 - Custom Template 01
  • 95 - Formatting and Exporting custom Template
  • 96 - Final Formatting
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 6215
    حجم: 7011 مگابایت
    مدت زمان: 628 دقیقه
    تاریخ انتشار: 3 اسفند 1401
    طراحی سایت و خدمات سئو

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