Digital Analytics Training

Website Designing with WordPress

• What is Domain, Hosting & Types
• Register a Domain Name
• Secure Socket Layer (SSL)
• WordPress Installation
• Theme Settings and Customization
• Adding a menu to the website
• Plugins – Elementor Pro, Wp forms, Starter template, all in One WP migration, Wp optimize, Word Fence, Jetpack booster, Yoast SEO, WooCommerce, Light speed cache, TinyPNG
• Conversion Page Development using Elementor Pro

About Search Engine

• Google Algorithms
• Major & Minor Algorithm Updates
• Panda, Penguin, Rank Brain, Hummingbird, Core Update
• What is crawling?
• Processing & Indexing
• Uses of sitemap

Keyword Research & Competitor Analysis

• Introduction to Keyword Research
• Types of Keywords
• Keyword Research Methodology
• Google Keyword Planner Tool
• Competition Analysis
• Paid Competition Analysis tools
• Finalizing the Keywords List
• SEMrush

On-page SEO

• Introduction to on page
• Importance of HTTPS
• URL Optimization
• Title Tag Optimization
• Meta Tags Optimization
• Content Optimization
• Heading optimization
• Internal Links
• Image Optimization

Off page SEO

• Introduction to Off page (Link Building)
• Link Building Guidelines
• Types of Backlinks Link Analysis Tools
• Directory Submissions
• Local Business Submission
• Classified Posting
• Q & A Backlinks
• Blogging & Blog Comments
• Guest Blogging
• Document Sharing
• Other Advanced Strategies

Technical On-page SEO

• Website Speed Optimization
• Speed Analysis Tools
• Sitemaps Generation
• robots.txt File
• URL Redirecting Techniques
• Canonical Links
• Rich Snippets
• Google Page speed insights
• Mobile Friendliness Checking

Local SEO

• What is Local SEO?
• Importance of Local SEO
• Submission to Google My Business
• Optimizing the GMB Profile
• Local SEO Ranking Signals
• Local SEO Negative Signals
• Citations and Local Submissions
• Google My Business Analytics
• Fix Duplicate, Terminated, Non-verified business

Google Ads

1.Google Ads Account Setup:

• Creating a Google Ads account
• Smart Mode vs Expert Mode
• Understanding Google Ads interface
• Account structure:
• Account
• Campaign
• Ad Group
• Ads
• Keywords
• Billing & payment setup
• Time zone & currency setup

2. Keyword Research & Planning

• What are keywords?
• Buyer intent keywords vs informational keywords
• Google Keyword Planner (hands-on)
• Keyword match types:
  • Broad
  • Phrase
  • Exact
• Negative keywords & importance
• Competitor keyword analysis
• Long-tail keywords strategy

3. Search Ads Campaign

• Search Ads campaign creation (step by step)
• Campaign goals & objectives
• Location targeting (local, national, global)
• Language targeting
• Budget & bidding strategies
• Writing high-converting ad copies
• Responsive Search Ads (RSA)
• Ad extensions:
  • Sitelinks
  • Callouts
  • Structured snippets
  • Call extensions
• Ad relevance & Quality Score

4. Display Ads:

• What is Google Display Network?
• Types of Display Ads
• Audience targeting:
  • Interests
  • Demographics
  • In-market
  • Custom audiences
• Placement targeting
• Responsive Display Ads creation
• Banner sizes & best practices
• Remarketing basics

5. Shopping Ads (E-commerce)

• What are Google Shopping Ads?
• Google Merchant Center setup
• Product feed creation
• Linking Merchant Center with Google Ads
• Shopping campaign creation
• Optimizing product titles & images
• Performance Max overview (basic)

6. Conversion Tracking & Analytics

• What is conversion tracking?
• Types of conversions:
  • Calls
  • Form submissions
  • Purchases
• Google Ads conversion setup
• Linking Google Analytics with Google Ads
• Understanding conversion data
• Measuring ROI & CPA

