₦airaland Forum

Progress your career today with a 5 Day Tableau Training Course

21st - 25th October 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Introduction to SQL Programming Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Sturctured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server 2016.

III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376

Progress your career today with a 5 Day Tableau Training Course

1st - 5th September 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with Microsoft Power BI training with our 2 day Microsoft Power BI training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft Power BI course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/powerbi/

Next Courses dates: 26th-27th September 2019


Course Content:


Day 1

Getting started with Microsoft Power BI

What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer

Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports

Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI

Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile

Accessing your report & dashboards from Mobile

Data Alerts

Setting up Data driven alerts
Using Annotations

Day 2

Transforming and shape your Data

Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI

Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI

Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards

Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion


Contact us today to register

Phone:08103382376
Email:training@habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

3rd - 7th September 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

3rd - 7th September 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Introduction to SQL Programming Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Sturctured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server 2016.

III – Our training venue is based in Abuja, (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376

Progress your career today with a 5 Day Tableau Training Course

3rd - 7th September 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

3rd - 7th September 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

3rd - 7th September 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Qlikview Training Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Qlikview. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Qlikview course. To enrol or register please call 08103382376 or email training@habanerodata.net


Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to QlikView and Business Intelligence

The course will begin with a brief history & technical view of Business Intelligence. Delegates will then be given an Overview on Data Discovery before moving on to an Introduction to QlikView interface, Data Sources & and exploration of Data Modelling. We will conclude with loading data into QlikView and building your first dashboard.


Day 2

Creating Dashboards

We will continue on the dashboard development started on day one and look further into methods for displaying data. We will go deeper into dashboard design, data visualisation practices and core QlikView front end functionality. Delegates will be given an overview and effectiveness of Listboxes, tableboxes, multiboxes and basic charts.


Day 3

QlikView scripting & data modelling

We will look in more detail at the QlikView back-end and how to load and manipulate new data sources and how best to model data in QlikView, achieving the uppermost performance in your applications.


Day 4

Data Transformations & Advanced Expressions

We will begin to tackle more advanced back-end scripting and front-end expression writing, extending our QlikView capability.


Day 5

Advanced Data Transformations, Set Analysis & Security

We will learn to bring to bear the full power of QlikView using advanced data transformation techniques and set analysis to satisfy advanced reporting requirements and achieve point in time reporting.




Your Trainer

Our international certified trainers are highly experienced QlikView practitioners who have real-world expertise. Our trainers will be able to give you the answers you need.
Key Information

I – All course material including a copy of QlikView 12 for developers will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed QlikView

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

IIII – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course)

For more information on our training, please email training@habanerodata.net or call 08103382376

Progress your career today with a 5 Day Qlikview Training Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Qlikview. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Qlikview course. To enrol or register please call 08103382376 or email training@habanerodata.net


Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to QlikView and Business Intelligence

The course will begin with a brief history & technical view of Business Intelligence. Delegates will then be given an Overview on Data Discovery before moving on to an Introduction to QlikView interface, Data Sources & and exploration of Data Modelling. We will conclude with loading data into QlikView and building your first dashboard.


Day 2

Creating Dashboards

We will continue on the dashboard development started on day one and look further into methods for displaying data. We will go deeper into dashboard design, data visualisation practices and core QlikView front end functionality. Delegates will be given an overview and effectiveness of Listboxes, tableboxes, multiboxes and basic charts.


Day 3

QlikView scripting & data modelling

We will look in more detail at the QlikView back-end and how to load and manipulate new data sources and how best to model data in QlikView, achieving the uppermost performance in your applications.


Day 4

Data Transformations & Advanced Expressions

We will begin to tackle more advanced back-end scripting and front-end expression writing, extending our QlikView capability.


Day 5

Advanced Data Transformations, Set Analysis & Security

We will learn to bring to bear the full power of QlikView using advanced data transformation techniques and set analysis to satisfy advanced reporting requirements and achieve point in time reporting.




Your Trainer

Our international certified trainers are highly experienced QlikView practitioners who have real-world expertise. Our trainers will be able to give you the answers you need.
Key Information

I – All course material including a copy of QlikView 12 for developers will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed QlikView

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

IIII – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course)

For more information on our training, please email training@habanerodata.net or call 08103382376

Progress your career today with Microsoft Power BI training with our 2 day Microsoft Power BI training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft Power BI course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/powerbi/

