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 Book a Seat

Schedule

Starting

28 January ’23

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!

Mohsin Mahmood

Senior Manager Strategy and Analytics

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.

View Profile

Ammar Arshad

Business and Data Consultant

Ammar Arshad is an experienced business and data consultant serving local and international clients on projects of various scales. He brings with him an overall 6+ years of experience, with hands-on expertise in business analytics, data analysis, extraction and management, and a great command on MS Excel, and other tools. He has worked for startups as well as the large industrial and non-profit organizations in the energy sector which enables him to bring a diverse perspective to this course. He is currently based in Sweden, pursuing a Masters Degree in Innovation and Industrial Management.

View Profile

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: SQL & SQL Functions

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

Aggregate Functions

SUM

AVERAGE

MAX

MIN

Grouping and Sorting

Order By

Group By

Aliasing in SQL

Using filters with aggregate functions using HAVING

Week 3: 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 4: Business 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 5: 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 6: 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 7 & 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 Details

Online Banking details will be shared by our representatives after you reserve your seat

Individual Price
- PKR 30,000 Per Person
- Total charges for complete training
- Book a seat

Group of Two
- PKR 27,900 Per Person
- Avail 7% off on Group of two
- Book 2 Seats

Group of Three
- PKR 27,000 Per Person
- Avail 10% off on Group of three
- Book 3 Seats

Group of Four or more
- PKR 25,500 Per Person
- Avail 15% off on Group of four or more
- Book 4 or more Seats

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.

Can I rejoin this workshop/training?

Yes, you can rejoin the training within the span of an year of your registration. Please note following conditions in case you’re rejoining.
1) There are only 5 seats specified for rejoiners in each iteration.
2) These seats will be served on first come first basis.
3) If you have not submitted your complete fee, you may not be able to rejoin. Your registration would be canceled.

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!

Are you a:
StudentWorking Professional