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
Download Brochure Download Brochure
X

Download our FREE Data Analytics Brochure

Firstname

Lastname

Email

X

Download our FREE Data Analytics Brochure

Firstname

Lastname

Email

  • 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
Download Brochure Download Brochure
X

Download our FREE Data Analytics Brochure

Firstname

Lastname

Email

X

Download our FREE Data Analytics Brochure

Firstname

Lastname

Email

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

How Did You Hear About Us






How Did You Hear About Us