7. Bidding Strategies & Optimization

1. Manual CPC vs Automated bidding
2. Smart bidding strategies:
3. Maximize clicks
4. Maximize conversions
5. Target CPA
6. Target ROAS
7. A/B testing ads
8. Keyword optimization
9. Budget optimization
10. Improving Quality Score

8. Remarketing & Advanced Targeting:

• What is remarketing?
• Website remarketing
• App remarketing
• Customer list remarketing
• Custom audiences
• Similar audiences
• Cross-campaign remarketing strategy

Meta Ads

Meta Business Manager Setup :

• Creating Meta Business Manager
• Business settings overview
• Ad account creation
• Payment & billing setup
• Page & Instagram account linking
• User roles & access control
• Ads Manager interface walkthrough

Campaign Structure & Objectives:

• Meta Ads structure:
  • Campaign
  • Ad Set
  • Ad
• Marketing funnel in Meta Ads
• Campaign objectives:
  • Awareness
  • Traffic
  • Engagement
  • Leads
  • App Promotion
  • Sales

• Choosing the right objective

Audience Targeting:

• What is audience targeting?
• Core audiences:
  • Demographics
  • Interests
  • Behaviors
• Custom audiences:
  • Website visitors
  • App users
  • Lead forms
  • Customer lists
  • Lookalike audiences
• Audience overlap & exclusions
• Local business targeting strategy

Ad Formats & Creative Types:

• Image ads
• Video ads
• Carousel ads
• Collection ads
• Instant Experience
• Story & Reels ads
• Creative best practices
• Text, headline & CTA optimization

Lead Generation Ads:

• What are Lead Ads?
• Instant form setup
• Form types:
  • More volume
  • Higher intent
• Custom questions
• Thank you screen optimization
• CRM & WhatsApp integration
• Lead quality improvement techniques

Conversion Tracking (Meta Pixel & Events):

• What is Meta Pixel?
• Pixel installation methods
• Standard events & custom events
• Custom conversions
• Event prioritization
• Conversions API (CAPI) basics
• Tracking form fills, purchases & calls

Budget, Bidding & Optimization:

• Daily vs Lifetime budget
• Campaign Budget Optimization (CBO)
• Ad Set Budget Optimization (ABO)
• Bidding strategies
• Scaling ads (vertical & horizontal)

Ecommerce & Catalog Ads:

• Ecommerce ads overview
• Catalog setup
• Product feed integration
• Dynamic Product Ads (DPA)
• Advantage+ Shopping campaigns
• ROAS optimization techniques

Reporting, Policy & Account Safety:

• Ads Manager reports
• Key metrics:
  • CTR
  • CPC
  • CPA
  • ROAS
• Client reporting format
• Meta Ads policies
• Ad rejection reasons
• Account disable & recovery process

Email Marketing

• What is Email Marketing?
• Importance of Email Marketing
• Introduction to Mail Chimp
• MailChimp pricing structure
• Account setup and settings
• Email marketing strategy
• Creating a Subscriber List
• Integration of Forms in Site
• Import subscribers in list
• Types of Email marketing campaigns
• Email Marketing Campaign
• Analyzing Reports of Campaign

Google Search Console

• What is Search Console
• Features of Search Console
• Site Verification Process
• Location Targeting
• Search Performance Tool
• Link Analysis Tool
• Manual Actions
• Sitemaps Tool
• Fetch as Google Tool
• Crawl Errors Analysis
• The Latest updates in Search Console

Google Analytics

• Introduction to Analytics
• Implementing Analytics Code
• Setup of Conversion Tracking Code
• Types of Reports
• Audience Reports
• Acquisition Reports
• Behavior Reports
• Conversions Reports

Conversion Tracking:

• Google Tag Manager
• Microsoft Clarity Tool

1. Power BI Fundamentals:

• Overview of Power BI
• Power BI Components
• Understanding the Power BI Workflow
• Installing Power BI Desktop
• Introduction of Power BI Interface

