February 14, 2018 at 9:46 am
Deleted.
February 14, 2018 at 10:30 am
All of Ralph Kimball's books are good, but I'd suggest the following as a first read, because it covers concepts of star-schema modeling, slowly changing dimensions, types of fact tables, requirements gathering using the business matrix technique, etc.
The Data Warehouse ToolKit, Third Edition: The Definitive Guide to Dimensional Modeling, 3rd edition, 2013
https://www.amazon.co.uk/Data-Warehouse-ToolKit-Third-Dimensional/dp/1118530802
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, 2004
https://www.amazon.co.uk/Data-Warehouse-ETL-Toolkit-Techniques/dp/0764567578
Books specific to SQL Server, SSIS, and the Microsoft technology stack; I'd suggest reading them only after first reading the above.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 14, 2018 at 12:36 pm
I second the Kimball books recommendation. While they may seem old, the wealth of information in them is difficult to match.
For PowerBi, here is a good article:
https://www.red-gate.com/simple-talk/sql/bi/power-bi-data-modelling/
February 16, 2018 at 10:15 am
Deleted.
February 20, 2018 at 7:55 am
As others have said, start here: