Business Intelligence Training Courses in the Philippines

Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.

Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.

Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.

The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.

The participant will acquire knowledge of scripting XML / A and MDX.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data scientists who wish to use Alteryx for data analysis.

By the end of this training, participants will be able to:

- Prepare data in Alteryx to later visualize in Power BI or Excel.
- Create and Perform ETL operations with little to no code.
- Embed custom R code inside Alteryx.

This instructor-led, live training in the Philippines (online or onsite) is aimed at technical persons who wish to gain a practical understanding of available cloud solutions, the data analysis processes needed to work with data in the cloud, and the hands-on practice to apply tools such as Power BI to analyze data.

By the end of this training, participants will be able to:

- Install and configure Power BI.
- Evaluate the various data solutions offered by cloud providers such as Azure.
- Gain an understanding of the different structures, modeling approaches, and data warehouse designs used to store, manage and access Big Data.
- Apply tools and techniques to clean data in preparation for analysis.
- Build reporting and analytics solutions based on on-premise as well as cloud data.
- Integrate data analytics solutions with a data warehouse.
- Mitigate data security risks and ensure data privacy.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts and data scientists who wish to search, analyze, and visualize data using Splunk.

By the end of this training, participants will be able to:

- Install and configure Splunk.
- Collect and index all kinds of machine data.
- Implement real-time search, analysis and visualization of large datasets.
- Create and share complex dashboards and reports.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.

By the end of this training, participants will be able to:

- Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
- Use DAX formulas in Power BI for complex calculations.
- Create and use visualizations and charts for particular analysis cases.
- Import with Power View to move from Excel based Power BI to independent Power BI.

This instructor-led, live training in the Philippines (online or onsite) is aimed at content managers who wish to optimize and update company content with IRIS.

By the end of this training, participants will be able to:

- Improve business reports using IRISXtract.
- Use IRISPowerscan to file documents automatically.
- Process purchase orders, accounts payable, automate email extraction, and more with solution packages.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to program in SAS for advanced data management, data analysis, and more.

By the end of this training, participants will be able to:

- Master macros to write efficient SAS programs.
- Train a model and make predictions on unseen data with predictive modeling.
- Create charts and plots for data visualization.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to analyze large data sets with Stata.

By the end of this training, participants will be able to:

- Create statistic models for predicting key interest variables and events.
- Generate descriptive visualizations, summary tables, frequencies, and more.
- Manage and structure large databases, ready for data analysis.

This instructor-led, live training in the Philippines (online or onsite) is aimed at business analysts who wish to automate trade with algorithmic trading, Python, and R.

By the end of this training, participants will be able to:

- Employ algorithms to buy and sell securities at specialized increments rapidly.
- Reduce costs associated with trade using algorithmic trading.
- Automatically monitor stock prices and place trades.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data scientists who wish to program in R for Tableau.

By the end of this training, participants will be able to:

- Implement Tableau analytics with R.
- Return values to Tableau with learning algorithms in R.
- Structure and visualize R functions in Tableau.
- Make data driven decisions for business operations.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts and web developers who wish to develop associative models in Qlik Sense.

By the end of this training, participants will be able to:

- Apply Qlik Sense in data science.
- Use and navigate the Qlik Sense interface.
- Build a data literate workforce with AI interaction.
- Create a data-driven enterprise with Qlik Sense.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to program with R in SAS for cluster analysis.

By the end of this training, participants will be able to:

- Use cluster analysis for data mining
- Master R syntax for clustering solutions.
- Implement hierarchical and non-hierarchical clustering.
- Make data-driven decisions to help to improve business operations.