2. Data Sources:

• Connecting to Data Sources
• Importing Data from Various Sources – Excel, CSV, PDF, MySQL, Folders and Web
• Understanding Data Connectivity Modes – Import Mode
• Understanding Data Connectivity Modes – Direct Query Mode

3. Data Cleaning (Power Query Editor):

• Remove rows & columns
• Remove duplicates
• Replace values
• Change data types
• Rename columns
• Trim, clean & format text
• Handling blank & null values
• Split column (by delimiter, position)
• Merge columns
• Extract values:
  • Left, Right, Middle
• Add custom columns
• Conditional columns
• Index column
• Column from examples
• Filtering rows
• Sorting data
• Keep / remove top rows
• Remove errors
• Remove blank rows
• Conditional row filtering
• Advanced filtering logic

4. Data Modelling:

• What is Data Modeling and Why is it Important?
• Key Concepts in Data Modeling – Tables, Relationships, Measures, Columns, and Schema Types
• Understanding Entities – Dimension Tables & Fact Tables
• Exploring Data Relationships
• Creating Relationships (Cardinality) in Power BI
  • One-to-One
  • One-to-Many
  • Many-to-Many
  • Many-to-One
• Cross Filter Direction

5. DAX – Data Analysis Expression:

Maths & Statistical Functions 

SUM, SUMX, AVERAGE, AVERAGEX, MEDIAN, MEDIANX, COUNT, COUNTX, MIN, MAX, DISTINCTCOUNT, COUNTROWS 

Filter Functions 

FILTER, CALCULATE, ALLNOBLANKROW, ALL, ALLEXCEPT, REMOVEFILTERS 

Logical Functions 

IF, AND, OR, NOT, SWITCH, IFERROR 

 Date & Time Functions 

CALENDAR, DATE, DATEDIFF, DATEVALUE, DAY, WEEKNUM, MONTH, QUARTER 

Time Intelligence Functions 

DATEADD, DATESBETWEEN, TOTALYTD, STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR 

Relationship Functions 

CROSSFILTER, RELATED 

Text Functions 

EXACT, FIND, FORMAT, LEFT, RIGHT, LEN, LOWER, UPPER, TRIM, CONCATENATE, SUBSTITUTE, REPLACE 

Information Functions 

COLUMNSTATISTICS, NAMEOF, ISBLANK, ISLOGICAL, ISNUMBER, ISFILTERED, ISCROSSFILTERED, USERPRINCIPALNAME() 

DAX Operators 

=, ==, <,>, > =, = <, < >, &, &&, || 

6. Visualization:

• Overview of Data Visualization
• Types of Visuals
• Bar Charts: Comparing data across different categories.
• Line Charts: Displaying trends over time.
• Pie Charts: Representing proportions or percentages of a whole.
• Column Charts: Displaying data comparisons across categories (vertical bars).
• Scatter Plots: Showing relationships or correlations between two variables.
• How Power BI Handles Data Visuals
• Formatting Visuals
• On-object Interaction: Using interactive elements like filters and slicers.
• Font and Font Size: Customizing text appearance in visuals for better readability.
• Colors and Stylistic Options: Personalizing visuals through color schemes, themes, and styles to enhance user experience.
• Scatter Charts and Bubble Charts
• Customizing Visuals
• Advanced Filtering
• Hierarchies, Drill-Downs, and Conditional Formatting
• Matrices and Bar Charts
• Tree Maps and Funnel Charts
• Maps and Geo-Data Visualizations
• Key Performance Indicator (KPI) Dashboard
• Drill Through and Drill-Down Visualizations
• Time-Based Visualization
• AI Visuals in Power BI – Decomposition Tree, Key Influencers Visual & Q&A Visual

1. Introduction to Python

• What is Python & why for Power BI
• Python vs Excel vs Power BI
• Installing Python (Anaconda / Jupyter)
• First Python program

2. Variables & Data Types

