Data Analyst Bootcamp In collaboration with Microsoft

Data Analyst Bootcamp

In collaboration with Microsoft

This Data Analyst Course, developed in collaboration with Microsoft, equips you with the skills to become a data analytics professional. You’ll master the latest analytics tools and techniques, work with SQL databases, learn R and Python, create compelling data visualizations, and apply statistical and predictive analysis to real-world business scenarios.

Key Features

• Course and material are in English
• Beginner-Advanced level
• 11 months long live online bootcamp and eLearning (self-paced)
• New live class course cohort every 1-3 months
• 1 year access to learning platform & classroom recordings
• 220 hours of total study time needed
• Comprehensive curriculum featuring exclusive Microsoft courses
• 10+ course-end projects from different industries
• Master 10 in-demand data analytics tools and integrated labs
• Certification for each courses and Bootcamp certification upon completion
• Microsoft course certification

Course Content

• Business Analytics with Excel
• SQL Certification Course
• Python Refresher With AI
• Data Analytics With R
• Tableau Desktop Specialist Certification Training
• Data Analyst Master’s Capstone
• Introduction to MS Azure Data Analytics (Microsoft)

Electives

• Pl-300 Microsoft Power BI Certification Training
• Model Data With Power BI (Microsoft)

Program Outcomes

• Utilize Excel functions, pivot tables, and dashboards to analyze and visualize business data effectively.
• Write SQL queries to extract, manage, and optimize data from relational databases.
• Strengthen your Python programming skills to process data and build a foundation for AI and machine learning.
• Apply R for data manipulation, visualization, statistical modeling, and introductory machine learning tasks.
• Develop professional BI reports and dashboards in Power BI, leveraging DAX formulas and performance optimization methods.
• Design large-scale and real-time analytics solutions using Microsoft Azure, Microsoft Fabric, and Apache Spark.
• Build interactive dashboards and compelling visual stories with Tableau.
• Gain practical, industry-relevant experience through hands-on projects and a capstone simulation.

Target Audience

• IT professionals
• Banking and finance specialists
• Marketing managers
• Supply chain and operations managers
• Beginners entering the data engineering field
• Undergraduate and postgraduate students seeking to build data analytics skills

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 Certification Course

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. Python Refresher With AI

Python serves as the core programming language for AI development, making it the essential starting point for anyone pursuing applied generative AI. This course introduces you to Python fundamentals with a focus on real-world AI applications. By the end, you’ll have a strong technical foundation to confidently move forward in training, deploying, and managing AI models effectively and responsibly.

Key Learning Objectives

• Write and run Python programs to address real-world challenges.
• Use data types, operators, and control structures to create efficient code.
• Implement functions, loops, and error handling to build well-structured programs.
• Manage files effectively for AI and machine learning applications.
• Build the essential coding foundation needed for AI model development.

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. Data Analytics with R

The next step toward becoming a Data Analyst is mastering R — a highly sought-after open-source language for data science and analytics. Known for its powerful capabilities and active community, R is rapidly becoming the preferred tool for organizations leveraging analytics to gain a competitive edge.

Key Learning Objectives

• Build a solid foundation in business analytics concepts.
• Install and set up R, RStudio, and the workspace environment, and explore essential R packages.
• Master R programming fundamentals and learn how statements are executed.
• Understand R data structures and learn to import and export data efficiently.
• Apply various apply and dplyr functions for data manipulation.
• Create effective data visualizations using R’s graphical tools.
• Develop a basic understanding of core statistical concepts.
• Apply hypothesis testing to support data-driven business decisions.
• Use linear and nonlinear regression models, along with classification techniques, for analytical tasks.
• Explore association rules and the Apriori algorithm for pattern discovery.
• Implement clustering techniques such as K-Means, DBSCAN, and hierarchical clustering.

Topics Covered

• Lesson 01 Introduction to Business Analytics
• Lesson 02 Introduction to R Programming
• Lesson 03 Data Structures
• Lesson 04 Data Visualization
• Lesson 05 Statistics for Data Science (Part 1)
• Lesson 06 Statistics for Data Science (Part 2)
• Lesson 07 Regression Analysis
• Lesson 08 Classification
• Lesson 09 Clustering
• Lesson 10 Association Analysis

5. Tableau Desktop Specialist Certification 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)

6. 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.

7. Introduction to MS Azure Data Analytics (Microsoft)

This beginner-friendly program introduces the fundamental concepts and key services of Microsoft Azure, helping you design large-scale and real-time analytics solutions. Tailored for professionals with a basic grasp of data principles, it covers data ingestion, storage, modeling, visualization, and stream processing. By the end, you’ll gain hands-on experience with Microsoft Fabric, Apache Spark, and Power BI, along with the knowledge to confidently pursue the Azure Data Fundamentals certification.