This instructor-led, live training in the Philippines (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.

By the end of this training, participants will be able to:

- Analyze and share insights about data.
- Visualize business performance.
- Use AI-assisted preparation to cleanse and combine data sources.
- Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.

Tableau helps people see and understand data.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to use Google Sheets for data analysis.

By the end of this training, participants will be able to:

- Build spreadsheets with Google Sheets.
- Use formulas that work both in Google Sheets and Excel.
- Format and analyze any data.
- Create data visualizations with charts and graphs.

This instructor-led, live training in (online or onsite) is aimed at data analysts who wish to use Stata and R to analyze big data for statistical analysis.

By the end of this training, participants will be able to:

- Create statistic models for predicting key interest variables and events.
- Generate descriptive visualizations, summary tables, frequencies, and more.
- Manage and structure large databases to preapare for data analysis.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data scientists who wish to use Alteryx to prepare data for visualization and analysis.

By the end of this training, participants will be able to:

- Preapre data with Alteryx to visualize later.
- Perform ETL operations with zero code.
- Leverage Alteryx to improve business intelligence and business analytics.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to use Alteryx for data processing and data visualization.

By the end of this training, participants will be able to:

- Leverage Alteryx to improve business intelligence and business analytics.
- Perform ETL operations with zero code.
- Visualize data with a data analytical suite, such as Excel.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts and data scientists who wish to search, analyze, and visualize data using Tableau.

By the end of this training, participants will be able to:

- Connect to your data.
- Edit and save a data source.
- Understand Tableau terminology.
- Use the Tableau interface / paradigm to effectively create powerful visualizations.
- Create calculations including arithmetic calculations, custom aggregations and ratios, date math, and table calculations.
- Represent your data using different visualization types.
- Build dashboards to share visualizations.

This instructor-led, live training in the Philippines (online or onsite) is aimed at system administrators who wish to set up and manage Tableau Server.

By the end of this training, participants will be able to:

- Install and configure Tableau Server.
- Set up users, roles and permissions to get a team up and running.
- Access various data sources, manage content and access to the content by users.
- Automate administrative tasks, including monitoring and log management.
- Deploying Tableau Server to cluster.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts who wish to prepare and shape data using Tableau Prep Builder.

By the end of this training, participants will be able to:

- Install Tableau Prep.
- Understand and implement a Data Science Workflow.
- Read data from a variety of sources, such as Excel and databases.
- Prepare, shape and sample data for analysis in Tableau Desktop.
- Explore and validate data.
- Create and publish Tableau Prep flows.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts, data scientists and data engineers who wish to carry out advanced data search, analytics, and visualization using Splunk.

By the end of this training, participants will be able to:

- Create a Splunk application and a technology add-on.
- Use different data input methods and sources.
- Implement advanced search, analysis and visualization of large datasets.
- Customize and share dashboards and reports.

This instructor-led, live training in the Philippines (online or onsite) is aimed at engineers who wish to get data into Splunk Indexers and manipulate data in Splunk.

By the end of this training, participants will be able to:

- Use different data input methods and sources.
- Install, configure, manage and moniter Forwarders.
- Manipulate raw data in Splunk.
- Create a Splunk Diag.

This instructor-led, live training in the Philippines (online or onsite) is aimed at data analysts, data scientists and data engineers who wish to carry out advanced data analytics and visualization using Apache Superset.

By the end of this training, participants will be able to:

- Install and configure Apache Superset.
- Implement advanced data analysis and visualization using Apache Superset.
- Customize and share dashboards and reports.
- Managing security in Apache Superset.

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.

In this instructor-led, live training, participants will learn how to start developing with QlikView.

By the end of this training, participants will be able to:

- Install and configure QlikView
- Transform data from various sources through QlikView scripting
- Build data models with QlikView

Format of the Course

- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.

Course Customization Options

- To request a customized training for this course, please contact us to arrange.

Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their devices.

This instructor-led, live training (online or onsite) is aimed at business managers, business analysts, data analysts, report developers, and team leads who wish to design a perfect Power BI dashboard.

By the end of this training, participants will be able to:

- Design beautiful and efficient dashboards following the critical rules.
- Choose the right charts based on the kind of data for display.

Format of the Course

- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.

Course Customization Options

- To request a customized training for this course, please contact us to arrange.

This instructor-led, live training (online or onsite) is aimed at data analysts and data scientists who wish to explore, organize, and visualize data using Apache Superset.

By the end of this training, participants will be able to:

- Install and configure Apache Superset.
- Combine data from different databases.
- Visualize large datasets.
- Create and share complex dashboards.

Format of the Course

- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.

Course Customization Options

- This training is based on the latest version of Apache Superset.
- To request a customized training for this course, please contact us to arrange.
- To learn more about Apache Superset, please visit: https://superset.incubator.apache.org

Advances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of mobile devices and applications, smart sensors and devices, cloud computing solutions, and citizen-facing portals. As digital information expands and becomes more complex, information management, processing, storage, security, and disposition become more complex as well. New capture, search, discovery, and analysis tools are helping organizations gain insights from their unstructured data. The government market is at a tipping point, realizing that information is a strategic asset, and government needs to protect, leverage, and analyze both structured and unstructured information to better serve and meet mission requirements. As government leaders strive to evolve data-driven organizations to successfully accomplish mission, they are laying the groundwork to correlate dependencies across events, people, processes, and information.

High-value government solutions will be created from a mashup of the most disruptive technologies:

- Mobile devices and applications
- Cloud services
- Social business technologies and networking
- Big Data and analytics

IDC predicts that by 2020, the IT industry will reach $5 trillion, approximately $1.7 trillion larger than today, and that 80% of the industry's growth will be driven by these 3rd Platform technologies. In the long term, these technologies will be key tools for dealing with the complexity of increased digital information. Big Data is one of the intelligent industry solutions and allows government to make better decisions by taking action based on patterns revealed by analyzing large volumes of data — related and unrelated, structured and unstructured.

But accomplishing these feats takes far more than simply accumulating massive quantities of data.“Making sense of thesevolumes of Big Datarequires cutting-edge tools and technologies that can analyze and extract useful knowledge from vast and diverse streams of information,” Tom Kalil and Fen Zhao of the White House Office of Science and Technology Policy wrote in a post on the OSTP Blog.

The White House took a step toward helping agencies find these technologies when it established the National Big Data Research and Development Initiative in 2012. The initiative included more than $200 million to make the most of the explosion of Big Data and the tools needed to analyze it.

The challenges that Big Data poses are nearly as daunting as its promise is encouraging. Storing data efficiently is one of these challenges. As always, budgets are tight, so agencies must minimize the per-megabyte price of storage and keep the data within easy access so that users can get it when they want it and how they need it. Backing up massive quantities of data heightens the challenge.

Analyzing the data effectively is another major challenge. Many agencies employ commercial tools that enable them to sift through the mountains of data, spotting trends that can help them operate more efficiently. (A recent study by MeriTalk found that federal IT executives think Big Data could help agencies save more than $500 billion while also fulfilling mission objectives.).

Custom-developed Big Data tools also are allowing agencies to address the need to analyze their data. For example, the Oak Ridge National Laboratory’s Computational Data Analytics Group has made its Piranha data analytics system available to other agencies. The system has helped medical researchers find a link that can alert doctors to aortic aneurysms before they strike. It’s also used for more mundane tasks, such as sifting through résumés to connect job candidates with hiring managers.

Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion.

In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources.

By the end of this training, participants will be able to:

- Create, curate, and interactively explore an enterprise data lake
- Access business intelligence data warehouses, transactional databases and other analytic stores
- Use a spreadsheet user-interface to design end-to-end data processing pipelines
- Access pre-built functions to explore complex data relationships
- Use drag-and-drop wizards to visualize data and create dashboards
- Use tables, charts, graphs, and maps to analyze query results

Audience

- Data analysts

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

Overview

Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow at a compound annual growth rate (CAGR) of 78 percent to 2016, reaching 10.8 exabytes per month.

Meanwhile, CSPs are generating large volumes of data, including call detail records (CDR), network data and customer data. Companies that fully exploit this data gain a competitive edge. According to a recent survey by The Economist Intelligence Unit, companies that use data-directed decision-making enjoy a 5-6% boost in productivity. Yet 53% of companies leverage only half of their valuable data, and one-fourth of respondents noted that vast quantities of useful data go untapped. The data volumes are so high that manual analysis is impossible, and most legacy software systems can’t keep up, resulting in valuable data being discarded or ignored.

With Big Data & Analytics’ high-speed, scalable big data software, CSPs can mine all their data for better decision making in less time. Different Big Data products and techniques provide an end-to-end software platform for collecting, preparing, analyzing and presenting insights from big data. Application areas include network performance monitoring, fraud detection, customer churn detection and credit risk analysis. Big Data & Analytics products scale to handle terabytes of data but implementation of such tools need new kind of cloud based database system like Hadoop or massive scale parallel computing processor ( KPU etc.)

This course work on Big Data BI for Telco covers all the emerging new areas in which CSPs are investing for productivity gain and opening up new business revenue stream. The course will provide a complete 360 degree over view of Big Data BI in Telco so that decision makers and managers can have a very wide and comprehensive overview of possibilities of Big Data BI in Telco for productivity and revenue gain.

Course objectives

Main objective of the course is to introduce new Big Data business intelligence techniques in 4 sectors of Telecom Business (Marketing/Sales, Network Operation, Financial operation and Customer Relation Management). Students will be introduced to following:

- Introduction to Big Data-what is 4Vs (volume, velocity, variety and veracity) in Big Data- Generation, extraction and management from Telco perspective
- How Big Data analytic differs from legacy data analytic
- In-house justification of Big Data -Telco perspective
- Introduction to Hadoop Ecosystem- familiarity with all Hadoop tools like Hive, Pig, SPARC –when and how they are used to solve Big Data problem
- How Big Data is extracted to analyze for analytics tool-how Business Analysis’s can reduce their pain points of collection and analysis of data through integrated Hadoop dashboard approach
- Basic introduction of Insight analytics, visualization analytics and predictive analytics for Telco
- Customer Churn analytic and Big Data-how Big Data analytic can reduce customer churn and customer dissatisfaction in Telco-case studies
- Network failure and service failure analytics from Network meta-data and IPDR
- Financial analysis-fraud, wastage and ROI estimation from sales and operational data
- Customer acquisition problem-Target marketing, customer segmentation and cross-sale from sales data
- Introduction and summary of all Big Data analytic products and where they fit into Telco analytic space
- Conclusion-how to take step-by-step approach to introduce Big Data Business Intelligence in your organization

Target Audience

- Network operation, Financial Managers, CRM managers and top IT managers in Telco CIO office.
- Business Analysts in Telco
- CFO office managers/analysts
- Operational managers
- QA managers