Next Courses dates:12th - 13th August 2019


Course Content:


Day 1

Getting started with Microsoft Power BI

What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer

Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports

Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI

Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile

Accessing your report & dashboards from Mobile

Data Alerts

Setting up Data driven alerts
Using Annotations

Day 2

Transforming and shape your Data

Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI

Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI

Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards

Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion


Contact us today to register

Phone:08103382376
Email:training@habanerodata.net
Web:www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

5th - 9th August 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with Microsoft Power BI training with our 2 day Microsoft Power BI training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft Power BI course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/powerbi/

Next Courses dates: 22nd - 23rd July 2019


Course Content:


Day 1

Getting started with Microsoft Power BI

What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer

Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports

Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI

Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile

Accessing your report & dashboards from Mobile

Data Alerts

Setting up Data driven alerts
Using Annotations

Day 2

Transforming and shape your Data

Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI

Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI

Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards

Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion


Contact us today to register

Phone:08103382376
Email:training@habanerodata.net
Web:www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

17th - 21st June 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

17th - 21st June 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


To register for this course, please call 08103382376 (Whats App) or visit www.habanerodata.net

22nd - 26th July - Introduction to Big Data and Hadoop Course in Port Harcourt

This 4 day intensive fast paced course will deliver a technical overview of the Hadoop landscape. No prior knowledge of databases is assumed. However, previous basic Java programming experience and linux command line experience will be very useful for this course.
The course is targeted towards technical people who want to understand the emerging world of Big Data, with a specific focus on Hadoop.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 4 Days, 32 Academic Hours


Course Syllabus:

Day 1

Introduction to Hadoop and its Ecosystem, Map Reduce and HDFS

Big Data, Factors constituting Big Data
Hadoop and Hadoop Ecosystem
Map Reduce – Concepts of Map, Reduce, Ordering, Concurrency, Shuffle , Reducing, Concurrency
Hadoop Distributed File System (HDFS) Concepts and its Importance
Deep Dive in Map Reduce – Execution Framework, Partioner, Combiner, Data Types, Key pairs
HDFS Deep Dive – Architecture, Data Replication, Name Node, Data Node, Data Flow
Parallel Copying with DISTCP, Hadoop Archives

Hands on Exercises

Installing Hadoop in Pseudo Distributed Mode, Understanding Important configuration files, their Properties and Demon Threads
Accessing HDFS from Command Line
Map Reduce – Basic Exercises
Understanding Hadoop Eco-system
Introduction to Sqoop , use cases and Installation
Introduction to Hive , use cases and Installation
Introduction to Pig , use cases and Installation
Introduction to Oozie , use cases and Installation
Introduction to Flume , use cases and Installation
Introduction to Yarn

Day 2

Deep Dive in Map Reduce and Yarn

How to develop Map Reduce Application , writing unit test
Best Practices for developing and writing , Debugging Map Reduce applications
Joining Data sets in Map Reduce
Algorithms – Traversing Graph, etc
Hadoop API’s

Deep Dive in Pig

Grunt, Script Mode, Data Model
Advance Pig Latin, Evaluation and Filter functions, Pig and Ecosystem
Real time use cases – Gaming Industry, Oil and Gas Sector

Day 3

Deep Dive in Hive

Understanding Hive , Architecture, Physical Model, Data Model, Data Types
Hive QL- DDL,DML,other Operations
Understanding Tables in Hive, Partitioning, Indexes,Bucketing,Sub Queries, Joining Tables,Data Load and appending data to existing Table
Hands on Exercises – Playing with huge data and Querying extensively.
User defined Functions,Optimizing Queries, Tips and Tricks for performance tuning

Introduction to Hbase architecture

Introduction to HBase, Architecture, Map Reduce Integration, Different Client API – Features and Administration.

Day 4

Deep Dive into Ooze

Understanding Oozie
Designing and Implementing Workflow
Oozie Coordinator application Implementation

Hadoop Cluster Setup and Running Map Reduce Jobs

Hadoop Multi Node Cluster Setup using Amazon ec2 – Creating 4 node cluster setup
Running Map Reduce Jobs on Cluster

Major Project – Putting it all together and Connecting Dots

Putting it all together and Connecting Dots
Working with Large data sets, Steps involved in analyzing large data

Advance Mapreduce

