Google Data Studio

The most impactful features of DataStudio are the wide range of visualizations you have access to in order to present your data in the most engaging and insightful way. Coupled with the wide range of data connectors that are available natively and also third-party connectors, which expands the scope widely.
Once you have understood the overall way of working, the tool is very easy to use. There are lots of training videos available and lots of support available over the internet, in case you get stuck.
Integration into my business practises was easy because of the flexibility in data input sources. If a specific connector does not exist, then you can always fall back on file imports.

The most important missing feature for me personally is a native (free) data connector to Facebook Ads. One has free access to all the Google platforms and I have a constant struggle to get a decent data connector to Facebook ad platform data.
One improvement that I suggest is to add the functionality to do processing on calculated fields to do for instance 7-day moving average calculations on the platform itself. Now I have to do those calculations on a Google Sheet first and then import the results into the DataStudo reports. Or even make that a built-in function?

Google Data Studio provides a great option for creating dashboards that present your basic data, particularly if that data resides in a Google tool (Analytics, Analytics360, even Google Sheets, etc.) The learning curve for this tool is not extensive before you are ready to build dashboards and reports. The template library is useful to learn what ways you can style your data.

With any data tool there is a learning curve, and the documentation provided by Google is not extensive. Fortunately there is a large offering of YouTube user generated content that covers almost every possible question you may have to get the desired result out of the platform, making it one of easiest Data Visualization tools to learn and get current information.

It seems that every third party SaaS that collects data online has native synchronization support for Google sheets. And this is how Google Data Studio makes itself the best option for non profits and small businesses in need of automated business intelligence.

On top of the plug'n'play integration experience, data studio has a unique approach to interactive chart and dashboard design that lets you position elements as if you were working in Adobe Photoshop. You can add shapes, layer elements on top of each other, add text or objects anywhere. This means you can produce the most beautiful and intuitive dashboards and reports ever (or the least if you're more of a Picasso).

It really is the poor man's business intelligence automation tool. Some key setbacks for data scientists is that data studio can only do 1 type of join/blend (outter left) and when using blended data to create calculated fields it really feel more like art than science, and not always working out. There is also no way to create unions across all data sources or make a file directory a data source.

All this means that you really need to do a lot of data prep in Google sheets and find a way to do some automatic data blending in Google sheets as well in some cases. This will keep the complexity of your needs in Data Studio minimal, which seems to work best.

Easy to use: Google Data Studio has a user-friendly interface that makes it easy for even non-technical users to create professional-looking reports and dashboards.Integrations: Google Data Studio integrates seamlessly with other Google products, such as Google Sheets, Google Analytics, and Google Ads, making it easy to pull in data from multiple sources.Customization: Google Data Studio allows users to customize their reports and dashboards with a wide range of visualizations, such as charts, maps, and tables.Collaboration: Google Data Studio has built-in collaboration tools, allowing multiple users to work on the same report or dashboard at the same time.Sharing: Google Data Studio allows users to easily share their reports and dashboards with others, either by embedding them in a website or sharing a link.

Limited data sources: While Google Data Studio integrates with many popular data sources, it doesn't have as many integrations as some other business intelligence tools.Limited customizability: While Google Data Studio allows users to customize their reports and dashboards to a certain extent, it doesn't offer as much customization as some other tools.Lack of advanced features: Google Data Studio doesn't have as many advanced features as some other business intelligence tools, such as predictive analytics or machine learning capabilities.Dependence on Google products: To fully utilize Google Data Studio, users may need to rely on other Google products, such as Google Sheets or Google Analytics, which may not be suitable for all organizations.Limited support: While Google Data Studio has a large user community and extensive documentation, it may not offer as much support as some other business intelligence tools.