The Smart Data Guide is a website that provides resources and tools for business data analysts in the asset management industry, including templates, education, coaching, and training to help them communicate data solutions to complex business problems, be more productive and efficient, and achieve career success. It caters to primarily Business Data Analysts, but I hope Project Managers, Product Owners, Scrum Masters, and Developers can benefit too.
Latest Posts
How to create dataflow diagrams with Mermaid?
When working with diagrams it’s sometimes easier to Mermid to show the data flow. This code can be applied to https://www.eraser.io/ai/mermaid-diagram-editor to generate a data flow diagram.
How to Understand the Investment Trade Lifecycle from Front to Back Office
Investment Decision Made – Front Office identifies investment opportunity. Pre-Trade Compliance Check – Trade is validated against client mandates, regulatory limits (e.g., UCITS, AIFMD), and internal policies. Order Placement with International Broker – Investor places order via International Broker. Broker Routing (if applicable) – International Broker routes the order to a Local Broker if necessary.…
How to Analyze SQL Server Tables and Metadata Using System Queries
1. List All Tables in the Current Database When to Use:To list all user-defined tables in the current database. SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = ‘BASE TABLE’; 2. Get All Columns and Metadata of a Table When to Use:To review column names, data types, and constraints in a given table. SELECT COLUMN_NAME, DATA_TYPE,…
Smart Data Guide 