microsoft / Azure-Analytics-and-AI-Engagement

Azure Analytics and AI Engagement
Other
136 stars 114 forks source link

Create a list of PowerBI Reports required based on the meeting recording video from Ron. #69

Closed daronyondem closed 4 years ago

xor-ranavikrant commented 4 years ago

Attaching the list of powerbi resources along with their table references here: WWI App Powerbi Resources .xlsx

daronyondem commented 4 years ago

The current upload was the demo recording instead of the meeting recording. Here are my findings.

image

Executive Dashboard for May is used to show the current dataset, real-time, and predictions.

image

IoT Network is presented. The "Car" option is selected. Video playback starts once the option is selected.

image

Global Operations Overview is the next step.

image

image

Miami Factory is selected.

image

The factory floor view is maximized. Heatmap is presented.

image

Back to the factory floor view, the red alert is selected.

image

User navigates to "Equipment View".

image

"Predictive Maintenance" is selected next.

image

CNC Machine issues are showed.

image

Product Defect Rate Spike is next.

image

Data points selected to see what's wrong.

image

Back on Equipment View, the asset is selected to launch Hololens Video.

image

image

PPE Compliance Alert is next.

image

Clicking the button launches PPE video.

image

Production Quality Degradation is next.

image

The selection launches the Production Quality Degradation report.

image

Azure Synapse Link animation is presented.

image

Azure Synapse Link Report is presented

image

Azure Synapse Link video is played.

image

App Architecture is presented.

image

Executive Dashboard for August is next.

image

Campaign Report is selected.

image

The report is launched in a separate window.

image

"Wheels of Steel" campaign is selected to filter out the dataset.

Investment Incremental Revenue and ROI by Campaign are maximized.

image

Data is played to show change based on the timeline.

Back on the Campaign Analytics report, different sentiments are selected from Sentiment by Product Category widget to filter out data.

Car real-time video is played.

Predictive Analytics is selected.

image

Worker Safety and Product Quality Report is presented.

image

Incident risk is selected to filter out data. Anomaly data points are selected to filter out data.

Injury Type by Source report is selected.

image

Global Occupational Safety Report is presented.

image

Injury type is selected to filter out data. "ppe" keyword is searched in the keyword search box to filter data.

Incident Reports is selected.

image

Handwritten incident report is presented.

image

Translation, Image Form and PDF Form are presented

image

Incident Report Search is shown.

image

"fractures" is searched in the search box.

A video for Rio for December 31st is shown.

image

The mobile experience is presented and video playback is shown on a mobile screen interface.

image

IoT Hub is shown to receive data.

image

Manufacturing data is shown in CosmosDB

image

image

Analytical Store is shown.

image

MesQuality container is shown.

image

MFG_WITHOUT_HTAP, MFG_WITH_HTAP, 8a MFG Cosmos... notebooks are presented.

image

7a Production Quality report is presented in Synapse.

The first six reports in the below screenshot are presented.

image

mfg-iot-data container from data lake is shown with parquet files in it.

image

1 MFG SQL Query with Synapse is shown.

image

1 Prepare data for Predictive Maintenance, 3 Prepare Data for Product Anomaly Detection is shown in Synapse. 1 Predictive Maintenance Model Training and Deploy, 2 Product Anomaly Detection Motel Training and Deploynotebook is shown in Jupiter

1 Billion Rows report is shown in Synapse.

daronyondem commented 4 years ago

Here are the artifacts I found to be used in the video.

Dashboards

Executive Dashboard for May Global Operations Overview Executive Dashboard for August

Videos

Car Video Playback from Executive Dashboard for May Damage Alert Hololens Video PPE Video Car real-time video A video for Rio for December 31st.

PowerBI Reports

Miami Factory Report Equipment View Report CNC Machine Issue View Product Defect Rate Spike Report Production Quality Degradation report Azure Synapse Link Report Campaign Report Worker Safety and Product Quality Report Global Occupational Safety Report Incident Report Search 7a Production Quality 1 Billion Rows

Others

Factory Heatmap Factory Floor View Azure Synapse Link animation Azure Synapse Link video The mobile experience is presented and video playback

CosmosDB

Manufacturing database MfgMesQuality collection

Notebooks

MFG_WITHOUT_HTAP MFG_WITH_HTAP 8a MFG Cosmos... 1 Prepare data for Predictive Maintenance in Synapse 3 Prepare Data for Product Anomaly Detection in Synapse 1 Predictive Maintenance Model Training and Deploy in Jupiter 2 Product Anomaly Detection Motel Training and Deploy in Jupiter

Data Lake

mfg-iot-data container

SQL Scripts

1 MFG SQL Query with Synapse

daronyondem commented 4 years ago

Received the meeting recording, and will report back will findings.

daronyondem commented 4 years ago

Notes from meeting recording.

No additional requirements, artifacts found compared to the demo video analysis.