How to Pick the Best Size for an Infographic and Get Data from Relational Data Sources

How to Pick the Best Size for an Infographic and Get Data from Relational Data Sources

Infographics have become increasingly popular in recent years as a way to present information in a visually appealing and easily understandable format. However, one of the key factors in creating an effective infographic is choosing the right size. In this article, we will explore the best practices for selecting the size of an infographic and also discuss how to import data from relational data sources.

When it comes to determining the size of an infographic, there are a few guidelines to keep in mind. According to Edraw, a leading provider of infographic software, the perfect infographic width must not exceed 600 pixels, while the length should be below or equal to 1800 pixels. This ensures that the infographic is easily viewable on various devices and platforms.

If you are creating a vertical infographic, the width should ideally be between 600 and 1100 pixels. This range allows for optimal readability and presentation of the content. On the other hand, if you are working on a short-heightened infographic, it is recommended to keep the height at 2000 pixels or below. This ensures that the infographic fits within the screen without the need for excessive scrolling. For larger infographics, such as those with a lot of detailed information, the height can go up to 5000 pixels, but it is important to strike a balance between size and readability.

Now that we have covered the basics of infographic sizing, let's shift our focus to importing data from relational data sources. There are several ways to accomplish this, depending on the source and the tools you are using. One common method is to use your Windows account or Azure Active Directory credentials to access the data. This is especially useful when working with cloud-based services or databases.

Another option is to use your database credentials, such as those for SQL Server. If you have been given a unique sign-in to the database, you can enter those credentials on the Database tab. This allows you to directly connect to the database and import the required data. Similarly, if you have a Microsoft account, you can use those credentials to access Azure services and import data.

In some cases, you may need to write an SQL query to specify the tables and columns you need. This can be done by entering the server and database names and then expanding the Advanced options section to view your query options. Writing an SQL query gives you more control over the data you import, allowing you to select only the relevant information.

However, it is important to note that using the wildcard character (*) to import all columns within a table is not recommended. This can lead to redundant data in your data model, resulting in performance issues and the need for additional steps to normalize your data for reporting. It is always best to carefully select the specific columns you need to avoid unnecessary complications.

To summarize, when creating an infographic, it is crucial to choose the right size to ensure optimal readability and presentation. Following the guidelines provided by Edraw, you can determine the perfect width and height for your infographic. Additionally, when importing data from relational data sources, make sure to use the appropriate credentials and consider writing SQL queries to selectively import the required information.

In conclusion, by understanding the best practices for infographic sizing and data import, you can create visually appealing and informative infographics that effectively convey your message. Remember to keep the dimensions within the recommended ranges and be mindful of the data you import to maintain a clean and efficient data model. With these tips in mind, you are well-equipped to create compelling infographics that captivate your audience.

Actionable Advice:

1. Consider the platform and devices on which your infographic will be viewed before finalizing its size. This ensures optimal readability and user experience.
2. Always use specific credentials when accessing relational data sources to maintain data security and integrity.
3. When importing data, carefully select the columns you need and avoid using the wildcard character to prevent redundant data in your data model.