Deleted

Question

Deleted

chocthree

Ten Centuries

Points: 1276
More actions
February 14, 2018 at 9:46 am

#329217

Deleted.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Eric M Russell SSC Guru Points: 125560 More actions · Answer 1

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

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 2

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/

chocthree Ten Centuries Points: 1276 More actions · Answer 3

chocthree

Ten Centuries

Points: 1276

February 16, 2018 at 10:15 am

#1980095

Deleted.

david_h_edmonds Default port Points: 1430 More actions · Answer 4

david_h_edmonds

Default port

Points: 1430

February 20, 2018 at 7:55 am

#1980457

As others have said, start here:

chocthree Ten Centuries Points: 1276 More actions · Answer 5

chocthree

Ten Centuries

Points: 1276

February 20, 2018 at 8:17 am

#1980466

Deleted.

david_h_edmonds Default port Points: 1430 More actions · Answer 6

Hi, I am sorry I haven't seen the older version so I cant say what the differences are.
The books are great so long as you have a good knowledge of SQL databases and SSMS.
They give you a guide to creating an architecture for your DW but obviously your data is unique to your company so there is a limit.
I have done some Microsoft courses on this stuff and the tutors always mention Kimble as being the definitive word on DW design.
Happy Trails

Dave

chocthree Ten Centuries Points: 1276 More actions · Answer 7

Thanks again Dave.
Did you go on to buy other Kimball books or did you find the one you've a photo of the only one you needed to understand the concepts?

david_h_edmonds Default port Points: 1430 More actions · Answer 8

Hi, I ordered the ETL book (2nd in the set) the other day. I am excited to read it.

Dave

Eric M Russell SSC Guru Points: 125560 More actions · Answer 9

Also, check out the website.
http://www.kimballgroup.com

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 10

Ralph Kimball retired, but other members of the group have continued the work under a new name:
https://decisionworks.com/
I don't know if the old website gets any of the new updates.