Do You Need a Business Intelligence Tool?

Business intelligence tools help companies analyze and act on internal and external data. A good BI tool can import data from multiple sources — ecommerce software, ad platforms, selling channels — to produce tables and charts with insights for better decisions. Meta Ads

To illustrate, I’ll export performance data from the Meta (Facebook) Ads Manager and then import it into QuickSight, an Amazon-owned BI tool, for analysis and visualization. Data from a Meta Ads report can also be exported and uploaded to a BI tool. The first step is to create an Ads Manager report containing the fields to import into the tool. For this example, I’ll build a report containing the Month, Campaign ID, Ad Set ID, Platform, and several metrics. Create a report in Meta Ads Manager containing the fields to import into the BI tool. AWS QuickSight

QuickSight is part of Amazon Web Services. Amazon built the tool to solve its own business intelligence and data visualization needs. Staff throughout the company reportedly now use the tool as do 100,000 external folks.

There are many BI tools . Popular options include Looker (part of Google Cloud), Tableau, and Sisense, although all tools are generally similar in concept.

Accessing QuickSight requires an account. Prices start at $24 per month plus utility-like usage charges. Customers of Amazon Web Services can add QuickSight easily. Add a New Dataset

QuickSight can connect to databases. Hence I could have accessed a Meta Ads API to add performance info to a database, such as Redshift or MySQL. Instead, I’ll upload the CSV file. QuickSight can connect to databases or receive a CSV file upload. It is worth mentioning that QuickSight can load data into server memory — using what it calls “Super-fast, Parallel, In-memory Calculation Engine” or SPICE — for fast data computations . […]

Click here to view original web page at

On y est presque!
À quelle adresse dois-je vous envoyer le Guide?