Delving Deeper Into The Hadoop API
More Advanced Map Reduce Programming, Joining Data Sets in Map Reduce
Graph Manipulation in Hadoop




Contact us today to register

Phone:08103382376
Email:training@habanerodata.net

Progress your career today with Microsoft Power BI training with our 2 day Microsoft Power BI training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft Power BI course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/powerbi/

Next Courses dates: 17th-19th June 2019


Course Content:


Day 1

Getting started with Microsoft Power BI

What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer

Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports

Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI

Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile

Accessing your report & dashboards from Mobile

Data Alerts

Setting up Data driven alerts
Using Annotations

Day 2

Transforming and shape your Data

Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI

Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI

Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards

Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion


Contact us today to register

Phone:08103382376
Email:training@habanerodata.net

Progress your career today with Microsoft SQL Server Reporting Services (SSRS) training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Microsoft SQL Reporting Services (SSRS). Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft SQL Server Reporting Services (SSRS) course.

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/reportingservices/

Next Course dates: 17th - 21st June 2019

Contact us today to register.

Phone:08103382376
Email:training@habanerodata.net
Web:www.habanerodata.net

Office Address:
Habanero Data Solutions Ltd
Capital Square
Garnet Building
Lekki Epe-Express Road
Lekki
Lagos
Nigeria

Progress your career today with a 5 Day Introduction to SQL Programming Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Sturctured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server 2016.

III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376

Hello,

Get the most of your data and advance your career by taking a BI course. Take a look at our Quarter Two Dates.

April

1st –5th April 2019 4 Days SAP BI Fundamentals
8th – 12th April 2019 5 Days SAS BI
15th – 19th April 2019 5 Days Introduction to SQL
15th – 19th April 2019 5 Days SQL Reporting Services
15th – 17th April 2019 2 Days Power BI Essentials
22nd -26th April 2019 2 Days Tableau Essentials
29th – 30th April 2019 2 Power BI Essentials


May

1st – 3rd May 5 Days Intro to R
6th – 10th May 5 Days Qlikview Essentials
4th – 8th May 4 Days Intro to Python
13th – 17th May 5 Days Tableau Essentials
27th – 28th May 2 Days Power BI Essentials
27th -31st May 5 Days SQL Server Integration Services


June

3rd – 7th June 5 Days Into to Oracle
10th – 14th June 5 Days Intro to Penhato
10th – 14th June 5 Days Qliksense Essentials
17th – 19th June 5 Days Power BI Essentials
17th – 21st June 5 Days Tableau Essentials
24th – 28th June 5 Days Introduction to SQL Programming


Contact us today!

Phone:08103382376 (WhatsApp)
Email:training@habanerodata.net
Web:www.habanerodata.net

Office Address:
Habanero Data Solutions Ltd
Capital Square
Garnet Building
Lekki Epe-Express Road
Lekki
Lagos

Progress your career today with a 5 Day Tableau Training Course

29th - 3rd May 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions

For more information on our training, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

29th - 3rd May 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


For more information on our training, please call 08103382376 (Whats App) or visit www.habanerodata.net

Progress your career today with Microsoft Power BI training with our 2 day Microsoft Power BI training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft Power BI course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/powerbi/

Next Power Essentials Course dates: 27th - 28th May 2019


Course Content:


Day 1

Getting started with Microsoft Power BI

What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer

Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports

Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI

Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile

Accessing your report & dashboards from Mobile

Data Alerts

Setting up Data driven alerts
Using Annotations

Day 2

Transforming and shape your Data

Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI

Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI

Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards

Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion


Contact us today to register

Phone:08103382376 (WhatsApp)
Email:training@habanerodata.net
Web:www.habanerodata.net

Progress your career today with a 5 Day Tableau Training Course

22nd - 26th April 2019: Tableau Essentials

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Tableau. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Tableau course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

This five day course is designed for the beginner to Tableau user. It is for anyone who works with data regardless of technical or analytical background. This course is designed to help you understand and use the important concepts and techniques in Tableau to move from simple to complex visualizations and learn how to combine them in interactive dashboards. This course will be taught on Tableau Desktop version 9.2

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Tableau.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

All delegates will be taken through the following topics over 5 days:

Day 1

Getting Started with Tableau

Power
Speed
Flexibility
Simplicity
Beauty

Tableau Basics

Download, install and open Tableau
Connect to sample data and review the Tableau interface
“Show Me” Tableau in action
Categorically clear views

