Analyzing the loaded data
From: Developing big data solutions on Microsoft Azure HDInsight
After successful completion of the ETL process the LapData table in Azure SQL Database is populated with the filtered and combined telemetry data. Engineers in the team can then use familiar tools such as Excel to connect to the database, import the data, and analyze and visualize it. For example, team engineers could use Power View to visually compare key sensor reading values at specific points during the lap, as shown in Figure 1.
Figure 1 - Visualizing racecar telemetry data in Power View
Note
For information about using Power View see Visualizing data in Excel.