We may earn an affiliate commission when you visit our partners.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/r6zr49/offloading
What's inside
Syllabus
Offloading Financial Mainframe Data into BigQuery and Elastic Search
Good to know
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
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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.
Review SQL Basics
Show steps
Review basic SQL syntax and concepts to prepare for data analysis tasks.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Review online or textbook materials on SQL basics.
- Practice writing simple SQL queries.
Financial Data Analysis Concepts
Show steps
Review fundamental concepts related to financial data analysis and interpretation.
Browse courses on
Financial Data Analysis
Show steps
Show steps
Show steps
- Review materials on financial data analysis techniques.
- Identify key metrics and indicators in financial statements.
Financial Data Resources Collection
Show steps
Compile a list of useful resources, including datasets, tools, and articles, related to financial data analysis.
Browse courses on
Financial Data
Show steps
Show steps
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
Show steps
Complete SQL queries in your own environment to reinforce understanding of data querying and analysis techniques.
Show steps
Show steps
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
Show steps
Follow an online tutorial to enhance your understanding of advanced BigQuery features for data analysis.
Browse courses on
BigQuery
Show steps
Show steps
Show steps
- Choose a tutorial on advanced BigQuery analysis.
- Follow the tutorial steps.
- Apply the techniques to your own dataset.
Elasticsearch Data Visualizations
Show steps
Create interactive data visualizations to gain insights from the financial records in Elasticsearch.
Browse courses on
Elasticsearch
Show steps
Show steps
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
Show steps
Develop a machine learning model to detect fraudulent financial activities in the imported dataset.
Show steps
Show steps
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/r6zr49/offloading
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.
Save
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.
Provides a gentle introduction to data science. It covers topics such as data cleaning, data analysis, and data visualization.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/r6zr49/offloading
Share
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 Cloud
OpenCourser.com/course/1swgue/configuring
Configuring and Deploying Windows SQL Server on Google...
Datadog: Getting started with the Helm Chart
OpenCourser.com/course/y1pssq/datadog
Datadog: Getting started with the Helm Chart
Analyzing Natality Data Using Vertex AI and BigQuery
OpenCourser.com/course/l85ljy/analyzing
Analyzing Natality Data Using Vertex AI and BigQuery
Building Demand Forecasting with BigQuery ML
OpenCourser.com/course/w95ifb/building
Building Demand Forecasting with BigQuery ML
The Electronics Workbench: a Setup Guide
OpenCourser.com/course/t1f3vb/the
The Electronics Workbench: a Setup Guide
Exploring the Public Cryptocurrency Datasets Available in BigQuery
OpenCourser.com/course/5rb6zv/exploring
Exploring the Public Cryptocurrency Datasets Available in...
Developing with Cloud Run
OpenCourser.com/course/p8a85r/developing
Developing with Cloud Run
Set Up and Configure a Cloud Environment in Google Cloud - Azure: Challenge Lab
OpenCourser.com/course/c8tj6b/set
Set Up and Configure a Cloud Environment in Google Cloud ...
Configure Palo Alto Firewalls in a Home Lab
OpenCourser.com/course/lgwfer/configure
Configure Palo Alto Firewalls in a Home Lab
Effort
60 minutes
Level
Introductory
Via
Coursera
Institution
Google Cloud
Instructor
Google Cloud Training
Language
English
Good to know
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
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