Business Analytics using Excel

“Information is the oil of the 21st century, and analytics is the combustion engine” – Peter Sondergaard, Senior Vice President, Gartner

Without data analytics, companies are blind and deaf, wandering like deer on a freeway. Hence, professionals who can analyze data & create useful information are highly sought after by companies across the world. A graduate from PMtutor, will be able to make use of tools and techniques like data mining, pattern matching, data visualizations and predictive modeling to predict and optimize outcomes and derive value from the data. This program focuses on Forecasting, Econometrics  and Time Series Analysis and prediction of future outcomes based on historical patterns. The use of Business Analytics is widespread across all industries and functions hence an important ingredient-mix to becoming indispensable in any management career.

 

PMtutor Delegates  in Analytics Class

 

 

Benefits

  • 1-days Classroom Interactive and Hands-On Classroom Training
  • 1-Mini Case Study Projects before the class ends.
  • Career and Job Placement Advice
  • 12 PMI PDUs
  • FREE EXCEL Software Training
  • Save Money up to 100K vs. Other courses 
  • Easy to follow modules
  • Makes you study faster and easier
  • Cuts your studying time significantly
  • Focus on understanding rather than memorization

 

 

PMtutor Business Analytics using MINITAB INSTRUCTOR-LED CLASSROOM TRAINING IN LAGOS

TRAINING FEE: NA

 

Schedule for Business Analytics using EXCEL

 

Month

Date

Venue

Time

MAR

2017

  • 18th

POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.

9am – 5pm

MAY

2017

  • 20th
POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.

9am – 5pm

JUL

2017

  • 15th
POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos.

9am – 5pm

SEP

2017

  • 16th
POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos. 9am – 5pm

NOV

2017

  • 18th
POeTSolvers, The PentHouse,125A Apapa Road behind Skye Bank by Costain Bus Stop, Ebute Metta West, Lagos. 9am – 5pm

 

ONLY 4 SEATS AVAILABLE for each Class!!!

DELEGATES ARE ALLOWED TO PAY TWICE – ALL PAYMENTS MUST BE IN BEFORE THE 2ND WEEKEND CLASS.

TO BOOK FOR A SEAT, YOU HAVE TO PAY A MINIMUM OF NXXX OUT OF THE NXXX

PLS, SEE PAYMENT INFO BELOW:

________________________________________________________________________________________

PAYMENT INFORMATION: Monies can be paid to:

Access Bank

Poet Solvers Limited

0006551542

OR

UBA

Poet Solvers Ventures

1005870878

Those that paid to the bank should please, send their teller number to this email address (support [at] pmtutor [dot] org).

N/B: Due to cashless Lagos, we may not collect payments in our office or at the date of training. All payments must be settled via the means above.

 

___________________

Listed below are some of the topics covered in the course:

Business Analytic Using EXCEL

1. Descriptive Statistics and Graphical Analysis

  • Types of Data
  • Using Graphs to Analyze Data
  • Using Statistics to Analyze Data

 

2. Probability Distribution

  • Normal Distribution
  • Binomial Distribution
  • Poisson Distribution

 

3. Statistical Inference

  • Sampling Distribution
  • Sampling Error
  • Central Limit Theorem
  • Confidence Interval
  • Estimating Population Mean using Small Sample Size
  • Estimating Population Mean using Large Sample Size
  • Estimating Sample Size

 

4. Hypothesis Testing

  • Steps to Conducting Hypothesis Test
  • 1-Sample Z-test
  • 1-Sample t-test
  • 2-Sample t-test
  • Paired t-test
  • Variance test
  • Proportion Test
  • Chi Square Test

 

5. Analysis of Variance (ANOVA)

  • One-Way ANOVA
  • Two-Way ANOVA

 

6. Predictive Analysis

  • Correlation
  • Simple Linear Regression
  • Multivariate Linear Regression