The Data Architecture category provides a listing of various posts covering the design and organization of data structures and systems that support data management, storage, and retrieval. These would typically include the following types of articles; Introduction to Data Architecture, Data Modeling, Data Storage and Retrieval, and Data Management.
The date dimension is the table that controls your time analysis and is the most important to get right, especially with PowerBI, Excel, and other visualization tools. Having various tags and descriptors that aid in your analysis gives your end users several options in creating their visualizations in addition to a base for DAX time intelligence calculations.
There are many tools that you can purchase to generate documentation, however, also costs money or requires an install on client machines or servers. I wanted something fast which would not leave a foot print or require weeks of negotiations to get installed. The T-SQL script generates an HTML document out of the schema results that you can paste into Word to kickstart the documentation process.
This article reviews Data Governance Initiatives to determine how to secure data usage, manage activity, gain visibility, and control of one of your most important assets. Whether on-premises or in the cloud, more employees are using and sharing an ever-increasing amount of data throughout your organization.
This walk-through and resource list will provide an introduction of Power BI’s Object-Level Security (OLS) and when combined with Row-Level security (RLS), you can secure and hide specific metrics, measures, tables, or columns from report viewers when using Roles.
For GitHub projects, Markdown is an accessible format that is cross-platform and compatible with many web editors and CMS systems. This article shows how to add a Wiki to your GitHub project, write in markdown, and convert HTML documentation to the Markdown format.
With the announcement of Azure Purview, it is a great time to review some of the key features and provide a learning path made up of free online resources to help you get up to speed. This article will take you through an overview of Azure Purview by setting the stage focusing on Data Governance and providing links to the next steps.
