PKR. 51,000 PKR. 30,000 Reserve Seat

Business Analytics Training

PKR. 51,000 PKR. 30,000

Starting in

Learn to create data visualizations, develop predictive models, and interpret the results to enhance their business operations.
Start Date
Dec 30, 2023
End Date
Feb 17, 2024
Timing
11:00 AM-04:00 PM
Location
Online
Type
Instructor Led
Duration
80 Hours
training image

Overview

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. 

Tools Covered

  • Degree Levels: Bachelors,Masters
  • Field of Studies: Information Technology
  • Prior Job Experience: NA
  • Other Programs:

  • 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

Meet the Instructor

Mohsin Mahmood

Ed-Tech| Data Analysis | Data Visualization | Data Driven Story Telling| Data Sciences | Machine Learning

Mohsin Mahmood

Ed-Tech| Data Analysis | Data Visualization | Data Driven Story Telling| Data Sciences | Machine Learning


Professional with 13+ years of experience primarily in business analytics, data-driven product/service design and management, performance management, business analysis, data sciences, data visualization, and data-driven storytelling. I am experienced at delivering innovative, customer-centric solutions that enhance user experience and ease product/service adaptability while optimizing business profitability.


Course Outline

  • 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
  • Quick Analysis Tool
  • Forecasting Tool
  • Index Match Formula

  • What is SQL
  • Understanding Tables
  • How do tables communicate (Concept of Keys)
  • Installing PostgreSQL
  • Loading a dummy database
  • 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
  • Grouping and Sorting
  • Aliasing in SQL
  • Using filters with aggregate functions using HAVING

  • 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
  • What is P-Value
  • Rejecting or accepting a hypothesis
  • Types of Data and appropriate Visualizations
  • Types of visualizations suited for types of data

  • 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

  • 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

  • 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
  • Approaches to Market Sizing
  • Market sizing hands on exercise

  • 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

Our Methodology

Industry Usecases

With real world projects and immersive content built in partnership with top tier companies, you’ll master the tech skills companies want.

Technical Support

Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track.

Career Mentorship

You’ll have access to resume support, portfolio review and optimization to help you advance your career and land a high-paying role.

Certificate

Testimonials

Hiba Khursaid
Hiba Khursaid
Business Intelligence Specialist

Initially skeptical of online training, Dice Camp's business analytics program exceeded expectations. The Trainer Mr. Mohsin Mehmood showcased mastery in advanced Excel, SQL, and Power BI, translating theory into practical applications. Hands-on projects were instrumental, immediately impacting my career with a 20% efficiency boost. The course's well-paced structure, coupled with engaging trainers, made learning enjoyable. I highly recommend Dice Camp for its tangible results and valuable skills in the dynamic realm of business analytics.

Sabeen Farooq
Sabeen Farooq
Operations Manager

The Business analytics training on Dice Camp proved pivotal for my career growth. Mohsin Mehmood's profound expertise left a lasting impression. The thoughtfully designed course outline covered essential analytics aspects, making the learning experience simultaneously challenging and rewarding. I enthusiastically recommend Dice Camp to those committed to mastering analytics; it's a transformative investment in your professional journey.

Irfan Haider
Irfan Haider
Project Cordinator

I had the pleasure of completing The business analytics training program on Dice Camp as it was a game-changer for my project coordination role. The hands-on approach, solving actual project challenges, equips me to analyze data effectively and contribute strategically. Dice Camp is a must for professionals seeking practical analytics skills in project coordination.

Madeeha Ahmed
Madeeha Ahmed
Finance Officer

As a Finance Officer, opting for Dice Camp's online business analytics training was a strategic career move. The course's tailored content on advanced analytics tools has significantly enriched my financial skill set. The hands-on training with real-world applications has equipped me to analyze financial data with precision. The training is highly recommended for finance professionals seeking to elevate their analytical capabilities and make impactful financial decisions.

Kashif Khan
Kashif Khan
Fresh Graduate

Choosing Dice Camp's online business analytics training right out of university has proven to be a game-changer. The practical skills acquired in advanced tools such as Excel, SQL, and Power BI are directly applicable to real-world scenarios. The hands-on experience has accelerated my learning curve, instilling confidence in my ability to navigate complex data challenges. Dice Camp's training is a realistic and invaluable investment for fresh graduates, providing a tangible edge in today's competitive job market.

Video Reviews

Frequently Asked Questions

Yes, You will be awarded a course completion certificate by Dice Analytics if you pass the course.

Since our trainings are led by Industry Experts so it is made sure that content covered in workshop is designed with hand on knowledge of more than 70-75 % along with supporting theory.

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

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 commitments.

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
So, what's your plan?

Follow the footsteps of thousands of successful alumni...

Reserve Seat
svg img
Reserve Seat