• Variables & naming conventions
• Data types: int, float, str, bool
• Type conversion
• Practical examples

3. Operators

• Arithmetic
• Comparison
• Logical operators
• Business logic examples

4. Strings (Text Processing)

• String operations
• Slicing & indexing
• Cleaning text:
  • lower(), upper()
  • replace()
  • split(), strip()
• f-strings

5. Lists, Tuples & Sets

• Lists (creation, modification, sorting)
• Tuples (immutable data)
• Sets (unique values)
• Use cases in analytics

6. Dictionaries (Important)

• Key-value structure
• Nested dictionaries
• JSON-like data handling
• Real-time examples

7. Conditional Statements

• if, elif, else
• Nested conditions
• IF logic (Excel equivalent)

8. Loops (Basic Usage)

• for loop
• while loop (intro)
• Loop control statements

9. Functions (Basic)

• Creating functions
• Parameters & return values
• Code reusability

10. Introduction to Pandas

• What is Pandas
• Pandas vs Power Query
• Series & DataFrames
• Pandas workflow for Power BI

11. Importing & Exploring Data

• Reading data:

  • CSV

  • Excel

  • SQL (basic idea)

• Exploring data:

  • head(), tail()

  • info(), describe()

12. Data Cleaning & Preparation

• Handling missing values

• Removing duplicates

• Renaming columns

• Changing data types

• Text cleaning

• Standardizing values

13. Data Transformation

• Filtering & sorting

• Adding calculated columns

• Conditional columns

• Categorization & binning

• Index handling

14. Date & Time Handling

• Date parsing

• Extracting year, month, day

• Financial year logic

• Creating calendar columns

15. Combining Data (Modeling Prep)

• Merge (joins):

  • Inner

  • Left

  • Right

• Append / concatenate tables

• Lookup table preparation

16. Aggregation & Grouping

• groupby()

• Aggregation functions

• Business summaries:

  • Sales by month

  • Revenue by category

• Pivot tables in Pandas

17. Performance Optimization

• Handling large datasets

• Memory optimization

• Best practices for fast processing

18. Pandas → Power BI Integration

• Exporting clean data to CSV / Excel

• Using Python Script in Power BI

• Pandas vs DAX responsibility

• Best data modeling practices

Introduction

• The Relational Model

Understanding Basic SQL Syntax

• Basic SQL Commands – SELECT
• Basic SQL Commands – INSERT
• Basic SQL Commands – UPDATE
• Basic SQL Commands – DELETE
• Querying Data with the SELECT Statement
•  The SELECT List
• SELECT List Wildcard (*)
• The FROM Clause
• How to Constrain the Result Set
• DISTINCT and NOT DISTINCT

Filtering results with Where Clause

• WHERE Clause
• Boolean Operators
• The AND Keyword
• The OR Keyword
• Other Boolean Operators BETWEEN, LIKE, IN, IS, IS NOT

Shaping Results with ORDER BY and GROUP BY

• ORDER BY
• Set Functions
• Set Function And Qualifiers
• GROUP BY
• HAVING clause

Matching Different Data Tables With JOINS

• CROSS JOIN
• INNER JOIN
• OUTER JOINs
• LEFT OUTER JOIN
• RIGHT OUTER JOIN
• FULL OUTER JOIN
• SELF JOIN

Creating Database Table Stamp

• CREATE DATABASE
• CREATE TABLE
• NULL Values
• PRIMARY KEY
• CONSTRAINT
• ALTER TABLE
• DROP TABLE

1. Introduction to Shopify  

• What is Shopify? 
• Key Features and Benefits of Shopify 
• Overview of Shopify Dashboard and Interface 
• Setting Up Your First Shopify Store 

 2. Shopify store setup and design  

• Choosing and Customizing Shopify Themes 
• Understanding Shopify Store Structure (Home Page, Collections, Products) 
• Adding Products, Product Variants, and Collections 
• Designing Your Store with Shopify’s Drag-and-Drop Editor 

 3. Shopify payment and store configuration  

