We may earn an affiliate commission when you visit our partners.
Course image
Google Cloud Training

This is a self-paced lab that takes place in the Google Cloud console. In this hands-on lab, you will import synthetic data* representing financial records offloaded from a bank’s mainframe.

Enroll now

What's inside

Syllabus

Offloading Financial Mainframe Data into BigQuery and Elastic Search

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Studies a domain-specific topic using theory and practice
Exploration of financial mainframe data is standard in the banking industry
Suitable for those with some experience in data analysis
Requires a foundational understanding of BigQuery and Elastic Search
May not be appropriate for beginners in data analysis

Save this course

Save Offloading Financial Mainframe Data into BigQuery and Elastic Search to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Offloading Financial Mainframe Data into BigQuery and Elastic Search with these activities:
Review SQL Basics
Review basic SQL syntax and concepts to prepare for data analysis tasks.
Browse courses on SQL
Show steps
  • Review online or textbook materials on SQL basics.
  • Practice writing simple SQL queries.
Financial Data Analysis Concepts
Review fundamental concepts related to financial data analysis and interpretation.
Browse courses on Financial Data Analysis
Show steps
  • Review materials on financial data analysis techniques.
  • Identify key metrics and indicators in financial statements.
Financial Data Resources Collection
Compile a list of useful resources, including datasets, tools, and articles, related to financial data analysis.
Browse courses on Financial Data
Show steps
  • Search for and identify relevant resources.
  • Organize resources into a structured document or website.
  • Share the compilation with other students or professionals.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Practice Queries
Complete SQL queries in your own environment to reinforce understanding of data querying and analysis techniques.
Show steps
  • Setup a local database environment.
  • Review basics of SQL.
  • Import the provided financial data.
  • Write queries to extract and analyze data.
BigQuery Advanced Analysis Tutorial
Follow an online tutorial to enhance your understanding of advanced BigQuery features for data analysis.
Browse courses on BigQuery
Show steps
  • Choose a tutorial on advanced BigQuery analysis.
  • Follow the tutorial steps.
  • Apply the techniques to your own dataset.
Elasticsearch Data Visualizations
Create interactive data visualizations to gain insights from the financial records in Elasticsearch.
Browse courses on Elasticsearch
Show steps
  • Review data visualization best practices.
  • Choose a visualization tool.
  • Connect to Elasticsearch and import data.
  • Design and create visualizations.
Financial Fraud Detection Model
Develop a machine learning model to detect fraudulent financial activities in the imported dataset.
Show steps
  • Review machine learning algorithms for fraud detection.
  • Choose a programming environment and tools.
  • Engineer features from the financial data.
  • Train and evaluate the model using supervised learning.

Career center

Learners who complete Offloading Financial Mainframe Data into BigQuery and Elastic Search will develop knowledge and skills that may be useful to these careers:
Data Analyst
Data Analysts design and build data collection and analysis systems to help businesses make informed decisions. This course can give you the skills you need to succeed as a Data Analyst by showing you how to use BigQuery and Elastic Search to manage and analyze data. These skills will provide a foundation for jobs that require expertise in data analysis and interpretation.
Data Engineer
Data Engineers build and maintain the infrastructure that stores and processes data for businesses. This course can help teach you how to use BigQuery and Elastic Search to set up and manage data systems as a Data Engineer.
Data Scientist
Data Scientists use data to solve business problems and develop new products and services. This course can give you the skills you need to succeed as a Data Scientist by showing you how to use BigQuery and Elastic Search to analyze data and extract insights.
Cloud Architect
Cloud Architects design and build cloud infrastructure for businesses. This course will help teach you how to use BigQuery and Elastic Search to manage data in the cloud for this role.
Software Developer
Software Developers design, build, and maintain software applications for businesses. This course may help you build a foundation for this role by teaching you how to manage data using BigQuery and Elastic Search.
Business Analyst
Business Analysts help businesses understand their data and make informed decisions. This course may help you develop the data analysis skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.
Database Administrator
Database Administrators manage and maintain databases for businesses. This course may help teach you how to use BigQuery and Elastic Search to manage data as a Database Administrator.
Information Security Analyst
Information Security Analysts help businesses protect their data from unauthorized access and use. This course may help you develop skills relevant to this role by teaching you how to manage and analyze data using BigQuery and Elastic Search.
Big Data Engineer
Big Data Engineers design and build systems to manage and analyze large datasets. This course may help you develop the skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.
Data Visualization Analyst
Data Visualization Analysts help businesses visualize and interpret data. This course may help you develop the skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.
Data Mining Engineer
Data Mining Engineers design and build systems to extract insights from data for businesses. This course may help you develop the skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.
Financial Analyst
Financial Analysts help businesses make financial decisions. This course may help you develop the data analysis skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze financial data.
Machine Learning Engineer
Machine Learning Engineers design and build machine learning models for businesses. This course may help you develop the skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.
Data Warehouse Engineer
Data Warehouse Engineers design and build data warehouses for businesses. This course may help you develop the skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.
Software Test Engineer
Software Test Engineers test software applications for businesses. This course may help you develop the skills needed for this role by teaching you how to use BigQuery and Elastic Search to manage and analyze data.

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Offloading Financial Mainframe Data into BigQuery and Elastic Search.
Provides a practical guide to using Google Cloud Platform for big data analytics. It covers topics such as data engineering, data science, and machine learning.
Provides a comprehensive overview of Elasticsearch, an open-source search and analytics engine. It covers topics such as Elasticsearch installation, configuration, and querying.
Gives a good introduction to machine learning, a key area in data science. It covers topics such as machine learning algorithms, data preprocessing, and model evaluation. This can be used as a supplement for the course.
This comprehensive guide to Hadoop, a popular framework used for distributed computing and big data processing. It covers topics such as Hadoop installation, configuration, and administration.
Provides a gentle introduction to deep learning, a subfield of machine learning that has gained popularity in recent years. It covers topics such as neural networks, deep learning architectures, and deep learning applications.
Provides a practical overview of cloud computing. It covers topics such as cloud architecture, cloud services, and cloud security.
Provides an introduction to natural language processing, a subfield of AI that deals with the interaction between computers and human (natural) languages. It covers topics such as text analysis, sentiment analysis, and machine translation.
Provides a practical guide to data science. It covers topics such as data exploration, data modeling, and data visualization. It also provides hands-on examples using popular data science tools.
Provides an introduction to computer vision, a subfield of AI that deals with the interaction between computers and images. It covers topics such as image processing, object recognition, and facial recognition.
Can serve as a reference to the course. It comprehensively discusses data warehousing and how it is used to store and manage large amounts of data. It also covers data warehouse design, implementation, and maintenance.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Offloading Financial Mainframe Data into BigQuery and Elastic Search.
Configuring and Deploying Windows SQL Server on Google...
Datadog: Getting started with the Helm Chart
Analyzing Natality Data Using Vertex AI and BigQuery
Building Demand Forecasting with BigQuery ML
The Electronics Workbench: a Setup Guide
Exploring the Public Cryptocurrency Datasets Available in...
Developing with Cloud Run
Set Up and Configure a Cloud Environment in Google Cloud ...
Configure Palo Alto Firewalls in a Home Lab
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser