Data Modeling Tools

Modeling Tools

https://my.vertabelo.com/model/Rq7DHBGO83r5piJZJ16j61Tsn0oozsrU

http://www.anchormodeling.com/modeler/latest/

https://blog.codecentric.de/en/2017/07/agile-database-design-using-anchor-modeling/

<<Anchor_Modeling.pdf>>

https://anchor.teachable.com/p/an-introduction-to-anchor-modeling

https://www.red-gate.com/simple-talk/sql/bi/power-bi-data-modelling/

https://gerardnico.com/data/modeling/modeling

https://gerardnico.com/data/quality/quality

http://www.softwaregems.com.au/Documents/Documentary%20Examples/IDEF1X%20Notation.pdf

https://docs.oracle.com/cd/B19306_01/bi.102/e10084/logical.htm#BABBHEEA

Looping thru the data

https://support.microsoft.com/en-us/help/299036/how-to-loop-through-a-list-of-data-on-a-worksheet-by-using-macros-in-e

http://codevba.com/excel/for_each_cell_in_range.htm#.XMiF8ehKjIU

how to create new rows in Excel

https://powerspreadsheets.com/excel-vba-insert-row/