reviewer1389651's Professional Profile

Badges

User Activity

About 3 years ago

Answered a question: What are the benefits of having separate layers or a dedicated schema for each layer in ETL?

I have over 15 years of ETL experience on "real world" projects & am now teaching grad courses in the Business Intelligence life cycle. It does not make any sense to separate the ETL process into "layers". I do recommend that "all" tables do show in a star schema diagram so…

Over 3 years ago

Replied to reviewer1389651 Is a data warehouse the best option to consolidate data into one location?

@Jay Allen Jay, Look again at sources for your own understanding. My understanding of top down data warehouse for an enterprise has an origin that has been trusted for decades. "Subject-oriented, non-volatile, integrated..." (crediting Bill Inmon). As a practitioner, I do…

Over 3 years ago

Answered a question: Is a data warehouse the best option to consolidate data into one location?

A definition of a data warehouse was been for years anchored in retaining data that is no longer changing. A B2B e-commerce environment includes many dynamics of data while being volatile, with factors that influence the frequency of queries and updates. eCommerce is…

Almost 4 years ago

Contributed a review of Microsoft Power BI: Helps introduce data analytics in a way that students understand and appreciate

Over 4 years ago

Contributed a review of Blackboard Collaborate: Great for online learning, and straightforward setup, however needs more hands-on tutorials

Over 4 years ago

Contributed a review of SQL Server: Stable with a straightforward setup and the capability to scale

Over 4 years ago

Contributed a review of Office 365: Helps with preparing presentations but it should have more tutorials