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

Advanced Microsoft Power BI

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

View Helen's LinkedIn Newsletter


Data visualization allows you to represent information digitally and graphically, to convey the results of data analysis. Microsoft Power BI is a suite of business analytics tools that help you gain insights from your data. The suite brings together familiar operations from well-known products—including Excel, Access, Power Query, and Power Pivot—to help you quickly move past the basics and on to comprehensive analysis. In this course, Helen Wall guides you through the advanced capabilities of the service. She shows how to work with calculations, effectively leverage the DAX language, create advanced queries, and use the M language to improve the querying process. Helen also demonstrates how to get data into Power BI using the Power Query editor and then model the loaded data using DAX columns, tables, and measures. To lend these concepts a real-world context, she shares how to create a financial model for loans.


01 - Introduction
  • 01 - Explore advanced features of Power BI
  • 02 - What you should know
  • 03 - Exercise files

  • 02 - 1. Working with Power BI
  • 01 - Introducing the course project
  • 02 - Power Query and M language
  • 03 - DAX language
  • 04 - Efficient data strategies

  • 03 - 2. DAX Language
  • 01 - DAX tables and GENERATESERIES
  • 02 - DAX columns
  • 03 - DAX measures
  • 04 - DATE, YEAR, MONTH, and DAY date DAX functions
  • 05 - CALENDAR and CALENDARAUTO DAX functions
  • 06 - DAX measure evaluation context
  • 07 - CALCULATE DAX function
  • 08 - DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions
  • 09 - Challenge Crop modeling
  • 10 - Solution Crop modeling

  • 04 - 3. DAX Formulas
  • 01 - ALL DAX function
  • 02 - POWER DAX function
  • 03 - DIVIDE DAX function
  • 04 - Variables in DAX formulas
  • 05 - Iterator DAX functions and SUMX
  • 06 - FILTER DAX function
  • 07 - Challenge Rate of change by commodity
  • 08 - Solution Rate of change by commodity

  • 05 - 4. Advanced DAX Calculations
  • 01 - SELECTEDVALUE DAX function
  • 02 - IF DAX function for conditional formulas
  • 03 - EOMONTH DAX function
  • 04 - DATEDIFF DAX function
  • 05 - BLANK and ISBLANK DAX functions
  • 06 - Filtering between tables
  • 07 - DAX acrobatics
  • 08 - GENERATE and ROW DAX functions with calculated dates tables
  • 09 - DATESBETWEEN DAX function
  • 10 - DATEADD DAX function
  • 11 - MTD, QTD, and YTD date DAX functions
  • 12 - DAX quick measures
  • 13 - Power BI summarized view
  • 14 - Challenge DAX time intelligence modeling
  • 15 - Solution DAX time intelligence modeling

  • 06 - Continuing Your Power BI Learning Journey
  • 01 - Next steps and additional resources
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 2744
    حجم: 538 مگابایت
    مدت زمان: 184 دقیقه
    تاریخ انتشار: 28 دی 1401
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید