Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
The Data Warehouse Lab: A step-by-step guide using SSIS and SSAS 2017
Stockholm University, Faculty of Social Sciences, Department of Computer and Systems Sciences.
2017 (English)Book (Other academic)
Abstract [en]

This book aims to help students and practitioners who are new to data warehousing to start developing a new data warehouse project from scratch. It shows different phases of data warehousing projects through a simple case. So readers can experience the full data warehouse development life-cycle through a simple example step-by-step. The book is written for the novice user, so there is no requirement for previous experience of working with MS SQL Server and other tools. However, it expects readers to know basics of databases like the table, columns, etc. The book does not aim to teach data warehousing multi-dimensional design principle, nor play the role of a comprehensive reference book on Microsoft Business Intelligence Toolset. It only intends to help readers to gets a hands-on experience on data warehouse development quickly. It aims to give readers basic understanding and experience, so they become more confident in using reference books and online materials. The book does not go through the installation of tools that are used in the sample project. The readers need to install the following tools in order to follow the steps, i.e., Microsoft SQL Server Database Engine, Microsoft SQL Server Integration Services 2017 (SSIS), Microsoft SQL Server Analysis Services 2017(SSAS), Microsoft SQL Server Management Studio (SSMS), Microsoft Excel, and Microsoft Power BI.

Place, publisher, year, edition, pages
Egen utgivning , 2017. , 91 p.
Keyword [en]
Data Warehouse, OLAP, SSIS, SSAS
National Category
Information Systems
Research subject
Computer and Systems Sciences
Identifiers
URN: urn:nbn:se:su:diva-148236ISBN: 9781549918797 (print)OAI: oai:DiVA.org:su-148236DiVA: diva2:1150491
Available from: 2017-10-19 Created: 2017-10-19 Last updated: 2017-10-19Bibliographically approved

Open Access in DiVA

No full text

Search in DiVA

By author/editor
Jalali, Amin
By organisation
Department of Computer and Systems Sciences
Information Systems

Search outside of DiVA

GoogleGoogle Scholar

isbn
urn-nbn

Altmetric score

isbn
urn-nbn
Total: 36 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf