قدرت دو هفته ای

مدرس Helen Wall

انتشار 2022/04/07

به‌روز‌رسانی 2025/10/01

مدت زمان 17h 48m

سطح مناسب همه

فایل تمرینی دارد

آموزش Power BI Weekly

به سریال هفتگی Power BI خوش آمدید. هر هفته ، مربی هلن وال یک موضوع جالب و مرتبط را در Power BI ، پلت فرم اطلاعات تجاری کم کد از مایکروسافت پوشش می دهد. هلن مباحثی مانند بهینه سازی اقدامات پویا روی صفحه نمایش ، ترفندهای DAX ، تکنیک های پرس و جو قدرت و سفارشی کردن تصاویر را برای کاربران نهایی پوشش می دهد. اگر می خواهید از این نرم افزار تجسم داده های تعاملی اطلاعات بیشتری کسب کنید ، هفتگی را برای آخرین درس های هلن بررسی کنید.

Analytics Business Intelligence (BI) Data Analytics Microsoft Power BI

New This Week

Heat map with standard scatter plot ()

Introduction

Unlocking techniques with Power BI ()

What you should know ()

Previous Episodes

Icon map visual ()

Box and whisker plots with standard visuals ()

Highlighting maps ()

Category labels in Azure maps ()

Azure map zoom levels ()

Tessellated choropleth maps in the Azure map visual ()

Stepped color gradients ()

Ridgeplots or ridgeline plots ()

Automatic mobile view ()

TMDL to batch delete code ()

Splitting and stacking data ()

Creating a clock visual ()

New list slicer ()

Text search visual ()

Folders in Power BI service ()

DAX data liineage for unique values ()

TMDL scripting ()

Radial charts from line charts ()

Radial calculations in Power Query ()

Radial charts from scatter plots ()

Optimized foreground colors ()

Visualized RGB color models ()

Hexadecimal values with colors ()

Azure map visual map tile layer ()

Azure map visual path layer ()

Optimizing web accessible font colors ()

Leveraging ISBLANK for blank values ()

Applying custom marker formatting ()

Adding DAX measures through DAX query view ()

Leveraging data lineage with SUMMARIZE DAX function ()

Utilizing ROWNUMBER DAX function ()

Leveraging Image URLs as data ()

Leveraging 100% stacked area charts ()

Building report themes ()

Utilizing dark mode ()

Aligning visual elements ()

Creating a choropleth map with custom map outlines ()

Formatting value strings ()

Utilizing the TOCSV and TOJSON DAX functions ()

Leveraging the Metrics visual ()

Utilizing a Mekko chart to uncover hidden proportions ()

Using COUNTBLANK and ISBLANK DAX functions ()

Creating advanced drillthrough pages with DAX measures ()

Using ROWNUMBER DAX function to add a table index ()

Adding parameters to online paginated reports ()

Utilizing map outlines in ArcGIS Map visual ()

Building a dynamic Azure Map reference layer ()

Formatting Azure Map reference layer elements ()

Saving as PBIP project ()

Building weekly calculations ()

Pivoting by index ()

Displaying daylight times in an area chart ()

Formatting times ()

Solar calculations for sunrise and sunset times ()

Dealing with time zones ()

Daylight savings in Power Query for multiple years ()

Daylight savings in Power Query for a single year ()

Payroll dates table ()

Visual calculations ()

DAX INFO functions with the DAX query editor ()

Using the SELECTEDMEASURENAME DAX function ()

Calculation groups with the DAX SELECTEDMEASURE function ()

Azure Maps reference layer ()

Stream graphs ()

Sorting column order in Power Query ()

Customizing the appearance of bars ()

Adding customized data labels ()

Leveraging the new slicer visual ()

Leveraging Azure Maps clustering ()

Building tessellated maps ()

Using the DAX ISFILTERED function ()

Integrating Power Apps into Power BI ()

Adding images to the new card visual ()

Adding borders to the new card visual ()

Adding background card colors in the new card visual ()

