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

Microsoft Power BI Desktop for Business Intelligence (2023)

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

Master Power BI Desktop for data analysis with hands-on assignments & projects from top-rated Power BI instructors


01 - Getting Started
  • 001 READ ME Important Notes for New Students.html
  • 002 Course Introduction
  • 003 Course Structure & Outline
  • 004 AdventureWorks-Images.zip
  • 004 AdventureWorks-PBIX-Files.zip
  • 004 AdventureWorks-Raw-Data.zip
  • 004 DOWNLOAD Course Resources.html
  • 004 Power-BI-for-Business-Intelligence.pdf
  • 005 Introducing the Course Project
  • 006 Setting Expectations

  • 02 - Introducing Microsoft Power BI Desktop
  • 001 Section Introduction
  • 002 Meet Power BI Desktop
  • 003 Downloading Power BI
  • 004 IMPORTANT Adjusting Settings
  • 005 Power BI Desktop Interface & Workflow
  • 006 Resources & Monthly Updates

  • 03 - Connecting & Shaping Data
  • 001 Section Introduction
  • 002 Power BI Front-End vs. Back-End
  • 003 Types of Data Connectors
  • 004 The Power Query Editor
  • 005 Basic Table Transformations
  • 006 ASSIGNMENT Table Transformations
  • 007 SOLUTION Table Transformations
  • 008 PRO TIP Storage & Connection Modes
  • 009 Connecting to a Database
  • 010 Extracting Data from the Web
  • 011 Data QA & Profiling Tools
  • 012 Text Tools
  • 013 ASSIGNMENT Text-Specific Tools
  • 014 SOLUTION Text-Specific Tools
  • 015 Numerical Tools
  • 016 ASSIGNMENT Numerical Tools
  • 017 SOLUTION Numerical Tools
  • 018 Date & Time Tools
  • 019 Change Type with Locale
  • 020 PRO TIP Rolling Calendars
  • 021 ASSIGNMENT Calendar Tables
  • 022 SOLUTION Calendar Tables
  • 023 Index & Conditional Columns
  • 024 Calculated Column Best Practices
  • 025 Grouping & Aggregating
  • 026 Pivoting & Unpivoting
  • 027 Merging Queries
  • 028 Appending Queries
  • 029 PRO TIP Appending Files from a Folder
  • 030 Data Source Settings
  • 031 PRO TIP Data Source Parameters
  • 032 Refreshing Queries
  • 033 PRO TIP Importing Excel Models
  • 034 Power Query Best Practices

  • 04 - Creating a Data Model
  • 001 Section Introduction
  • 002 Data Modeling 101
  • 003 Database Normalization
  • 004 Fact & Dimension Tables
  • 005 Primary & Foreign Keys
  • 006 Relationships vs. Merged Tables
  • 007 Creating Table Relationships
  • 008 Managing & Editing Relationships
  • 009 Star & Snowflake Schemas
  • 010 ASSIGNMENT Table Relationships
  • 011 SOLUTION Table Relationships
  • 012 PRO TIP Active & Inactive Relationships
  • 013 Relationship Cardinality
  • 014 Connecting Multiple Fact Tables
  • 015 Filter Context & Filter Flow
  • 016 Bi-Directional Filters & Ambiguity
  • 017 Hiding Fields from Report View
  • 018 ASSIGNMENT Filter Flow
  • 019 SOLUTION Filter Flow
  • 020 PRO TIP Model Layouts
  • 021 Data Formats & Categories
  • 022 Creating Hierarchies
  • 023 ASSIGNMENT Hierarchies
  • 024 SOLUTION Hierarchies
  • 025 Data Model Best Practices

  • 05 - Calculated Fields with DAX
  • 001 Section Introduction
  • 002 Data Analysis Expressions 101
  • 003 DAX vs. M Languages
  • 004 Intro to DAX Calculated Columns
  • 005 Intro to DAX Measures
  • 006 Implicit vs. Explicit Measures
  • 007 Quick Measures
  • 008 RECAP Calculated Columns vs. Measures
  • 009 PRO TIP Dedicated Measure Tables
  • 010 Understanding Filter Context
  • 011 Step-by-Step DAX Measure Calculation
  • 012 DAX Syntax & Operators
  • 013 Common DAX Function Categories
  • 014 Basic Math & Stats Functions
  • 015 Counting Functions
  • 016 ASSIGNMENT Math & Stats Functions
  • 017 SOLUTION Math & Stats Functions
  • 018 Conditional & Logical Functions
  • 019 The SWITCH Function
  • 020 ASSIGNMENT Logical Functions
  • 021 SOLUTION Logical Functions
  • 022 Common Text Functions
  • 023 ASSIGNMENT Text Functions
  • 024 SOLUTION Text Functions
  • 025 Basic Date & Time Functions
  • 026 ASSIGNMENT Date & Time
  • 027 SOLUTION Date & Time
  • 028 Joining Data with RELATED
  • 029 The CALCULATE Function
  • 030 DAX Measure Totals
  • 031 ASSIGNMENT CALCULATE
  • 032 SOLUTION CALCULATE
  • 033 The ALL Function
  • 034 ASSIGNMENT CALCULATE & ALL
  • 035 SOLUTION CALCULATE & ALL
  • 036 The FILTER Function
  • 037 Iterator (X) Functions
  • 038 ASSIGNMENT Iterators
  • 039 SOLUTION Iterators
  • 040 Time Intelligence Patterns
  • 041 ASSIGNMENT Time Intelligence
  • 042 SOLUTION Time Intelligence
  • 043 DAX Best Practices

  • 06 - Visualizing Data with Reports
  • 001 Section Introduction
  • 002 The 3 Key Questions
  • 003 Dashboard Design Framework
  • 004 Sketching the Dashboard Layout
  • 005 Adding Report Pages & Objects
  • 006 Naming & Grouping Objects
  • 007 Cards & Multi-Row Cards
  • 008 ASSIGNMENT Cards
  • 009 SOLUTION Cards
  • 010 Building & Formatting Charts
  • 011 Line Charts
  • 012 PRO TIP Trend Lines & Forecasts
  • 013 ASSIGNMENT Line Chart & Trend
  • 014 SOLUTION Line Chart & Trend
  • 015 KPI Cards
  • 016 Bar & Donut Charts
  • 017 Basic Filtering Options
  • 018 ASSIGNMENT Donuts & Filters
  • 019 SOLUTION Donuts & Filters
  • 020 Table & Matrix Visuals
  • 021 Conditional formatting
  • 022 Top N Filtering
  • 023 ASSIGNMENT Tables
  • 024 SOLUTION Tables
  • 025 Top N Text Cards
  • 026 ASSIGNMENT Top N Text Cards
  • 027 SOLUTION Top N Text Cards
  • 028 Map Visuals
  • 029 Report Slicers
  • 030 ASSIGNMENT Slicers
  • 031 SOLUTION Slicers
  • 032 PRO TIP HASONEVALUE
  • 033 Gauge Charts
  • 034 PRO TIP Advanced Conditional Formatting
  • 035 Area Charts
  • 036 Drill Up & Drill Down
  • 037 ASSIGNMENT Drill Up & Drill Down
  • 038 SOLUTION Drill Up & Drill Down
  • 039 Drillthrough Filters
  • 040 Editing Report Interactions
  • 041 ASSIGNMENT Report Interactions
  • 042 SOLUTION Report Interactions
  • 043 Adding Bookmarks
  • 044 ASSIGNMENT Bookmarks
  • 045 SOLUTION Bookmarks
  • 046 PRO TIP Custom Navigation Buttons
  • 047 PRO TIP Slicer Panels
  • 048 Numeric Range Parameters
  • 049 Fields Parameters
  • 050 ASSIGNMENT Fields Parameters
  • 051 SOLUTION Fields Parameters
  • 052 PRO TIP Custom Tool Tips
  • 053 Importing Custom Visuals
  • 054 Managing & Viewing Roles
  • 055 Mobile Layouts
  • 056 PREVIEW Publishing to Power BI Service
  • 057 Data Visualization Best Practices

  • 07 - Artificial Intelligence (AI)
  • 001 Section Introduction
  • 002 Anomaly Detection
  • 003 Smart Narratives
  • 004 Q&A Visuals
  • 005 Decomposition Trees
  • 006 Key Influencers

  • 08 - Power BI Optimization Tools
  • 001 Section Introduction
  • 002 The Optimize Ribbon
  • 003 Pausing Visuals
  • 004 Optimization Presets
  • 005 Applying All Slicers
  • 006 Performance Analyzer
  • 007 External Tools

  • 09 - BONUS PROJECT Maven Market
  • 001 Introduction.html
  • 001 Maven-Market-CSV-Files.zip
  • 001 Maven-Market-Report-COMPLETE.zip
  • 001 maven-market.zip
  • 002 PART 1 Connecting & Shaping the Data.html
  • 003 PART 2 Creating the Data Model.html
  • 004 PART 3 Adding DAX Measures.html
  • 005 PART 4 Building the Report.html

  • 10 - BONUS LESSON
  • 001 BONUS LESSON.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 20942
    حجم: 4685 مگابایت
    مدت زمان: 888 دقیقه
    تاریخ انتشار: ۷ آبان ۱۴۰۲
    طراحی سایت و خدمات سئو

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