Tableau Objects

Save time with the Tableau toolbar
When tables trump graphs
Insightful maps
View shifting – the underrated histogram and flexible bins
Exporting results to share your insights

Basic views in Tableau

Tables – an eye for detail
Text tables
Highlight tables
Heat maps
Bar Charts – five flavors to meet your needs
Horizontal bars
Stacked bars
Side-by-side bars
Histogram
Bullet graphs
Line Charts – display what happened over time
Lines (continuous)
Lines (discrete)
Pie Charts – a common go-to view (use at your own risk!)
Hands on Practical Sessions

Day 2

Advanced views in Tableau

Scatter Plots – explore relationships
Circle Plots – go beyond bar charts
Circle views
Side-by-side circles
Maps – great for location data
Symbol maps
Filled maps
Area Charts – track multiple groups over time
Area charts (continuous)
Area charts (discrete)
Dual Charts – compare two measures on two vertical axes
Dual lines
Dual combination
Dual points
Gantt Chart – track activity over time

Customization of views with Tableau

Customize views using the Columns, Rows, Pages and Filters Shelves
Enhance your visual appeal with the Marks card
Label
Text
Color
Size
Shape
Level of Detail

The Summary Card – handy description of your data
Headers and Axes
Titles, Captions, Field Labels and Legends
Format values in your views
Organise the data in your views

Day 3

Sort views for quick comparison
Filter views to find the right information
Aggregations for measures – sums, averages and more
Use percentages to find the right ratios
Spotlight your view to emphasize important values
Add totals and subtotals
Create a motion chart after connecting to a new data source
Hands on Practical Sessions

Calculations and Models

Quick Table Calculations
Custom Table Calculations using data in your views
Reference Lines, Bands and Distributions
Model your data with Trend Lines

Day 4

Data management in Tableau

Data items: names, types, roles, properties, attributes and hierarchies
View Data to see the data behind your view
Bins to divide numeric data items
Group dimensions into categories
The power of sets to combine and filter your views

Advanced data management in Tableau

Calculated Fields, Functions, and Parameters
Calculated Fields – power to answer your difficult questions
Calculated Field Operators
Numeric Functions (Singular)
Character Functions (Modify Items)
Character Functions (Locate Values in String)
Date Functions
Type Conversion Functions
Logical Functions (If, Then, Else)
Aggregate Functions
Table Calculation Functions
Parameters add additional control for your analysis
Hands on Practical Sessions

Data Blending

Queries to retrieve the data you need
Data blending to use data from multiple sources in one view
Extracts to accelerate your data exploration in Tableau

Day 5

Deploy and Publish workbooks

Export images to other applications
Export data to other applications or back into Tableau
Print to PDF – export your views to Adobe Reader format
Packaged Workbooks – take Tableau on the road!
Tableau Reader – share packaged workbooks with your colleagues
Tableau Server – powerful insights for everyone!
Tableau Desktop and Tableau Server
Tableau Public – share your insights with the world!
Hands on Practical Sessions

Customer Specific Topics

Hyperlink Access
Regression Analysis
Forecasting
P/E Ratio
Calculations using Statistical Functions
Integration with R model
Social Media Analytics (Data from Twitter , Facebook, etc..)
Best Practices
Performance Tuning / Tipsat Data and Application Level

Tableau Server

Publishing Dashboard on Tableau Server
Creating Users
Creating Project
Embedded code / Tool box
Hands on Practical Sessions


For more information on our training, please call 08103382376 or visit www.habanerodata.net

Progress your career today with Microsoft Power BI training with our 2 day Microsoft Power BI training

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Microsoft Power BI. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Microsoft Power BI course

Our instructor-led training course is designed to deliver dynamic, thorough and relevant content. The courses we offer are taught by experienced & certified practitioners who are passionate about their subject matter.

We recommend Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects who are looking to develop further skills for career progression to attend.

We train professionals in the Oil & Gas, Finance, Insurance, Banking, Telecommunications, Insurance, Retail, Manufacturing and Government.

Click here for course information: http://www.habanerodata.net/courses/powerbi/

Next Courses dates: 15th - 17th April 2019


Course Content:


Day 1

Getting started with Microsoft Power BI

What is Power BI
Understanding BI
Understanding Microsoft Power BI

Power BI Designer

