#VirginMediaO2

[govindhtech]

With BigQuery Analytics Hub, Virgin Media O2 Data Sharing

How BigQuery Analytics Hub streamlined internal data exchange for Virgin Media O2

Data sharing made simple is now a vital tool for any company looking to make well-informed decisions. Nevertheless, a lot of businesses still find it difficult to share data in an efficient and legal manner. Uncertain governance, version control problems, data silos, access limitations, and a lack of data management expertise within the larger organization are common obstacles that data teams must overcome.

Virgin Media O2, a media and telecoms company, uses internal data sharing to drive strategy, enhance operations, and give decision makers more authority. The data team supports every department for timely and reliable information, from marketing to finance.

Virgin Media O2 required a system that would facilitate governance and data access amongst business units. Without it, it wouldn’t be able to achieve org-level visibility and efficiency and would be stuck without a centralized data-sharing method.

Overcoming obstacles to internal data-sharing

Strong version control was necessary to guarantee that the data was always correct, consistent, and up to date because teams were already working on Google Cloud-based projects. However, this frequently prolonged the time it required to generate new insights. In order to meet their enterprise and AI needs, Virgin Media O2 already had their corporate data in BigQuery. Therefore, one possible way to build on their current infrastructure was to use Analytics Hub, which is BigQuery’s data sharing feature.Image credit to Google Cloud

After learning about BigQuery Analytics Hub‘s scalability, self-service capabilities, and straightforward governance mechanism for data tagging and quality, the data platform team made the decision to trial the product. This final aspect, in particular, was in line with enhancing the implementation of privacy by design.

Following a successful trial, Virgin Media O2 had developed a well-defined onboarding and training procedure. Two owners were assigned to each new data exchange, and two owners were assigned to the subscriber side to facilitate the tracking of any actions within BigQuery. This method was expanded to 25 teams, over 50 exchanges, 100 postings, 500 tables, and around 300 daily customers over the course of the following nine months.

The absence of data duplication in BigQuery Analytics Hub saves on network and storage expenses, which is one of the main advantages the team discovered. It accomplishes this by generating a shareable real-time pointer to the underlying dataset, referred to as a Linked Dataset. As a result, any subscriber can access updated data instantly and it’s simple to audit, trace, and restore the original data source. By using this method, a safety net for catastrophe recovery is also included.

The complexity issues associated with building views are also resolved by BigQuery Analytics Hub, notably the fact that permitted views frequently cause original table metadata to be lost when accessing data. All table descriptions and columns are still visible to subscribers who have direct access to the original dataset.

Virgin Media O2 was able to save time, lower latency, and improve management and usability for publishers and subscribers by connecting data directly from the data publisher to a data subscriber. Additionally, the platform’s enhanced governance offered a centralized location for managing data access and quality.

BigQuery Analytics Hub minimizes human labor and mistakes by streamlining the data sharing process between teams and business divisions. Within Virgin Media O2, the platform has been especially helpful to software developers, analytics engineers, data scientists, data engineers, and analysts. It guarantees that everyone has instant access to the data they require for their different jobs.

Using data that is more readily available than ever to save time

The solution helped save up to 30 hours a week on time spent on training, support, pipelines difficulties with deployment, and communication overhead from squads using the old approach after BigQuery Analytics Hub was rolled out to about 25 squads. Due to the nearly nonexistent problems, the weekly time spent by all teams is now as little as thirty minutes. According to the team, this results in an effort savings of about 95%. Data is now widely accessible to the various departments that require it, as it is no longer stored in silos.

Without requiring users to use BigQuery Analytics Hub directly, the team was able to democratize data access for subscribers and their larger teams by creating a dashboard. While retaining a robust governance approach, self-service is made possible by allowing users to subscribe to datasets. Cutting out the intermediary simplifies and expedites this tedious procedure while preserving a strong governance framework.

Principal advantages of secure data exchange

Security and Integrity of Data

By guarding against metadata loss and unwanted access, secure, zero-copy sharing guarantees consistent data integrity across departments.

Economy of Cost and Streamlined Administration

The platform lowers operational overhead and long-term costs by doing away with data transfer, and data oversight may be efficiently handled by a small workforce.

Centralized Administration and Observation

Real-time control over data sharing operations is made possible by a single dashboard, which also enforces stringent access and authorization regulations and enables prompt issue detection.

The group’s future priorities include streamlining four important areas: data ownership, data catalog, data quality measurements, and more efficient sensitive data tagging. After data is certified, these four areas need to be precisely specified and strictly adhered to as a policy via BigQuery Analytics Hub in order to achieve the goal of automating the complete data activity.Image credit to Google Cloud

