Data science and Business Intelligence Courses

Master data-driven decision making

McKinsey predicts “by 2020, there will be 40,000 exabytes of data collected". Data Science & Business Intelligence is a field that encompasses anything related to data cleansing and analysis. Learn how to extract insights and gain information from data by taking up our wide range of courses from Data Science to Business Intelligence.

                   Course Advisor

 
Ronald van Loon
Top 10 Big Data & Data Science Influencer, Director - Adversitement

Named by Onalytica as one of the three most influential people in Big Data, Ronald is also an author for a number of leading Big Data and Data Science websites, including Datafloq, Data Science Central, and The Guardian. He also regularly speaks at renowned events.

All Data Science & Business Intelligence Courses

Foundational & Advanced

Business Analytics Certification Training with Excel

Key features

  • 12 hours of self-paced video

  • Two hands-on industry-based projects on healthcare and e-commerce

  • Eight practical exercises

  • Includes training on business intelligence using Power BI

  • Downloadable e-book 

 

Course objectives

With our training on business analytics with Excel, you will be able to:

  • Understand the meaning of business analytics and its importance in the industry

  • Grasp fundamentals of excel analytics functions and conditional formatting

  • Learn how to analyze with complex datasets using pivot tables and slicers

  • Solve stochastic and deterministic analytical problems using tools like scenario manager, solver and goal seek

  • Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using Excel

  • Represent your findings using charts and dashboards

  • Get introduced to the latest Microsoft analytic and visualization tools i.e. Power BI

Course Fees

1121 SR 

 Qlikview Developer Training

Key Features

  • Get familiar with QlikView terminologies

  • Build data model, resolving synthetic keys and organizing script sections

  • Build an application that fulfills the D.A.R approach

  • Optimise Data Models by using advanced Script Functions

What are the course objectives?

What are the course objectives?

After completing this course you will be able to:

  • Creating Analysis Reports, Add Visualizations to the report

  • Building the data model, resolving synthetic keys and organizing script sections to load data

  • Optimise Data Models by using advanced Script Functions

  • Create Data Layers with QVD files

  • Build an application that fulfills the D.A.R (Dashboard, Analysis, and Report) approach suggested by Qlik

How will I execute the hands-on practicals?

Course Fees

1121 SR 

Power BI Certification Training Course

Key Features

  • Create stunning reports and generate visuals

  • Transform data for analysis and create effective data views

  • Create dashboards with Quick Insights

  • Improve team collaboration with Microsoft Teams

What skills will you learn?

By the end of this Power BI Certification course, you will comprehend and master the following concepts:

  • Create dashboards from published reports

  • Quickly generate visuals and dashboards with Quick Insights

  • Use natural language in the Q&A feature to quickly generate visuals for actionable insight

  • Create and manage data alerts

  • Get report layout and data visualization best practices

  • Understand which charts/graphs to use depending on the question being answered or the story being told

  • Use shapes to design, emphasize, and tell a story

  • See how to incorporate custom visuals into your reports and dashboards

  • Share reports and dashboards, as well as their pro’s and con’s

  • Complete a Power BI data analysis/visual project from start to finish

  • Improve team collaboration with Microsoft Teams

  • Know how to get and prepare your data for analysis and visualization

  • Find out how to create relationships between tables in your data model

  • Create calculated columns and measures using the DAX language

Course Fees

1121 SR

Data Science Certification Training - R Programming

Key Features

  • 24 hours of self-paced video

  • Hands-on practice with R CloudLab

  • Includes “Business Analytics with Excel” course

  • 8 real-life industry projects in retail, insurance, finance, airlines and other domains

  • Includes statistical concepts such as regression and cluster analysis

What skills will you learn?

This data science training course will enable you to:

  • Gain a foundational understanding of business analytics

  • Install R, R-studio, and workspace setup, and learn about the various R packages

  • Master R programming and understand how various statements are executed in R

  • Gain an in-depth understanding of data structure used in R and learn to import/export data in R

  • Define, understand and use the various apply functions and DPLYR functions

  • Understand and use the various graphics in R for data visualization

  • Gain a basic understanding of various statistical concepts

  • Understand and use hypothesis testing method to drive business decisions

  • Understand and use linear, non-linear regression models, and classification techniques for data analysis

  • Learn and use the various association rules and Apriori algorithm

  • Learn and use clustering methods including K-means, DBSCAN, and hierarchical clustering

Course Fees

1500 SR

Big Data Hadoop Certification Training

Key Features

  • 24 hours of self-paced video

  • Hands-on practice on CloudLab

  • Aligned to Cloudera CCA175 certification exam

  • 5 real-life industry projects using Hadoop and Spark

  • Training on Yarn, MapReduce, Pig, Hive, Impala, HBase, and Apache Spark

What skills will you learn?

Big Data Hadoop training will enable you to master the concepts of the Hadoop framework and its deployment in a cluster environment. You will learn to:

Understand the different components of Hadoop ecosystem such as Hadoop 2.7, Yarn, MapReduce, Pig, Hive, Impala, HBase, Sqoop, Flume, and Apache Spark with this Hadoop course.

  • Understand Hadoop Distributed File System (HDFS) and YARN architecture, and learn how to work with them for storage and resource management

  • Understand MapReduce and its characteristics and assimilate advanced MapReduce concepts

  • Ingest data using Sqoop and Flume

  • Create database and tables in Hive and Impala, understand HBase, and use Hive and Impala for partitioning

  • Understand different types of file formats, Avro Schema, using Arvo with Hive, and Sqoop and Schema evolution

  • Understand Flume, Flume architecture, sources, flume sinks, channels, and flume configurations

  • Understand and work with HBase, its architecture and data storage, and learn the difference between HBase and RDBMS

  • Gain a working knowledge of Pig and its components

  • Do functional programming in Spark, and implement and build Spark applications

  • Understand resilient distribution datasets (RDD) in detail

  • Gain an in-depth understanding of parallel processing in Spark and Spark RDD optimization techniques

  • Understand the common use cases of Spark and various interactive algorithms

  • Learn Spark SQL, creating, transforming, and querying data frames

  • Prepare for Cloudera CCA175 Big Data certification

Course Fees

1500 SR