Business Analytics
Training program
For non-technical people who want to make more data-driven decisions, this program is ideal. Whether you
work in logistics, sales, marketing, finance, operations, or another field, you'll learn data analysis techniques
and tools that will be useful to you all along the way. In order to manipulate, analyze, and visualize data so that
you can make better, data-informed decisions, you'll learn how to use Power BI, SQL, and Excel. Additionally,
you will learn through practice how to perform basic statistical analysis, and some modelling! You will gain
experience using analytical skills on real-world cases as a result of this training program.
Program structure
• Course term: 84 hours / 3.5 months
• Schedule: 6 Hours in a week
• Practice class: 20 hours
• Mentor support: 8 hours
What you'll learn
• The fundamental and important data analysis skills;
• Data literacy and analytical thinking skills based on real-cases;
• Analytical and report skills for functional analysis in MS Excel
• The fundamentals of statistics knowledge and analysis skills
• Using Oracle SQL and basic SQL coding skills;
• Reports and basic analysis skills using SQL functions and commands
• Visualization, reporting and analysis skills with Power BI
For more information, visit www.gigroup.az or email us at info@gigroup.az
Programs developed by proficient instructors according to international practice.
Modules and Subjects
Modules Subjects
- What is Business Analytics?
Module 1 - Differences between Data Science and Analytics
What is Business - Why business analytics and how its applied?
Analytics? - Who is business analyst?
- Types of data analytics
- Data analytics techniques
- Defining the right questions
Module 2 - Collecting the data
Data Analytics - Cleaning the data
Process - Analyzing the data
- Visualizing and sharing results
Quiz and Exam
Introduction
- Monitor and Validate
Assigments
4 hours
Module 3 - Top business analytics tools
Analytics tools and - Explanation of the main tools
techniques - Most useful data analysis techniques
- Explanation of analytical techniques
- What is data literacy?
Module 4 - Why analytical mindset?
Data literacy and - Reading Data
analytical mindset - Understanding data
- Analytics framework
- Data-informed Decision Making
For more information, visit www.gigroup.az or email us at info@gigroup.az
Programs developed by proficient instructors according to international practice.
Modules and subjects
- Types of Data
Module 1 - Variables, Types of variables
Introduction to - Sample and Population
statistics
- Random Variables and Probability
- Conditional Probability, and Bayes’ Theorem
- Normal, Binomial and Poisson Distribution
- The main measures: mean, median and mode
Module 2 - Range, interquartile range
Business statistics
Measures of central - Skewness
Quiz and Exam
tendency Variance
Assigments
-
12 hours
- Standard deviation and coefficient of variation
- What Hypothesis Tests
Module 3 - Confidence Intervals
Descriptive and - The P Value
Inferential Statistics - T Tests
- Z Tests
- Correlation and Regression
Module 4
Statistical analysis - You will build statistical models with real data based on the statistical
with Excel knowledge.
For more information, visit www.gigroup.az or email us at info@gigroup.az
Programs developed by proficient instructors according to international practice.
Modules and subjects
- Introduction to Excel
- Entering, Editing and Formatting Data
Module 1 - Working with Cells and Ranges in Excel
Excel - Formatting Numbers
Basics - Managing Worksheets
- Modifying Rows and Columns
- AutoFill and Custom Lists
- Outline, Sort, Filter, and Subtotal
- Excel Tables
Module 2 - Conditional Formatting
Excel - Adding Graphics to Spreadsheets
Essentials - Collaboration
- Changing Views
Data Analysis with Excel
- Printing
- Protecting Data
Quiz and Exam
Assigments
24 hours
- Excel Formula Basics
- Cell referencing
- Logical Formulas in Excel
Module 3 - Math Formulas in Excel
Excel Formulas - Lookup and Reference Formulas in Excel
- Stats Formulas in Excel
- Text Formulas in Excel
- Date and Time Formulas in Excel
Module 4 - Introduction to data mining concepts
Data Mining and
- Data sorting, filtering, and database functions
Transforming with
- Power Query for data transformation
Excel
- Data Tools
Module 5 - Pivot Tables
Business Analytics - Introduction to Excel Charting
with Excel - Formatting Charts
- Dynamic Charts
For more information, visit www.gigroup.az or email us at info@gigroup.az
Programs developed by proficient instructors according to international practice.
Modules and subjects
- Information about DB and SQL
- Selecting single,multiple columns
- Filtering and sorting the rows
- Mathematical operators
Module 1
- Llike,not like
Introduction to
SQL - Between,not between
- In,not in
- Null,Not null
- Alias
- Or, And
- String functions
- Date functions
Module 2 - Comparison functions
Functions in SQL - Aggregate functions
- Group by
SQL for Data Analytics
- Having
Quiz and Exam
Assigments
20 hours
- Foreign/Primary key
- Inner join
- Left/right join
Module 3 - Full outer join
Joins, Subqueries - Cross join
in SQL - Inner join…using
- Joining multiple tables
- Self join
- Set operators
- Subqueries
- Constraints
- Create table
- Creating table AS statement
- Drop table statement
Module 4 - Truncate table statement
Creating tables - Alter table add/modify statement
- Insert and delete statement
- Insert with subquery
- Update using statement
- Analytics functions
For more information, visit www.gigroup.az or email us at info@gigroup.az
Programs developed by proficient instructors according to international practice.
Modules and subjects
- Introduction to Power BI tool & Desktop Applications
- Introduction to Power Query
- Importing Data
Module 1
Collect, Combine - Loading & Refresh
and Transform - Data Transformation
data - In built transformation in Power Query
with Power BI - Consolidate and Append Data
- Merge Queries
- Data Modeling Introduction
- Relationship, Need of Relationship
Module 2
- Relationship Types / Cardinality in General
Data Modelling
Data Analysis with Power Bi
- One-to-One, One-to-Many (or Many-to-One), Many-to-Many
- AutoDetect the relationship, Create a new relationship, Edit existing
relationships
Quiz and Exam
Assigments
Make Relationship Active or Inactive
24 hours
- Delete a relationship
- What is DAX, Calculated Column, Measures, DAX Table
- DAX Functions Types
- Time Intelligence Functions
Module 3 - Date and Time Functions
Analysis Data with
- Text Functions
DAX
- Logical Functions
- Math & Statistical Functions
- Filter Functions
- Report View User Interface
- Grouping and Binning Introduction
Module 4 - Visualizations
Power BI Desktop
- Power BI Service
- Creating Dashboards
Final Capstone Project
12 hours
For more information, visit www.gigroup.az or email us at info@gigroup.az
Programs developed by proficient instructors according to international practice.