Basic concepts of Power BI
Using Microsoft Power BI to get data
Types of Microsoft Power BI Datasources
Connecting to Data Sources
Merging Queries

Power BI Reports

Creating Power BI Reports
Saving a Power BI Report
Uploading Power BI Designer files
Difference between Report and Dashboards

Refreshing Data in Power BI

Data sources that support refresh in Power BI
Setting up a refresh schedule

Power BI features in Tablets and Mobile

Accessing your report & dashboards from Mobile

Data Alerts

Setting up Data driven alerts
Using Annotations

Day 2

Transforming and shape your Data

Query Overview in Power BI Designer
Shape and Combine Data in Power BI Designer
Common Query Tasks in Power BI
Using Variables under Queries
Error Handing in Queries

Data Modelling within PowerBI

Create and manage relationships in Power BI Designer
Calculated Columns in Power BI Designer
Measures in Power BI Designer
Data Types in Power BI
Sort by Columns in Power BI Designer

Visualistion types in Power BI

Creating a column chart
Creating Bar, Line and Pie Charts
Creating a scatter chart

Power BI Dashboards

Creating a dashboard
Sharing a dashboard

Working with Natural Language using Q & A

How to ask questions in Power BI Q & A
Preparing a workbook for Q & A

Size limit in Power BI

Limitation of the free Power BI subscription

Conclusion


Contact us today to register

Phone:08103382376
Email:training@habanerodata.net
Web:www.habanerodata.net

Hello,

2019 is here! Get the most of your data and advance your career by taking a BI course. Take a look at our First Quarter Dates.

January

1st – 4th January 2019 4 Days Introduction to Python
7th – 11th January 2019 5 Days Tableau Essentials
7th – 11th January 2019 5 Days Introduction to SQL
14th – 18th January 2019 5 Days QlikView Essentials
21st – 25th January 2019 5 Days SQL Reporting Services
21st -25th January 2019 5 Days Introduction to Excel
28th – 30th January 2019 5 Days Introduction to R


February

4th – 8th February 5 Days SQL Integration Services
4th – 5th February 2 Days Introduction to Microsoft Power BI
4th – 8th February 5 Days Tableau Essentials
11th – 15th February 5 Days Introduction to Excel
18th – 22nd February 5 Days Introduction to SAS
18th – 22nd February 5 Days QlikView Essentials
25th -28th February 5 Days Introduction to Python


March

4th – 8th March 5 Days Qliksense Essentials
11th – 15th March 5 Days Tableau Essentials
11th – 15th March 5 Days Introduction to R
18th – 22nd March 5 Days SQL Analysis Services
18th – 22nd March 5 Days Qlikview Essentials
25th – 28th March 5 Days Introduction to Hadoop & Big Data
25th – 29th March 5 Days Introduction to SQL Programming


Contact us today!

Phone:08103382376 (WhatsApp)
Email:training@habanerodata.net
Web:www.habanerodata.net

Office Address:
Habanero Data Solutions Ltd
Capital Square
Garnet Building
Lekki Epe-Express Road
Lekki
Lagos

Progress your career today with a 5 Day Introduction to SQL Programming Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 (WhatsApp) or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Sturctured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server 2016.

III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376 (Whats App)

Progress your career in 2019 with a 5 Day Qlikview Training Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Qlikview. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking a Qlikview course. To enrol or register please call 08103382376 or email training@habanerodata.net


Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to QlikView and Business Intelligence

The course will begin with a brief history & technical view of Business Intelligence. Delegates will then be given an Overview on Data Discovery before moving on to an Introduction to QlikView interface, Data Sources & and exploration of Data Modelling. We will conclude with loading data into QlikView and building your first dashboard.


Day 2

Creating Dashboards

We will continue on the dashboard development started on day one and look further into methods for displaying data. We will go deeper into dashboard design, data visualisation practices and core QlikView front end functionality. Delegates will be given an overview and effectiveness of Listboxes, tableboxes, multiboxes and basic charts.


Day 3

QlikView scripting & data modelling

We will look in more detail at the QlikView back-end and how to load and manipulate new data sources and how best to model data in QlikView, achieving the uppermost performance in your applications.


Day 4

Data Transformations & Advanced Expressions

We will begin to tackle more advanced back-end scripting and front-end expression writing, extending our QlikView capability.


Day 5

Advanced Data Transformations, Set Analysis & Security

