Giter Club home page Giter Club logo

azure-data-services-go-fast-capability-assessment's Introduction

Data And Analytics Platform Capability Assessment

This repo contains collateral that provides organisations with a framework for assessing their level of maturity or capability within the sphere of data and analytics.

Introduction

The primary objective of this repository is to provide a list of "features" or "capabilities" that could be considered indicators or oragnisational maturity within the area of data and analytics. In order to assist with the creation of such a list we broadly define the area as data and analytics using the simple conceptual model shown below.

Conceptual Architecture

Using the model shown above we categorise our "features" into 6 primary "variants" of data and analytics:

  1. Data Lake
  2. Agile Bi
  3. Modern Data Warehouse
  4. Machine Learning & Data Science Exploration
  5. Real-Time Analytics
  6. OLTP Databases

Viewing and Collaborating on the Core Feature List

The core reporistory consists of an issues list. An issue has been created for each "feature" that is considered an indicator of maturity. You can view and collaborate on the features using the standard issue list (https://github.com/microsoft/azure-data-services-go-fast-capability-assessment/issues) contained in this repository.

If you wish to view and interact with a summary report containing these issues please got to the Power BI report found at the link below:

Public Feature List in Power BI

Power BI Summary

Performing an Assessment and Getting a Maturity Score

The issues list contained in this repository can be used to carry out a "self" assessment and obtain a capability or maturity score for each of the data and analytics variants. To do this please carry out the following steps:

  1. Download and fill out the orange columns in the Excel Assessment Template.
  2. Download the Assessment Power BI Report Power BI Assessment Template and use it to generate your capability scores. Note you will need to point the Power BI Assessment template to your version of the Excel Assessment Template. Do this by editing the Power BI File parameters.
  3. Download the Power Point Assessment Template. Modify this template to create a maturity assessment summary presentation.

Once the process is complete you will be able to generate charts similar to those shown below:

Power BI Assessment - Summary

Power BI Assessment - Incomplete

Building your Data and Anlytics Strategy

Using the tools provided in this repository you can build out a data and analytics strategy that is designed to drive targeted capability uplift for your organisation. By reviewing and customising the feature list items you can effectively build your organisation's view of the utopian future state. By rating your organisation's current cpabilities as they pertain to each of the feature list items you can effectively build out your current state. Finally, by prioritising the gaps in your current capabilities and grouping these into projects you can define a full program of work that clearly sets out your transition plan from current to future state. A grapghical depiction if this is provided in the figure below.

Capabilitly Assessemnt Overview

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.opensource.microsoft.com.

When you submit a pull request, a CLA bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., status check, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Trademarks

This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.

azure-data-services-go-fast-capability-assessment's People

Contributors

jrampono avatar sergiozenatti avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

azure-data-services-go-fast-capability-assessment's Issues

Power BI Template Files - Layout & Branding

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  106,
   "UniqueId":  "563153e2-c2f3-4b8e-81ff-f99c470466de"
} 

Datasources - Oracle

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  85,
   "UniqueId":  "92ab2cec-0c8a-4184-9834-2d26253e0170"
} 

Schedules abstracted into Meta Data?

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  68,
   "UniqueId":  "853bf45f-2e54-4d99-892a-4d7bc67bfdcf"
} 

ARM Templates

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  77,
   "UniqueId":  "ead1631f-bd1e-4fac-8555-d00020d757c2"
} 

Data Catalog Integration

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  111,
   "UniqueId":  "f0be20ef-d997-4ca0-ad28-2c277be3cd01"
} 

Datasources - APIs

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  87,
   "UniqueId":  "323d1883-ebb5-462a-a6a4-dc2d7a0fd220"
} 

Data Lake Access controls

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  113,
   "UniqueId":  "8ccfa1f0-758a-4fc2-b5f8-92cf96d24b65"
} 

Datasources - Sharepoint

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  86,
   "UniqueId":  "03a7a145-088d-4c21-8e91-c0ffe0897da1"
} 

Blob and DL Gen2 Support?

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  93,
   "UniqueId":  "00fb531c-70ed-41bc-9a05-c3af31c5741d"
} 

Datasources - Excel

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  81,
   "UniqueId":  "8e4078d2-0aa2-4dba-a220-8d0b6bb094f6"
} 

Workspace Creation Workflow and DevOps

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  107,
   "UniqueId":  "24029396-60fe-47d8-9de1-32332461e172"
} 

Network Isolation

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  76,
   "UniqueId":  "b8a6b80a-335b-4cf7-9bb8-f6788c2db387"
} 

Automatic Teiring (Async)

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  92,
   "UniqueId":  "6d857939-b680-4916-8c36-acaee12a0a12"
} 

Datasources - JSON

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  83,
   "UniqueId":  "3f0c5c22-e79d-4a4e-ad2f-ea98b574db6d"
} 

Datasources - SQL Server

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  84,
   "UniqueId":  "f8ad5c24-5f88-41f1-92a8-7022d1073a46"
} 

Dynamic Merge into Stage

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  95,
   "UniqueId":  "84b6aa2f-adb6-4b6b-86da-b0a4292ab827"
} 

Key / Password Rotation

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  75,
   "UniqueId":  "f2db66d0-6a50-4f05-a9bc-3167b06a756c"
} 

ML Workspace Workflow and DevOps

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  112,
   "UniqueId":  "22a424b5-4e82-4c26-ba24-28333669aef6"
} 

Data Lake Zones & Naming Conventions

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  89,
   "UniqueId":  "aecf2bc3-17ec-41b4-829e-f20b9472edf3"
} 

Tasks Abstracted into Meta Data?

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  65,
   "UniqueId":  "bd61649c-f098-40e7-8465-d96f348637a4"
} 

Dynamic Schema Creation (Initial)

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  94,
   "UniqueId":  "d9603394-9524-462e-b684-3c15274d917f"
} 

Upload Metadata to Data Catalog

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  80,
   "UniqueId":  "0960c040-9d61-4062-9cb6-2a15d1e4f2c1"
} 

Moving B/W Zones Async

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  91,
   "UniqueId":  "35232beb-195a-43a7-8329-8203a1a63289"
} 

Azure ML Compute Templates / automation

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  114,
   "UniqueId":  "4015d6bd-370b-42e3-83cf-ee2014eb3662"
} 

JIT Firewall Whitelisting

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  73,
   "UniqueId":  "9530342c-3b2e-4d1f-b171-36a53dc82402"
} 

Datasources - CSV

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  82,
   "UniqueId":  "7051b563-682f-4104-b8d6-7d7ed82506d1"
} 

Key Vault Integration - ADF Linked Services

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  74,
   "UniqueId":  "d6edfb2c-3160-499e-89d8-53072748ba59"
} 

Upload Schema

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  79,
   "UniqueId":  "95feca7a-0a83-4539-9342-cfd5dcbf6212"
} 

Upload Data Payload

Issue Description:

Please Add a meaningful description here!!!.

Standard Tags Below - Do Not Remove

 {
   "DevOpsId":  78,
   "UniqueId":  "2352483f-b438-4ed7-b565-720a41ce7b9c"
} 

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.