Skip to content

Advance Data Analyst: Data Analysis
Blackboard Learning

8 in 1 bundle | Gain competencies in Data Analysis | Free PDF Certificate | Support

Summary

Price
£72 inc VAT
Or £24.00/mo. for 3 months...
Study method
Online
Course format
Video
Duration
24 hours · Self-paced
Access to content
365 days
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Overview

During the Data Analyst: Data Analyst course, you’ll engage with knowledge and real-life case studies as you develop practical skills and techniques for immediate application to data analysis projects, or within your organisation. You will be benefited from the unique pedagogy and multidisciplinary approach of BlackBoard Learning—an institution at the forefront of research and online learning—as you develop data analysis skills to better understand the SQL environment setup, constraints and functions, and working with excel datasets and the factors that contribute to career success and failure.

Throughout this Data Analyst: Data Analyst course, developed by industry experts, you’ll get the opportunity to learn from experts with diverse experience. Guided by experts, Data Analyst: Data Analyst course prepares you to become a change-maker with the skills to drive your career or organisation forward.

Data Analyst: Data Analyst course will demystify data analysis and give you the toolkit to make better contributions and to become an even greater asset to your organisation. It will also allow you to communicate more effectively and confidently about data analysis issues, whether it is with the relevant people in your own business or with those outside your workplace.

After completing Data Analyst: Data Analyst course from Blackboard Learning, you will be more skillful with more knowledge, along with practical tips and advice that will help you to learn the essential aspects of data analysis. Skills development on data analysis leads you to career development in the data analysis sector.

Courses included in this Data Analyst: Data Analyst bundle course:

Enrol in the Data Analyst: Data Analyst course and get started with the Data Analyst: Data Analyst journey!

This Data Analyst: Data Analyst course is a course consisting of 8 courses with many data analysis related topics.

You will get in this bundle course-

Course 1: SQL Queries 101

Course 2: The Complete MS SQL Course Content

Course 3: MySQL Course

Course 4: Excel Model 101 - Google Drive

Course 5: Learn Microsoft Excel from A-Z: Beginner To Expert Course

Course 6: Mastering Essential Excel in 3 Hrs

Course 7: Excel Data Analysis

Course 8: Building Robust Excel Models with Power Query, formulas and VBA

Certificates

Certificate of completion

Digital certificate - Included

Description

The Data Analyst: Data Analyst course contains important modules that teach learners about their professional needs and succession. In the United Kingdom, BlackBoard Learning is one of the most popular online Data Analyst: Data Analyst course providers. You will get a solid foundation of knowledge about data analysis in this Data Analyst: Data Analyst course.

Curriculum for Data Analyst: Data Analyst bundle courses:

Course 1: SQL Queries 101

  • Unzipping the sample files.
  • Creating the sample database.
  • Basic Select Statements.
  • Sorting the query with the order by statement.
  • Using the where statement to filter the query.
  • Creating subtotals using the group by statement.
  • Introduction to using the join statement to create queries from more than 1 table.

Course 2: The Complete MS SQL Course Content

  • Course Introduction
  • Introduction
  • Course Curriculum overview
  • Overview of Databases
  • SQL Environment Setup
  • MSSQL Installation
  • MSSQL Management Studio Installation
  • Connecting to MS-SQL (Windows Authentication)
  • Connecting to MS-SQL (SQL Server Authentication)
  • SQL Statement Basics
  • Overview of Challenges
  • SQL Statement Basic
  • SELECT Statement
  • SELECT DISTINCT
  • Column AS Statement
  • COUNT
  • Filtering Data Rows
  • SELECT WHERE Clause – One
  • SELECT WHERE Clause – Two
  • SQL Query Operators
  • ORDER BY
  • TOP in MSSQL
  • BETWEEN
  • IN
  • LIKE
  • HAVING
  • JOINS
  • Overview of JOINS
  • Introduction to JOINS
  • AS Statement
  • INNER Join
  • Full Outer Join
  • Left Outer Join
  • Right Outer Join
  • Union
  • Advanced SQL Commands
  • Basic of Advanced SQL Commands
  • Timestamp
  • Extract from Timestamp
  • Mathematical Scalar Functions
  • String Functions
  • SubQuery
  • Creating Database and Tables
  • Basic of Database and Tables
  • Data Types
  • Select Data type on SSMS
  • Create Table on SSMS
  • How to set Primary Key
  • How to set Foreign Key
  • Create Table using SQL Script
  • SQL CRUD Operations
  • Insert
  • Update
  • Delete
  • Alter Table
  • Drop Table
  • Check Constraint
  • NOT NULL Constraint
  • UNIQUE Constraint
  • Backup and Restore Functions
  • Overview of Database and Tables
  • Creating a Database backup using SSMS
  • Restoring a Database from backup using SSMS

