Books Applications

Books Summary:


Applications:


Nested Mind – Book Project Chapters:


Data Properties – Book Project Chapters:

Structural Properties:

Dynamic Properties:

Relational Properties:

Causal Properties:

Projective Properties:

Validation Properties:

Quantum Properties:


Training:

Problems That Cannot Wait:

Home Problems That Cannot Wait
Computer Problems That Cannot Wait
Phone Problems That Cannot Wait
Document Problems That Cannot Wait
Car Problems That Cannot Wait
Small Business Problems That Cannot Wait
Job Search Problems That Cannot Wait
Senior Tech Problems That Cannot Wait
Digital Scam Problems That Cannot Wait
Rental / Tenant Problems That Cannot Wait
Health Appointment Problems That Cannot Wait
Money Problems That Cannot Wait

English Series:

Ecosistema Moderno de Datos:

Basic:

Advanced:

Financial Ratios BI Course:

Financial Ratios BI Course Overview
Topic 1 – Create Synthetic Financial Companies Dataset
Topic 2 – Create the Chart of Accounts
Topic 3 – Generate Synthetic Trial Balance
Topic 4 – Validate the Trial Balance
Topic 5 – Map Accounts to Financial Statements
Topic 6 – Build the Income Statement
Topic 7 – Build the Balance Sheet
Topic 8 – Build Cash Flow Indicators
Topic 9 – Create Market Data
Topic 10 – Liquidity Ratios
Topic 11 – Profitability Ratios
Topic 12 – Debt Ratios
Topic 13 – Operating Performance Ratios
Topic 14 – Cash Flow Indicator Ratios
Topic 15 – Investment Valuation Ratios
Topic 16 – Data Quality Issues
Topic 17 – SQL Server Financial Model
Topic 18 – Power BI Model Preparation
Topic 19 – Executive Financial Dashboard Dataset
Topic 20 – Final Training Package
Topic 21 – Deploy Financial Ratios BI Model to SQL Server
Topic 22 – Power BI DAX Ratio Measures
Topic 23 – Compare Precalculated Ratios vs DAX Ratios
Topic 24 – Build Dynamic Financial Ratio Cards
Topic 25 – Build Company and Period Ratio Trends
Topic 26 – Executive Dashboard Using DAX Measures

Power Query vs SQL:

power_query_vs_sql_series_01 Core Transformation Map.html
power_query_vs_sql_series_02 Merge Is Not Append.html
power_query_vs_sql_series_03 Merge Queries vs SQL JOIN.html
power_query_vs_sql_series_04_append_union_all.html
power_query_vs_sql_series_05_remove_duplicates_group_by.html
power_query_vs_sql_series_06_conditional_case_when.html
power_query_vs_sql_series_07_replace_values_case_replace.html
power_query_vs_sql_series_08_change_type_cast_convert.html
power_query_vs_sql_series_09_split_column_text_parsing.html
power_query_vs_sql_series_10_pivot_unpivot.html
power_query_vs_sql_series_11_fill_down_window_logic.html
power_query_vs_sql_series_12_applied_steps_sql_script.html

Dax Function:

POST LinkedIn:

sql_data_quality_checks_10_linkedin_posts.html
data_security_checks_10_linkedin_posts.html
data_governance_checks_10_linkedin_posts.html
data_privacy_checks_10_linkedin_posts.html
data_ethics_checks_10_linkedin_posts.html
data_literacy_checks_10_linkedin_posts.html
data_reliability_checks_10_linkedin_posts.html
data_modeling_checks_10_linkedin_posts.html
ai_data_readiness_checks_10_linkedin_posts.html
dashboard_trust_checks_10_linkedin_posts.html

Pandas Use Cases:

Pandas_Use_Case_01_Load_Inspect_Messy_City_Service_Data.html
Pandas_Use_Case_02_Standardize_Text_and_Category_Values.html
Pandas_Use_Case_03_Clean_and_Convert_Mixed_Date_Formats.html
Pandas_Use_Case_04_Handle_Missing_Values_Strategically.html
Pandas_Use_Case_05_Detect_and_Remove_Exact_Duplicates.html
Pandas_Use_Case_06_Resolve_Conflicting_Duplicate_Request_IDs.html
Pandas_Use_Case_07_Validate_Numeric_Ranges_and_Business_Rules.html
Pandas_Use_Case_08_Validate_ZIP_Codes,_Phones,_and_Emails.html
Pandas_Use_Case_09_Validate_Latitude_and_Longitude.html
Pandas_Use_Case_10_Create_Data_Quality_Flags.html
Pandas_Use_Case_11_Build_a_Data_Quality_Score_per_Record.html
Pandas_Use_Case_12_Create_a_Clean_Master_Dataset.html
Pandas_Use_Case_13_Analyze_Requests_by_Service_Type.html
Pandas_Use_Case_14_Analyze_Requests_by_Department.html
Pandas_Use_Case_15_Analyze_Requests_by_City_and_ZIP_Code.html
Pandas_Use_Case_16_Measure_Resolution_Time_and_SLA_Performance.html
Pandas_Use_Case_17_Analyze_Request_Channels.html
Pandas_Use_Case_18_Analyze_Satisfaction_Scores.html
Pandas_Use_Case_19_Detect_Trends_and_Operational_Patterns.html
Pandas_Use_Case_20_Build_an_Executive_City_Service_Summary.html

ChatGPT City Government Use Case:

ChatGPT_City_Government_Use_Case_01_Project_Initiation_for_a_Municipal_Service_Portal.html
ChatGPT_City_Government_Use_Case_02_Requirements_Gathering_for_Resident_and_Department_Needs.html
ChatGPT_City_Government_Use_Case_03_Scope_Definition_and_Municipal_Work_Breakdown_Structure.html
ChatGPT_City_Government_Use_Case_04_Schedule_Planning_and_Municipal_Milestones.html
ChatGPT_City_Government_Use_Case_05_Resource_Planning_and_Municipal_RACI.html
ChatGPT_City_Government_Use_Case_06_Cost_Estimation_and_Municipal_Budget_Support.html
ChatGPT_City_Government_Use_Case_07_Risk_Management_for_a_City_Technology_Project.html
ChatGPT_City_Government_Use_Case_08_Quality_Planning,_Testing,_and_Municipal_Acceptance.html
ChatGPT_City_Government_Use_Case_09_Communication_Management_and_Public-Sector_Reporting.html
ChatGPT_City_Government_Use_Case_10_Procurement_and_Vendor_Evaluation_for_Municipal_Technology.html
ChatGPT_City_Government_Use_Case_11_Monitoring,_Control,_and_Municipal_Change_Management.html
ChatGPT_City_Government_Use_Case_12_Municipal_Project_Closure_and_Lessons_Learned.html

Learning by Doing:

Electronic Business Card Project: