Digital Analytics Training

Website Designing with WordPress

• What is Domain Name
• Types of Domains
• Register a Domain Name
• Domain & Hosting
• Secure Socket Layer (SSL)
• Domain Name Server (DNS)
• WordPress Installation
• Theme Settings and Customization
• Categories, Tags and Posts
• Pages and Sub Pages
• Adding a menu to the website
• Plugins and Widgets
• Using Plugins in Site
• Adding widgets to the website
• Yoast SEO Plugin
• WooCommerce Plugin
• Website Speed up Process
• Core Web Vitals

Introduction of Digital Marketing

• What is Digital Marketing?
• Benefits of Digital Marketing
• Traditional Digital Marketing
• List of Search Engines
• Types of Digital Marketing

About Search Engine

• How does the search engine work?
• 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
• Social Signals & Footer

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
• 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

• Introduction to Paid Advertising
• Google Ads Account setup
• Account Structure
• PPC Campaign Settings
• Ad Group setup
• Keyword Match Types
• Keyword Research Tools (Google Keyword Planner)
• Ad Formats & Guidelines
• Ad Extensions
• Understanding Ad Auction
• What is Quality Score
• Factors to improve Quality Score
• Actual CPC Calculation
• Types of CPC’s
• Bidding strategies
• What is Conversion?
• Implementing conversion tracking
• Calculating ROI
• What is DSA ?
• Create a DSA Campaign?
• Segments and Filters
• Search Terms and Ad Auctions
• Customization Tools
• Generating Reports

Google Ads Express

• What is Ads Express (Smart Campaign)
• Benefits of Smart Campaign
• Creating Campaign for Local Results
• Bidding & Budgets Setup
• Ad Creation
• Reports

Facebook Marketing

• Types of Facebook Account
• Personal Account Setup
• Facebook business page setup
• Types of Business pages
• Cover Photo/Video Design
• Page Settings & Options
• Types of Posts and Statistics
• Designing FB Posts using canva
• User engagement metrics
• Facebook Insights
• Facebook Groups

Facebook Advertising

• What is Facebook Ads
• Types of Objectives
• Popular Ads Campaigns
• Defining Target Audience
• Types of Targeting
• Bidding & Budget Settings
• Types of Ads
• Designing FB Ads
• Setup of Facebook Pixel
• Conversion Tracking Pixel
• Remarketing Strategy
• Reports & Analytics

YouTube Marketing

• Creating Channel in YouTube
• Customizing the YouTube Channel
• Types of Video Formats
• Create video marketing strategy
• Upload the First Video
• Video Optimizing Tips
• Video Settings
• Cards, End Screens & Sub Titles
• How to use Playlists
• YouTube Creator Studio
• Features of Creator Studio
• YouTube Analytics
• Increasing Subscribers
• Understanding copyrights and spam

Instagram Marketing

• Creating Instagram Account
• Types of Instagram Accounts
• Linking Instagram with Facebook
• Types of Content (Posts & Stories)
• Post Designing Tools (canva)
• Stories & Highlights
• Importance of Hashtags
• How to use Hashtags
• Instagram Analytics
• Instagram Ads
• Types of Campaign
• Creating your Campaign
• Measuring Results

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, JSON, Folders, and Web
• Understanding Data Connectivity Modes – Import Mode
• Understanding Data Connectivity Modes – Direct Query Mode

3. Data Cleaning (Power Query Editor):

• Creating Custom Columns in Power Query
• Managing and Splitting Columns
• Reducing Rows in Power Query
• Applied Steps and Error Handling
• Transforming Unstructured Data
• Exploring Transform Menu Options
• Pivoting Data in Power Query
• Unpivoting Columns
• Transforming Text, Numbers, Dates, and Times
• Filtering and Sorting Data in Power Query
• Grouping Data in Power Query
• Merging Queries in Power Query
• Appending Queries in Power Query
• Removing Duplicate Rows in Power Query
• Creating Conditional Columns and Custom Logic
• Using Group By for Data Aggregation
• Extracting Data from JSON and XML Sources
• Applying Date and Time Functions in Power Query
• Creating and Using Query Parameters
• Data Profiling and Quality Control in Power Query

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 with Real-World Examples
• Establishing a One-to-One Relationship
• Establishing a One-to-Many Relationship
• Establishing a Many-to-Many Relationship
• Cross Filter Direction
• Best Practices for Managing Relationships
• Data Models
• Gaining insight into Flat or Denormalized Structures with a real-life example
• Exploring the Star Schema with an actual use case
• Understanding the Snowflake Schema with a real-world illustration
• Normalization & Denormalization
• Understanding How to Normalize Real-Time Data

