3-Text Operation | Excel Masters

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Power Bi Masterclass

0-Introduction

Introduction (2:37)
Exercise files

1-understanding the basics

1-What is the power bi (2:08)
2-download and install (2:15)
3-On Object Interaction (0:42)
4-Navigate the interface (5:52)
5-Important setting (3:03)
6-getting data (3:38)
7-working with query editor (4:36)
8-editing rows & columns (4:40)
9-changing data type (7:50)
10-using locale (2:54)
11-Replacing values (4:42)

2-Data prep & Data model fundamentals

1-extracting values (6:44)
2-Split columns (2:20)
3-Text Operation (4:55)
4-Numerical Operation (2:48)
5-Data model & relationship (3:01)
6-Practice data cleaning & relationship (5:03)
7-stacked column chart (3:34)
8-The format pane (6:57)
9-data labels (3:21)
10-Pie chart guide lines (5:12)
11-pie chart (5:06)

3-Data Preparation , Modeling & visualization

1-append queries (6:08)
2-Hide tables (3:37)
3-date hierarchies (6:05)
4-drill down and hierarchies (4:09)
5-line chart (8:16)
6-from folder (4:06)
7-edit relationship (4:14)
8-Activate & deactivate relationship (2:16)

4-Data Transformations ( Intermediate)

1-Tables (5:14)
2-customize tables (5:14)
3-Condtional formatting (5:12)
4-Merge quries (4:42)
5-pivot & unpivot (7:35)
6-Many to many relationships & cross filter direction (3:55)

5-Interactive visualization ( Intermediate)

1-Slicers visual (7:33)
2-Edit page (4:36)
3-filter pane (8:10)
4-Top N (3:25)
5-sync slicers (4:50)
6-Treemap (5:20)
7-Edit interactions (3:33)

6-Advanced transformations & Visualizations ( advanced)

1-Custom column (3:02)
2-enable - disable load (3:41)
3-References & duplicates (4:51)
4-column from example (7:51)
5-Visual header & sorting (2:48)
6-Condtional column (3:42)
7-maps (9:23)

7-Advanced dashboard enhancement

1-clear and apply slicers (5:14)
2-reset , back and page navigator (4:57)
3-Bookmark (4:42)
4-top N with bookmark (3:57)
5-card visual (4:55)
6-Multi row card (6:34)

8-Dax - Essentials

1-Calculated columns (6:11)
2-Measures.autosave (3:24)
3-average (3:22)
4-Measures Table (2:15)
5-Count (7:08)

Teach online with

3-Text Operation

Complete and Continue