Data Analyst Bootcamp - In collaboration with IBM

Data Analyst Bootcamp

In collaboration with IBM

This Data Analyst Bootcamp, in collaboration with IBM, will transform you into a data analytics expert. In this course, you will learn the latest analytics tools and techniques, how to work with SQL databases, the languages of R and Python, the art of creating data visualizations, and how to apply statistics and predictive analytics in a business environment.

Key Features

• Course and material are in English
• 11 months long live online bootcamp and eLearning (self-paced) can be done faster!
• 1 year access to learning platform & classroom recordings
• Exclusive hackathons and live interaction with IBM leadership
• Live masterclasses and Ask Me Anything sessions from IBM experts
• 8X higher live interaction with live online classes by industry experts
• Capstone and 20+ real-life projects built on data sets from different industries such as Banking, eCommerce, Technology, and Manufacturing
• Top-notch curriculum with integrated labs

Course Content

• Business Analytics with Excel
• SQL Training
• Programming Basics and Data Analytics with Python
• R-Programming for Data Science
• Data Analytics with R
• Tableau Training
• Data Analyst Capstone
• Power BI (Elective course)

Program Outcomes

• Understand essential statistical concepts, including measures of central tendency, dispersion, correlation, and regression.
• Master SQL concepts such as Universal Query Tool and SQL command
• Write your first Python program by implementing concepts of variables, strings, functions, loops, and conditions.
• Understand the nuances of lists, sets, dictionaries, conditions and branching, objects, and classes in Python.
• Work with data in Python, including reading and writing files, loading, working, and saving data with Pandas.
• Learn how to interpret data in Python using multi-dimensional arrays in NumPy, manipulate DataFrames in Pandas, use SciPy library of mathematical routines, and execute machine learning using Scikit-Learn.
• Perform data analytics using popular Python libraries.
• Gain insights on several data visualization libraries in Python, including Matplotlib, Seaborn, and Folium.
• Gain an in-depth understanding of the basics of R, learning how to write your own R scripts.
• Master R programming and understand how various statements are executed in R.

Target Audience

A career as a data analyst requires a foundation in statistics and mathematics. Aspiring professionals of any educational background with an analytical frame of mind are best suited to pursue the Data Analyst Master’s Program, including:

• IT professionals
• Banking and finance professionals
• Marketing managers
• Supply chain network managers
• Beginners in the data engineering domain
• Students in UG/ PG programs

Prerequisites: A career as a data analyst requires a foundation in statistics and mathematics. Aspiring professionals of any educational background with an analytical frame of mind are best suited to pursue the Data Analyst Bootcamp

Learning Path

1. Business Analytics with Excel

Business Analytics with Excel training will boost your analytics career with powerful new Microsoft Excel skills. This business analytics training course will equip you with the concepts and hard skills required for a strong analytics career. You’ll learn the basic concepts of data analysis and statistics, helping promote data-driven decision making. Your new knowledge of this commonly used tool combined with official business analytics certification is guaranteed to ensure career success.

Key Learning Objectives

• Understand the meaning of business analytics and its importance in the industry
• Grasp the fundamentals of Excel analytics functions and conditional formatting
• Learn how to analyze with complex datasets using pivot tables and slicers
• Solve stochastic and deterministic analytical problems using tools like scenario manager, solver, and goal seek
• Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA, and regression to data sets using Excel
• Represent your findings using charts and dashboards
• Get introduced to the latest Microsoft analytic and visualization tools, such as Power BI

Course Curriculum

• Lesson 1- Introduction to Business Analytics
• Lesson 2- Conditional Formatting and Important Functions
• Lesson 3- Analysing Data with Pivot Tables
• Lesson 4- Dashboarding
• Lesson 5- Business Analytics with Excel
• Lesson 6- Data Analysis Using Statistics
• Lesson 7- Power BI

2. SQL Training

This course gives you the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn the concepts of fundamental SQL statements, conditional statements, commands, joins, subqueries, and various functions to manage your SQL database for scalable growth.

Key Learning Objectives

• Understand databases and relationships
• Use common query tools and work with SQL commands
• Understand transactions, creating tables, and views
• Comprehend and execute stored procedures

Course Curriculum

• Lesson 1 - Fundamental SQL Statements
• Lesson 2 - Restore and Back-up
• Lesson 3 - Selection Commands: Filtering
• Lesson 4 - Selection Commands: Ordering
• Lesson 5 - Alias
• Lesson 6 - Aggregate Commands
• Lesson 7 - Group By Commands
• Lesson 8 - Conditional Statement
• Lesson 9 - Joins
• Lesson 10 - Subqueries
• Lesson 11 - Views and Index
• Lesson 12 - String Functions
• Lesson 13 - Mathematical Functions
• Lesson 14 - Date and Time Functions
• Lesson 15 - Pattern (String) Matching
• Lesson 16 - User Access Control Functions

