Grade "A+" Accredited by NAAC with a CGPA of 3.46
Upon course completion, students will possess the skills to proficiently utilize advanced Excel tools, Power BI, data modelling, and Tableau. The course recognizes the expansive nature of Data Science and Business Intelligence, which constantly evolves. The program’s objective is to cultivate a cohort of learners who will continually enhance their capabilities in line with industry developments, contributing to both their personal growth and the broader community’s success stories.
The design of this course aims to provide understanding and proficiency in advanced Excel tools, Power BI, and Tableau. These tools are in high demand within the contemporary business landscape.
Students, working professionals and faculty who want to upgrade their skill sets.
Upon finishing this course, students will be well-prepared to pursue internships and entry-level managerial positions in the marketing and finance sectors. The course not only introduces these tools to beginners but also provides practical experience, enhancing their comprehension. As a result, students will have a solid foundation to confidently use these tools and apply their skills in real-world settings. This exposure is particularly valuable for those seeking internships, as it equips them with the necessary expertise to excel in their roles.
Experts from the industry and accomplished professionals with strong domain knowledge and faculty from eminent business schools.
Account Name: Principal SSCBS Students Society A/C
Bank: State Bank of India
Account Number: 35810781108
IFS Code: SBIN0011550
MICR: 110002303
Branch: (11550)- Pascon Building Garg Trade Centre, Sector-11, Rohini, New Delhi-110085
Title: ADVANCED EXCEL
Duration (Hours): 15
DATA CLEANING AND PROCESSING
ADVANCED DATA CLEANING AND PROCESSING
FORMULAS AND FUNCTIONS
ADVANCED FUNCTIONS
BASIC VLOOKUP
ADVANCED LOOKUP
PIVOT TABLES AND CHARTS
ADVANCED PIVOT TABLES
BASIC CHARTS
ADVANCED CHARTS
HANDLING DATES
ADVANCED DATE FUNCTIONS
CONDITIONAL FORMATTING
ADVANCED CONDITIONAL FORMATTING
PRACTICAL STATISTICS
DYNAMIC ARRAYS
Title: VBA AUTOMATION
Duration (Hours): 5
INTRODUCTION TO VBA
Setting up your environment
Excel object library
Write and run your first code
Data types
Variables
If else statements
Loops
Built in boxes – MessageBox, InputBox
Recording Macros – automate your tasks
Create your own UserForm
Title: POWERPOINT
Duration (Hours): 10
Navigation + Shortcuts
Starting with Templates
Working with Shapes
Using Colors Effectively
Process Charts
Working with Images
Working with Icons
Working with Text
How Fonts work
Working with Tables
Morph, Animation and Zoom Effect
Working with Charts
Working with Video and Audio
Export Options, Protect Options
Presenting
Title: POWER BI – BASICS OF DATA VISUALIZATION
Duration (Hours): 25
Connecting to different data sets
Basic data prep and model on Power Query
Drill down and Tooltip
Ai visuals (Q&A, Analyze, Decomposition)
Inbuilt visuals
Custom visuals
Visualization as a Tooltip
Learn from existing reports
Final dashboard – putting it together
Filter, slicer, bookmarks, buttons
Date tables
Relationship
Basic DAX
Merge and append
Conditional columns
Custom calculations
Column from examples
Title: POWER BI – ETL AND DATA MODELING
Duration (Hours): 15
Advanced Editor
Advanced Merge and Append
Reference and Duplicate Query
Combine Multiple Sheets and Multiple Workbooks
Split Into Rows / Combine into Row
Introduction to DAX
Calculated Column vs Measures
CALCULATE, FILTER, ALL, RELATED, UNION
AVERAGEX, SUMX, SUMMARIZE
DATE TABLE AND TIME INTELLIGENCE FUNCTIONS
TOPN, RANK, CONCATENATEX
DAX PATTERNS
POWER QUERY PARAMETERS (M)
CUSTOM FUNCTIONS (M)
CUSTOM DATE TABLES (M)
WHAT IF SCENARIO (DAX)
ADVANCED VISUALIZATIONS
CUSTOMIZING VISUALIZATIONS AND TOOLTIPS
Title: TABLEAU
Duration (Hours): 5
Getting Data Ready
Dimensions and Measures
Understand Marks Card
Visualizations – Heat map, Tables, Maps, Bar, Column, Pie
Format Visualizations
Creating Custom Charts
Create Calculated Fields
Create Parameters
Create Story and Dashboards