fbpx

Upcoming Events

No Events on The List at This Time

 

Business Analytics

Grow your skills as Business Analyst!

Learn the art and science of data driven decision making. This 8 Weeks training is ideal for career newbies and professionals who aspire to familiarize and improve their marketing programs with daily commercial/business decision making tools and techniques.

 

In this Zoom Interactive training you will expanse over modules covering Decision Making in Business, Decision Modelling & Data Visualization, Segmentation and Profiling, Lifecycle Management and finally Contextual Marketing.

 

The training is structured around industry learnings and practice, all the while augmented with speaker sessions by subject experts. At the end of the course, attendees will be adept with a comprehensive understanding of how primary & secondary data are used for improved business decision making through different models, matrixes and tools.

View Course Outline

Our Approach for ZOOM Interactive Classes

After establishing a reputable Physical Training Model, based on our stellar records and customer earned trust we gradually progressed to establish the same reputation in the Live Training Model. We are committed to empowering you by making our trainings accessible, interactive, and well-curated specifically to your objective.

live training process 2

Schedule

Starting

1st January 2022

Duration & Timings

8 Weeks  (Sat & Sun)

11:00 AM – 4:00 PM

Language

Urdu / Hindi

Remaining

Limited Seats Available

Meet the Trainer

Meet the trainer of this workshop who is highly experienced!

qodef-fullwidth-slider

Mr. Mohsin Mahmood

Senior Manager Strategy and Analytics

Mr. Mohsin Mahmood brings 10 years of vast experience in Business Analytics domain and currently working as Senior Manager Strategy and Analytics. His expertise includes ETL, Strategic Planning, developing Dashboards on Power BI, Tableau, Stata, Python, SQL etc.

Course Outline

Week 1: Refreshing Excel Concepts

Vlookup/Hlookup, Match, Find & Exact functions
Nested Loops of If conditions (SUMIF, SUMIFS, COUNTIF, COUNTIFS)
Data Validation (Fixed, Delimited)
Pivot table and slicer functions.
Delamination through excel
End goals in terms of revenue or investments etc. by using Goal Seek Solver
Key shortcuts in excel
Tables + Slicers
Quick Analysis Tool
Forecasting Tool
Index Match Formula

Week 2: Statistics for Data Analysis

Types of variables
Continuous Vs Discrete Variables
What are distributions, normal distribution, standard deviation, Skewness, Mean, Median and Mode
Central Limit Theorem
Population and samples
Sampling distribution
Z-Score
Hypothesis testing
Assumptions for hypothesis testing
Steps of hypothesis testing
What is P-Value
Rejecting or accepting a hypothesis
Types of Data and appropriate Visualizations
Types of visualizations suited for types of data

Week 3: Data & Forecasting

Data Digitization and its importance in today’s corporate world
Data collection via primary and secondary data sources (Data Warehouse, Big Data)
Forecasting tactics to take improved business decisions (Single variate, multi-variate regression)
Hands-on forecasting on datasets
Single variable Linear Regression
Multivariate Linear Regression

Week 4: Strategy & Business Frameworks

Recency, Frequency, Monetary Value (RFM) framework
Business Model Canvas
Boston Consultancy Group (BCG) Matrix
Porter’s 5 Forces Model
SWOT Matrix
PEST Analysis
McKinsey 7S Framework
GE-McKinsey 9 Box Matrix

Week 5: Pricing & Segmentation

Building pricing and the psychology/economics behind it
Determine pricing at which you can maximize profits through sensitivities
Understanding customer segmentation
Hands-on segmentation on datasets
Market Sizing
What is market sizing?
Approaches to Market Sizing
Market sizing hands on exercise

Week 6: SQL

What is SQL
Understanding Tables
How do tables communicate (Concept of Keys)
Installing PostgreSQL
Loading a dummy database
Commands
Selection commands
Comparison Operators (Utilizing WHERE clause)
Multiple conditions (using WHERE, AND, OR, BETWEEN, WHERE IN)
Concept of NULL & IS NOT NULL and examples of how to use them
LIKE & NOT LIKE

Week 7: SQL Functions

Aggregate Functions
SUM
AVERAGE
MAX
MIN
Grouping and Sorting
Order By
Group By
Aliasing in SQL
Using filters with aggregate functions using HAVING

Week 8: Microsoft Power BI

Microsoft Power BI
Introduction to Power BI
Understanding Power BI’s interface
Walkthrough of in-built Power BI tools
Connecting and Shaping Data
Creating Data Models
Calculated fields with DAX
Common DAX Functions
Developing reports
Using filters with aggregate functions using HAVING

Pricing

Online Banking details shall be shared via our representatives after you reserve your seat

Actual Training Price

Price for a Regular Member
PKR 22,000 Per Person

For [email protected] Members

20% OFF for [email protected] Members
PKR 17,600 Per Person

Tools

Frequently Asked Questions

Who should attend the course?

  • Business/Marketing Heads & Executives
  • C-Suite Employees responsible for determining and achieving Revenue Targets
  • Sales Heads & Executives
  • IT employees assigned for assisting Sales, Marketing and Business Analytics Departments
  • Students/graduates with business, commerce, marketing background

What if I miss any of the lectures?

Don’t worry! We have got you covered. You shall be shared recorded lectures after each session, in case you want to revise your concepts or miss the lecture due to some personal or professional commitment.

What is the timing of the course?

Duration: 8 weeks

Class Days: Saturday & Sunday

Timings: 11:00 AM – 4:00 PM

Can I get a job after this course?

Since our instructors are industry experts so they do train the students about practical world and also recommend the shinning students in industry for relevant positions.

How much hands-on will be performed in this course?

Since our courses are led by Industry Experts so it is made sure that content covered in course is designed with hand on knowledge of more than 50% along with supporting theory.

How integrative classes would be?

Classes will be interactive throughout & LIVE on Zoom. You would be able to ask questions & share views with the Technical Assistant, Trainer & class other participants.

What are the PC requirements?

For this professional course, you need to have a PC with minimum 4GB RAM and ideally 8GB RAM.

Will I get a certificate after this course?

Yes, you will be awarded with a course completion certificate by Dice Analytics. We also keenly conduct an annual convocation for the appreciation and recognition of our students.

Reserve your Seat

You can reserve your seat  by filling the form below!

     

     

    ×
    X
    \