ACEDU Logo

Certificate Validation Page

Certificate Details

First Name: MARIAM

Middle Name: OPEYEMI

Last Name: AWUJOOLA

Has successfully completed the requirements to be recognized as an Adroitsoft Certified Intermediate Data Analyst

Date of Achievement: Dec 2024

Certificate Number: ACEDU/01/3232/08

Certificate Preview

Certificate Course Details
Exercises and Datasets
What is Data Analytics?
Importance of Data Analytics:
Dealing with Different Types of Data
Excel Overview
Documents
Data Cleansing - Value
Data Cleansing - Text
VLOOKUP function
Introduction to Power BI
Why Power BI?
Power BI Components
Power BI Pro
Power BI Interface
Wide World Importers (WWI) dataset
Practice
Power Query Editor
Practice
Visualization options
Practice
Drilling Down and Filtering
Practice
Introduction to DAX in Power BI
Practice
The Date table
Practice
Dimensional modeling
Creating a star schema
Databases
Tables
Data
Introducing queries
Writing queries
SQL flavors
Query execution
SQL style
FILTERING RECORDS
Multiple criteria
Filtering text
AGGREGATE FUNCTIONS
Combining filtering and selecting
Summarizing subsets
Aliasing and arithmetic
SORTING AND GROUPING
Grouping data
Filtering grouped data
Joining Data
Defining relationships
Multiple joins
LEFT and RIGHT JOINs
FULL JOINs
Crossing into CROSS JOIN
Self joins
Set theory for SQL Joins
At the INTERSECT
EXCEPT
Subquerying with semi joins and anti joins
Subqueries inside WHERE and SELECT
Subqueries inside FROM
Final challenge