SQL & PBI STTM Documentation

@mobasherreza10

As a technology partner with a diverse range of skills, I am well-positioned to turn your rough notes into clear and concise documentation. With a background in software development, SQL and Power BI among my many other talents, I understand the intricacies of weaving together SQL logic and Power BI configurations. My broad expertise also includes snowflake-specific syntax, which will be invaluable as we create your Source-to-Target Mapping (STTM) guide. Your requirement for detailed table schemas, field mappings, and transformation rules is something I perceive vital for impactful documentation. As a technologist focused on delivering results in seemingly complex systems, I am adept at turning intricate technical information into an easily understandable format. By implementing my structured approach, your new engineers would confidently navigate from raw tables through to the published Power BI dataset without any gaps in their knowledge of the process.

@geethasekar1995

Hello, I have read your job description and I am interested in your job post. I am ready to start now. Please send me a message to discuss more about your project, Can you please give me a chance I am a Senior Software Developer with over 8+ years of experience in designing and developing scalable web and desktop applications. I specialize in Microsoft technologies and delivering high-quality, secure, and performance-driven applications. My Expertise: Backend Development:ASP.NET, ASP.NET Core, MVC, Web API, WebForms, WCF Services Programming Languages:C#, Frontend Development:JavaScript, jQuery, AJAX, HTML, CSS Database Technologies:SQL Server, MySQL Reporting Tools:Crystal Reports, RDLC, SSIS, SSRS

@alluankit01

Hi, I can turn your rough notes into a clear, developer-ready STTM document that explains the full lineage from source SQL tables through transformation logic and into the Power BI reporting layer. The best solution is to first review your notes, SQL scripts, table structures, Power BI dataset, measures, and target reporting logic. I’ll then document source and target schemas, column-level mappings, renamed fields, derived columns, one-to-one and one-to-many relationships, transformation rules, and any DAX or Power BI-side calculations. I’m comfortable with SQL, Oracle/Snowflake-style data warehouse documentation, Power BI, DAX, table schemas, source-to-target mapping, data lineage, transformation logic, and technical documentation for developers. Deliverables will include: * Source and target table schemas * Column names, data types, and keys * Field-level mappings * Derived and renamed column rules * SQL transformation explanation * Power BI/DAX calculation notes * Data lineage documentation * Developer-ready STTM guide * Clean formatting and review-ready structure I’ll focus on making the document clear enough for a new engineer to understand the data flow, validate the logic, and make future changes confidently. Best regards Ankit

@abhay686

Hi, I can turn your rough notes, SQL logic, and Power BI calculations into a clear, developer-ready STTM document. It will cover source and target schemas, field mappings, relationships, transformation rules, derived columns, Power BI measures, and complete data lineage. I have experience with SQL, Oracle databases, data warehousing, Power BI, and STTM documentation. I will ensure the document is accurate, easy to understand, and practical for future development or changes. Let’s connect over the chat so that I can show you my previous work.

@rishi9343

I'll turn your rough notes into a clear Source-to-Target Mapping guide covering table schemas, field mappings, and transformation rules, including Oracle and Snowflake specifics. I'll deliver a detailed document that lets new engineers understand data lineage and implement changes confidently. Ready to start immediately.

@gunjan1711

- I have hands-on experience creating technical documentation for SQL, Power BI, and data warehouse solutions, including Source-to-Target Mapping (STTM) documents. - My expertise includes SQL, Oracle, Snowflake, Power BI, data modeling, ETL documentation, and data lineage mapping. - I can prepare a comprehensive STTM document covering source and target schemas, field mappings, primary keys, data types, transformation logic, and Power BI calculations in a structured, developer-friendly format. - I have experience documenting SQL transformations, business rules, data models, and reporting logic to simplify maintenance and future enhancements. - In a recent project, I developed a PHP API, integrated database data into Power BI, and created automated real-time dashboards for business performance monitoring. - The documentation will clearly describe SQL transformations, derived fields, joins, business logic, and any Power BI DAX measures while highlighting Oracle and Snowflake-specific considerations where applicable. - Deliverables will include the complete STTM document, data lineage diagrams (if required), mapping tables, and a concise hand-off guide for developers and analysts. - I am available to start immediately and can provide regular updates throughout the documentation process. Reference work is available in my profile.

@elvirt