• Setting Up Payment Gateways and Methods 
• Managing Taxes, Shipping, and Delivery Options 
• Configuring Store Settings (Currency, Notifications, etc.) 
• Setting Up Legal Pages (Privacy Policy, Terms & Conditions) 

 4. Shopify marketing and sales tools 

• Creating Discount Codes and Promotions 
• Integrating Social Media and Shopify’s Marketing Tools 
• Setting Up Google Analytics and Tracking Sales 
• Email Marketing with Shopify Email 

5. Shopify apps and Integrations 

• Adding and Managing Shopify Apps for Enhanced Functionality 
• Integrating Third-Party Apps for Marketing, Accounting, and Inventory 
• Automating Tasks with Shopify Flow and other Apps 

 6. Shopify ecommerce Analytics 

• Understanding Shopify Analytics and Reporting 
• Tracking Sales, Visitors, and Conversion Rates 
• Using Data Insights for Improving Sales and Customer Retention 
• Understanding Shopify’s Performance Metrics 

 7. Shopify mobile optimization 

• Ensuring Your Shopify Store is Mobile-Responsive 
• Customizing Your Store’s Mobile Experience 
• Using Shopify’s Mobile App for Store Management 

 8. Shopify SEO customization 

• Optimizing Your Shopify Store for Search Engines 
• Managing Meta Tags, Product Descriptions, and SEO Settings 
• Creating SEO-Friendly URLs and Product Pages 
• Implementing Structured Data for Rich Results

9. Shopify advance customization  

• Using Liquid to Customize Shopify Themes 
• Advanced Product Page Customization 
• Editing Shopify Templates and Sections 
• Working with Custom Code (HTML, CSS, JavaScript) 

10. Final project   

• Launching a Fully Functional Shopify Store 
• Final Project: Creating and Launching a Store in Your Niche 

HTML Essentials (Days 1-3)

Day 1: HTML Basics & Structure

• Introduction to web development
• Setting up VS Code and live server
• HTML document structure
• Headings, paragraphs, line breaks
• Lists, links, images

Day 2: HTML Layout & Forms

• Grouping elements: <div>, <span>
• Tables: structure and use
• Form elements: <input>, <label>, <button>, <textarea>, <select>

Day 3: Semantic HTML & Accessibility

• Semantic tags: <header>, <nav>, <main>, <footer>
• Accessibility principles: alt text, labels, proper structure
• HTML validation and formatting best practices

CSS Foundations (Days 4-6)

Day 4: CSS Basics

• Syntax, selectors, comments
• Color, font, and text styling
• Applying CSS (inline, internal, external)

Day 5: Box Model & Visual Styling

• Box model: padding, margin, border
• Display types: block, inline, inline-block, none
• Width, height, background properties

Day 6: Flexbox, Grid & Animations

• Flexbox layout: display: flex, justify-content, align-items
• CSS Grid basics: grid-template-columns, grid-gap, grid-area
• CSS transitions and keyframe animations

JavaScript Fundamentals (Days 7-15)

Day 7: JavaScript Introduction

• Script tag, console, debugging
• Variables (let, const), data types

Day 8: Operators & Conditionals

• Arithmetic, comparison, logical operators
• if, else, switch statements

Day 9: Loops & Control Flow

• for, while, do…while
• Loop control: break, continue

Day 10: Functions

• Declaring and calling functions
• Parameters, return values
• Function scope

Day 11: Arrays & Objects

• Creating and accessing arrays/objects
• Basic array methods (push, pop, length)
• Object properties and access

Day 12: DOM Manipulation

• Selecting elements (getElementById, querySelector)
• Modifying content and styles

Day 13: Event Handling

• addEventListener
• Handling form input, clicks, and user interactions

Day 14: JavaScript Destructuring

• Array and object destructuring
• Nested destructuring
• Function parameter destructuring

Day 15: JavaScript Modules (ES6)

• export, import syntax