Key Learning Objectives

• Describe large-scale analytics architectures and workflows.
• Explore data ingestion pipelines and analytical data storage solutions.
• Understand the principles of batch and stream data processing.
• Implement real-time analytics using Microsoft Fabric and Apache Spark.
• Apply data modeling and visualization techniques with Power BI.

Topics Covered

• Lesson 1 Fundamentals of Large-Scale Analytics
• Lesson 2 Fundamentals of Real-Time Analytics
• Lesson 3 Fundamentals of Data Visualization

Elective Courses

1. Pl-300 Microsoft Power BI Certification Training

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 interactive dashboards from published reports.
• Quickly build visuals and dashboards using the Quick Insights feature.
• Use natural language with the Q&A tool to generate visuals for actionable insights.
• Set up and manage data alerts to monitor key metrics.
• Learn best practices for report layout and data visualization design.
• Identify the most suitable charts and graphs based on your data story or analytical question.
• Use shapes and design elements to highlight insights and enhance storytelling.
• Integrate custom visuals into your reports and dashboards.
• Share reports and dashboards effectively, understanding the advantages and limitations of each method.
• Complete a Power BI data analysis and visualization project from start to finish.

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

2. Model Data With Power BI (Microsoft)

This intermediate-level program is designed to help you master the skills needed to configure semantic models, write DAX formulas, and optimize Power BI models for maximum performance. You’ll gain practical experience in creating relationships, hierarchies, measures, and calculations, while applying advanced DAX methods, time intelligence functions, and visual calculations to produce precise, high-impact analytics. The course also includes performance tuning techniques for efficient model execution, preparing you for the Microsoft Certified: Data Analyst Associate certification.

Key Learning Objectives

• Configure tables, columns, relationships, hierarchies, and measures within semantic models.
• Write and apply DAX formulas to perform custom calculations.
• Create calculated tables, columns, and explicit measures for deeper analysis.
• Modify filter context to achieve precise and accurate insights.
• Use DAX time intelligence functions to evaluate trends over time.
• Build visual calculations to streamline and simplify reporting.
• Optimize semantic models to enhance overall performance.

Topics Covered

• Configuring Semantic Models
• Writing DAX Formulas
• Creating DAX Calculations
• Modifying DAX Filter Context
• Applying DAX Time Intelligence Functions
• Creating Visual Calculations in Power BI
• Optimizing Model Performance

Program Projects

Employee Performance Mapping

Use SQL databases to analyze employee performance and generate appraisal reports.

Air Cargo Analysis

Apply SQL to create reports from historical airline data, helping improve operational efficiency and customer experience.

Analyzing Customer Orders Using Python

Utilize Python data structures to analyze customer orders, categorize products, identify buying trends, and extract valuable business insights.

Building a Python Adventure Game with GitHub Copilot

Create a text-based adventure game using Python and GitHub Copilot. Players can explore locations, make decisions, and complete quests while learning key Python concepts like variables, lists, loops, conditionals, and functions.

Data Manipulation and Reporting with Power BI

Develop an interactive Power BI report for Zomato to analyze global restaurant data, exploring insights by location, service, rating, cost, and cuisine.

Data Visualization and Reporting with Power BI

Build a Power BI dashboard to assess agent performance metrics for a regional insurance company comprising ten firms.

Crime Analysis with Tableau Dashboard

Design a Tableau dashboard to help the police and city officials monitor and visualize crime statistics, creating an engaging visual narrative.

Regional Sales Analysis

Use Tableau to develop a dashboard that compares sales performance across two different regions.

Designing a Sales Dashboard in Excel

Evaluate an e-commerce store’s performance using Excel by building interactive dashboards to visualize and analyze sales trends across various product categories.

Predicting Restaurant Tips

Clean and analyze restaurant tipping data to create a predictive model. Apply regression and variable encoding to estimate tip amounts and generate insights for improving service quality.

Anomaly Detection in Credit Card Transactions

Develop a fraud detection model to identify suspicious credit card transactions in real time.

Patient Readmission Prediction

Evaluate the probability of a patient being readmitted to a healthcare facility within 30 days after discharge.

Predicting Customer Purchase Behavior

Gain insights into customer behavior and preferences by analyzing retail transaction data to understand purchasing patterns.

ChatGPT-Based Storytelling

Create an interactive storytelling experience using ChatGPT, allowing users to collaboratively build engaging narratives—no coding required.

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.