Home>>training>>our-packages
Delegates to this course will learn how to use SSIS a component of Microsoft Business Intelligence package software to building enterprise-level data integration and data transformations solutions. It is a robust ETL tool that is needed when creating a Data Warehousing application or migrating data from one source to another.
Course content
Who should attend
This course comprehensively covers SQL Server as a full-featured RDMS with support for robust server-side development and data duplication. You will be taken through T-SQL to manipulate and administer data in databases. Also you will learn how to use and develop high-performance database applications. Knowledge of this language is essential for all people who are developing applications for SQL Server or planning on doing so in the nearest future.
Course content
Who should take this course?
This course comprehensively covers SAS Macro Language. The theory and methods of the SAS Macro facility are dealt with through examples and applications. Delegates to this course will become more productive and understand how to filter data and give it meaning. You'll learn new and immediately actionable tip to help you build your community, track engagement, measure analytics, generate brand awareness, or help you accomplish other goals as desired.
Course content
Who Should Attend
This course is a training course for the fundamentals of SAS – data access, manipulation, analysis and reporting. Delegates to this course will become more productive and understand how to filter data and give it meaning. You'll learn new and immediately actionable tip to help you build your community, track engagement, measure analytics, generate brand awareness, or help you accomplish other goals as desired.
Course content
Who Should Attend
Delegates to this course will Learn how to understand customer better by segmenting them using unique identifiers. At KCL we believe every customer is different, so on this course you’ll learn a variety of skills, tool and techniques on how to harness the uniqueness of each customer to the advantage of any business.
Course content
Who should Attend
At the completion of the course, you can work across industries with pleasant pays. This course will implant the knowledge of how to understand customers based on their segmented features. It will also enable you to apply the Cluster analysis, Factor analysis and Decision trees confidently.
Skills needed are:
Delegates to this course will become more productive and boost the impact of your marketing efforts with this course. You'll learn new and immediately actionable tip to help you build your community, track engagement, measure analytics, generate brand awareness, or help you accomplish other marketing goals.
Course content
Who Should Attend
Delegates to this course will covers the core concepts of database administration, including securing the server with user authentication and roles, assigning object-level permissions, and performing a backup and restore. Along the way, he'll provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned
Course content
Who should attend
This course will train you and enable
you to work with businesses of all kinds. It will give you the knowledge and
skills to restore database, create backups, inspect database, evaluate their
conditions, carry out required maintenance, observe database to ensure maximum
productivity.
Skills needed are:
Delegates to this course will learn to make use of direct marketing to manage campaigns targeting customers based on their preferences. Using dedicated tools, you will be able to carry out effective marketing campaigns which will increase customer base and productivity.
Course content
Who should attend
Delegates to this course will learn to build reporting dashboards for marketing insight using advanced SQL querying skills, integrate Excel with SQL and use this to structure marketing plans.
You will also learn to identify reporting resources within data elements, transform data from databases into answer tools for stakeholders.
Course content
Who should attend
This course will enable you
understand various customer segmentation, the failures and successes of the
customer segmentation, interpretation of customer data, marketing
communications and services communication.
Skills needed are:
Ms Excel 1
Advanced Ms Excel 2
Direct Marketing
Transact SQL RDBMS & Querying
KCL’S Work Experience Project
CV and
Interview Preparation.
The course will groom students with a variety of skills, tools and techniques to understand data and analyse big data set over huge computer clusters within seconds, real time data and examine business problems, bring about key business solutions in a structured manner.
Course content
Who should attend
Google Big Query Expert as a Package Programme
This course will enable individual to analyse large number of data, automate business reporting templates, understand how to identify patterns, trends and relationship in data. These skills outlined have hands-on practices and the learning environment is designed to stimulate a typical work environment.
Skills needed include:
Delegates to this course will learn financial analysis and modelling portfolio and it involves analyzing large volumes of financial, operational and transaction data. As a finance analyst, you will be equipped to maintain daily cash flow spreadsheets for all bank accounts; prepayment and accruals, P&L, Reconcile relevant balance sheet accounts on a regular basis.
Course content
Who should attend
This course has
a very importance in all organisations. The skills you acquire will be regularly
in high demand within the Finance sector and Non-finance sector as a database
analyst. It is highly recommended for individual who has successfully attained
a study in Professional programs like; ACCA and CIMA.
Skills needed
are:
Delegates to this course will learn how to provide detail level analysis and report essential for business to understand operational and commercial outcome at every point. You will collect raw data manipulate them based on requirements and transform them into tools used for strategic decisions making.
This course will enable you to know when and why to use the various techniques, how to apply them and how to interpret their output. This course will also educate you on the understanding of Factor Analysis, K-means cluster Analysis, Two-step analysis.
Course content
Who should attend
Data Analyst with SPSS as a Package Programme
This course will enable you to know
when and why to use the various techniques, how to apply them and how to
interpret their output. This course will also educate you one the understanding
of Factor Analysis, K-means cluster Analysis, Two-step analysis.
Skills needed
are:
Delegates to this course will learn to perform frequent repeatable operational reporting, testing and technical maintenance activities to support the MI Data Analyst and Insight. to meet organizational requirements e.g. MI reports, Ad-hoc reports, self-updating charts and graphs.
You will also learn to identify reporting resources within data elements, transform data from databases into answer tools for stakeholders.
What these types of analysts do is to provide strategic management information reports to senior management and stakeholders to support business understanding and decision making. Your job will involve running large volumes of data through analytical process and producing reports weekly, monthly or on an ad-hoc basis
Course content
Who should attend
You will learn how to use SSAS as an online analytical data engine to boost decision making process and provide analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports and other data visualization tools.
Every organisation needs business intelligence to automate the maintenance of its information delivery to users. The velocity and variety of data flooding businesses today poses huge challenges. This means that the traditional methods of querying, extracting and reporting are no longer sufficient.
As a Business Intelligence Analyst, with SSAS skills, you will help organisations automate complex data analysis processes by building OLAP reporting cubes. This programme provides the broader Business Intelligence skills, with focus on SQL Server Analysis Services.
Course content
Who should attend
As an MI analyst, you will be responsible for providing professional, effective and insightful management information and marketing alaysis and performance reports. You will be pivotal to making information insight available and accessible to various business functions and departments. You will also be responsible for collating and analysing daily, weekly and monthly reports to support strategic decision making.
Course content
Who should attend
Delegates to this course will learn how to use SSRS as a solution that you can deploy for creating, publishing, and managing reports, then delivering them in different ways, whether that’s viewing them in web browser, on mobile devices, or as an email. Some of the benefit of this training includes:
Course content