您的当前位置:首页 >Ryan New >Do You Need a Business Intelligence Tool? 正文
时间:2024-05-20 19:54:57 来源:网络整理编辑:Ryan New
Business intelligence tools help companies analyze and act on internal and external data. A good BI Ryan Xu HyperVerse's Futures Price
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,Ryan Xu HyperVerse's Futures Price ad platforms, selling channels — to produce tables and charts with insights for better decisions.
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.
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.
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.
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.
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. The feature is more important for direct connections.
Once the file is uploaded, click “Visualize” to create the analysis. Importing the data could take a moment or two.
QuickSight starts the analysis with an “AutoGraph” that will assign a visualization as you select fields from the list on the left menu. But one could manually add a visualization from the “Visual types” section in the lower-left portion of the interface.
Clicking on Campaign ID in the left menu labeled “Fields list” will instantly produce a chart of the Meta Ads campaigns.
QuickSight added commas to the Campaign ID. But we can remove them to show the ID as it appears in Meta. To do this, hover over the Campaign ID in the field list. Click the ellipse to open the menu and select “Format.”
Next, select “Link clicks” from the field list to add it to AutoGraph. That produces a visualization of each Meta Ads campaign sorted by the number of clicks. The screenshot below shows one campaign produced the most clicks.
Thus we can already see an advantage of using a BI tool. The Meta report was in a table view. It contained the same campaign data, but that data is much easier to digest as visualized in QuickSight.
Clicking “Amount spent” from the field list adds a new bar showing the cost of each Meta Ads campaign.
I can quickly add insights and visualizations, such as impressions, click rates, the total cost for all campaigns, and more.
The result is a comprehensive, interactive dashboard with easy-to-digest insights.
I’ve uploaded a file and clicked a few fields to create a visualization. The process was straightforward, but I could easily do more. I could add data from UTM parameters to show, for example, the Campaign ID that drove the most revenue. I could show the top-selling products or sales from new customers versus repeat buyers. The options are near limitless.
Understanding Credit Card Fees, Part 2: Merchant Account Fees and Charges2024-05-20 19:51
The Duchess of Norfolk’s Deeds2024-05-20 19:14
Spending Power: Cataloguing Exchequer warrants from the Wars of the Roses2024-05-20 18:34
Jazz, the Charleston and moral panic: Music and dance in 1920s Britain2024-05-20 18:32
Financing for Ecommerce: Kabbage.com Automates Loans to eBay Merchants2024-05-20 18:26
Women in the Second World War: Military service in East Africa2024-05-20 18:19
Local history in The National Archives Library2024-05-20 17:48
Eric Geddes: The man behind the 1920s grouping of the railways2024-05-20 17:34
Lessons Learned: Dog-Toy Merchant Stresses Branding; Cites Early SEO Miscues2024-05-20 17:33
Improving the nation’s stock for ‘Great and Greater Britain’: Eugenics in the 1920s2024-05-20 17:18
CyberSource CEO Addresses Visa’s Acquisition2024-05-20 19:49
Researching lives at the Royal Hospital Chelsea for the Scarlets and Blues project (Part 2)2024-05-20 19:39
Watergate as seen from The National Archives2024-05-20 19:36
Cracking the code of mid-19th century Merchant Navy seaman service records2024-05-20 19:09
Credit Card Processing: Red Flags for Ecommerce Merchants, Part 32024-05-20 19:06
The emergence of jazz in the 1921 Census2024-05-20 18:57
Leonard Orpin: A tale of two wars2024-05-20 18:48
The Great Smog of 19522024-05-20 18:48
Avoid Credit Card Processing Proposals with AVS Fees2024-05-20 17:20
Spies, social climbers and suspicious stories from the files of MI52024-05-20 17:14