data analysis using python, sql, tableau

Foundation in Data Analysis using Python and SQL and Tableau – N140,000

data analysis using python, sql, tableau

​​About the Courses

Data analysis using Python; you will understand why a data scientist should choose Python as a programming language, situations where Python is a good choice with some good practices in application development and give some coding examples that a data scientist needs in their day-to-day job.

Data analysis using SQL; you will get a big-picture view of using SQL for big data, starting with an overview of data, database systems. Then you will learn the characteristics of data analysis using SQL tools for working on big data platforms. You will be taught also how to install an exercise environment (virtual machine) to be used through the course, and you will have practical  exploration of databases and tables in that environment during the course of the training

Data analysis using Tableau; you will understand the evolution of Big Data systems, the fundamentals of Big Data systems and popular vendors in this space. How to access these systems using Tableau Software and visualize in ways that will leave your boss singing your praise and make you stand out.

Course Fee: N140,000

Duration: 3 months

Delivery Mode – Live, Instructor Led Online

 

Register for this Course

Contact us for Group or Team Registration

 

Course Outline

Python
● Introduction to Python Programming
● Installing Python
● The Python IDLE
● Understanding command prompt
● Data types in Python
● Variables
● List
● Dictionary
● Functions in Python
● For loop
● While loop
● Installing libraries
● Series
● Data Frame
● Creating a csv file using pandas
● Math functions

 

SQL

● Introduction to SQL
● Installation of RDBMs
● Understanding MySQL Workbench/ Postgres PG Admin
● Data types
● Constraints in SQL
● Understanding primary key and foreign keys
● Working with SQL command line tools
● Database creation
● Data manipulation language
● Data definition language
● The WHERE clause
● The SELECT keyword
● Updating a table with the UPDATE keyword
● The SQL BETWEEN keyword
● The SQL LIKE keyword
● The SQL IN keyword
● Comments in SQL
● Using MySQL for EXCEL to interact with MySQL
● Importing data into an RDBMSs from external files
● Loading query results into an external file

 

Tableau

  • Tableau
  • Getting started with Tableau
  • Tableau Basics: Your First Bar chart
  • Time series, Aggregation, and Filters
  • Maps, Scatterplots, and Your First Dashboard
  • Joining, Blending and Relationships; PLUS: Dual Axis Charts
  • Table Calculations, Advanced Dashboards, Storytelling
  • Advanced Data Preparation
  • Clusters, Custom Territories, Design Features

Leave a Comment

Your email address will not be published. Required fields are marked *