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

Become An Expert In Microsoft Power BI Desktop

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

2024's cutting-edge Power BI course tailored for Business Intelligence Analysts, Data Analysts and Data Professionals


1 - Introduction and Course Structure
  • 1 - Read Me.html
  • 2 - Introduction to Course
  • 3 - Course Design
  • 4 - Adventure-Works-Image-Resources.rar
  • 4 - Adventure-Works-Raw-Data.rar
  • 4 - Adventure-Work-Dashboard.rar
  • 4 - Become-an-Expert-in-Power-BI.rar
  • 4 - Download Resources.html
  • 5 - Course Project
  • 6 - Setting Expectations

  • 2 - Power BI Introduction
  • 1 - Quiz Introduction to Power BI Desktop.html
  • 7 - Introduction
  • 8 - What is Power BI
  • 9 - Power BI Download and Installation
  • 10 - Power BI Settings
  • 11 - Work Flow Interface
  • 12 - Resources and Monthly Updates

  • 3 - Connecting Preparing Data
  • 13 - Introduction Connecting Preparing Data
  • 14 - Power BI Data Sources Connectors
  • 15 - New Power Query Editor Tools
  • 16 - Table transformation
  • 17 - Assignment Table Transformation
  • 18 - Solution Table Transformation
  • 19 - Expert Tip Data Storage Connection Modes
  • 20 - Connecting to SQL Server Datasource
  • 21 - Connecting to a Web Page
  • 22 - QA Column Profiling Tools
  • 23 - Numeric Tools
  • 24 - Assignment Numeric Tools
  • 25 - Solution Assignment Numeric Tool
  • 26 - Text Tools
  • 27 - Assignment Text Tools
  • 28 - Solution Assignment Text Tools
  • 29 - Date Time Calendar Table
  • 30 - Changing Locale to Format Date
  • 31 - Expert Tip Rolling Calendar
  • 32 - Assignment Date Table
  • 33 - Solution Date Table
  • 34 - Index Conditional Columns
  • 35 - Guidelines to Work With Calculated Columns
  • 36 - Grouping Aggregation
  • 37 - Pivot UnPivot Columns
  • 38 - Merging Queries
  • 39 - Appending Queries
  • 40 - Expert Tip Adding Files From Folder
  • 41 - Data Source Setting
  • 42 - Expert Tip Parameterised Data Source
  • 43 - Refreshing Queries Organizing
  • 44 - Expert Tip Import Excel Model in Power BI
  • 45 - Best Practices Data Connection Preparation

  • 4 - Data Model
  • 46 - Data Modeling Introduction
  • 47 - Data Modeling 101
  • 48 - Normalization
  • 49 - Fact Dimension Tables
  • 50 - Primary Foreign Keys
  • 51 - Understanding Table Relationships
  • 52 - Creating Table Relationships
  • 53 - Managing Table Relationships
  • 54 - Star Snowflake Schemas
  • 55 - Assignment Table Relationships
  • 56 - Solution Assignment Table Relationships
  • 57 - Expert Tip Active InActive Relationship
  • 58 - Cardinality
  • 59 - Connecting to Multiple Data Tables
  • 60 - Filter Context Flow Waterfall Model
  • 61 - Bidirectional Filters Risks
  • 62 - Hiding Fields From Report View
  • 63 - Expert Tip Custom Model Layout
  • 64 - Assignment Hiding Fields
  • 65 - Solution Assignment Hiding Fields Filter Flow
  • 66 - Categorizing Formatting Data
  • 67 - The Data Hierarchies
  • 68 - Assignment Date Hierarchy
  • 69 - Solution Assignment Date Hierarchy
  • 70 - Best Practices Desiging a Data Model

  • 5 - Using DAX in Power BI
  • 71 - Introduction to Using DAX in Power BI
  • 72 - DAX
  • 73 - Mcode vs DAX Code
  • 74 - Calculated Columns
  • 75 - DAX Measures
  • 76 - Implicit Explicit Measures
  • 77 - Quick Measures
  • 78 - Comparing Calculated Columns Measures
  • 79 - Expert Tip Measures Tables
  • 80 - The Filter Context
  • 81 - Calculation Steps for a Measure
  • 82 - DAX Syntax and Operators
  • 83 - Frequently Used Functions
  • 84 - Maths Statistics Functions
  • 85 - Maths Counting Functions
  • 86 - Assignment New Measures
  • 87 - Solution Assignment New Measures
  • 88 - Expert Tip Organising Measures
  • 89 - Logical Functions in DAX
  • 90 - Switch Logical Function
  • 91 - Assignment Logical Functions
  • 92 - Solution Assignment Logical Functions
  • 93 - Text Functions in DAX
  • 94 - Assignment Text Functions
  • 95 - Solution Assignment Text Functions
  • 96 - DAX Functions for Date Time
  • 97 - Assignment Date Functions
  • 98 - Solution Assignment Date functions
  • 99 - The DAX Function RELATED
  • 100 - The DAX Function CALCULATE
  • 101 - The Peculiar Case of Unmtached Totals
  • 102 - Assignment CALCULATE Function
  • 103 - Solution Assignment CALCULATE Function
  • 104 - The ALL Function of DAX
  • 105 - Assignment CALCULATE ALL
  • 106 - Solution Assignment Calculate All
  • 107 - The FILTER Function of DAX
  • 108 - The Iterator Functions of DAX
  • 109 - Assignment Iterator Functions
  • 110 - Solution Assignment Iterator Functions
  • 111 - Time Intelligence Functions in DAX
  • 112 - Assignment Time Intelligence
  • 113 - Solution Assignment Time Intelligence
  • 114 - Best Practices Using DAX

  • 6 - Advanced DAX for Measures
  • 115 - Introduction to Advanced DAX
  • 116 - DAX Shortcuts
  • 117 - Formatting DAX Code
  • 118 - Comments in DAX Code
  • 119 - Error Handling in DAX
  • 120 - DAX Variables and Uses
  • 121 - Evaluation Order for Variables
  • 122 - Expert Tip Debug Test DAX
  • 123 - Modifiers for CALCULATE Function
  • 124 - Modifier REMOVEFILTERS
  • 125 - Modifier KEEPFILTERS
  • 126 - Assignment Modifiers
  • 127 - Solution Assignment Modifiers
  • 128 - Expert Tip Advanced CALCULATE Uses
  • 129 - Table Filter Functions
  • 130 - Calculated Virtual Tables
  • 131 - The DISTINCT Function
  • 132 - Versatile VALUES Function
  • 133 - Table Relationships
  • 134 - Iterator Cardinality
  • 135 - CONCATENATEX Function
  • 136 - Expert Tip Dynamic Labels
  • 137 - Requirements of a Date Table
  • 138 - Calendar Function
  • 139 - Expert Tip Reusable Date Table
  • 140 - Time Intelligence Functions
  • 141 - PARALLELPERIOD Function
  • 142 - PREVIOUSQUARTER Function
  • 143 - SAMEPERIODLASTYEAR Function
  • 144 - Additional Time Intelligence Calculations
  • 145 - Best Practices Advanced DAX

  • 7 - Visualizing Data
  • 146 - Introduction Visualizing Data on Dashboards
  • 147 - Key Questions Before You Design
  • 148 - Analytics Dashboard
  • 149 - The Dashboard Layout
  • 150 - Adding Pages Objects to Report View
  • 151 - Format Selection Panes
  • 152 - Cards MultiRow Cards
  • 153 - Assignment KPI Cards
  • 154 - Solution Assignment KPI Cards
  • 155 - OnObject Formatting
  • 156 - Adding Line Charts
  • 157 - Expert Tip Trend Lines Forecasts
  • 158 - Assignment Line Chart
  • 159 - Solution Assignment Line Chart
  • 160 - KPI Cards
  • 161 - Doughnut Bar Charts
  • 162 - The Filter Options Pane
  • 163 - Assignment Doughnut Chart Filters
  • 164 - Solution Assignment Doughnut Chart Filters
  • 165 - Tables Matrix Visuals
  • 166 - Conditional Formatting
  • 167 - Top N Filter
  • 168 - Assignment Tables
  • 169 - Solution Assignment Tables
  • 170 - Expert Tip Top N Text Cards
  • 171 - Assignment Top N Cards
  • 172 - Solution Assignment Top N Cards
  • 173 - New Card Visual
  • 174 - Advanced Formatting New Card Visual
  • 175 - More Advanced Formatting New Card Visual
  • 176 - Assignment New Card Visual
  • 177 - Solution Assignment New Card Visual
  • 178 - Expert Tip Sparkline Chart in Card
  • 179 - Map Visual
  • 180 - Slicers
  • 181 - Assignment Slicer
  • 182 - Solution Assignment Slicer
  • 183 - New Button Slicer
  • 184 - The DAX Function HASONEVALUE
  • 185 - Radial Gauge Charts
  • 186 - Expert Tip Advanced Formatting Gauge Charts
  • 187 - Area Charts
  • 188 - Drill Up Down
  • 189 - Assignment Drill Up Down
  • 190 - Solution Assignment Drill Up Down
  • 191 - CrossReport Drillthrough
  • 192 - Editing Report Interactions
  • 193 - Assignment Report Interactions
  • 194 - Solution Assignment Report Interactions
  • 195 - Power BI Bookmarks
  • 196 - Assignment Bookmarks
  • 197 - Solution Assignment Bookmarks
  • 198 - Expert Tip Custom Navigation Buttons
  • 199 - Expert Tip Slicer Panel
  • 200 - Report Parameters
  • 201 - Fields Parameters
  • 202 - Assignment Field Parameters
  • 203 - Solution Assignment Field Parameters
  • 204 - Expert Tip Custom Tooltips
  • 205 - Assignment Custom Tooltip
  • 206 - Solution Assignment Custom Tooltip
  • 207 - Using Custom Visuals
  • 208 - Using Roles in Power BI
  • 209 - Mobile Layouts
  • 210 - Preview Publishing to Power BI Service
  • 211 - Best Practices Data Visualizations

  • 8 - Artificial Intelligence in Power BI
  • 212 - Introduction to AI in Power BI
  • 213 - Anomaly Detection
  • 214 - Smart Narrative Summaries
  • 215 - QA Visuals
  • 216 - Decomposition Tree
  • 217 - Key Influencers

  • 9 - Optimization Tools in Power BI
  • 218 - Introduction to Optimization in BI
  • 219 - Optimize Menu Ribbon
  • 220 - Pausing Visuals
  • 221 - Optimization Presets
  • 222 - Applying AIl slicer button
  • 223 - Performance Analyzer
  • 224 - External Tools

  • 10 - Power BI Updates New Features
  • 225 - About This Section.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 38627
    حجم: 11662 مگابایت
    مدت زمان: 1563 دقیقه
    تاریخ انتشار: 28 تیر 1403
    دسته بندی محصول
    طراحی سایت و خدمات سئو

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