Business Intelligence for IoT Solutions


About This Course

Are you ready to create data visualization reports that help you to discover hidden trends in your business data? Do you want to get up-to-speed on the latest tools?

This course guides students through a series of lab activities that provide hands-on experience querying and visualizing data. After completing this course, students will be able to construct IoT data visualizations that allow a business to gain insights related to its operations.

The first module examines the characteristics of time series data – how it can be used for analysis and prediction. It specifically walks the student through how IoT telemetry data is typically generated as time series data and techniques for managing and analyzing it with Azure Time Series Insights.

Module two takes a closer look at specific features of Azure Time Series Insights – how it can be used to store, analyze and instantly query massive amounts of time series data.

In the third module, students get a general introduction to using Power BI, with specific emphasis on how Power BI can load, transform and visualize IoT data sets.

In the final module, students will move from using BI with static IoT data sets to working with real time streaming IoT data. Students use Azure Stream Analytics as a data source for Power BI and explore the unique capabilities and insights that provides.



第一个模块检查时间序列数据的特征 - 如何用于分析和预测。它特别指导学生了解物联网遥测数据通常如何生成为时间序列数据,以及使用 Azure Time Series Insights 管理和分析的技术。

第二部分详细介绍了 Azure Time Series Insights 的特定功能 - 如何使用它来存储,分析和即时查询大量的时间序列数据。

在第三个模块中,学生将对使用 Power BI 进行一般性介绍,特别强调 Power BI 如何加载,转换和可视化物联网数据集。

在最后一个模块中,学生将从使用具有静态 IoT 数据集的BI转向使用实时流式 IoT 数据。学生使用 Azure Stream Analytics 作为 Power BI 的数据源,并探索提供的独特功能。

What you'll learn

After completing this course, students will be able to:

  • Describe when and why to use the Time Series Insights and Power BI data visualization tools
  • Install and configure Time Series Insights
  • Connect Time Series Insights with IoT Hub and Event Hub
  • Configure data retention and create a reference data set
  • Build dashboards and heat maps
  • Scale the environment and manage resources using templates
  • Transform Data using Power BI Desktop
  • Model data using the Power BI Desktop
  • Visualize data using the Power BI Desktop
  • Create a Dashboard using the Power BI Service
  • Configure Organization Packs, Security and Groups
  • Get your IoT hub ready for data access by adding a consumer group
  • Create, configure, and run a Stream Analytics job for data transfer from your IoT hub to your Power BI account
  • Create and publish a Power BI report to visualize the data
  • 描述何时以及为何使用 Time Series Insights 以及 Power BI 数据可视化工具
  • 安装和配置 Azure Time Series Insights
  • 使用 IoT Hub 和 Event Hub 连接Azure Time Series Insights
  • 配置数据保留并创建参考数据集
  • 构建仪表板和热图
  • 使用模板扩展环境并管理资源
  • 使用 Power BI Desktop 转换数据
  • 使用 Power BI Desktop 建模
  • 使用 Power BI Desktop 可视化数据
  • 使用 Power BI 服务创建仪表板
  • 配置组织包,安全和组
  • 通过添加使用者组,让您的 IoT Hub 为数据访问做好准备
  • 创建,配置和运行 Stream Analytics 作业,以便将数据从 IoT Hub传输到 Power BI 帐户
  • 创建并发布 Power BI 报告以可视化数据


Before starting this course, students should understand the following:

  • IoT terminology and business goals
  • Data analytics tools and techniques
  • Modern software development tools


  • 物联网术语和业务目标
  • 数据分析工具和技术
  • 现代软件开发工具

Course Syllabus

This course is completely lab-based. There are no lectures or required reading sections. All of the learning content that you will need is embedded directly into the labs, right where and when you need it. Introductions to tools and technologies, references to additional content, video demonstrations, and code explanations are all built into the labs.

Some assessment questions will be presented during the labs. These questions will help you to prepare for the final assessment.

The course includes four modules, each of which contains two or more lab activities. The lab outline is provided below.

Module 1: Time Series Data

  • Lab 1: Introducing Time Series Insights
  • Lab 2: Producing Simulated Data
  • Lab 3: Provisioning Time Series Insights
  • Lab 4: Analysis with Time Series Insights

Module 2: Visualizing and Querying Data

  • Lab 1: Setting Up Data Generation
  • Lab 2: Using Time Series Analysis Patterns
  • Lab 3: Using Advanced TSI Features
  • Lab 4: Managing Time Series Insights

Module 3: Power BI and IoT

  • Lab 1: Introducing Power BI
  • Lab 2: Transforming Data
  • Lab 3: Modeling Data
  • Lab 4: Visualizing Data

Module 4: Streaming with Power BI

  • Lab 1: Using Power BI with Streaming Data
  • Lab 2: Configuring Power BI
  • Lab 3: Using Power BI in an IoT architecture
  • Lab 4: Sharing Power BI Dashboards





  • 实验1:介绍 Time Series Insights
  • 实验2:生成模拟数据
  • 实验3:配置 Time Series Insights
  • 实验4:使用 Time Series Insights 进行分析


  • 实验1:设置数据生成
  • 实验2:使用时间序列分析模式
  • 实验3:使用高级TSI功能
  • 实验4:管理 Time Series Insights

第3单元:Power BI 和物联网

  • 实验1:介绍 Power BI
  • 实验2:转换数据
  • 实验3:建模数据
  • 实验4:可视化数据

第4单元:使用 Power BI 进行流式处理

  • 实验1:将 Power BI 与流数据结合使用
  • 实验2:配置 Power BI
  • 实验3:在物联网架构中使用 Power BI
  • 实验4:共享 Power BI 仪表板

Course Staff


Chris Howd

Engineer and Software Developer


Chris is an engineer and software developer who has been working at Microsoft in various roles for the past 15 years. Before coming to Microsoft, Chris worked for the U.S. Department of Defense designing and developing computer controlled instrumentation and robotic systems, and was a self-employed contractor doing engineering research with NASA and select engineering start-ups.


Rob Collins

Founder and lead consultant

RCP Consultants

Rob Collins is founder and lead consultant at RCP Consultants. He has been working with C# and the .NET Framework since its initial release more than fifteen years ago. He has been delivering software for enterprise customers, the mass market retail chain, mid-market companies, and startups for more than twenty years.

Frequently Asked Questions

Who can take this course?

Unfortunately, learners from one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. EdX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.