HabanerTraining's Posts
Nairaland Forum › HabanerTraining's Profile › HabanerTraining's Posts
1 2 3 4 5 6 7 8 9 10 11 12 (of 16 pages)
 Certification And Training Adverts › 18th - 22nd March 2019 Qlikview Essentials Course In Lagos by HabanerTraining(op): 11:48pm On Feb 17, 2019 |
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
|
| Certification And Training Adverts › 25th - 28th February 2019 Introduction To Python Course In Lagos by HabanerTraining(op): 9:23pm On Feb 09, 2019 |
Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Python. 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 Python 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: 4 Days, 32 Academic Hours About the Course: The course is aimed at Professionals looking to learn a simple but powerful modern programming language. The course will introduce participants to all the most essential and practical applications of Python programming language for data manipulation, management, analysis and basic visualisations. The course will also look to provide you with practical skills in general Python programming language and a number of Python libraries designed for scientific computing and data analysis e.g NumPy, pandas, matplotlib, IPython, SciPy etc. Upon completion of the course participants will have gained the skills to: - Understand programming in Python Syntax - Enable Python libraries - Collect data from various data sources - Clean and prepare data - Visualise the data Day One Introduction to Python Python History Python 2 vs Python 3 When to use Python Installing Python The Python Interface Python Set up The Python console Installing Pycharm Types, Statements and Other Goodies Introduction Types in Python – Wait, What? Integers and Floats Strings Data Types Numbers Sequences File Tuples Dictionaries Logic If Statement If Else Statement Switch Statement Loops While Loop Do…While Loop For Loop Foreach Loop Break and Continue Functions Declarations Variable Scope Passing Values Objects OO Programming Class declaration Methods & Properties Day 2 Data Analysis Introduction Why Python for Data Analysis Popular packages Use cases Popular Libraries Panda Numpy SeaBorn Stats Matplotlib Scikit-learn Working with data Reading & Writing to different data sources Cleaning data Visualisation Data Transformation Automation Day 3 Functions, Files, Yield, and Lambda Module Overview Our App – PyStudentManager Functions Function Arguments Adding Students to Our App Nested Functions and Closures Opening, Reading, and Writing Files Yield Lambda Functions Class work Summary APIs Connecting to an API Public BigQuery APIs Google Analytics API Day 4 Object Oriented Programming – Classes and Why Do We Need Them? Module Overview Classes and Why Do We Need Them? Defining a Class in Python Adding Methods to Our Class Constructor and Other Special Methods Instance and Class Attributes Breaking Our App into Modules Class work Summary Putting It All Together – Let’s Make It a Web App Module Overview Installing Python Packages and Flask Making Our App a Web App How Much Code Did We Share? Class work Summary Python Tips and Tricks 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 Python for developers will be provided to all candidates. II – Laptops will be provided for all candidates with pre-installed Python 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
|
| Certification And Training Adverts › 18th - 22nd March 2019 Qlikview Essentials Course In Lagos by HabanerTraining(op): 1:49pm On Feb 02, 2019 |
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
|
| Certification And Training Adverts › Habanero Data Solutions Business Intelligence Q1 2019 Training Dates by HabanerTraining(op): 9:40am On Jan 30, 2019 |
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 Email:training@habanerodata.net Web:www.habanerodata.net Office Address: Habanero Data Solutions Ltd Capital Square Garnet Building Lekki Epe-Express Road Lekki Lagos
|
| Certification And Training Adverts › 18th - 22nd March 2019 Qlikview Essentials Course In Lagos by HabanerTraining(op): 8:16pm On Jan 28, 2019*. Modified: 9:22pm On Jan 28, 2019 |
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 07035368449 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
|
| Certification And Training Adverts › Habanero Data Solutions Business Intelligence Q1 2019 Training Dates by HabanerTraining(op): 10:52pm On Jan 21, 2019 |
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 1 Like
|
| Certification And Training Adverts › 18th - 22nd February Qlikview Essentials Course In Lagos by HabanerTraining(op): 5:37pm On Jan 06, 2019 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › Habanero Data Solutions Business Intelligence Q1 2019 Training Dates by HabanerTraining(op): 10:31pm On Dec 27, 2018*. Modified: 9:38am On Jan 30, 2019 |
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 Email:training@habanerodata.net Web:www.habanerodata.net Office Address: Habanero Data Solutions Ltd Capital Square Garnet Building Lekki Epe-Express Road Lekki Lagos
|
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Lagos 26th - 30th November by HabanerTraining(op): 9:45pm On Nov 07, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › 26th - 30th November 2018 Tableau Essentials Course In Lagos! Enrol Now! by HabanerTraining(op): 10:00pm On Oct 31, 2018 |
Progress your career today with a 5 Day Tableau Training Course 26th - 30th November 2018: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 24th - 28th September Introduction To SQL Programming Course In Lagos by HabanerTraining(op): 9:16pm On Oct 30, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Lagos 26th - 30th November by HabanerTraining(op): 9:40pm On Oct 24, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Lagos 26th - 30th November by HabanerTraining(op): 8:15pm On Oct 21, 2018*. Modified: 11:35am On Nov 06, 2019 |
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 07035368449 |
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Lagos 26th - 30th November by HabanerTraining(op): 6:45pm On Oct 14, 2018 |
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 07035368449 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 07035368449 (Modify) (Quote) (Report) (Share)
|
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Lagos 26th - 30th November by HabanerTraining(op): 8:21am On Oct 10, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › 8th - 12th October 2018 Tableau Essentials Course In Lagos! Enrol Now! by HabanerTraining(op): 7:58am On Sep 27, 2018 |
Progress your career today with a 5 Day Tableau Training Course 8th - 12th October 2018: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 8th - 12th October 2018 Tableau Essentials Course In Lagos by HabanerTraining(op): 7:32am On Sep 13, 2018*. Modified: 10:14am On Dec 11, 2019 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September 2018: 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 08103383276 or visit www.habanerodata.net
|
| Certification And Training Adverts › 10th - 14th September Tableau Essentials Course In Lagos by HabanerTraining(op): 7:20am On Aug 21, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September 2018: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 10th - 14th September Tableau Essentials Course In Lagos by HabanerTraining(op): 3:35pm On Aug 18, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September 2018: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 10th - 14th September Tableau Essentials Course In Lagos by HabanerTraining(op): 8:01am On Aug 16, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September 2018: 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 07035368449 or visit[url] www.habanerodata.net[/url]
|
| Certification And Training Adverts › 24th - 28th September Introduction To SQL Programming Course In Lagos by HabanerTraining(op): 7:49am On Aug 16, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › 10th - 14th September Tableau Essentials Course In Lagos by HabanerTraining(op): 8:48am On Aug 09, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September 2018: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 24th - 28th September Introduction To SQL Programming Course In Lagos by HabanerTraining(op): 9:51pm On Aug 08, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › 10 - 14th September Tableau Essentials Training Course In Lagos by HabanerTraining(op): 1:11am On Aug 04, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September 2018: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 24th - 28th September Introduction To SQL Programming Course In Lagos by HabanerTraining(op): 7:53am On Aug 02, 2018 |
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 07035368449 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 07035368449
|
| Certification And Training Adverts › 10 - 14th September Tableau Essentials Training Course In Lagos by HabanerTraining(op): 7:55am On Jul 30, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › 10 - 14th September Tableau Essentials Training In Lagos by HabanerTraining(op): 9:50pm On Jul 22, 2018 |
Progress your career today with a 5 Day Tableau Training Course 10th - 14th September: 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 07035368449 or visit www.habanerodata.net
|
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Lagos 27th - 31st August 2018 by HabanerTraining(op): 9:32pm On Jul 15, 2018*. Modified: 11:40am On Nov 06, 2019 |
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
|
| Certification And Training Adverts › Introduction To Python Course In Abuja 13th - 16th July by HabanerTraining(op): 7:27am On Jun 25, 2018 |
Introduction to Python Course - 13th - 16th July 2018 This 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 operations, working with data, and using Python modules. 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 Course Introduction Introduction to Python What makes Python so amazing Python 2 vs Python 3 When to use Python Installing Python Python Set up The Python Interface The Amazing Python console Installing Pycharm Types, Statements, and Other Goodies Introduction Types in Python – Wait, What? Integers and Floats Strings Boolean and None If Statements Lists Loops Break and Continue While Loops Dictionaries Exceptions Other Data Types Class work Summary Day 2 Functions, Files, Yield, and Lambda Module Overview Our App – PyStudentManager Functions Function Arguments Adding Students to Our App Nested Functions and Closures Opening, Reading, and Writing Files Yield Lambda Functions Class work Summary Day 3 Object Oriented Programming – Classes and Why Do We Need Them? Module Overview Classes and Why Do We Need Them? Defining a Class in Python Adding Methods to Our Class Constructor and Other Special Methods Instance and Class Attributes Breaking Our App into Modules Class work Summary Day 4 Putting It All Together – Let’s Make It a Web App Module Overview Installing Python Packages and Flask Making Our App a Web App How Much Code Did We Share? Class work Summary Python Tips and Tricks Your Trainer Our international certified trainers are highly experienced Python trainers who have real-world expertise. Key Information Key Information: I – All course material including a copy of Python for beginners guide book will be provided to all candidates. II – Laptops will be provided for all candidates with pre-installed Python. 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 at www.habanerodata.net or call 07035368449
|
| Certification And Training Adverts › 3 Day Introduction To R For Data Analysis Course In Lagos - 18th - 20th July by HabanerTraining(op): 9:35pm On Jun 22, 2018 |
Progress your career today with a 3 Day Introduction to R Programming Training for Data Analysis Course **50% Discount applies in July 2018** The introduction to R programming course will help you understand and master the basics of R. The course will cover the basic syntax of R enabling you to undertake your own first data analysis using R. You will learn how to get going in R from the begining, understand file formats, basic R syntax from data objects to functions, graphics. and learn using text editors to write code. You will learn how to read files, use symbols and assignments and iterate simple loops. The course is suitable for complete beginners and no prior R programming knowledge is assumed. To enrol on this course, please call 07035368449 to register or email:training@habanerodata.net Day 1 Getting started with R Installing, starting and stopping R The R Console R and statistics R and the window system File Operations and file formats Writing code and text editors Basic R syntax Reading files Symbols and assignment Loops Sequences Simple Loops(iteration) Vectors Numeric vectors Special values Numeric summaries Text Text Processing Regular expressions Search, replace, split, paste Day 2 Reading Data Data Frames Matrices and data frames and Lists Free-format Input Fixed-Format Input Printing Data and Summaries Plotting Data Data processing Dates Dates Classes and generic functions Linear Models Fitting a Model Examining a Fit Extracting Results Factors and Covariates Regression Splines Generalized Linear Models Variance and Link Families Logistic Regression Updating Models Model Selection Day 3 Data Structures Data structures Subsetting Assigning to subsets Data Manipluation Apply functions Graphics Scatterplots Exporting Graphics Boxplots Histograms Density Plots Text Plots Faceting Common Aesthetics Your Trainer Our international certified trainers are highly experienced R 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 R: Easy R Programming for Beginners will be provided to all candidates. II – Laptops will be provided for all candidates with pre-installed R 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)
|
| Certification And Training Adverts › 3 Day Introduction To R For Data Analysis Course In Lagos - 18th - 20th July by HabanerTraining(op): 8:29am On Jun 12, 2018 |
Progress your career today with a 3 Day Introduction to R Programming Training for Data Analysis Course The introduction to R programming course will help you understand and master the basics of R. The course will cover the basic syntax of R enabling you to undertake your own first data analysis using R. You will learn how to get going in R from the begining, understand file formats, basic R syntax from data objects to functions, graphics. and learn using text editors to write code. You will learn how to read files, use symbols and assignments and iterate simple loops. The course is suitable for complete beginners and no prior R programming knowledge is assumed. To enrol on this course, please call 07035368449 to register or email:training@habanerodata.net Day 1 Getting started with R Installing, starting and stopping R The R Console R and statistics R and the window system File Operations and file formats Writing code and text editors Basic R syntax Reading files Symbols and assignment Loops Sequences Simple Loops(iteration) Vectors Numeric vectors Special values Numeric summaries Text Text Processing Regular expressions Search, replace, split, paste Day 2 Reading Data Data Frames Matrices and data frames and Lists Free-format Input Fixed-Format Input Printing Data and Summaries Plotting Data Data processing Dates Dates Classes and generic functions Linear Models Fitting a Model Examining a Fit Extracting Results Factors and Covariates Regression Splines Generalized Linear Models Variance and Link Families Logistic Regression Updating Models Model Selection Day 3 Data Structures Data structures Subsetting Assigning to subsets Data Manipluation Apply functions Graphics Scatterplots Exporting Graphics Boxplots Histograms Density Plots Text Plots Faceting Common Aesthetics Your Trainer Our international certified trainers are highly experienced R 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 R: Easy R Programming for Beginners will be provided to all candidates. II – Laptops will be provided for all candidates with pre-installed R 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)
|
| Certification And Training Adverts › Introduction To SQL Programming Training Course In Abuja 25th - 29th June by HabanerTraining(op): 7:25am On May 30, 2018 |
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 07035368449 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 07035368449
|