3. Programming Basics and Data Analytics with Python

Learn how to analyze data in Python using multi-dimensional arrays in NumPy, manipulate DataFrames in Pandas, use the SciPy library of mathematical routines, and perform machine learning using sci-kit-learn. This course will take you from the basics of Python to the many different data types. You will learn how to prepare data for analysis, perform simple statistical analyses, create meaningful data visualizations, predict future trends from data, and more.

Key Learning Objectives

• Import data sets
• Clean and prepare data for analysis
• Manipulate Pandas DataFrame
• Summarize data
• Build machine learning models using sci-kit-learn
• Build data pipelines

Course Curriculum

• Lesson 1 -Course Introduction
• Lesson 2 -Python Environment Setup and Essentials
• Lesson 3 -Python Programming Fundamentals
• Lesson 4 -Data Analytics Overview
• Lesson 5 - Statistical Computing
• Lesson 6 -Mathematical Computing using NumPy
• Lesson 7 -Data Manipulation with Pandas
• Lesson 8 -Data visualization with Python
• Lesson 9 - Intro to Model Building

4. R-Programming for Data Science

Gain insight into the R Programming language with this introductory course. An essential programming language for data analysis, R Programming is a fundamental key to becoming a successful Data Science professional. In this course, you will learn how to write R code, learn about data structures in R, and create your own functions. After completion of this course, you will be fully able to begin your first data analysis journey.

Key Learning Objectives

• Learn about key mathematical concepts, variables, strings, vectors, factors, and vector operations
• Gain fundamental knowledge on arrays and matrices, lists, and dataframes
• Get an understanding of conditions and loops, functions in R, objects, classes, and debugging
• Learn how to accurately read text, CSV and Excel files, and how to write and save data objects in R to a file
• Understand and work on strings and dates in R

Topics Covered

• Lesson 01 - R Basics
• Lesson 02 - Data Structures in R
• Lesson 03 - R Programming Fundamentals
• Lesson 04 - Working with Data in R
• Lesson 05 - Stings and Dates in R

5. Data Analytics with R

The next step to becoming a Data Scientist is learning R—the most indemand open source technology. R is a powerful Data Science and analytics language, which has a steep learning curve and a very vibrant community. This is why it is quickly becoming the technology of choice for organizations who are adopting the power of analytics for competitive advantage.

Key Learning Objectives

• Gain a foundational understanding of business analytics
• Install R, R-studio and workspace setup, and learn about the various R packages
• Master R programming and understand how various statements are executed in R
• Gain an in-depth understanding of data structure used in R and learn how to import/export data in R
• Define, understand, and use the various apply functions and DPLYR functions
• Understand and use the various graphics in R for data visualization
• Gain a basic understanding of various statistical concepts
• Understand and use hypothesis testing method to drive business decisions
• Understand and use linear and non-linear regression models, and classification techniques for data analysis
• Learn and use the various association rules and Apriori algorithm
• Learn and use clustering methods including K-Means, DBSCAN, and hierarchical clustering

Course Curriculum

• Lesson 01 - Introduction to Data Analytics
• Lesson 02 - Introduction to R Programming
• Lesson 03 - Programming Fundamentals of R
• Lesson 04 - Data Manipulation using R
• Lesson 05 - Data Visualization in R
• Lesson 06 - Hypothesis Testing
• Lesson 07 - Introduction to Machine Learning
• Lesson 08 - Classification
• Lesson 09 - Clustering
• Lesson 10 - Association Mining

6. Tableau Training

This Tableau course helps you understand how to build visualizations, organize data, and design charts and dashboards to empower more meaningful business decisions. You’ll be exposed to the concepts of Data Visualization, different combo charts, and stories, working with filters, parameters, and sets, and building interactive dashboards.

Key Learning Objectives

• Become an expert on visualization techniques such as heat maps, treemaps, waterfall, Pareto
• Understand metadata and its usage
• Work with Filters, Parameters, and Sets
• Master special field types and Tableau-generated fields and the process of creating and using parameters
• Learn how to build charts, interactive dashboards, and story interfaces, and how to share your work Master the concepts of data blending, creating data extracts, and organizing and formatting data
• Master arithmetic, logical, table, and LOD calculations

Course Curriculum

• Lesson 01 - Getting Started with Tableau
• Lesson 02 - Core Tableau in Topics
• Lesson 03 - Creating Charts in Tableau
• Lesson 04 - Working with Metadata
• Lesson 05 - Filters in Tableau
• Lesson 06 - Applying Analytics to the worksheet
• Lesson 07 - Dashboard in Tableau
• Lesson 08 - Modifications to Data Connections
• Lesson 09 - Introduction to Level of Details in Tableau (LODS)

