Go.Data: Building additional dashboards in Power BI

Go.Data is a platform for outbreak response and contact tracing developed by the World Health Organization (WHO) in collaboration with partners in the Global Outbreak Alert and Response Network (GOARN) and informed by years of field experience. Go.Data is a multi-language, easy-to-use tool that facilitates all elements of the outbreak response, from case investigation to identification, listing and tracing of contacts, as well as data management and analysis. In addition, Go.Data can be easily connected to other platforms for more customized dashboards or advanced analysis.

In this course, students will learn how to create additional dashboards in Power BI using the data collected in Go.Data.

Photo credits: WHO / NOOR / Mariceu Erthal

自学
语言: English
Health topic

课程信息

Overview: Go.Data is a platform for outbreak response and contact tracing developed by the World Health Organization (WHO) in collaboration with partners in the Global Outbreak Alert and Response Network (GOARN) and informed by years of field experience. Go.Data is designed to allow field-based users to register cases, contacts and their related data, including laboratory samples and hospitalizations. Go.Data also offers a range of analytics functionalities to help responders target local response efforts in real-time, which include a dashboard with key performance indicators for cases, contacts and chains of transmissions, and an interactive feature to visualise chains of transmission as networks and timelines. In addition to these analytic functionalities, Go.Data can be easily connected to other platforms for more customized dashboards or advanced analysis.

In this course, students will learn how to create additional dashboards in Power BI using the data collected in Go.Data.

Microsoft Power BI is a business intelligence platform that provides tools for aggregating, analysing, displaying, and sharing data with non-technical users. It brings together analytics, data visualisation, and best practices to assist organisations in making data-driven decisions.

The course covers essential aspects of the creation of customized dashboards in Power BI using the data collected in Go.Data, including how to connect Go.Data to Power BI, how to generate custom dashboards and reports, and how to publish and share the created dashboard with our colleagues or the public.

Course duration: Approximately 2 hours.

Certificates: A Certificate of Achievement will be available to participants who score at least 80% of the total points available in the final assessment. Participants who receive a Record of Achievement can also download an Open Badge for this course. Click here to learn how.

你将学到什么

  • Connect Go.Data to Power BI
  • Create customized dashboards in Power BI using the data collected in Go.Data
  • Clean and transform data in Power BI
  • Create key performance indicators and graphs using different attributes in Power BI
  • Publish and share the generated dashboard

课程内容

  • Module 0: Course introduction:

    By the end of this module, students will describe the course objectives and structure.
  • Module 1: What is Power BI:

    By the end of this module, students will describe what is Power BI; the key terms used in Power BI, and the main reasons to build additional dashboards in Power BI using the data collected in Go.Data.
  • Module 2: Download and install Power BI:

    By the end of this module, students will perform the required steps to download and install Power BI Desktop application and download the Go.Data - Power BI Dashboard template.
  • Module 3: Introduction to Power BI Desktop:

    By the end of this module, students will describe what is Power BI Desktop, and what are the Power BI Desktop principal uses and functionalities.
  • Module 4: Power BI Query Editor:

    By the end of this module, students will describe what is Power BI Query Editor, what are the Power BI Query Editor principal functionalities; and what is the advanced editor.
  • Module 5: Connecting Go.Data and Power BI applications:

    By the end of this module, students will connect Power BI and Go.Data using four parameters available in the Power BI Query Editor and solve the most common connection problems.
  • Module 6: Fetch data from Go.Data questionnaires to Power BI:

    By the end of this module, students will be able to fetch the data from the Go.Data cases, contacts, follow-ups, and laboratory questionnaires using the Power BI Query Editor.
  • Module 7: Go.Data Power BI Dashboard template:

    By the end of this module, students will describe what are the different tabs, key performance indicators and visualizations available in the Go.Data - Power BI Dashboard template.
  • Module 8: Creating new visuals in the Go.Data - Power BI Dashboard template:

    By the end of this module, students will describe the various visualization options in Power BI, and create new visuals such as graphs, maps, key performance indicators, and tabular reports.
  • Module 9: Customizing visuals in the Go.Data – Power BI Dashboard template:

    By the end of this module, students will edit visuals in Go.Data - Power BI Dashboard template, including titles, legends, colors, labels, and background.
  • Module 10: Calculated measures and calculated columns:

    By the end of this module, students will describe what are calculated measures and calculated columns in Power BI, understand the difference between them, create a calculated column and a calculated measure; and describe when to use a calculated measure and a calculated column.
  • Module 11: Sharing the Go.Data Power BI Dashboard template using Power BI Desktop:

    By the end of this module, students will export and share reports in different formats using Power BI Desktop, including PDF, PBIX file, and PNG/JPG.
  • Module 12: Refreshing data in the Go.Data Power BI Dashboard template using Power BI Desktop:

    By the end of this module, students will describe what is data refresh, and refresh data in Power BI Desktop.
  • Module 13: Introduction to Power BI Service (optative module):

    By the end of this module, students will describe what is Power BI Service, access Power BI Service and describe its main functionalities.
  • Module 14: Publishing and Sharing the Go.Data - Power BI Dashboard template using Power BI Service (optative module):

    By the end of this module, students will publish the Go.Data - Power BI Dashboard template to Power BI Service, and share it within their organization, and the public.
  • Module 15: Automate Go.Data - Power BI Dashboard template data refresh using Power BI Service (optative module):

    By the end of this module, students will describe what is the scheduled refresh, and schedule refresh in Power BI.

订阅本课程

该课程是免费的。 只需在OpenWHO上注册一个帐户并参加课程!
现在注册吧
当前注册用户: 4260

证书要求

  • 课程证书 授予者需要至少取得课程总分的百分之 80%