Introduction To Advance Data Analysis Course

Blackboard Learning

Certificate of completion

Digital certificate - Included

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. You will be able to think critically about Data Analyst: Data Analyst and comprehend basic data analyst theories and methods. This Data Analyst: Data Analyst course was created to provide you with the tools and methods you'll need to make a measurable effect in your career, whether your objective is to land a job, improve your abilities, or make a good influence in some other way.

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

• Overview of GROUP BY

• Aggregation Function – SUM()

• Aggregation Function – MIN()-MAX()

• GROUP BY – One(theory)

• GROUP BY – Two(practical)

• HAVING

• JOINS

• Overview of JOINS

• Introduction to JOINS

• A Statement

• INNER Join

• Full Outer Join

• Left Outer Join

• Right Outer Join

• Union

• Advanced SQL Commands

• Basic Advanced SQL Commands

• Timestamp

• Extract from Timestamp

• Mathematical Scalar Functions

• String Functions

• Sub Query

• Creating Database and Tables

• Basic Database and Tables

• Data Types

• Select Data type on SSMS

• Create a Table on SSMS

• How to set Primary Key

• How to set Foreign Key

• Create a 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: Excel Model 101 - Google Drive

Course 4: 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, Count IF 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 5: 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 6: 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 the exact start date (the payment date).

• Prepaid expenses summary with Power Query and Pivot Table.

• Advanced VBA prepaid expenses Amortization model.

• Bonus: Dynamic dashboard for divisional profit and loss statement (the easy way).

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

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

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

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 mind, a spirit of self-inspection, and a willingness to improve himself/herself.
• A desire to improve business (and personal) knowledge and skills.
• The desire to enhance skills in data analysis.

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-

• Data analyst
• Data insight professional
• Business analyst

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