Formatting values in the new card visual ()

Formatting labels in the new card visual ()

Calendar titles on new card visual ()

Calendar values on new card visual ()

Shaded areas with reference lines ()

Series label options ()

Mapbox visual with layers ()

Markers and labels for latest data point ()

Relative date slicer options ()

Help header icons with tooltips ()

Adding subtitles to titles ()

3D columns map layer ()

Heatmap map layer ()

ArcGIS map visual ()

Pattern matching in Power Query ()

Change matrix visual orientation ()

Query Power BI REST API ()

Highlight a line in a visual ()

Add leader lines ()

Build DAX date table ()

Interpolate values ()

Use new card visual ()

Label data points with DAX measures ()

Add local midnight markers ()

Create logistic regression visual ()

Add paginated report visual to Power BI report ()

Leverage Power BI Report Builder ()

Create paginated reports in Fabric ()

Visio diagrams ()

Radar charts ()

Custom gridlines ()

Field parameter groups ()

Sales from new customers ()

Conditional data label font colors ()

Hex color value formatting ()

Pop-out slicer pane ()

On-object visual editing ()

Text data labels ()

AI for DAX measures ()

Apply and clear all slicers ()

Dynamic measure formatting ()

Adding a shape map outline as a style with Mapbox custom visual ()

Updating Power BI visuals with modern tooltips ()

Expanding row filter context in DAX measures with WINDOW function ()

Building a pairplot visual for multiple scatter plots ()

Running linear regression with LINEST DAX function ()

Converting scatter plots into 2D and hexbin heat maps ()

Using SWITCH with multiple conditions ()

Creating correlation plot matrix ()

Using INDEX to access a value position ()

Adding budget lines to bar charts with actuals ()

Creating a star review DAX measure ()

Creating Gantt charts ()

Using OFFSET to change DAX measure context ()

Logarithmic visual scales ()

PRODUCTX DAX measure ()

Normal distribution curve in DAX measures ()

TOPN DAX function ()

Aggregated slicers using measure value inputs ()

Non-standard calendar DAX calculations ()

Date calculations with alternative year-end dates ()

NETWORKDAYS DAX function ()

Report filter resets for only selected visuals ()

Conditional formatting for data bars, icons, and web URLs ()

Clipped shapefile maps ()

Row-level security ()

DAX queries for import data ()

Power BI goals ()

XMLA endpoint ()

Performance analyzer ()

Deneb visual ()

Power BI REST API developer sandbox ()

Smart narrative visual ()

Field parameters ()

Dynamic axes start and end values ()

Sparklines on table and matrix visuals ()

DAX operators ()

Images as data ()

USERELATIONSHIP DAX filter function ()

Connecting to data with a Python script ()

Calculating durations dynamically ()

Highlighting selected data ()

Utilizing SWITCH ()

Building a Pareto chart ()

Combining text labels with CONCATENATEX ()

Configuring dynamic constant lines ()

Combining single-card visuals ()

Adding play button for time series fields ()

Building calendar heat maps ()

Adding error bars to a visual ()

Creating custom maps ()

Merging tables with fuzzy matching ()

Clustering values in Dataflows ()

Switching between two visuals in one space ()

Drilling through pages ()

Configuring condition color options ()

Changing visual titles dynamically ()

Changing displayed axes dynamically ()

Selecting columns dynamically in a matrix visual ()

Layering visual elements on a page ()

Adding a button for resetting filters ()

Integrating Python scripts into visuals ()

Calculating score sentiment with Text Analytics functions ()

Running Python script on existing query ()

Running R script on existing query ()

Converting local time to UTC time ()

Data_Sources.zip (5.2 MB)

05_13_begin.zip (499 KB)

05_12_begin.zip (120 KB)

05_11_begin.zip (96 KB)

05_10_begin.zip (215 KB)

05_09_begin.zip (246 KB)

05_08_begin.zip (176 KB)

05_07_begin.zip (71 KB)

05_06_begin.zip (215 KB)

06_01_begin.zip (64 KB)