Dear Client, I am excited about your Source-to-Target Mapping project. I have strong experience documenting data lineage from SQL logic to Power BI layers. --- **What is your target of this project?** Turn your rough notes into a clear, developer-ready Source-to-Target Mapping (STTM) guide—covering table schemas, field mappings, transformation rules (SQL + Power BI), and lineage from raw tables to published datasets. --- **Core skills:** - SQL (Oracle, Snowflake) - Power BI (Measures, Calculations) - Data Lineage Documentation - Source-to-Target Mapping - Technical Writing --- **How I solve & deliver:** 1. Review your notes and data structure. 2. Document table schemas and field mappings. 3. Explain transformation logic step-by-step. 4. Highlight Snowflake-specific syntax. 5. Deliver clear, engineer-ready documentation. --- Thank you for your time. I am confident I can deliver a comprehensive, usable STTM guide. Best Regards

@Glexy111

Hello, I have seen your are looking SQL documentation expert working in SQL, Power BI and Snowflake I am having 7 years of experienced as SQL documentation expert and I will work according to your features list. Please share more details of your project in chat. Looking forward to your response Thanks

@RKhakhula

Hi There, I can turn your rough notes into a comprehensive, developer-ready Source-to-Target Mapping (STTM) guide bridging your database logic and Power BI reporting layer. I will structure document to detail: Table schemas with source and target column names, data types, and primary key definitions. Field mappings covering one-to-one and one-to-many relationships, alongside renamed and derived attributes. Transformation rules translating SQL logic step-by-step, explicitly noting where Power BI downstream calculations or measures take over. Key migration nuances, ensuring Snowflake syntax and data warehouse best practices are highlighted. The result will give your engineering team clear lineage from raw tables through to published Power BI datasets for efficient implementation. Let's contact to discuss details. Solutin Vector Roman Khakhula

@shraddhas68

Hello, I can create a clear, structured, and developer-ready Source-to-Target Mapping (STTM) document that connects your Oracle data warehouse, SQL transformation logic, Snowflake-specific considerations, and Power BI dataset layer. The documentation will cover: • Source and target table schemas, including columns, data types, and primary keys • Detailed one-to-one and one-to-many field mappings • Renamed, calculated, and derived fields • Step-by-step SQL transformation logic • Additional Power BI calculations, measures, and transformations • End-to-end data lineage from raw source tables to the published Power BI dataset • Relevant Oracle, Snowflake, SQL, and Power BI syntax/behavior differences where applicable I will organize the documentation in a clean and easy-to-follow format so that a new developer or data engineer can understand the complete data flow and confidently implement future changes. I have hands-on experience with SQL, MySQL, database design, data processing, backend development, and technical documentation. I focus on accuracy, clarity, and maintaining a logical connection between source data, transformations, and final reporting layers. I am available to review your existing SQL scripts, schemas, Power BI logic, and rough notes and convert them into complete technical documentation. Best regards, Shraddha Sonwani

@jagratip3

Hello, I can convert your rough notes into a professional, developer-ready Source-to-Target Mapping (STTM) document that clearly documents the complete data lineage from Oracle source tables through SQL transformations to the final Power BI dataset. The documentation will include detailed table schemas, field mappings, transformation logic, business rules, derived columns, and Power BI calculations, while incorporating relevant Snowflake syntax and best practices where applicable. The final deliverable will be well-structured, easy to maintain, and suitable for onboarding new engineers and future enhancements. I'm available to start immediately and can deliver clear, high-quality documentation with regular progress updates. Thank you.

@shivp488

Hi, I can create a clear, developer-ready STTM document from your notes. I'll document table schemas, field mappings, transformation logic, SQL workflows, and Power BI calculations, while highlighting Oracle and Snowflake-specific details where needed. The final document will be easy to understand, maintain, and use for future development. Looking forward to discussing your requirements. Thanks, Shiv

@Abrotab

As a skilled data and business solutions specialist, with expertise in Power BI, I feel I can transform your rough notes into an effective Source-to-Target Mapping (STTM) guide. My proficiency in working with large datasets and experience in understanding complex SQL logic would allow me to convert your documentation needs into an easily consumable format. Apart from Power BI, I am proficient with Google Sheets automation, PowerApps development, R programming, and SharePoint solutions - skills that lend themselves well to streamlining processes and simplifying workflows. In particular, my proficiency in Power BI is highly relevant to your project. I develop interactive reports that transform complex raw data into actionable insights. This is done by mapping one-to-one or one-to-many relationships and understanding derived columns. Additionally, my ability to apply statistical models and advanced analytics through R programming would be invaluable when explaining the transformation rules of the SQL logic, ensuring the nuances of the Snowflake-specific syntax are woven seamlessly into the narrative. Lastly, as a freelancer, my tailored solutions would cater specifically to your unique needs. Your documentation will be delivered timely without compromising clarity or accuracy.

@prashantm302

