Proposal
Internship Module for MBA / BBA / [Link] / BCA / MCA / ME / [Link] Computer Science / PGDCA
BI and Digital Marketing : Duration minimum 1month for the course which can be extended / decreased as per the curriculam needs keeping in view the Advance
and Basic model
Advanced Excel : Power Booster Workshop for all ( 3 days )
the same can be extended upto 1 week
Curriculam Details for Summer School
The Power BI Course Curriculum is designed by Microsoft Power BI Certified Experts. Our Power BI Course Syllabus covers basic to
advanced level concepts that consist of Report Designing, Visual Sync, Grouping, Hierarchies, Filters, Bookmarks, Azure, Modelling,
DAX Functions - Level 1
A. Course Details : Power BI
Who can attend : anyone who has interest in programming .
Module 1: SQL SERVER INTRODUCTION
Data, Databases and RDBMS Software
Database Types: OLTP, DWH, OLAP
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server
SQL: Purpose, Real-time Usage Options
SQL versus Microsoft T-SQL [MSSQL]
Microsoft SQL Server - Career Options
SQL Server Components and Usage
SQL Query like DELETE, ALTER, UPDATE
SQL Query DML,DDL,TCL etc.
Module 2: Introduction to Power BI
Power BI Job Roles in Real-time
Power BI Data Analyst Job Roles
Business Analyst - Job Roles
Power BI Developer - Job Roles
Power BI for Data Scientists
Comparing Tableau and Power BI
Types of Reports in Real-World
Module 3: Basic Report Design
Power BI Desktop Installation
Data Sources & Visual Types
Canvas, Visualizations and Fields
Get Data and Memory Tables
In-Memory xvelocity Database
Table and Tree Map Visuals
Format Button and Data Labels
Legend, Category and Grid
PBIX and PBIT File Formats
Module 4: Hierarchies, Filters
Creating Hierarchies in Power BI
Independent Drill-Down Options
Dependant Drill-Down Options
Conditional Drilldowns, Data Points
Drill Up Buttons and Operations
Expand & Show Next Level Options
Dynamic Data Drills Limitations
Show Data and See Record
Digital Marketing
Module 2: SEO
Module 1: Introduction What is SEO?
What Exactly is Digital Marketing? What is SERP?
Digital Marketing Vs Traditional What is one Page seo?
Marketing How to Select a Domain Name?
What is B2B & B2C Marketing? Page Naming (URL Structuring)
How to Start Digital Marketing? Image Naming, Image Title and ALT Tags Creation
What is Traffic? What are Meta Tittle
What is Keywords? What Is Meta Description
One By One Process Of Digital Marketing Search Engine Optimization(on Page SEO)
How to get Traffic? Headings Tags {H1 to H6}
How to Engage Traffic on Website? What is Content Writing?
Types Of Lead& Conversion SEO Friendly Content Writing {Insert keywords in content}
How to Retain your Web Customer? Anchor Text, Link Title
Analysis your Traffic Sources & ROI [Link] file use and creation
Benefit Of Digital marketing HTML Sitemap creation
XML Site Map Creation
Tools for seo
Site Tracking Tools (Google Webmaster Tool, Google Analytics Tool
Module 3 : Off Page Seo
Module 5: Google Adwords( Search Advertising)
What are Backlinks?
Why Backlinks are Important? Introduction to PPC & Adwords
How to Get Backlinks? Setting Up Google Adwords Account
Difference Between Do-Follow and Payment Option- Which is better ?
No-Follow Backlinks Create First Campaign
What is Google Page Rank? Understanding Adgroup, Ads, Keyword Concept
How to Increase Page Rank? Learn Biding Strategy
Search Engine Submissions Geo Targeting
Directory Submissions Site Link Extensions
Article Writing and submissions Phone Extensions
Module 4: Advance SEO Module 6: Social Media Marketing
How to optimize your site for Google Hummingbird Algorithm? What is Social media Marketing
What is Google Panda Algorithm? How to market Company’s Product On Social Media
What is Google Penguin? Why Social Media is Important?
What is Google EMD Update? 7 Wonders of Social Media
How to save your site from Google Panda, Penguin and EMD Create your Profile One by one
Update?
How to recover your site from Panda, Penguin and EMD?
Black Hat SEO( Use at your Own Risk)
Facebook Marketing
History of Facebook
How to market on Facebook
Create your Company Page,
Group
How to manage your One week Post in Advance Module 7 : Lead Generation
How to increase your Facebook Likes( White
hat) How to get likes in bulk( Do it at your Own
Risk) How to Engage your Fan on Page Definition of an online sales Lead
Make your Post Viral Cold, Warm and Hot leads
Do some extra activity( Updated What is landing page?
part) Facebook PPC( Advertisement) Difference Between Landing page & Website
Example of some Successful Facebook Page How to create landing page?
How to use Thank you page?
Twitter Marketing Tools to create landing page
What is A/B testing?
Introduction to Twitter Lead Funnel
Create your Proflie Converting Leads into sales through internet Marketing
Why is it
Microbloging?
How to increase Followers (White & Black hat)
How to Market your Product
Understanding # (Hastag)
concept Advertising on Twitter
Tools for Twitter Marketing
Example of Successful
Twitter Company Page
Day 1: (5 Hours )
Power Booster Advance Excel
Macros vs VBA - What's the Difference?
Setting up the Macro Environment
Creation of Macro
Running Macros: Using the Macro Dialog /Using Keyboard Shortcuts/Using Button
Day 2 : (5 Hours )
Flash Fill
Data Tables in Excel
A Second Data Table
Excel Scenarios
Goal Seek
Absolute Cell References
Named Ranges in Excel
Create a Custom Name in Excel
More on Named Ranges
Excel Pivot Tables
Pivot Tables, Part Two
Day 3 : (5 Hours )
The LOOKUP Functions
The VLOOKUP Function in Excel
Searching with MATCH and INDEX
Create a Business Invoice, Part
One Excel Business Invoice, Part Two
Business Invoice, Part Three/ payroll / Balance sheet
The students of all branches can attend
Student Take away :
A) We will provide software i.e. ( for installation) coursework and certifications.
B) Knowledge on the latest technologies
C) Placement assistance ( guidance is available for 1 year) (* this will include Pre-Placement needs and not the course revision or certifications )
Minimum strength of 50 students is needed for the course .
Thanks and Regards
Dr. Tulika
Mehta Director
Kaizen Systems
Contact no : 6284949125
Email : kaizensystems34@[Link]
info@[Link]