Sample Data Guide

Sample Data Guide

Sample Data is an innovative offering from Power My Analytics. This guide will dive into the details of the Sample Data, its value, and how to use it. It covers two primary topics: The Value of Sample Data, and How to Use Sample Data.

The Value of Sample Data



Sample Data provides a substantial benefit to marketers. It is randomized data for each field of every data source and can be used with data destinations such as Looker Studio, Microsoft Excel, and Google Sheets. Its main use is in designing templates and showcasing marketing prowess without revealing actual user data.

Benefits of Sample Data:

  1. Report Building: Sample Data is crucial for building effective and aesthetically pleasing reports. It allows you to generate a dummy report to visualize how your real data will look in various formats.
  2. Dashboard Templates Creation: The data is invaluable for generating dashboard templates. It provides a blank slate to lay out and plan how the data will be displayed.
  3. Sharing Reports/Dashboards: Sample Data helps share reports and dashboards safely. It ensures that sensitive data isn't accidentally exposed.
  4. Educational Material Creation: For creating tutorials, guides, or any other educational material, Sample Data serves as a neutral, non-sensitive data source.

How to Use Sample Data

To utilize the full potential of Sample Data, you'll need to understand the process of accessing and implementing it.

Steps to Use Sample Data:

  1. Select a Data Destination: Begin by choosing a destination for your data. Power My Analytics supports Looker Studio, Microsoft Excel, and Google Sheets for this purpose.
  2. Configure a Data Source: Once you've chosen a destination, start configuring your chosen data source.
  3. Select "Sample Account": While configuring the data source, you'll come across an option for "User Account". Choose "Sample Account" from this option to opt for Sample Data.
  4. Adjust Sample Data: Power My Analytics allows customization of Sample Data with two optional parameters:
    1. Seed: Use the 'Seed' option if you need a consistent set of Sample Data. To use seed, enter a unique number. This number will generate the same set of Sample Data every time.
    2. Magnitude: The 'Magnitude' option helps to adjust the sample size. Entering a percentage less than 100 will reduce the data size, and entering a percentage over 100 will increase it.


By following these steps, you can harness the benefits of Sample Data, enabling the design of efficient templates, the creation of educational material, and the secure sharing of reports and dashboards.

Wrapping It Up

Sample Data from Power My Analytics gives marketers a versatile tool for showcasing their skills without compromising any user data. It's easy to access, customize, and integrate into your marketing strategy. Remember to make full use of this feature to elevate your reporting, education, and template designs.

Still Have Questions?

  1. What Seed Should I Use in Sample Data?
  2. What Magnitude Should I Use in Sample Data?


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • How to Use Sample Data

        Sample Data allows you to showcase templates and reports to potential clients without sharing sensitive information. Read this article to learn how to use Sample Data in Looker Studio. Can I Use Sample Data? Currently, Sample Data is only available ...

      • Looker Studio Demo Template Guide

        When connecting to Looker Studio, there are a few best practices to keep in mind. From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Demo Power My ...

      • How to Avoid Duplicate Reports in Looker Studio

        After making a copy of a report, you may notice that changes made to the copy reflect on the original. This article will show you how this happens and how to fix it. What Is a Duplicate Report? When a copy is made, selecting from available data ...

      • How to Use a Multi-Source Report Template in Looker Studio

        Are you a Looker Studio template user looking to streamline your reporting process? Look no further! In this article, we'll cover how to use a multi-source report template in Looker Studio. We'll walk through the steps of selecting data sources, ...

      • What Magnitude Should I Use in Sample Data?

        When utilizing Sample Data in Power My Analytics, users often inquire about the 'Magnitude' parameter. Magnitude is an optional field users can adjust to increase or decrease the size of the Sample Data set. What is 'Magnitude' in Sample Data? In the ...