
يبدأ الفيديو بتعريف استخبارات الأعمال وشرح أهمية استخدام أدوات استخبارات الأعمال في عصر البيانات الكبير. ثم ينتقل إلى شرح مفهوم self-service BI والذي يسمح للمستخدمين النهائيين بإنشاء التقارير واستخدام التطبيق بأنفسهم دون الحاجة إلى متخصصين.
في الجزء الأخير من الفيديو هننزل برنامج تابلو ديسكتوب سواء النسخه التجربيبيه المجانيه او تابلوه بابلك
هنا هنتعرف علي صفحة البداية
وهنشوف المصادر المختلفه اللي بتساعدنا علي الاتصال بالبيانات
وهنقوم بالاتصال بملف البيانات اللي هسنتخدمه في تصميم التقارير خلال الفيديوهات القادمه
في الفيديو دا هنقارن بين الاقسام المختلفة من حيث المبيعات من خلال رسم Bar chart
كيفية استخدام المخطط البياني الخطي لقياس تغير قيم متغير معين خلال الزمن
خلال الفيديو دا هنتعلم تصميم رسم بياني للمنطقة " Area Chart"
خلال الفيديو دا هنتعلم Stacked bar chart
خلال الفيديو دا هنتعلم المدرج التكراري
خلال الفيديو دا هنتعلم الخريطة الحرارية
Identify different data types in Tableau and their appropriate uses in calculations.
Text
Date Values
Date & Time Values
Numerical Values
Boolean Values
Image Role
Cluster or Mixed Values
Apply operators and keywords correctly to create various calculations.
AND
OR
NOT
IN
= OR ==
+
1
*
^
( )
[ ]
{ }
//
Performing Row-Level Calculations:
Determine when and how to use row-level calculations effectively.
Concatenate text fields to create new fields with combined information.
Utilize the Split() function to separate text fields into multiple parts.
Apply the Transform option to split fields or perform custom splits.
Incorporate IF conditions for conditional logic within calculations.
Extract specific portions of text using the Left() and Len() functions.
Mastering Aggregate Calculations:
Understand when and how to apply aggregate calculations meaningfully.
Calculate sums using the Sum() function.
Modify field default properties to control their behavior in calculations.
Distinguish between Measure Names and Measure Values for effective aggregation.
Grasp the relationship between level of detail and aggregation in Tableau.
Create date fields using the date() function.
Calculate date differences using the datediff() function.
Construct Gantt charts to visualize project timelines.
Create parameters to make calculations more dynamic and adaptable.
Utilize reference lines to highlight specific values or thresholds.
Build Boolean calculated fields to generate true/false results.
Incorporate parameters within calculated fields for added flexibility.
Understand the concept of ad hoc calculations and their application in Tableau.
Create custom calculations to address specific analytical needs.
Distinguish between Deferent level of details
التمييز بين مستويات التفاصيل المختلفة -
When & how to use LOD – مستوي التفاصيل متى وكيف يتم استخدام حسابات
Fixed ثابت
Include متضمن
Exclude استبعاد
Over view of table calculations
Tableau's Order of Operations
Running Total
Difference
Percent Difference
Percent of total
Rank
Moving Average
YTD Total
Year over Year Growth
Relative ( Scope and Direction )
Fixed ( Addressing and Partitioning )
Using Index ( ) Function
Using First ( ) Function
Using Last ( ) Function
Using Size ( ) Function
Using Lookup ( ) Function
Using Attr ( ) Function
Using Previous_Value ( ) Function
Custom Calculations
Using Running_Sum ( ) Function
Using Running_Min ( ) Function
Using Running_Max ( ) Function
Using Running_Count ( ) Function
Using Running_Avg ( ) Function
Using Window_Avg ( ) Function
Using Window_Count ( ) Function
Using Window_Max ( ) Function
Using Window_Min ( ) Function
Using Window_Median ( ) Function
Using Window_Sum ( ) Function
Using Total ( ) Function
Difference between Total Function and Window Functions
Using Rank ( ) Function
Using Rank_Dense ( ) Function
Using Rank_Unique ( ) Function
Using Rank_Modified ( ) Function
Quarter Over Quarter
Dynamic Titles
Introduction to dashboards
Dashboard objectives
Dashboard approaches
Create “Profit by Sub-Category“ Worksheet
Create “Top 10 Least Profitable Items“ Worksheet
Create “Profit by state“ Map Worksheet
Create “Profit Trend“ Worksheet
Create Is “Least Profitable Always Unprofitable” Dashboard
Resize Worksheets in dashboard
Adjust which views the filter applies to
All Using Related Data Sources
All Using This Data Source
Selected Worksheets...
Only This Worksheet
Add Context Filter
hide worksheets
Designing for different displays and devices
Desktop
Tablet
Phone
Horizontal Container
Vertical Container
Text Object
Image Object
Blank Object
Download Object
Padding
custom shapes
Enhancing analysis with animation
Enhancing data storytelling with animation
Using Pages shelf
Edit Locations
Background Maps
Background Layers
Ad hoc custom territories
Field-defined custom territories
Section 1 : Chart Types - انواع الرسومات
Introduction & Download the application - مقدمة عن تابلو ديكستوب وتحميل البرنامج
connect to data - الاتصال بالبيانات
Bar chart
Line Chart - مخطط بياني خطي
Area Chart - رسم بياني للمنطقة
Stacked Bar chart - مخطط الشريط المركب
Histogram - المدرج التكراري
Heat map - الخريطة الحرارية
Treemap
Bullet Graph
Combined axis chart
Scatterplot
Cross-tab
Chart Types Quiz
Section 2 : Tableau Essentials - اساسيات تابلو
Navigating GUI
Using show me
Annotaions and Captions
Dimension, measures, Discrete and continuous part 1
Dimension, measures, Discrete and continuous part 2
Live Connection
Extract Connection
Extract & Data Source Filters
Measure Filters
Context, Dimension and measure filters
Sorting Data
hierarchies
groups
Sets
Parameters
Tableau Essentials Quiz
Section 3 : Row-Level and Aggregate Calculations
Introduction to Calculations - مقدمة عن الحسابات
Data Types in tableau – انواع البيانات في تابلو
Operators and Keywords – المشغلات والكلمات الرئيسية
Row-level calculations – الحسابات علي مستوي الصفوف
When & how to use row level calculations
Concatenate Text fields
Using Split( ) Function
Using transform option to split
Using transform option to use Custom Split
Using IF Condition
Using Left( ) Function
Using Len( ) Function
Aggregate calculations – الحسابات المجمعة
When & How to use aggregate calculations
Using Sum( ) Function
Change Field default properties
Measure Names & Measures Values
Level of details & Aggregation
Date Calculations – حسابات التاريخ
Using date( ) Function
Using datediff( ) Function
Gantt Chart
Using Parameters with calculated fields – استخدام المعلمات في الحسابات
Create parameters
Using Reference line
Boolean calculated field
Using Parameter in calculated field
Ad hoc calculations - الحسابات المخصصة
Section 4 : Level of details calculations
Introduction to LOD Calculation مقدمة إلى حسابات مستوى التفاصيل -
Distinguish between Deferent level of details
التمييز بين مستويات التفاصيل المختلفة -
When & how to use LOD – مستوي التفاصيل متى وكيف يتم استخدام حسابات
Types of LOD Calculation - انواع حسابات مستوي التفاصيل
Fixed - ثابت
Include متضمن -
Exclude استبعاد -
Fixed Level of Detail Calculation حسابات مستوى التفاصيل الثابتة الجزء الاول -
Fixed Level of Detail Calculation Part 2 حسابات مستوى التفاصيل الثابتة الجزء الثاني -
Include Level of Detail Calculation حسابات مستوى التفاصيل المتضمنة -
Exclude Level of Detail Calculation حسابات مستوى التفاصيل المستبعدة -
Section 5 : Table Calculations
Introduction to Table Calculations مقدمة الي حسابات الجداول -
Over view of table calculations
Tableau's Order of Operations
Quick table calculations – حسابات الجداول السريعة
Running Total
Difference
Percent Difference
Percent of total
Rank
Moving Average
YTD Total
Year over Year Growth
Table calculation concepts مفاهيم حسابات الجداول –
Relative ( Scope and Direction )
Fixed ( Addressing and Partitioning )
Using Index ( ) Function
Meta table functions
Using First ( ) Function
Using Last ( ) Function
Using Size ( ) Function
Lookup & Previous Value Functions
Using Lookup ( ) Function
Using Attr ( ) Function
Using Previous_Value ( ) Function
Running Functions
Custom Calculations
Using Running_Sum ( ) Function
Using Running_Min ( ) Function
Using Running_Max ( ) Function
Using Running_Count ( ) Function
Using Running_Avg ( ) Function
Window Functions
Using Window_Avg ( ) Function
Using Window_Count ( ) Function
Using Window_Max ( ) Function
Using Window_Min ( ) Function
Using Window_Median ( ) Function
Total Function
Using Window_Sum ( ) Function
Using Total ( ) Function
Difference between Total Function and Window Functions
Rank Functions & Other Table Calculation Functions
Using Rank ( ) Function
Using Rank_Dense ( ) Function
Using Rank_Unique ( ) Function
Using Rank_Modified ( ) Function
Table Calculations Examples - امثلة علي حسابات الجداول
Quarter Over Quarter
Dynamic Titles
Table calculation filtering (late filtering) - تصفيه حسابات الجداول
Section 6 : Dashboards
Introduction to dashboards
Introduction to dashboards
Dashboard objectives
Dashboard approaches
Creating a Dashboard
Create “Profit by Sub-Category“ Worksheet
Create “Top 10 Least Profitable Items“ Worksheet
Create “Profit by state“ Map Worksheet
Create “Profit Trend“ Worksheet
Create Is “Least Profitable Always Unprofitable” Dashboard
Resize Worksheets in dashboard
Adjust which views the filter applies to
All Using Related Data Sources
All Using This Data Source
Selected Worksheets...
Only This Worksheet
Implementing Actions
Context Filtering
Add Context Filter
hide worksheets
Designing for different displays and devices
Desktop
Tablet
Phone
Filter Actions
Highlight actions
URL actions
Go to Sheet actions
Parameter actions
Set actions
Using objects
Section 7 : Advanced Visualizations
Slope & Bump Charts
Waterfall charts
Step lines & jump lines Charts
Sparklines
Dumbbell Chart
Unit/symbol charts
Animated visualizations
Section 8 : Dynamic Dashboards
Show-Hide buttons
Sheet swapping
Automatically showing and hiding other controls
Section 9 : Exploring Mapping and Advanced Geospatial Features
Rendering maps with Tableau
Edit Locations
Customizing map layers
Background Maps
Background Layers
Customizing map options
Including latitude and longitude in your data
MakeLine( ) & MakePoint( ) Functions
Distance( ) Function
Buffer( ) Function
Ad hoc custom territories
Field-defined custom territories
Creating Custom Territories
Dual Axis Map
Plotting data on background images