Course 3: MySQL Course

  • Section 1 Introduction
  • Intro
  • Section 2 Installation
  • Installing Xampp
  • Section 3 First Steps and Basics
  • Creating and dropping DBs
  • Creating Tables
  • Dropping Tables
  • Inserting into Tables
  • Updating and Deleting
  • Data Types
  • Operators
  • Section 4 Constraints and Functions
  • Primary Keys
  • Foreign Keys
  • Functions
  • Section 5 Clauses
  • Select with Where
  • Order By
  • Group By
  • Section 6 Alters
  • Alters
  • Section 7 Joins
  • Aliases
  • Inner Join
  • Left and Right Joins

Course 4: Excel Model 101 - Google Drive

Course 5: Learn Microsoft Excel from A-Z: Beginner To Expert Course

  • Excel from A-Z Course Introduction
  • Excel from A-Z Course Section Overview
  • What is Microsoft Excel?
  • Who This Course is For
  • Microsoft Excel Marketplace
  • Microsoft Excel Job Opportunities
  • Microsoft Excel Job Types
  • Getting Started with Excel
  • Finding & Opening Microsoft Excel
  • Excel's Start Screen
  • Explaining the Excel Interface
  • Excel Interface Continued
  • Excel Workbook vs. Excel Worksheet
  • Saving & Opening Excel Documents
  • Customizing the Excel Quick Access Toolbar
  • Customizing the Excel Ribbon
  • Excel Shortcut Keys
  • Values, Referencing and Formulas
  • Creating Excel Labels
  • Entering Numeric Values in Excel
  • Formatting Date Values in Excel
  • Building Basic Formulas in Excel
  • Order of Operations
  • Relative vs. Absolute Cell References
  • Intro to Excel Functions
  • Excel Functions Explained
  • The SUM() Function
  • The MIN() & MAX() Function
  • The AVERAGE() Function
  • COUNT() Functions
  • Adjusting Excel Worksheets
  • Moving & Copying Data
  • Insert & Delete Rows/Columns
  • Adjusting the Width & Height of Cells
  • Hiding and Unhiding Excel Rows and Columns
  • Renaming, Moving & Deleting Excel Worksheets
  • Adding Protection to Specific Cells
  • Protecting the Structure of a Workbook
  • Adding a Workbook Password to Open File
  • Visually Pleasing Cell Formatting
  • Formatting Fonts and Cell Background Color
  • Adding Cell Borders
  • Formatting Data Appropriately
  • The Magic behind Excel's Format Painter
  • Creating Styles for Formatting Efficiency
  • Creating Subtotals within a Dataset
  • Converting Datasets into Tables
  • Finding & Removing Duplicate Values
  • Excel Database Functions
  • The SUMIF() Function
  • The DSUM() Function
  • DSUM() Function Cont.
  • The SUBTOTAL() Function
  • Excel Data Validation
  • What is Excel Data Validation?
  • Creating a Drop Down List with Data Validation
  • Different Types of Excel Data Validation
  • Adding Custom Alerts to Data Validation
  • Creating a Dynamic Drop Down List
  • Complex Validation: Dependent Drop Down List!
  • Excel PivotTables
  • Creating an Excel Pivot Table
  • Modifying Excel PivotTables
  • Grouping & Filtering PivotTable Data
  • Drilling Down into PivotTable Data
  • Creating Pivot Charts & Utilizing Slicers
  • Excel's PowerPivot Add-In
  • What is PowerPivot?
  • Activating the Excel PowerPivot Add-In
  • Creating Relationships between Data Tables
  • Using Data Models to Create PivotTables
  • How to Create PowerPivot KPIs
  • Excel's Conditional Functions
  • Excel’s IF() Function

