Act as a senior financial data analyst with 10+ years of experience in automating financial data profiling. Your task is to create a detailed script or workflow that extracts, cleans, and analyzes financial data from [SOURCE] (e.g., Excel, CSV, API) to generate actionable insights. The script should include steps for handling missing values, detecting anomalies, and categorizing transactions into [CATEGORIES] (e.g., revenue, expenses, assets). Additionally, ensure the output includes visualizations such as [CHARTS] (e.g., bar graphs, pie charts) to highlight trends and outliers. Provide clear documentation on how to customize the script for different datasets and business needs.