Reading notes Where exactly in your organization is the data which you are searching for? It is a usual fiasco happends in any big/enterprise to search for information/data when an employee resigns, because ‘catalog’ information resides with certain people in the organization which creates a dependency. Find my reading notes on Azure Purview: Azure Purview provides: Unified data governance service Manage and govern – on-premises, – multi-cloud, and – SaaS data Create a – holistic, – up-to-date map of your data landscape with – automated data discovery, – sensitive data classification, –…
-
-
Read here – https://datascience.foundation/datatalk/modern-enterprise-data-management-in-healthcare
-
Here is my attempt to create first draft of my whitepaper on Data Governance. Will be working on improving the version my missing elements soon. Read paper here : First page for preview:
-
A very nice, informative deck on Data Lake / Modern Data Warehouse by james Serra.
-
“Dimension relationship” refers to the direct or indirect relationships between dimension and its measure groups in a Cube. Regular Refers to a standard relationship, when a Key column in the dimension is directly joined to fact table. Reference When a Key column in the dimension is indirectly joined to fact table by referencing another dimension. Fact / Degenerate Dimensions constructed from attribute columns in fact tables than from attribute columns in dimension tables. Many-to-Many One dimension is associated with multiple facts Read more: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models-olap-logical-cube-objects/dimension-relationships?view=sql-server-2017 Note: My study notes
-
Must read for data enthusiasts – https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dw-bi-lifecycle-method/
-
Introduction What is Azure Databricks? Azure Databricks is the same Apache Databricks, but a managed version by Azure. This managed service allows data scientists, developers, and analysts to create, analyse and visualize data science projects in cloud. Databricks is a user friendly, analytics platform built on top of Apache Spark. Databricks acts as an UI layer, a WYSIWYG dashboard where you can create clusters, manage notebooks, write code and analyse data without knowing the internals of the system. Apache Spark is a unified analytics engine for large scale data processing and currently it supports popular languages such as Python, Scala,…
-
You can change the Analysis Services mode from Multidimensional Mode to Tabular Mode or vice versa easily by following below steps. I did this on SQL Server Analysis Services 2016 version. Step 1: Edit msmdsrv.ini file Go to folder X:\Program Files\Microsoft SQL Server\MSAS13.MSSQLSERVER\OLAP\Config Change X: with your correct installation drive. Open file msmdsrv.ini in notepad It is recommended to take a backup first. There is a chance this folder require additional permission to edit so I would suggest you to open the file “as Administrator” Find the tag <DeploymentMode>0</DeploymentMode> If your current mode is Multidimensional then the DeploymentMode value will be 0 or…
-
OLAP – OnLine Analytical Processing ROLAP – Relational OnLine Analytical Processing MOLAP – Multidimensional OnLine Analytical Processing HOLAP – Hybrid OnLine Analytical Processing DOLAP – Desktop/Database OnLine Analytical Processing WOLAP – Web Enabled OnLine Analytical Processing Read more here – https://social.technet.microsoft.com/wiki/contents/articles/19898.differences-between-olap-rolap-molap-and-holap.aspx