Description
Course content
Practice materials
Introduction to EXCEL PT1
Introduction to EXCEL PT2
Introduction to EXCEL pPT3
Operators in EXCEL PT1
Operators in EXCEL PT2
Operators in EXCEL PT3
Data transpose
Formulas and function in EXCEL PT1
Formulas and function PT2
IF FUNCTTION IN EXCEL
Count IF and Count IF function
Vlookup , lookup and find in EXCEL
Formulas and functions in excel 3
Time and date function PT1
Time and date function PT2
How to make barcodes in EXCEL
Excel flash FILL
How to use filter in EXCEL
Advanced filter in EXCEL
Data sorting and slicers
Data validation in EXCEL
Conditional formatting
Pivot tables and responsive dashboard creation PT1
Pivot tables and responsive dashboard creation PT2
Pivot tables and responsive dashboard creation PT3
Pivot tables and responsive dashboard creation PT4
Pivot tables and responsive dashboard creation PT5
Pivot tables and responsive dashboard creation PT6
Learning materials
Activating office 365
Activating office 365 PT2
Logging into office 365
What is Power Pivot
Office versions of power pivot
Enable power pivot in excel
What is power query
Connecting to a data source
Preparing query
Cleansing data
Enhancing query
Creating a data model
Building data relationships
Create lookups with DAX
Analyse data with pivot tables
Analyze data with pivot charts
Refresh Source data
Update Queries
Create new reports
Practice materials
What is power BI
What is power BI DESKTOP
Installing Power BI DESKTOP
Power BI DESKTOP tour
Power BI overview part1
Power BI overview part2
Power BI overview part 3
Components of power BI
Building blocks of power BI
Exploring power BI Desktop interface
Exploring power BI service
Power BI apps
Connecting to web data
Clean and transform data PT1
Clean and transform data PT2
Combining data sources
Creating visualization PT1
Creating visualization PT2
Publishing reports to POWER BI service
Importing and transforming data from access db file
Changing locale
Connecting to MS Access DB file
Creating and managing query groups
Renaming queries
Changing data types
Removing and reordering columns
Duplicating and adding columns
Creating and conditional columns
Connecting to files in folder
Appending queries
Merge queries
Query dependency view
Transform less structured data PT1
Transform less structured data PT2
Creating tables
Query parameters
Why use SQL
Why use MYSQL
Introducing databases
Relational database Fundamentals
Important database terminology
The concept of relational schemas primary key
The concept of relational schemas unique key and null values
The concept of relational schemas relationship between tables
Installing MYSQL Workbench and server
Linking GUI with the MYSQL server
Creating a new user and new connection to it
Familiarize yourself with the MYSQL interface
Coding tips and best practices
coding tips and best practice 2
SQL - Loading the _employees_ Database
Using LIKE - NOT LIKE
Using wildcard characters
Applying COUNT()
Applying SUM()
Applying MIN() and MAX()
Applying AVG()
Rounding Numbers with ROUND()
The functionality of INNER JOIN PT1
The functionality of INNER JOIN
Duplicate Rows
The functionality of LEFT JOIN PT1
The functionality of LEFT JOIN PT2
The functionality of RIGHT JOIN
Difference between the new and old join syntax
Using JOIN and WHERE Together
Combining agregate functions with JOIN
JOIN more than two tables
The Difference between UNION and UNION ALL
SQL subqueries with IN embedded inside WHERE
SQL subqueries with EXISTS NOT EXIST embedded inside WHERE
SQL subqueries Nested in SELECT and FROM
Definning Stored Routines
Create stored procedures with MYSQL Syntax
An example of stored procedures PT1
An Example of stored procedures PT2
Creating a procedure in MYSQL Another way
Create procedures with an input parameter
Create stored procedures with an output parameter
SQL Variables
The benefit of user defined funtion in MYSQL
Concluding stored routines
THE SQL CASE statement
Introduction
What is python
What is jupyter Notebook
Installing jupyter Notebook Server
Running jupyter Notebook Server
Common juputer Notebook commands
Jupyter Notebook components
Jupyther Notebook Dashboard
Jupyter Notebook Interface
Creating a new jupyter Notebook
Kaggle datasets
Tabular data
Exploring pandas Dataframe
Analysing and manipulating pandas dataframe
What is data cleaning
Basic data cleaning
Data visualization
Visualizing qualitative data
Visualizing quanlitative data
What is tableau
Tableau Data sources
Tableau file types
Tableau help menu
Connect to a data source
join related sources
Join data sources with inconsistent field
Data cleaning
Exploring tableau interface
Reorder fields in visualization
Change Summary
Split text into multiple columns
Presenting data using stories
Earn Your Certificate
Finish every lesson to unlock your verified **LVG Academy Certificate**.
Official & Verified Achievement
Certificate of Completion
Student Name
Data Analysis
Watch Preview
₦0.00
Course Features:
165 on-demand videos
Certificate included