LAB: How to visualize system exposures in your community using the Google Data Studio tool
Visualizing your data is a great way to understand risks in your community such as data breaches, system exposure, and many others. In this article, I will show you how to get started visualizing your risk using Data studio. Data studio is an easy to use data visualization tool that enables you to track different metrics and KPIs across a variety of programs, databases, and storage systems.
443ID provides a CSV file that can be easily used with a number of different data visualization tools such as Databox, Tableau, and Retool.
Note: This guide should be used as an overview to get you started. For more information on how to customize your data to fit your use case, please refer to the Data Studio documentation here.
To follow along with this tutorial, you will need the following:
- An active 443ID account.
- An active Google account.
- Your CSV file from 443ID.
Note: 443ID provides a CSV file. Feel free to convert the document if needed. Data Studio supports multiple upload formats.
Upon running a risk score on your users, you will be given the option to download a CSV file. How to download your CSV file from 443ID.
Choose a data source. 443ID provides a CSV that can be converted to Excel, Google sheet, or any other supported source that fits your needs. Data Studio offers over 400 different services to connect to your data.
Click the “Create” button in the upper left hand side, and choose “Data source.”
You can use the CSV file you downloaded from 443ID, or you can convert the CSV file to another format.
Edit the data source schema and change any data types you need, or add any fields you’d like. Once done click “create report” (top right).
Next, select the data source you just uploaded, the report builder opens with a blank page. Start building out the metrics that matter to you.
To start building your report, you can select one of the charts. On the right side, you will see a panel to start dragging and dropping metrics. dimensions are the identifiers that you want to chart,such as Email, IP, and Phone. Metric is the category, such as Deny list, Email fraud, and VPN.
With this information you can now create customized charts, tables, and scorecards to better visualize the risk that 443ID has identified.
This example shows an Email address by VPN, Email address by FRAUD, and Email address by DENY LIST. You can customize each graph to display your user’s most relevant categories.
Share what you build! Follow us and let us know how you plan to use your Risk report!
Want to learn more about 443ID? Head over to 443ID.com