Business Analyst to Data Analyst

ABOUT THE PROGRAM

Talend data integration provides an easy way to get integration projects done quickly and with less overhead. It has several tools that make it a powerful, cost-effective suite.

Data management/predictive analytics uses techniques, such as statistics and machine learning, to build predictive models, often using big data to test and validate these models. It is becoming a key component for organizational success.

Data warehousing is the secure electronic storage of information by a business or other organization. The warehouse becomes a library of historical data that can be retrieved and analyzed in order to inform decision-making in the business.

Teradata provides a relation database system for data storage that offers various tools and utilities for management, administration, and querying. It offers a high quality system including a parallel database architecture providing a “share nothing” architecture.

Occupational Objectives: Data Integration Analyst, Data Miner, Data Warehousing Business Analyst, Data Warehousing Developer

Prerequisites: HS Diploma/GED, basic PC skills and familiarity with the Internet

Tuition: $997

Duration: 36 Hours

Students will have access to the program for 1 full year.

This program includes e-books.

To learn more about ETI’s tuition and financial aid options, click here.

COURSE Outline

    • Getting Started

    • Working with Charts and Sparklines

    • Using Formatting, Styles, and Themes

    • Linking, Printing, and Protecting Workbooks

    • Validating, Cleaning, and Performing Lookups on Data

    • What-if Analysis, Solver, and Analysis ToolPak

    • Pivot, PowerPivot, and Financial Modeling

    • LAB: Business Analyst

    • FINAL EXAM: Business Analyst

    • Tableau for Data Visualization: Introduction

    • Tableau for Data Visualization: Exploring Visualizations and Data Formats

    • Tableau for Data Visualization: Advanced Features

    • Business Reporting: Getting Started with Power BI Desktop for Data Analysis

    • Business Reporting: Visualizing and Merging Data in Power BI

    • Business Reporting: Creating and Formatting Matrix Visualizations in Power BI

    • Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI

    • LAB: Decision Analyst

    • FINAL EXAM: Decision Analyst

    • Google Chart Tools: Basic Charts

    • Google Chart Tools: Interacting with Charts

    • Google Chart Tools: Advanced Visuals with Charts

    • Plotly for Data Visualization: an Introduction to Plotly Chart Studio

    • Plotly for Data Visualization: Exploring Chart Studio Visualization

    • Plotly for Data Visualization: Advanced Charts and Features in Chart Studio

    • SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis

    • SQL Programming with MariaDB: Analyzing Relational Data

    • SQL Programming with MariaDB: Using Joins, Triggers, and Stored Procedures

    • LAB: Systems Analyst

    • FINAL EXAM: Systems Analyst

    • VBA: Getting Started with VBA in Excel

    • VBA: Building User Interfaces with Forms in VBA and Excel

    • VBA: Leveraging VBA to Work with Charts, Stocks, and MS Access

    • Using BigML: an Introduction to Machine Learning and BigML

    • Using BigML: Getting Hands-on with BigML

    • Using BigML: Building Supervised Learning Models

    • Using BigML: Unsupervised Learning

    • Analyzing Data Using Python: Data Analytics Using Pandas

    • Analyzing Data Using Python: Importing, Exporting, and Analyzing Data with

    • Pandas

    • Analyzing Data Using Python: Filtering Data in Pandas

    • Analyzing Data Using Python: Cleaning and Analyzing Data in Pandas

    • LAB: Data Analyst

    • FINAL EXAM: Data Analyst