Curriculum
8 Sections
117 Lessons
10 Weeks
Expand all sections
Collapse all sections
Advance Excel
39
1.1
Quick review on MS Excel Options, Ribbon, Sheets
1.2
Saving Excel File as PDF, CSV and Older versions
1.3
Using Excel Shortcuts with Full List of Shortcuts
1.4
Copy, Cut, Paste, Hide, Unhide, and Link the Data in Rows, Columns and Sheet
1.5
Using Paste Special Options
1.6
Formatting Cells, Rows, Columns and Sheets
1.7
Advanced Filtering in Excel
1.8
Grouping & Subtotal in Excel
1.9
Protecting & Unprotecting Cells, Rows, Columns and Sheets with or without Password
1.10
Page Layout and Printer Properties
1.11
Working with Formulas / function
1.12
Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, etc
1.13
Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc
1.14
Database Functions
1.15
Date & Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY
1.16
Information Functions
1.17
Math & Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, EVEN, SUMIF
1.18
Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK,COUNTIF, MAX, MAXA,MIN, MINA, STDEVA
1.19
Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE.
1.20
Conditional Formatting
1.21
Using Conditional Formatting
1.22
Using Conditional Formatting with Multiple Cell Rules
1.23
Using Color Scales and Icon Sets in Conditional Formatting
1.24
Creating New Rules and Managing Existing Rules
1.25
Data Lock & Protection
1.26
Advance Charts in Excel
1.27
Area Charts and Surface Charts
1.28
Trend line Charts and Candle Stick
1.29
Charts and Pie Charts
1.30
XY (Scatter Charts)
1.31
Time Series Charts and Bubble Charts
1.32
Radar Charts and Doughnut Charts
1.33
Rotating 3D Excel Charts
1.34
Working with Fill Series & Go to Special
1.35
Consolidation in Excel
1.36
What if Analysis in Excel
1.37
-Goal Seek
1.38
-Scenario Manager
1.39
-Data Table
AI Automation with Excel
6
2.1
Working with Histogram
2.2
Helps in summarize discrete or continuous data
2.3
Helps in identifying the most efficient pricing plans in sales & marketing
2.4
It will determine the issues with a certain process
2.5
Calculating peak time hours in restaurants & Hospitals
2.6
To identify the trading potential
Regression Analysis in Excel
5
3.1
To Measure the Effectiveness of the Marketing Campaigns, Pricing, And Promotions On Sales Of A Product
3.2
Used To Analyse Categorical Data
3.3
Commonly Used In Understanding Customer Behaviour
3.4
To Understand the Relationship between a Company’s Stock Price & The Company’s Quarterly Earnings
3.5
Credit Risk Assessment
Working With Forecasting
5
5.1
Sales Forecasting
5.2
Demand Forecasting
5.3
Forecasting For Decision Making
5.4
Being Able To Generate Scenarios – Optimistic, Pessimistic, What If We Win This Tender?
5.5
Know How To Capture Information About Significant Market Events.
Solving Complex Data Using The Power Query In Excel
0
Professional Dashboards In Excel
5
9.1
Interactive Sales Dashboard In Excel
9.2
Bank & Marketing Dashboard
9.3
Interactive HR Dashboard In Excel
9.4
Project Management Dashboard In Excel
9.5
Call Centre Dashboard In Excel
Microsoft Power BI
34
10.2
COMPONENTS OF POWER BI: DESKTOP, SERVICE, AND MOBILE APPS
10.3
BENEFITS AND APPLICATIONS OF POWER BI
10.4
POWER BI ARCHITECTURE OVERVIEW
10.5
INSTALLING AND SETTING UP POWER BI DESKTOP
10.6
CONNECTING TO DATA SOURCES (EXCEL, CSV, ONLINE SERVICES, ETC.)
10.7
Dashboards Creation
10.8
CLEANING AND TRANSFORMING DATA
10.9
HANDLING MISSING DATA SPLITTING AND MERGING COLUMNS
10.10
DATA FORMATTING AND STANDARDIZATION WORKING WITH RELATIONSHIPS BETWEEN TABLES
10.11
CREATING CUSTOM COLUMNS AND MEASURES WITH DAX (DATA ANALYSIS EXPRESSIONS)
10.12
CREATING RELATIONSHIPS BETWEEN TABLES UNDERSTANDING
10.13
CALCULATED COLUMNS AND MEASURES
10.14
MANAGING MODEL PERFORMANCE WITH OPTIMIZATION TECHNIQUES
10.15
CREATING BASIC CHARTS: BAR, LINE, PIE, AND COLUMN CHARTS
10.16
ADVANCED VISUALS: SCATTER PLOTS, MAPS, FUNNEL CHARTS, & GAUGES USING SLICERS, FILTERS, & DRILL-THROUGHS.
10.17
CREATING AND CUSTOMIZING DASHBOARDS FORMATTING AND STYLING REPORTS FOR BETTER USER EXPERIENCE USING POWER BI MARKETPLACE FOR CUSTOM VISUALS
10.18
DAX (DATA ANALYSIS EXPRESSIONS)
10.19
CALCULATED COLUMNS AND MEASURES
10.20
AGGREGATION FUNCTIONS (SUM, AVERAGE, COUNT)
10.21
TIME INTELLIGENCE FUNCTIONS (YTD, MTD, QTD)
10.22
PUBLISHING AND SHARING
10.23
PUBLISHING REPORTS TO POWER BI SERVICE
10.24
CREATING DASHBOARDS IN POWER BI SERVICE
10.25
SHARING REPORTS AND DASHBOARDS WITH OTHERS
10.26
EXPORTING REPORTS TO PDF
10.27
POWER BI FOR BUSINESS USE CASES
10.28
SALES ANALYSIS
10.29
FINANCIAL REPORTING
10.30
CONNECTING POWER BI DESKTOP WITH MOBILE FOR REAL TIME ANALYSIS
10.31
CASE STUDIES AND LIVE PROJECTS
10.32
RETAIL ANALYSIS DASHBOARDS
10.33
TELECOM CHURN RATE DASHBOARD
10.34
OLA COMPANY DASHBOARD
10.35
BLINKIT ANALYSIS DASHBOARD
Database design with SQL
23
11.2
INTRODUCTION
11.3
WHAT IS A DATA WAREHOUSE ?
11.4
STAR SCHEMA
11.5
PROJECT MANAGEMENT DASHBOARD IN EXCEL
11.6
OLAP VS. OLTP
11.7
SETL
11.8
ENTITY CONSTRAINTS
11.9
DDL AND DML STATEMENTS
11.10
SQL STATEMENTS AND OPERATORS
11.11
AGGREGATE FUNCTIONS
11.12
ORDERING
11.13
STRING AND DATE-TIME FUNCTIONS
11.14
REGULAR EXPRESSIONS
11.15
NESTED QUERIES
11.16
CTES
11.17
VIEWS
11.18
SET THEORY
11.19
TYPES OF JOINS
11.20
TYPES OF JOINS: A DEMONSTRATION
11.21
OUTER JOINS: A DEMONSTRATION
11.22
VIEWS WITH JOINS
11.23
SET OPERATIONS WITH SQL
11.24
ASSIGNMENT & CASE STUDY
Business analytics with AI
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Your Website
Modal title
Main Content