The Perfect Data Analytics Course For Digital Marketers
Weekend Batch Starts : 19th June, 6:30 - 9:30 pm
Weekday Batch Starts : 22nd July, 7:30 - 9:30 pm
Days
Hours
Minutes
Seconds
Syllabus designed with respect to the growing demand of skills in digital marketers beyond campaigns
Advanced Ms Excel
Conditional Formatiing, Cells & Data, Vlookup, hlookup, Writing Macros, SQL linking, solver analysis, MIS Dashboard, Concat
- Absolute Reference
- Index Match
- Filters
- Pivot Tables
- Power Pivots & ...
Tableau
Interactive Filters, Maps, Joining and importing Multiple data from multiple sources. Advanced Dashboards, Storytelling.
- DAX functions
- Power Query
- Dashboards
- Joining On Multiple Fields
SQL
Creating and Dropping Databases, Retrieving Data From a Single and Multiple tables, Database linking, Select, Insert, Create
- Joins
- And Or Operators
- Conditional Clauses
- Logical Models
- Foreign Keys & ..
Power BI
Data Model Optimization, creating hierarchies, KPIs, Concurrent Dashboards
- DAX functions
- visual, page, report filters
- Power Query, Power view, Power maps
Google Tag Manager
Events, Conversion tracking, custom dimensions, custom metrics, Data layer concept
- url parameters extraction to tags
- GA4 ecommerce implementation via GTM
- User behavior metrics tracking
Google Analytics
Custom Reports, Dashboards, Universal Analytics, GA4 setup,Audience Insight, behaviour reports, Analytics for ecommerce
- Goal setup and reports
- Custom dimension and metrics
- Goals and funnels
- Audience segmentation
Google Data Studio
Bar charts, pivot table, scatter plots, Geo maps, tree maps, linking marketing platforms data
- Filter controls for viewers
- Blending data from multiple tables
- Pulling data from Google ads, Facebook ads
Addons
Url TRacking parameters, Webhooks, MS Visio
- Import, manipulate, and visualize business data in Ms Visio
- Taxonomy structure