₦airaland Forum

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

10th - 14th February 2020: 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 2019.4

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

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

Progress your career today with our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 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: 13th-14th January 2020
Venue: Lagos


Contact us today to register

Phone:08103382376
[b]Email:[/b]training@habanerodata.net

Introduction to Python Course - 24th - 27th February 2020
Location: Lagos

Python is the most popular programming language today, and its developers are constantly in high demand. As it continues to increase in popularity, it's becoming the closest thing to a must-know language for every programmer.

On this 4 day we will help you accelerate your career in this top programming language. Our course is aimed at anyone who wants to learn a simple but powerful modern programming language. The course leads participants from the basics of writing and running Python scripts to more advanced features such as file operartions, working with data and using Python Modules.

By the end of the course, you'll be familiar with the concept of data structures and functional programming in Python.

To register or for more details on the course, call 08103382376 or 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: 13th-14th January 2020


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

Introduction to Python Course - 24th - 27th February 2020 Location: Lagos

Python is the most popular programming language today, and its developers are constantly in high demand. As it continues to increase in popularity, it's becoming the closest thing to a must-know language for every programmer.

On this 4 day we will help you accelerate your career in this top programming language. Our course is aimed at anyone who wants to learn a simple but powerful modern programming language. The course leads participants from the basics of writing and running Python scripts to more advanced features such as file operartions, working with data and using Python Modules.

By the end of the course, you'll be familiar with the concept of data structures and functional programming in Python.

To register or for more details on the course, call 08103382376 or 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: 13th-14th January 2020


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 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 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: 13th-14th January 2020


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[b][/b]

Progress your career today with our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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[code][/code]

Progress your career today with a 5 Day Tableau Training Course

6th - 10th January 2020: 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 or visit www.habanerodata.net

Places still available.

Progress your career today with our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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[b] Data Analysts, Developers, Data Managers, IT Administrators, Business Intelligence Analysts, Data Architects[/b] 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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[code][/code]

Progress your career today with our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 Tableau Training Course

9th - 13th December 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: 12th-13th December 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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 our Business Intelligence training. We're 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 Business Intelligence course. We train our participants on some of the most comprehensive business intelligence (BI) platforms on the market including: Tableau, Qlikview, Microsoft PowerBI, R, Python, Hadoop, Microsoft SQL BI, Cognos, Microstrategy, Informatica, SAP, SAS to name a few.

Whether you are looking to learn a new Business Intelligence software package or increase your level of knowledge in a particular BI package, we can help. Our instructor-led training courses are 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.


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 Tableau Training Course

2nd - 6th December 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: 4th-5th November 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 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: 14th-15th October 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

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