Hi, I can put together the STTM guide you're describing — table schemas, field mappings, and SQL-to-Power BI transformation lineage in one clear, developer-ready document. Quick flag before we start: your brief mentions the warehouse is in Oracle but also asks for Snowflake syntax woven in — could you clarify if this is a migration or if Snowflake is the actual current platform? Want the technical details to be precise, not generic. Once that's confirmed, share your rough notes and SQL scripts and I'll structure everything into a single document a new engineer can follow end-to-end — from raw tables through to the published Power BI dataset — including clear callouts wherever Power BI adds its own calculation logic beyond the SQL. Happy to get started as soon as you're ready. Thanks,

@godhani1

Hi there, I understand you need a clean, developer-ready Source-to-Target Mapping (STTM) guide to bridge your SQL logic (Oracle/Snowflake) and Power BI dataset layer. I can help convert your rough notes into a structured, production-ready documentation package. Here is how I will structure your STTM Document: 1. Table Schemas: Detailed source and target mappings (column names, primary keys, data types). 2. Field Mappings: Explicit 1:1 and 1:N relationships, renamed attributes, and derived metrics. 3. Transformation Rules: Step-by-step SQL logic, translation of Oracle to Snowflake nuances, and clear DAX/Power BI measure definitions. 4. Data Lineage Overview: A clear lineage flow so any new developer can quickly understand the path from raw tables to final visuals. Skills & Tech Stack: - Advanced SQL (Oracle, Snowflake) - Power BI & DAX Modeling - Technical & Data Architecture Documentation I can deliver this within a short timeframe upon reviewing your rough notes. Let’s connect in chat to discuss the details! Best regards, Godhani H.

@rushim21

I have proven experience in writing documents and coordinate with development team. So I can write this document as per your requirement.

@bhutrakichu

Hi! I can transform your rough notes into a clean, developer-ready STTM guide covering full lineage from Oracle source schemas to your Power BI semantic layer. ​Quick questions to align on the scope: ​You mentioned Oracle DW, but noted Snowflake nuances—are you migrating from Oracle to Snowflake, or using a hybrid setup? ​How complex are the Power BI calculations (simple DAX measures vs. multi-layered modeling)? ​Do you have a preferred format (Excel/Google Sheets or Markdown/Confluence)? ​I'll ensure all schemas, field mappings, SQL transformations, and DAX logic are crystal clear so any engineer can build with confidence. Ready when you are!

@dineshkumar1311

I've created comprehensive Source-to-Target Mapping documentation for three fintech and NBFC data warehouses—each bridging Oracle legacy systems through cloud transformation to BI layers. Most recently, I documented a 12-table Snowflake medallion architecture feeding Power BI real-time financial dashboards, including Oracle-to-Snowflake migration patterns and Power BI measure logic. My approach: Audit & Discovery — Review your SQL scripts, Oracle schemas, and Power BI models to map lineage end-to-end Schema Documentation — Detailed table specs (column names, data types, PKs, indexes, constraints) for both source and target Field Mapping Matrix — One-to-one and one-to-many mappings, renamed/derived columns, with transformation rules SQL Transformation Logic — Step-by-step breakdown of every transformation, with Snowflake-specific syntax annotations (PIVOT, dynamic tables, window functions) Power BI Integration — Map which tables feed which datasets; document measures, calculated columns, and dependencies Visual Diagrams — Entity-relationship diagrams, data lineage flowcharts, transformation pipeline visuals Deliverables: Production-ready STTM document (Word + PDF), Mermaid/Graphviz diagrams, SQL reference guide with Snowflake optimizations, change-implementation checklist. Ready to start. Please share your SQL scripts and Power BI model exports so I can begin the audit.

@AnjanSantra

Dear Sir, I am delighted to maintain a flawless 100% Job Success Score on Freelancer, a testament to my commitment to delivering exceptional results. With over 8 years of experience and holding the title of Microsoft Certified Power BI Data Analyst Associate, I specialize in developing interactive Power BI dashboards and reports using DAX and Power Query. Additionally, I offer comprehensive training and job support services in Power BI. Furthermore, I am a Microsoft Certified Excel Expert and possess expertise in SQL. Having recently completed numerous Power BI projects akin to yours, I am eager to discuss your project specifics and commence collaboration. I am fully prepared to initiate work immediately, ensuring prompt and precise project delivery. Additionally, I have expertise in Tableau, QlikView, Google Data Studio, Power Apps, Power Automate, Excel and SQL. Thank you for considering my application. I am excited about the opportunity to work together and contribute to the success of your project. Thanks & Regards, Anjan Santra Microsoft Certified Power BI Data Analyst Associate Power BI | Tableau | SQL | Excel | Power Automate Freelancer – 100% Job Success Score +91 9123742755 Kolkata, India