7. Data Analyst Capstone

This Data Analyst Capstone project will give you an opportunity to implement the skills you learned throughout this program. Through dedicated mentoring sessions, you’ll learn how to solve a real-world, industry-aligned data science problem, from data processing and model building to reporting your business results and insights. This project is the final step in the learning path and will enable you to showcase your expertise in data analytics to future employers.

Elective

Power BI

Microsoft Power BI is a suite of tools used to analyze data and extract business insights by building interactive dashboards. This Power BI Training course will help you get the most out of Power BI, enabling you to solve business problems and improve operations. This Power BI Training course will help you master the development of dashboards from published reports, discover greater insight from your data with Quick Insights, and learn practical recipes for the various tasks that you can perform with Microsoft Power BI—from gathering data to analyzing it. This course also contains some handy recipes for troubleshooting various issues in Power BI.

Key Learning Objectives

• Create dashboards from published reports
• Quickly generate visuals and dashboards with Quick Insights
• Use natural language in the Q&A feature to generate visuals for actionable insight
• Create and manage data alerts
• Get report layout and data visualization best practices
• Understand which charts/graphs to use depending on the question being answered or the story being told
• Use shapes to design, emphasize, and tell a story
• See how to incorporate custom visuals into your reports and dashboards
• Share reports and dashboards, including the pros and cons of each
• Complete a Power BI data analysis/visual project from start to finish
• Improve team collaboration with Microsoft Teams
• Know how to retrieve and prepare your data for analysis and visualization
• Learn how to create relationships between tables in your data model
• Create calculated columns and measures using the DAX language

Course Curriculum

• Lesson 01 - Get and prep like a Super-Nerd
• Lesson 02 - Develop Your Data-Nerd Prowess
• Lesson 3 - Generate Reports and Dashboards
• Lesson 4 - Tips & Tricks

Program Projects

Project 1: App Rating Recommendations

The Google Play Store team is launching a new feature that boosts the visibility of certain promising apps. This boost will manifest in multiple ways, including higher priority placement in recommendations sections. Make a model to predict the app’s rating, while providing other information about the app.

Project 2: Comcast Telecom Customer Complaints

Comcast is an American global telecommunication company. The firm has been providing terrible customer service and they continue to fall short despite repeated promises of improvement. Utilize the existing database of customer complaints as a repository to improve customer satisfaction.

Project 3: E-commerce Sales Dashboard

An online ecommerce company wants to design a sales dashboard to analyze sales based on various product categories. The company wants to make it easier for users to select the products they are looking for and consequently generate more sales. Help users select and review information about the products they are considering.

Project 4: Comparative Study of Countries

Create a dashboard to do a comparative study of different countries on various parameters using the sample insurance data set and world development indicators data set.

Project 5: Sales Performance Analysis

Build a dashboard that shows monthly sales performance by the product segment and product category to help clients identify the segments and categories that have met, exceeded, or failed their sales targets.

Project 6: Analysis of Sales Report of a Clothes Manufacturing Outlet

A high-end fashion retail store is looking to expand its product line. It wants to understand the market and find the current trends in the industry. Automate the recommendations for attributes of the products, predict sales trends, understand the factors of sales, and regularize the rating procedure of the product with the given data sets.

Project 7: College Admission

Every year, thousands of applications are submitted by international students for admission to colleges in the U.S. It becomes an iterative task for the U.S. Department of Education to know the total number of applications received and then compare that data with the total number of applications successfully accepted and visas processed. To make the entire process easy, the U.S. Department of Education is looking to analyze the factors that influence the admission of a student into colleges.

Project 8: Identifying and Recommending Best Restaurants

A restaurant consolidator is looking to revamp their B2C portal using intelligent automation technology. This requires creating two different matrices to identify “high-star” restaurants and generate recommendations. To create an effective model, it is critical to understand the behavior of the consumers who are generating the data. You are required to create reports on the top-rated restaurants, generate recommendations by inspecting data and utilizing exploratory data analysis, and share your findings with all stakeholders through intuitive dashboards.

Project 9: Predicting Loan Defaulters

Financial institutions incur significant losses due to the defaults on vehicle loans. This has led to the tightening up of vehicle loan underwriting and increased loan rejection rates. The need for a better credit risk scoring model among these institutions is evident. This warrants a study to estimate the determinants of vehicle loan defaults. Determine and examine factors that affect the ratio of vehicle loan defaults. Also, use the findings to create a model to predict potential defaults on agreements.

