DP-900

DP-900

1. Module 1: Explore core data concepts

   • Classify
     • Structured
     • Semi-structured
     • Unstructured
   • Defined and Stored
     • Read-only
       • Access means the users can read data but can't modify any existing data or create new data. 
     • Read/write
       • Access gives users the ability to view and modify existing data. 
     • Owner
       • Privilege gives full access to the data including managing the security like adding new users and removing access to existing users. 
   • Data Processing Solutions
     • Transactional system
       • Online Transactional Processing (OLTP)
     • Analytical system
       • Data Ingestion
         • Data ingestion is the process of capturing the raw data. This data could be taken from control devices measuring environmental information such as temperature and pressure, point-of-sale devices recording the items purchased by a customer in a supermarket, financial data recording the movement of money between bank accounts, and weather data from weather stations. Some of this data might come from a separate OLTP system. To process and analyze this data, you must first store the data in a repository of some sort. The repository could be a file store, a document database, or even a relational database.
       • Data Transformation/Data Processing
         • The raw data might not be in a format that is suitable for querying. The data might contain anomalies that should be filtered out, or it may require transforming in some way. For example, dates or addresses might need to be converted into a standard format. After data is ingested into a data repository, you may want to do some cleaning operations and remove any questionable or invalid data, or perform some aggregations such as calculating profit, margin, and other Key Performance Metrics (KPIs). KPIs are how businesses are measured for growth and performance.
       • Data Querying
         • After data is ingested and transformed, you can query the data to analyze it. You may be looking for trends, or attempting to determine the cause of problems in your systems. Many database management systems provide tools to enable you to perform ad-hoc queries against your data and generate regular reports.
       • Data Visualization
         • Data represented in tables such as rows and columns, or as documents, aren't always intuitive. Visualizing the data can often be useful as a tool for examining data. You can generate charts such as bar charts, line charts, plot results on geographical maps, pie charts, or illustrate how data changes over time. Microsoft offers visualization tools like Power BI to provide rich graphical representation of your data.

2. Module 2: Explore relational data in Azure

3. Module 3: Explore non-relational data in Azure

4. Module 4: Explore modern data warehouse analytics in Azure

Bilder und Dateien der Mindmap