The aforementioned procedure, referred to as “data certification,” has two main advantages:

By utilizing data quality measurements (at the column level) and data lineage, it is possible to quickly identify uncertified data assets and track out problems with the quality of the data in a matter of minutes.

Real-time audit logs that allow for the proactive control of data privacy issues by identifying sensitive data in real-time and tracking its consumption.

BigQuery is the best place for users who are new to Google Cloud to begin their adventure. After BigQuery, Analytics Hub is the next best thing for users.

Read more on Govindhtech.com

[goldiers1]

Rural Scots Reap Benefits of Mobile Phone Network Collaboration

  Virgin Media O2 and Vodafone have expanded their 4G networks to two rural Scottish communities, Traquair (Peeblesshire) and Balmacara (Ross-shire), as part of a collaboration between the Scottish Government’s Scottish 4G Infill Programme (S4GI) and UK Government’s Shared Rural Network (SRN). The mobile phone coverage in Traquair and Balmacara has increased significantly with the completion of upgrade works, installation of a new mast at Balmacara, and introduction of Virgin Media O2 & Vodafone 4G network equipment. Residents as well businesses can now benefit from better connection services while enjoying greater choice when it comes to providers. This is part of the Shared Rural Network (SRN) programme that was created by industry players such as Ofcom UK Government with an aim to fund existing masts or build new ones for improved signal reception across rural areas. The masts at Traquair and Balmacara follow upgrades at other sites such as New Luce (Dumfries and Galloway) and Ettrick (Scottish Borders), where both Virgin Media O2 and Vodafone have recently boosted coverage in partnership with the Scottish Government. The Government’s S4GI programme is delivered in partnership with WHP Telecoms and Scottish Futures Trust, and is part-funded by the European Regional Development Fund (ERDF).  

Appointment of Ministers. Photo by Scottish Government. Flickr.   Business Minister Ivan McKee MSP said:  “This is great news and will be welcomed by the local communities. Our successful S4GI programme continues to deliver life-changing mobile connectivity to 55 rural and island communities that wouldn’t otherwise get access to this vital service. “Thanks to the infrastructure deployed by our S4GI programme, Vodafone and Virgin Media O2 are now able to provide improved connectivity to local residents, businesses and visitors in these communities, enhancing the way they work, communicate and access public services.”   Jeanie York, Chief Technology Officer at Virgin Media O2, said: “We’re committed to investing in our network and providing seamless connectivity for all our customers across the UK. By working closely with industry partners and across government, we are delivering upgrades that will significantly improve 4G networks in rural communities, providing local people and businesses with faster and more reliable coverage than ever before, while also delivering benefits for the local economy and tourism.”   Andrea Dona, Vodafone’s UK Network and Development Director, said: “We remain committed to improving rural connectivity across Scotland. Vodafone played a leading role in the conception of the Scottish 4G Infill Programme when it was the first to go live with 4G at the New Luce site and that, alongside the Shared Rural Network programme is ensuring that we can now bring connectivity to the remotest parts of Scotland – connecting places for the first time and offering communities a wider choice of networks." “We’re looking forward to announcing more locations going live as part of the programme in the future.”   Sources: Vodafone & THX News. Read the full article

[mobilephonetechnology]

(2024-04-25 image ©virginmediao2.co.uk) Some of the masts in the Uk are jointly owned by a company -Cornerstone - that is jointly owned by O2 and Vodafone. There is another company that owns masts shared between EE and Three. Thus the impending merger of Vodafone and Three has some operational issues. It can be argued that the new Vodafone/Three mobile operator will have an unfair advantage over the others EE / O2 having access to both of the mobile mast operations. One ideal solution (ideal for the customer) would be for the operators to agree that each of them could use each other's masts this improving 4G coverage over the UK.

However the story today is that VM-O2 are looking to sell half of their half share of Cornerstone. they will use the money to fund their 5G rollout whilst renting space on the cornerstone masts. Again if all of the industry took this approach, it could lead to a single 4G network from which the Mobile Operators could rent space this making the prospect of universal 100% 4G coverage a step nearer.

[mobilephonetechnology]

(1-5-22 image ©capacitymedia.com) After the furrowy of the Huawei involvement in the 5G network and their subsequent banning in the UK, we were left with 2 suppliers Nokia and Ericsson. Many feared the effect that this duopoly would have on the 5G network and the operators have been looking at other options most notibly in ORAN deployment.

Vodafone have been working with Samsung in their large ORAN deployment in the South West. Now VirginMediaO2 have announced they have been working with Samsung in some of their installations in the UK. One issue with Samsung is that their equipment works with 4G & 5G networks and not the legacy networks that VMO2 must still support, at least for the next few years.