05_05_begin.zip (79 KB)

05_03_begin.zip (81 KB)

05_02_begin.zip (364 KB)

05_01_begin.zip (76 KB)

04_13_begin.zip (341 KB)

04_12_begin.zip (409 KB)

04_11_begin.zip (59 KB)

04_10_begin.zip (49 KB)

04_09_begin.zip (50 KB)

05_04_begin.zip (714 KB)

06_02_begin.zip (4.3 MB)

06_03_begin.zip (3.0 MB)

06_04_begin.zip (129 KB)

07_10_begin.zip (208 KB)

07_09_begin.zip (252 KB)

07_08_begin.zip (128 KB)

07_07_begin.zip (140 KB)

07_06_begin.zip (140 KB)

07_05_begin.zip (1.3 MB)

07_04_begin.zip (143 KB)

07_03_begin.zip (170 KB)

07_02_begin.zip (7 KB)

07_01_begin.zip (155 KB)

06_13_begin.zip (499 KB)

06_12_begin.zip (285 KB)

06_11_begin.zip (90 KB)

06_10_begin.zip (203 KB)

06_09_begin.zip (77 KB)

06_08_begin.zip (168 KB)

06_07_begin.zip (141 KB)

06_06_begin.zip (4.3 MB)

06_05_begin.zip (3.5 MB)

04_08_begin.zip (362 KB)

04_07_begin.zip (443 KB)

04_06_begin.zip (105 KB)

04_05_begin.zip (1.8 MB)

02_07_begin.zip (432 KB)

02_06_begin.zip (599 KB)

02_05_begin.zip (1.1 MB)

02_04_begin.zip (2.0 MB)

02_03_begin.zip (281 KB)

02_02_begin.zip (43 KB)

02_01_begin.zip (0 KB)

01_13_begin.zip (2.4 MB)

01_12_begin.zip (1.9 MB)

01_11_begin.zip (2.4 MB)

01_10_begin.zip (138 KB)

01_09_begin.zip (223 KB)

01_08_begin.zip (2.0 MB)

01_07_begin.zip (2.6 MB)

01_06_begin.zip (2.0 MB)

01_05_begin.zip (74 KB)

01_04_begin.zip (34 KB)

01_03_begin.zip (151 KB)

01_02_begin.zip (126 KB)

02_08_begin.zip (227 KB)

07_11_begin.zip (134 KB)

02_09_begin.zip (2.0 MB)

02_11_begin.zip (1.3 MB)

04_04_begin.zip (1.6 MB)

04_03_begin.zip (1.3 MB)

04_02_begin.zip (102 KB)

04_01_begin.zip (1.1 MB)

03_13_begin.zip (58 KB)

03_12_begin.zip (623 KB)

03_11_begin.zip (3.0 MB)

03_10_begin.zip (1.2 MB)

03_09_begin.zip (72 KB)

03_08_begin.zip (168 KB)

03_07_begin.zip (109 KB)

03_06_begin.zip (366 KB)

03_05_begin.zip (265 KB)

03_04_begin.zip (151 KB)

03_03_begin.zip (998 KB)

03_02_begin.zip (205 KB)

03_01_begin.zip (15 KB)

02_13_begin.zip (118 KB)

02_12_begin.zip (199 KB)

02_10_begin.zip (51 KB)

07_13_begin.zip (177 KB)

08_01_begin.zip (79 KB)

08_02_begin.zip (48 KB)

13_02_begin.zip (17 KB)

13_01_begin.zip (97 KB)

12_13_begin.zip (38 KB)

12_12_begin.zip (115 KB)

12_11_begin.zip (136 KB)

12_10_begin.zip (127 KB)

12_09_begin.zip (37 KB)

12_08_begin.zip (133 KB)

12_07_begin.zip (37 KB)

12_06_begin.zip (132 KB)

12_05_begin.zip (361 KB)

12_04_begin.zip (34 KB)

12_03_begin.zip (41 KB)

12_02_begin.zip (1.0 MB)

