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

Power BI Zero to Pro w/ Data Analysis Masterclass & ChatGPT

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

2 courses in 1: Starting from Zero, Master Power BI & Data Analysis in Power BI, leveraging tools like DAX, & ChatGPT


1. Introduction & Getting Started
  • 1. Introducing Power BI - Download & Install
  • 2.1 Business Data lecture file.xlsx
  • 2. Download the course data file.html
  • 3. Welcome to Power BI! Getting started
  • 4. Formatting the Data
  • 5. Adding the Calendar Table
  • 6. Connecting the Tables - Data Modeling
  • 7. Adding & Exploring our first Visual
  • 8. Formatting the Visual
  • 9. Quick yet Amazing Dashboard

  • 2. Exploring Other Amazing Visuals & Features
  • 1. Introduction to the section
  • 2. Tables - Reorganize Data & Make it Insightful!
  • 3. Slicers - Look at any specific parameters
  • 4. Drill through - From Dashboard to underlying transaction in a second
  • 5. Filters - Filter out clutter
  • 6. Matrix - The Magical Way to Prepare Insightful Reports!
  • 7. Bar & Column Chart - StackedClustered100% Stacked
  • 8. LineAreaStacked Area100% Stacked Area Chart - Tracing Trends
  • 9. Line & Column Chart - The Most Powerful Chart to Corelate things
  • 10. Ribbon Chart - Visualizing the Change in Relative Position
  • 11. Waterfall Chart - Identify the Drivers of Change!
  • 12. Funnel Chart - The Way to Measure Conversion
  • 13. Scatter Chart - Unveil Patters & Correlations
  • 14. PieDonut Chart & Tree Map - Show Composition
  • 15. Cards & Multirow Cards - Present the Absolute Value
  • 16. Maps & Filled Maps - Show Values over Map
  • 17. Other Charts and the plan

  • 3. Calculations in Power BI with DAX
  • 1. Introduction to DAX
  • 2. Adding columns with DAX - Part 1
  • 3. Adding Columns with DAX - Part 2
  • 4. Adding columns with DAX - Part 3 - Conditional Columns
  • 5. IF Statement IF OR IF OR IN
  • 6. IF AND
  • 7. Homework - IF OR AND.html
  • 8. Homework answers - IF OR AND
  • 9. Merging Columns - CONCATENATE
  • 10. Data from Other Tables - RELATED
  • 11. Basic Calculations in Calculated Columns
  • 12. Adding Calendar Table with DAX
  • 13. LookupValue
  • 14.1 3. Section 3.zip
  • 14. Section file.html

  • 4. Calculations in Power BI - Measures
  • 1. Introducing Measures
  • 2. AVERAGE
  • 3. SUMX - Row by row calculation first, then Sum
  • 4. RELATED in Measures
  • 5. Practice - SUMX & RELATED, and transforming the data in professional way
  • 6. Section files.html
  • 7. Getting ready for our next DAX Measures
  • 8. CALCULATE - The Golden DAX function - Filter data like a pro!
  • 9. Homework answers - CALCULATE
  • 10. DIVIDE
  • 11. Dividing in Matrix
  • 12. MIN & MAX
  • 13. ALL - Bypassing Filters
  • 14. Section end file.html
  • Files.zip

  • 5. Measures with DAX - Part 2 - Time Intelligence
  • 1. Introduction to the section
  • 2. YTD - Year to date totals
  • 3. QTD - Quarter to date MTD - Month to date
  • 4. TTD - Total to date
  • 5. Rolling Sum & Moving Average
  • 6. Rolling Sum & Moving Average - Excluding Initial Days
  • 7. Homework.html
  • 8. Homework Answers
  • 9. Section file.html
  • Files.zip

  • 6. Measures with DAX - Comparative Values
  • 1. Previous Period Value
  • 2. Making PP Dynamic - Calculating Dynamic Number of Months in the Period
  • 3. Period on Period Growth
  • 4. Previous Corresponding Period Value
  • 5. PCP Growth
  • 6. Visualizing these Values in a Stunning Chart
  • 7. Section end file.html
  • Files.zip

  • 7. Other Amazing DAX formulas & concepts that you MUST know
  • 1. Homework Ready your Power BI file for the section.html
  • 2. Introduction and setting up the file
  • 3. SWITCH - The magical way to conditional calculations!
  • 4. Homework SWITCH.html
  • 5. Homework answers and SWITCH with OR
  • 6. VAR in DAX
  • 7. Challenge Homework.html
  • 8. Homework answers
  • 9. Incorporating Dynamic Holidays
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 39828
    حجم: 5242 مگابایت
    مدت زمان: 615 دقیقه
    تاریخ انتشار: ۱ آبان ۱۴۰۳
    طراحی سایت و خدمات سئو

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