5. DAX – Data Analysis Expression:

• Introduction to DAX (Data Analysis Expressions)
• Overview of DAX and its role in Power BI, Power Pivot
• Purpose of DAX for creating custom calculations, aggregations, and enhancing data models.
• DAX Syntax and Functions
• Structure and syntax of DAX formulas.
• Commonly used DAX functions and operators.
• Creating Calculated Columns and Measures
• Differences between Calculated Columns and Measures.
• How to create Calculated Columns and Measures in Power BI.
• Performing Basic Calculations with DAX
• Basic arithmetic operations and common aggregation functions: SUM, AVERAGE, MIN, MAX.
• Calculating totals and averages using DAX.
• Measures vs. Calculated Columns: Key Differences
• Static calculations in Calculated Columns vs. dynamic, context-based calculations in Measures.
• When to use one over the other.
• Aggregation Functions in DAX
• Key aggregation functions: SUM, COUNT, AVERAGE, DISTINCTCOUNT, COUNTROWS.
• Aggregating data at different levels of detail.
• Logical Functions in DAX
• Conditional logic with IF, SWITCH.
• Complex logical expressions and handling multiple conditions.
• Time Intelligence in DAX
• Year-over-Year (YoY) comparisons, running totals, and other date-based calculations.
• Time Intelligence functions: SAMEPERIODLASTYEAR, TOTALYTD, DATESYTD, etc.
• Advanced DAX Functions
• CALCULATE, FILTER, and ALL functions for modifying filter context and performing advanced calculations.
• Using these functions for complex scenarios and calculations.
• Context in DAX
• Row Context: Row-wise calculations and iteration.
• Filter Context: Impact of filters applied in reports on DAX calculations.
• Iterators in DAX
• functions like SUMX, AVERAGEX, MINX, MAXX for row-wise calculations
• Using iterators to perform calculations across tables.

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

7. Power BI Service

Introduction to Python

• What are Python and the history of Python?
• Unique features of Python
• Python-2 and Python-3 differences
• Install Python and Environment Setup
• First Python Program
• Python Identifiers, Keywords, and Indentation
• Comments and document interlude in Python
• Command-line arguments
• Getting User Input
• Python Data Types
• What are the variables?
• Python Core objects and Functions
• Math Module

Control Statements

• If
• If-elif-else
• while loop
• for loop
• Break
• Continue
• Assert
• Pass
• return

List, Ranges & Tuples in Python

• Introduction
• Lists in Python
• Generators and Yield
• Generators Comprehensions and Lambda Expressions
• Next() and Range()
• Understanding and using Range

Python Dictionaries and Sets

• Introduction to the section
• Python Dictionaries
• More on Dictionaries
• Sets
• Python Sets Examples

Input and Output in Python

• Reading and writing text files
• Writing Text Files
• Appending to Files and Challenge
• Writing Binary Files Manually

Python built-in function

• Python Modules & Packages
• Python User defined functions
• Defining and calling Function
• The anonymous Function

Introduction to Data Analytics with Python

• Overview of Data Analytics and its applications
• Python basics for data analytics
• Introduction to Jupyter Notebook for code and data visualization
• Setting up the Python environment and installing key libraries

Data Handling with Pandas

• Introduction to Pandas: Series, DataFrames, and Data Structures
• Importing, exporting, and handling data with Pandas
• Data cleaning: handling missing data, duplicates, and data transformations
• Data aggregation, grouping, and summarization
• Merging and joining datasets

Numerical Computation with NumPy

• Introduction to NumPy and its importance in data analytics
• Working with arrays, array indexing, and slicing
• Mathematical operations with NumPy
• Array manipulations and reshaping
• Random number generation for data simulation

Data Visualization with Matplotlib

• Introduction to Matplotlib for basic plotting
• Customizing charts (labels, colors, styles)
• Plot types: line, bar, scatter, histogram, etc.

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