Course 6: Mastering Essential Excel in 3 Hrs.

  • Section 1 - Getting started with Microsoft Excel
  • Section 2 - Working on data entry management in Excel
  • Section 3 - Understanding and using formulas and functions
  • Section 4 - Understanding and using formatting methods
  • Section 5 - Exploring worksheet layout and data
  • Section 6 - Page setup and printing
  • Section 7 - Understanding and using excel charts
  • Section 8 - Exploring worksheet views
  • Section 9 - Mastering wordbook and worksheet management
  • Section 10 - Vlookup, CountIF and IF functions
  • Section 11 - Working with security and file sharing
  • Section 12 - Essential data management tools
  • Section 13 - Essential data analysis tools
  • Section 14 - Pivot tables and pivot charts

Course 7: Excel Data Analysis

  • Excel Data Analysis - Part 1
  • Excel Data Analysis - Part 2
  • Excel Data Analysis - Part 3
  • Excel Data Analysis - Part 4
  • Excel Data Analysis - Part 5
  • Excel Data Analysis - Part 6
  • Excel Data Analysis - Part 7
  • Excel Data Analysis - Part 8
  • Excel Data Analysis – Part 9

Course 8: Building Robust Excel Models with Power Query, formulas and VBA

  • Introduction.
  • Prepaid expense models (resources).
  • Accounting for prepaid expenses.
  • Excel formulas detailed (Intro to three Excel models).
  • Formula based prepaid expenses model (schedule).
  • Calculate prepaid expenses Amortization from exact start date (payment date).
  • Thank you and super bonus.

Why Blackboard Learning:

Blackboard Learning is an online learning platform through which students from any corner of the world can learn their desired course. Using online learning, we assist students in realizing their full potential and advancing their careers. Today, our goal is to be the world's leading provider of online learning experiences with a global impact. By leveraging online learning, we assist students in preparing for bright futures in world-changing jobs. We provide a wide range of categories, including Accounting & IT, Programming, Creative, and more. Our courses are designed to stretch students intellectually through state-of-the-art online learning.

Who is this course for?

This Data Analyst: Data Analyst course is for anyone looking to develop their skills and knowledge in data analysis related fields, as well as for those-

  • Want to enhance Data Analyst: Data Analyst related skills and knowledge.
  • Use data analysis related knowledge in his career or profession.
  • Needs data analysis related skills for new job applications and opportunities.
  • Who wants to learn Data Analyst: Data Analyst and apply in real life.
  • Anyone who wants to demonstrate Data Analyst: Data Analyst to prospective employers or jobs.
  • Anyone who wants to apply Data Analyst: Data Analyst course related skills and dive into relevant career paths.

Requirements

Data Analyst: Data Analyst course does not require prior knowledge or experience. Anyone with a PC, tablet, or mobile phone can do the Data Analyst: Data Analyst course. It would be ideal for the learner to have:

  • An open minded, a spirit of self-inspection, and willingness to improve himself/herself.
  • A desire to improve business (and personal) knowledge and skills.
  • The desire to enhance skills indata analysis.

Career path

This Data Analyst: Data Analyst course is exciting as it opens the doors to many professions related to data analysis. Prospective Data Analyst: Data Analyst course related career paths that include but are not limited to-

  • Business Intelligence Analyst
  • Data Analyst
  • Data Analytics Consultant
  • Operations Analyst
  • Marketing Analyst

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.