4b Toyin Street Ikeja, Lagos State
+(234) 803-796-1731
Data Analytics
Course Description
You can launch a new career in Data Analytics today . You don't need a computer science degree or expensive software. All you need is a computer, a bit of time, a lot of determination. Let us make a professional Data Analyst out of you and help you build a fantastic career in tech. .
In this eight-week course, you will master the following:
Excel Basics Work with cells and workspace Calculate your data: sum,average,count etc Functions such as IF,nested IF,VLOOKUP and HLOOKUP functions in Excel Format your workspace Add Charts and Graphics Pivot Table: Analyze your data X
Download our FREE Data Analytics Brochure
X
Download our FREE Data Analytics Brochure
-
Excel
-
Work with cells and workspace
Calculate Your Data:sum,average,count,etc
Spreadsheet functions to organise Data
-
-
SQL
-
Course Introduction
PostgreSQL Download & install
Create Database
Restore Database
Test yourself
SQL data Type
SQL table
Select Statement
Select statement for all Airlines Database Tables
Where Clause
Operators used with Where Clause
Fetch vs Limit
-
-
TABLEAU
-
Tableau Desktop:Introduction to Tableau
Installing Tableau
Connect to your Excel data using Drag and Drop
Basic Bar, columns ,Line and pie chart
Color coding and Text Labels
One click calculations:Running total,moving average and more
Building your first dashboard in seconds
Basic formatting
-
-
Tableau Desktop:Biginner
-
Simple charts:pie,bars,area and lines
How to fliter your your data with a few clicks
Basic Arithmetic:learn to add number fields together
-
-
Tableau Desktop:Intermidiate
-
How to connect to data using live and extract methods
Cleaning data:Splitting combined data into multiple columns
Create IF calculations,Rounding numbers,absolute formula
How to extract letters/numbers from left and right side of text
Trimming extra spaces
Create interactive dashboard
-
-
Tableau Desktop:Expert
-
Add data to another table easily UNIONS
Create a reference data anywhere on your visualization
Use parameters to change values on the fly
Create sets to group your data for further analysis
Learn new visualizations such as Histograms , funnels,Donuts,Dot time,jitter and more
Add additional views for mobile and tablet
-
-
Power BI
-
What is POWER BI?
Examining power BI suit of products
Identifying Diffrences between products
Power BI Desktop
Exploring the power BI Desktop interface
Utilizing File Types;PBIX vs PBIT
-
-
Working with CSV, TXT and Excel Worksheets
-
Importing,Transforming, and Loading Data
Appending Operations
Working with folders and files
Using pivot tables
-
-
Connecting to Database
-
Working with relational data
Understanding relationships
-
-
Brief history and applications of python
-
Installation of preferred IDLE, and testing with Hello world
Python syntax(Indentation, Variables and comments)
Data types
Text type
Numeric types(int,float,complex)
Mapping type
Boolean
Operators
Range function
Nesting
Lambda
-
X
Download our FREE Data Analytics Brochure
X
Download our FREE Data Analytics Brochure
Data Analytics
Register and book a seat on our Data Analytics Masterclass. Kindly fill out the form and a member of our support team will reach out to you
All field are required
All field are required
© 2021 PluralCode Technologies.