"Unsere Schwächen und Laster bleiben konstant;
 nur unsere Stärken wachsen, so daß die Täuschung entsteht, jene ersteren seien verschwunden.”
HEIMITO von DODERER

 

JOBPROFIL DATA WAREHOUSE-ANALYST:

Berufliche Schwerpunkte: - Data Warehousing / Datenmodellierung - Data Pipelines / ETL - Datenanalyse / Datenvisualisierung

BI-Stack: - MS SQL Server (incl. SSAS / SSIS) - Board - Cubeware - außerdem: Power BI / Tableau

Tools: - SQL / TSQL - MDX / DAX - PowerShell - R / Tidyverse

 

 

 

 

 

 

IT-Links zu den Themen Data Warehousing - Data Engineering - Data Analytics
 

Allgemeines:

- Enzyklopädie der Wirtschaftsinformatik	- Stackoverflow
- ITWissen	- TechNet
- Clean Coder	- msxfaq.de
- Administrator.de	- Informatiklexikon
- Connection Strings	- Github
- Intel Prozessoren	- Operating Systems Study Guide
- iX Magazin	- BI-Spektrum
- GeeksforGeeks	- Microsoft-Dokumentationen
- Informatik aktuell	- EntwicklerLexikon
- DotNetFramework	- DataCareer

 

 

 

 

 

 

 

 

Datenmanagement allgemein:

- Database Journal	- Modern SQL
- Digital Analytics Association Germany	- PostgreSQL
- Kaggle	- Apache Airflow
- Wikibooks PostgreSQL	- PostgreSQL Tutorial
- ETLBox	- BigData Insider
- ACM SIGMOD	- Data Science Central
- Data Virtuality	- TDWI
- Datendschungel	- Apache Spark
- Towards Data Science	- databricks
- KDnuggets	- Data Science Blog
- BI Corner	- Theobald Connector
- Diagrams.net	- Storage Insider

 

 

 

 

 

 

 

 

 

 

MS SQL Server:

- Wikibooks SQL Server	- MS SQL-Tips
- MS SQL Server	- PASS Deutschland
- Brent Ozar	- SQL Authority
- T-SQL Referenz	- Redgate - Simple Talk
- SQL Server Central	- Doku DMV SQL Server
- SQL Server Performance	- SQLShack
- PASS.org	- SQL Style Guide
- Glenn Berry	- Ola Hallengren
- Blog Andreas Wolter	- Blog Paul Turley
- SMA-EDV	- DB-Berater Blog
-SQL Server Blog	- Machine Learning Services
- SSIS Microsoft	- SSIS Tutorial
- SQL IS Blog	- Technet SSIS
- Matt Masson Links	- R in Machine Learning Services

 

 

 

 

 

 

 

 

 

 

 

 

 

Analysis Services (SSAS):

- SSAS on TechNet	- SSAS Info
- SSAS Forum	- Doku DMV SSAS
- SSAS DMV Tips	- MDX Fundamentals
- MDX-Referenz	- MDX Reference (iccube)
- Performance Improvements for MDX	- MDX Studio
- Chris Webb`s BI Blog
-DAX Studio	- DAX Funktionsreferenz
- DAX	- DAX Guide
- DAX Foundation	- Tabular Editor
- ALM Toolkit

 

 

 

 

 

 

 

 

 

BI-Systeme:

- Microsoft Power BI	- byoBI
- Excelerator BI	- M Reference
- Datachant	- Insight Quest
- SQLBI	- Tableau
- Cubeware	- Board

 

 

 

 

 

PowerShell:

- German PowerShell	- PowerShell
- PowerShell Gallery	- PowerShell Magazine
- PowerShell-Praxis	- Microsoft Scripting Center
- PowerShell-Befehle	- PowerShell Wikiversity
- PowerShell auf WindowsPro	- PowerShell XML
- PowerShell Script Example	- PowerShell Excel
- PowerShell MCP Mag	- PowerShell Data Files
- PowerShell SQL Server	- SSAS PowerShell
- SQL Server PowerShell Tips

 

 

 

 

 

 

 

 

BWL / Controlling:

- Controlling Wiki	- Gabler Wirtschaftslexikon
- Rechnungswesen verstehen	- BWL-Wissen
- WiWi Online	- ControllerSpielwiese
- Controlling-Wiki	- ICV-Blog

 

 

 

 

R / Tidyverse:

- Tidyverse	- ggplot2
- R for Data Science	- R Graphics Cookbook
- tidyquant	- Tidyverse Tutorial
- Modern Dive	- Data Visualization with R
- sparklyr	- Mastering Apache Spark with R
- Tidymodels	- Tidyverse Skills for Data Science
- R Cookbook (2. ed)	- Tidy Modeling with R
- Tidy Forecasting in R	- EDA with R in Tidyverse
- Wrangling Healthcare Data with R	- timetk
- Modern R with the tidyverse

 

 

 

 

 

 

 

 

 

Datenanalyse - speziell mit R:

- R Project	- RDocumentation
- RStudio	- Wikibooks Statistik
- Wikibooks R-Programming	- Wikiversity Statistics
- Wikibooks Data Mining R	- Handbook Engineering Statistics
- Statistical Analysis Introduction
- R Cookbook	- Wikibooks Formelsammlung Statistik
- R Journal	- Statsoft Textbook
- R Tutorial	- Wikibooks Regal Mathematik
- Quick R	- Microsoft R Application Network
- R Servcies Tutorial	- Stats Stackexchange
- R Shiny	- Shiny and SQL Server
- Advanced R	- Machine Learing with R
- R-Bloggers	- r-statistics.co
- Intro Statistical Learning	- Journal of Statistical Software
- YOU CANalytics	- Statistik-Forum
- Faes.de	- RStudio Cheatsheets
- SQL in R	- bookdown
- Using Apache Drill with R	- RPresto
- R Markdown	- Online Statistics Education
- Calculus	- R Companion-Website
- R for Operations Research	- Data Visualization
- Count Bayesie	- Modern Statistics with R
- RSeek	- RStudio Community
- R on stackoverflow	- R Packages
- Audit Analytics with R
- The Worst Stats Text eveR

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Ökonometrie / Zeitreihenanalyse / Survival Analyse in R

- Wikibooks Econometrics	- Econometrics with R
- tidyquant	- Rob J. Hyndman
- Forecasting: principles and practice (2. Aufl.)	- Forecasting principles and practice (3. Aufl.)
- Using R for Time Series Analysis	- Time Series Analysis
- timetk	- Tidy Time Series analysis
- Sweep	- Survival Analysis in R
- Principles of Econometrics with R

 

 

 

 

 

 

 

Lernen im Internet:

- Tutorialspoint	- Learn X in Y minutes
- Mapt	- DZone
- Simple Talk	- Tutorial Gateway
- Tutorialspoint Codingground	- datacamp