We will learn to bring to bear the full power of QlikView using advanced data transformation techniques and set analysis to satisfy advanced reporting requirements and achieve point in time reporting.




Your Trainer

Our international certified trainers are highly experienced QlikView practitioners who have real-world expertise. Our trainers will be able to give you the answers you need.
Key Information

I – All course material including a copy of QlikView 11 for developers will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed QlikView

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

IIII – Our training venue is based in Lagos (Specific venue will be emailed on confirmation of place on the course)

For more information on our training, please enquire using the form above or call 08103382376 (WhatsApp)

Progress your career today with a 5 Day Introduction to SQL Programming Course

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL. Habanero Data Solutions are a provider of Business Intelligence, Analytics, Big Data and Data Visualisation training courses in Nigeria. We deliver a wide range of Business Intelligence courses suitable for the beginner to the more experienced professional. All our courses are designed to enhance you with Business Intelligence skills and knowledge.

Change your career progression by taking an Introduction to SQL Progamming course. To enrol or register please call 08103382376 (WhatsApp) or email training@habanerodata.net



This 5 day hands on course is ideal for beginners new to databases and SQL programming language. The course will benefit anyone (technical & non-technical) who needs to understand and use SQL to manipulate a database.

The course will provide participants with the key concepts of databases and structured query lanaguage (SQL). Participants will learn how to read and write simple and complex SQL statements. Participants will gain a solid working knowledge of this powerful and universal database programming language. At the end of the course delegates would have gained a solid understanding of relational databases and SQL (Structured Query Langauge).

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL.

Audience: Business Analysts, Developers, IT Administrators, Sales Managers

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Course Syllabus:

Day 1

Introduction to databases and SQL (Sturctured Query Language)

On the first day delegates will learn about the basic structure and history of relational datbases. Delegates will then understand what SQL is and how it used with a relational database.

Overview of Relational Database Concepts
What is a relational database management system?
Databases! Why do we need them?
Relational Datbase Structures
Brief overview of typical databases: Microsoft Access and SQL Server
Introduction to SQL:
Overview of SQL (Stuructured Query Lanaguage)
Database building blocks: Tables, Columns, Primary key, Foreign Keys, Data Types, Indexes
Building a database
Creating tables and columns
Building tables with CREATE TABLE
Altering tables with ALTER TABLE
How to add columns to existing tables
How to add a Primary Key
How to add a Foreign Key
Adding a Data Type to a Table
How to improve performance with Indexes
Selecting Data: The SELECT statement
Setting Criteria using WHERE Clause
Inserting into a Table: The INSERT Statement
Updating a Table: The UPDATE Statement
Modifying a Table structure with ALTER Statement
Deleting from a Table: The DELETE Statement
Removing a tables with DROP statement

Day 2

Manipulating Data

How to add Table Row with INSERT
How to change rows with UPDATE
How to remove row with DELETE
Filtering Data
Having Clause
Order By
Joining Database Tables
Overview of Table Joins
Table Aliasas
Inner Joins
Outer Joins
Self Joins
Other Joins
Cross Joins
Full Outer joins
Aggregation and Grouping
Summarizing and Grouping Data

Day 3

Functions, Subqueries and Aggregated Data

Overview of SQL Functions
Creating Functions
Working with Subqueries
SUM, AVG, MIN, MAX
Ways to count
Group By Clause
Filtering data using the Having Clause
Overview of Subqueries
Basic Subqueries
String Functions

Day 4

Understanding views & performing analytics with functions

Date and Time Functions
Text Functions
NULL Functions
Overview of Stored Procedures
Creating Stored Procedures
Passing Parameters
Basic Variables
Creating and Understanding Views
Understanding Triggers & Cursors
Creating Unions

Day 5

Transactions and Concurrency and Programmble Objects

Introduction to Transactions
Transaction Control
Controlling transactions with COMMIT command and ROLLBACK command
Using BEGIN TRANSACTION in SQL SERVER
Properties of Transactions
Locks and Blocking
Isolation Levels
Deadlocks
Variables
Cursors
Temporary Tables
Dynamic SQL
Error Handling

Your Trainer

Our international certified trainers are highly experienced SQL practitioners who have real-world expertise.
Key Information

I – All course material including a copy of Head First SQL book will be provided to all candidates.

II – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server 2016.

III – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of place on the course).

For more information on our training, please enquire use the form above or call 08103382376 (Whats App)