microsoft
Exam DP-500: Designing and
Implementing Enterprise-Scale
Analytics Solutions Using
Microsoft Azure and Microsoft
Power BI
structured data
Lend well to all types of of Analytics.
Structured Query Language (SQL)
is used to query relational databases and is commonly used
by data analysts, data engineers, and data scientist alike.
,It is typically quantitative and stored in relational and data
warehouses.
It is Structured data.
Presentation of annual financial data is a common example
of?
Could be stored in Excel or relational databases like Azure
SQL.
Presentation of Structured data
unstructured data
is information that isn't organized in any discernible manner.
Often more suitable for qualitative analysis and stored in
non-relational databases and data lakes.
Unstructured data
Which of the following is an example of descriptive analytics?
A monthly sales report looking at sales data over the last year
,What are the first three steps in the data analytics process?
Requirements gathering, data ingestion and processing, and
data exploration
Data analytics
is the process of collecting, transforming, and presenting
data to inform decision making.
Requirement Gathering Exercise
Developing analytics solutions beings before any technology
is involved.
Data Exploration
is the effort to understand what you are working with, and
how the data can respond to the needs of business.
At a basic level what tool can be used for Data Exploration
, Excel is a tool that can be used.
A tool that Analyst make use to profile data is?
Power Query in Power BI
A tool that Data scientists May use to profile data is?
Apache Spark in Azure Synapse.
In the data exploration phase another steps that analysts
may also being with to protyping data exploration?
Dashboard and Report Protyping
Data Analysis
Analysis can be descriptive, predictive, prescriptive, or even
cognitive and can be conducted with different tools.
Descriptive analytics
Exam DP-500: Designing and
Implementing Enterprise-Scale
Analytics Solutions Using
Microsoft Azure and Microsoft
Power BI
structured data
Lend well to all types of of Analytics.
Structured Query Language (SQL)
is used to query relational databases and is commonly used
by data analysts, data engineers, and data scientist alike.
,It is typically quantitative and stored in relational and data
warehouses.
It is Structured data.
Presentation of annual financial data is a common example
of?
Could be stored in Excel or relational databases like Azure
SQL.
Presentation of Structured data
unstructured data
is information that isn't organized in any discernible manner.
Often more suitable for qualitative analysis and stored in
non-relational databases and data lakes.
Unstructured data
Which of the following is an example of descriptive analytics?
A monthly sales report looking at sales data over the last year
,What are the first three steps in the data analytics process?
Requirements gathering, data ingestion and processing, and
data exploration
Data analytics
is the process of collecting, transforming, and presenting
data to inform decision making.
Requirement Gathering Exercise
Developing analytics solutions beings before any technology
is involved.
Data Exploration
is the effort to understand what you are working with, and
how the data can respond to the needs of business.
At a basic level what tool can be used for Data Exploration
, Excel is a tool that can be used.
A tool that Analyst make use to profile data is?
Power Query in Power BI
A tool that Data scientists May use to profile data is?
Apache Spark in Azure Synapse.
In the data exploration phase another steps that analysts
may also being with to protyping data exploration?
Dashboard and Report Protyping
Data Analysis
Analysis can be descriptive, predictive, prescriptive, or even
cognitive and can be conducted with different tools.
Descriptive analytics