12_01_begin.zip (32 KB)

11_13_begin.zip (77 KB)

11_12_end.zip (12 KB)

11_11_begin.zip (257 KB)

11_10_begin.zip (162 KB)

13_03_begin.zip (12 KB)

11_09_begin.zip (139 KB)

13_04_end.zip (28 KB)

13_06_begin.zip (19 KB)

14_13_begin.zip (82 KB)

14_12_begin.zip (7.4 MB)

14_11_begin.zip (6.1 MB)

14_10_begin.zip (41 KB)

14_09_begin.zip (87 KB)

14_08_begin.zip (78 KB)

14_07_begin.zip (76 KB)

14_06_begin.zip (65 KB)

14_05_begin.zip (78 KB)

14_04_begin.zip (93 KB)

14_03_begin.zip (2.6 MB)

14_02_begin.zip (36 KB)

14_01_begin.zip (39 KB)

13_13_begin.zip (34 KB)

13_12_begin.zip (26 KB)

13_10_begin.zip (44 KB)

13_09_begin.zip (50 KB)

13_08_begin.zip (51 KB)

13_07_begin.zip (15 KB)

13_05_begin.zip (16 KB)

01_01_begin.zip (1.7 MB)

11_08_begin.zip (116 KB)

11_06_begin.zip (54 KB)

09_08_begin.zip (180 KB)

09_07_begin.zip (59 KB)

09_06_end.zip (66 KB)

09_05_begin.zip (1.3 MB)

09_04_begin.zip (171 KB)

09_03_begin.zip (167 KB)

09_02_begin.zip (137 KB)

09_01_begin.zip (136 KB)

08_13_begin.zip (147 KB)

08_12_begin.zip (138 KB)

08_11_begin.zip (123 KB)

08_10_begin.zip (68 KB)

08_09_begin.zip (34.6 MB)

08_08_begin.zip (99 KB)

08_07_begin.zip (390 KB)

08_06_begin.zip (584 KB)

08_05_begin.zip (152 KB)

08_04_begin.zip (3.3 MB)

08_03_begin.zip (2.8 MB)

09_09_begin.zip (1.1 MB)

11_07_begin.zip (57 KB)

09_10_begin.zip (1.3 MB)

09_12_begin.zip (53 KB)

11_05_begin.zip (65 KB)

11_04_begin.zip (51 KB)

11_03_begin.zip (185 KB)

11_02_begin.zip (56 KB)

11_01_begin.zip (49 KB)

10_13_begin.zip (104 KB)

10_12_begin.zip (103 KB)

10_11_begin.zip (99 KB)

10_10_begin.zip (58 KB)

10_09_begin.zip (112 KB)

10_08_begin.zip (25 KB)

10_07_end.zip (12 KB)

10_06_begin.zip (154 KB)

10_05_begin.zip (326 KB)

10_04_begin.zip (393 KB)

10_03_begin.zip (116 KB)

10_02_begin.zip (59 KB)

10_01_begin.zip (432 KB)

09_13_begin.zip (149 KB)

09_11_begin.zip (64 KB)

Installation_Reminder.zip (122 KB)

دانلود فایل فشرده

با توجه به امکانات آموزش و همچنین امکانات بسته انتخاب شده لینک دانلود فایل فشرده آماده خواهد شد. با در نظر داشتن این شرایط لطفا بسته مورد نظر خود را انتخاب کرده و روی دکمه درخواست لینک دانلود کلیک کنید

در حال به روزرسانی اطلاعات

درخواست لینک دانلود

در حال به روزرسانی اطلاعات

لطفا قبل از فعالسازی لینک دانلود به موارد زیر توجه کنید:

پسورد فایل‌های فشرده است.
لینک‌های آماده شده تا 8 روز پس از فعالسازی منقضی خواهند شد.
حجم فایل‌ها تخمینی هستند.
در صورتی که لینک دانلود تا 15دقیقه پس از درخواست آماده نشد، از بخش پشتیبانی پیگیری نمایید.