Project 10: Examining Factors Responsible for Heart Attacks

Cardiovascular diseases are one of the leading causes of death globally. To identify the causes and develop a system to predict potential heart attacks in an effective manner is critical. The data presented has all the information about relevant factors that might have an impact on cardiovascular health. The data needs to be studied in detail for further analysis. Determine and examine the factors that play a significant role in increasing the rate of heart attacks. Also, use the findings to create and predict a model.

QUESTIONS AND ANSWERS

What is data analytics?

Data analytics is a process of inspecting, cleaning, transforming and modeling data to discover useful information that helps businesses make accurate decisions. Data analysis is done with different methods like qualitative and quantitative methods using analytical or statistical tools. They help to extract useful information from data and translate them into insights. AVC's Data Analyst course covers all these aspects and gives you a comprehensive understanding of the field, including its practical applications

What does a data analyst do?

Data analysts play a unique role among the top data-centric jobs available today. A data analyst typically works on data mining, collecting and interpreting data, analyzing data outcomes, and using statistical tools to arrive at insights that are crucial for an informed business decision. The main responsibilities of a certified data analyst include cleaning and organizing data, performing complex calculations and ensuring data integrity at all times. They analyze data and translate it into concrete insights that can be applied to various business use cases, including improving operational efficiency, business performance, and much more.

Why enroll in the AVC Data Analyst Bootcamp?

Organizations generate and rely on extremely large amounts of data for decision-making and strategizing. There is a growing demand for professionals who can make sense of this data and help businesses make sound decisions; and this is where data analytics comes in.

AVC's Data Analyst course teaches in-demand skills in the areas of data collection, analysis, and visualization, three critical and highly sought-after job areas today. The course provides hands-on experience with tools such as Excel, SQL, Python, and Tableau, helping you interpret complex datasets and generate actionable insights.

The structured curriculum provided by this Data Analyst course enhances problem-solving skills and analytical thinking, giving you the skills needed to tackle real-world business challenges head-on. Completing a Data Analyst course can help you tap into the increasing demand for skilled data professionals in various industries.

What is the value of a Bootcamp Certificate?

AVC's Bootcamp will help you master in-demand skills at a faster pace and increase your marketability. Whatever your career goals, whether you are an entry-level employee or looking for skill development opportunities to change careers, AVC's Bootcamp will help accelerate those goals. These certificates are in high demand.

Note: We are not a university and do not award university degrees. This Bootcamp means that you have gone through the entire program and gained all the essential knowledge of the subject and thus fully mastered the subject. Each course/part of the program also results in a certificate.

What knowledge and experience is required for the Bootcamp?

In general, no previous experience is required to participate in the program. The training starts at the introductory level and proceeds (step by step) to the expert level. However, it is always helpful if you have basic knowledge or experience of the subject. Read more about your specific course details.

This program is self-paced, so you can learn at your own pace. You will start with a practical e-learning module, followed by a series of online courses tailored to your needs where you have the freedom to choose the dates and times that best suit your schedule - and if you miss a session, you can easily reschedule it. Each session is recorded so that you can go through the material as many times as needed.

By the end of the program, you will have gained extensive knowledge and be able to demonstrate and apply it in a variety of practical tasks and projects.

How long does it take to complete the Bootcamp?

This is very individual. Some people go through the program quite quickly, others need more time. You have access to the program and eLearning for one year. If you spend 5-10 hours a week on the program, it will take you about 11 months to complete the program. Note: Some other programs take longer. This is an estimate.

What is the structure of the Bootcamp?

The majority of programs are entirely based on distance learning. Most of them include intensive online bootcamps with eLearning that you can complete at your own pace. These Learning Paths consist of different courses and topics that are related to specific skills for a role or job. There are also online classroom sessions via our advanced professional distance learning system. There are a range of different time slots to choose from and we always record the sessions so you can listen to them if you miss something or want to review information. Someone is always on hand to help and support you if you have any questions about the skills you are learning.

When can I take Bootcamp live class courses?

The timing of the courses varies from group to group. You will have access to a dashboard with multiple time slots for each session or topic, so you can choose what works best for you. Sessions can be scheduled on weekday afternoons, weekend mornings or evenings, depending on participants' interest and trainer availability. If you miss a session, you can always catch up by watching the recordings, so you never miss any content.

When can I unlock my Bootcamp Certificate?

Once you have completed at least 85% of the course material, your certificate will be unlockable. This applies to all Bootcamp programs. One of the criteria for obtaining the Bootcamp Certificate is to participate in the live courses. However, exceptions can be made if you are not able to attend live, but watching the recordings is still required. Find out more about your specific course or email us for more information.