BI Product Owner and Managing Vision

Here is a nice article on managing BI with a scrum approach:$FILE/Whitepaper%20Barry.pdf I recommend starting with vision analysis sessions.. What is the vision of the company, what are the objectives, how they reach them. Then Draw a Mind-Map: Of vision (Big Hairy Audecious Goal BHOG, e.g. become Fortune 500) and objectives: Such as Increase[…]

Azure Machine Learning

Azure Machine learning is IDE where data scientists can develop machine learning experiments, operationalize them and integrate them into solutions using web services. This can be accomplished with the following steps:   – Create a training experiment. – Add your modules to it:   Click Run to run the experiment first from the bottom pane[…]

Installing SQL Server 2016

Configuring PolyBase: Configuring Service Accounts: Configuring TempDB options: Configuring access to SQL Server instance   Configuring SQL Server Analysis Services   Configuring SQL Server Reporting Services   Aggrement on R License Completing the installation: If SQL Server Management Studio did not load, allocate it in MS website, download it, and install it separately:

Fact Table Design Options

Comparison of Deisgn and ETL patterns for Fact Table, depending on its usage, and performance requirements: Criteria Full Re-flush Snapshot with Insert then Archive Differential Facts Periodic Snapshots ETL Structure Simplest and may be required when using any other pattern, once an error happens. 2 Snapshots: one new and one old snapshot data. Requires differential calculations[…]

Big Data–Intro

MapReduce: A distributed data-processing system. “Mapper” nodes preprocess data (filter etc.), then “Reducer” nodes aggregate the data into the result.– Java-code jobs running in Batch (non online) approach. So slower responsiveness.GFS – Google File System: A distributed file-storage system: HDFS. Hadoop: An (Yahoo) open source implementation of Google’s MapReduce and GFS (Google File System).Hadoop can[…]