Observed Signal · Jun 10, 2022 · Technical Release · Source: CMSWire · Impact: 2/5 · Sentiment: Positive
Google Enhances Data Blending in Data Studio
Google has progressively improved data blending capabilities in its Data Studio analytics platform, providing analysts with more flexible options for combining data from diverse sources. The article details that in February 2022, Google expanded the data blend function to support multiple join types—including cross joins, inner joins, and right and full outer joins—beyond the previously available left outer join. It also highlights an updated data source selector that simplifies join configuration and lists 22 connectors for Google services such as Google Ads, Firebase, Google Analytics, and BigQuery, as well as newly released from beta connectors for Amazon Redshift and Microsoft SQL Server. Third-party vendors like Supermetrics offer additional connectors for platforms with APIs. While the feature abstracts query syntax, making inspection harder than with SQL, Data Studio provides a reliable centralized platform for creating visualizations from blended data.
Feature update to Google Data Studio enhancing data blending capabilities, relevant to marketing analysts but not industry-shifting.
Track Google Signals & Market Shifts in Real-Time
Polaris7 autonomous intelligence agents track regulatory filings, primary sources, executive changes, and deal flow 24/7. Create your free Explorer workspace to monitor these entities.
Key Takeaways & Evidence Grounding
- Google expanded Data Studio data blending to include cross join, inner join, right outer join, and full outer join, in addition to the default left outer join.
- The updated data source selector introduced more configuration options for join conditions.
- Google offers 22 connectors for its cloud services including Google Ads, Firebase, Google Analytics, and BigQuery.
- Amazon Redshift and Microsoft SQL Server connectors were released from beta in 2022.
- Third-party vendors such as Supermetrics have developed connectors for other data platforms where APIs are available.
Connected Companies & Entities
4 Entities mapped“Google has been refining Data Studio to provide better blending capability and more flexibility in combining data....”
“There are also connectors for other platforms such as Amazon Redshift and Microsoft SQL server, both of which were released from beta this y...”
“There are also connectors for other platforms such as Amazon Redshift and Microsoft SQL server, both of which were released from beta this y...”
“Third party vendors like Supermetrics have developed connectors for other data platforms where an API is available....”
Ontology Mapping & Concepts
Related Market Signals & Shifts
Recent verified developments and strategic activity across this market segment.
Microsoft Xbox creates new division for films, series, parks
Microsoft's Xbox gaming division announced the creation of a new business unit dedicated to films, television series, and theme park attractions. The move signals an expansion into entertainment and immersive experiences beyond video games, leveraging Xbox's intellectual property. This strategic diversification is part of Microsoft's broader ambition to grow its media and entertainment footprint, following trends seen across the industry. The new division will focus on developing and producing content based on Xbox franchises, potentially opening new revenue streams for the company. Financial details or a timeline for the division's operations have not been disclosed.
US Government Excludes Microsoft from Visa Program
The US government has barred Microsoft from participating in the permanent residency process for foreign workers with H-1B visas, accusing the company of abusing the program. Vice President JD Vance stated that Microsoft laid off 6,000 American employees last year while benefiting from 6,300 H-1B visa holders. The Department of Labor, led by Keith Sonderling, will not accept new permanent residency applications from Microsoft, as well as several consulting firms and Adobe. This action comes weeks before the midterm elections and reflects the Trump administration's broader criticism of the H-1B program, which it claims disadvantages American workers. Microsoft has not yet responded. The move could impact the tech industry's ability to retain skilled foreign talent.
Outlook to Block MSIX Files as Email Attachments
Microsoft has announced that Outlook will begin blocking MSIX file attachments, a move aimed at preventing malicious distribution through email. The change affects both the classic Outlook for Windows and the new Outlook for Windows, as well as other clients like Outlook on the web. Microsoft's decision comes in response to the increasing use of MSIX files in phishing and malware attacks. The block will be implemented in phases, starting with a controlled rollout and then expanding to all users. The company advises users to use alternative secured methods for sharing such files. This technical update is part of Microsoft's broader security enhancements for its email clients.
Track Real-Time Market Signals & Shifts
Set up custom watchlists to receive automated, evidence-grounded executive digests whenever material signals or shifts occur across your tracked landscape.