BUSINESS ANALYTICS WITH EXCEL TRAINING COURSE
The Business Analytics With Excel course is a compilation of the company’s core financial analysis approaches. The first section introduces financial modelling (from selecting tools to conceptual model building).
Overview
The Business Analytics With Excel course is a compilation of the company’s core financial analysis approaches. The first section introduces financial modelling (from selecting tools to conceptual model building). The portion that follows is about practical application, in which we deal with various scenarios to discover new approaches and sophisticated Excel capabilities required in business analysis. The final session focuses on constructing financial models and overcoming common financial analysis issues with the help of the trainer. Business analytics training course aims to introduce you to business analytics as a foundational part of your business education.
The training is practical; participants work on business issue solving with the assistance of an instructor. As a result of this strategy, participants discover numerous viable solutions that can be used in various situations. You will also learn about some crucial tools and practices for moving forward with your own Business Analytics. It covers elements of data discovery and collection, data quality, analysis and data sharing, and generalizing data analytics results to wider business conclusions and decisions. It deploys IBM SPSS software, applied to a wide variety of business applications, including estimation and predictive analysis. Business Analytics training course will equip delegates with skills for extensive use of data, statistical and quantitative analysis, explanatory and predictive models, and fact-based management to drive decisions and actions.” It is a combination of :
BUSINESS ANALYTICS TRAINING COURSE
Course Outline
- To learn how managers utilise business analytics to formulate and solve business challenges and assist management decision-making.
- Apply analytics to customer need analysis, general management, marketing, finance, operations, and human resource management.
- To become acquainted with the procedures required to generate, report, and analyse business data.
- To study and use Excel and Excel add-ins to address business problems.
- Become empowered and prepared to advance your career.
- Different types of data, Data summarization
- Frequency table, Distributions and Histogram
- Measures of central tendency and dispersion
- Skewness and kurtosis
- Basic Probability, Conditional Probability
- Normal Distribution
- Sampling methods
- Point and Interval estimation
- Central Limit Theorem
- Null and alternative hypothesis
- Level of significance
- P value
- Types of errors
- Hypothesis Testing
Linear and Multiple Linear Regression
- Simple and Multiple Linear Regression
- R2 and Adjusted R2
- ANOVA
- Interpretation of coefficients
- Dummy Variables
- Residual Analysis
- Outliers
Logistic Regression
- Assumptions
- Logistic Function
- Chi-Square
- Hosmer Lemeshow test
- Kolmogorov-Smirnov statistic and chart
- Classification Table
- Interpreting Coefficients
- Dependent Variable Prediction
- Principles of Forecasting
- Time Series
- Causal models
- Types of Forecasting Methods and their characteristics
- Moving Average
- Exponential Smoothing
- Trend
- Seasonality
- Cyclicity
- Holt Winter’s forecasting method
Market Basket Analysis
- Basic concepts
- Data mining techniques
- Frequent Itemset Mining Methods
- Apriori, FPGrowth
- Pattern Evaluation Methods: Lift, Chi –Square
Classification
- Decision Tree Induction
- Bayes Methods
- Rule-Based Classification
- Model Evaluation and Selection
- Ensemble Approaches
Clustering
- Partitioning Methods
- Hierarchical Methods
- Density-Based Methods
- Grid-Based Methods
- Evaluation of Clustering
- K-means Method
Excel
- Formatting of Excel Sheets
- Use of Excel Formula Function
- Data Filter and Sort
- Charts and Graphs
- Table formula and Scenario building
- Lookups
- Pivot tables
R and Python
- Reading and Writing Data
- Data types
- Important Packages
- Data Manipulation
- Building models using learned algorithms
- Evaluating and optimizing models
Orientation on Big Data and Hadoop
- Awareness of Big Data and Hadoop
- Nosql vs Sql
- The four V’s
- Is Big Data = Hadoop
- Big Data and Cloud Computing
- Generators of Big Data
- Applications of Big Data
Exposure to Web and Mobile Analytics with focus on:
- Text Analytics
- Sentiment Analytics
- Click Analytics, Google Analytics
- Difference between Web and Mobile Analytics.
PERSONAL IMPACT
- Increases career opportunities
- Take advantage of structured training with the most up-to-date curriculum based on current industry requirements and best practices.
- Gives Global Recognition
- Creates Job satisfaction
- Increases your international marketability
- Increases Productivity
ORGANIZATIONAL IMPACT
- Provide flexible and cost-effective professional development opportunities to your team.
- Analyse case studies in this domain to use effective strategies in your organization.
- Enables organizations to assign and track corporate resources
- It increases business agility
- Increases Productivity
- Increases customer satisfaction
- Employee Satisfaction
JK Michaels institute also offers other products and courses, including Certification in Business Data Analytics, BUSINESS ANALYTICS WITH EXCEL, ADVANCED EXCEL, BASIC EXCEL TRAINING, and BUSINESS DATA ANALYTICS PROFESSIONAL.
Training Calendar
| MONTH | DAYS | Classroom | Virtual | |
|---|---|---|---|---|
| January | Make Enquiry | |||
| February | Make Enquiry | |||
| March | Make Enquiry | |||
| April | 2-4 | N280,000 | N280,000 | Make Enquiry |
| May | Make Enquiry | |||
| June | 18-20 | N280,000 | N280,000 | Make Enquiry |
| July | Make Enquiry | |||
| August | 11-13 | N280,000 | N280,000 | Make Enquiry |
| September | Make Enquiry | |||
| October | 27-29 | N280,000 | N280,000 | Make Enquiry |
| November | Make Enquiry | |||
| December | Make Enquiry |
testimonials
Curriculum
Curriculum
- 9 Sections
- 52 Lessons
- 3 Days
- Introduction to Business Analytics with Excel4
- Building financial model6
- Modelling techniques6
- Financial modelling with Excel6
- Financial modelling functions5
- Formatting tools in Excel3
- Excel8
- R and Python6
- Orientation on Big Data and Hadoop8
Reviews
Features
- JK Michaels is a PMI accredited ATP(Authorized Training Partner)
- Earn 30 PDUs with Practical, live instructor led sessions
- Ace the exam with 30 day, 60 day study plan by experts 2000 Free exam simulation question bank
- Introduction to predictive and Agile software(microsoft project +JIRA) Poject Leadership Quotients Assessment
- Regular monthly webinars,revisions and exam support.
- Action-oriented learning through case studies,role plays ,games e.t.c
You May Like
NEGOTIATION FOR RESULT
Negotiation for result are vital for career success. Learn to achieve results, create agreements and build relationships that last through effective negotiation. Negotiation skills...
SCRUM FUNDAMENTALS CERTIFICATION TRAINING (SFC)
SCRUM Fundamentals Certification Training (SFC) is a method for systematically identifying and eliminating flaws in all processes, products, and services. As a result, it...
PROBLEM SOLVING AND DECISION MAKING FOR MANAGERS
Problem Solving And Decision Making For Managers course will develop your skills as a critical thinker and problem solver. You learn to leverage your...
NEURO-LINGUISTIC PROGRAMMING TRAINING
Neuro-Linguistic Programming Training (NLP) course aims to teach some of the core principles of NLP in a simple, practical, and beneficial manner. This course...
SERVICE MARKETING COURSE
Service Marketing Course will strive to familiarize course members with marketing principles that can be applied explicitly to service businesses. This course will also...
Course Features
- Lectures 52
- Quizzes 0
- Duration 3 days
- Skill level All levels
- Language English
- Students 0
- Assessments Yes