- Pivot Tables & Charts
- VLOOKUP / XLOOKUP
- INDEX / MATCH
- Conditional Formatting
- Data Cleaning
- Charting
- VBA Automation
- Dashboard Creation
|
- Interactive Dashboards
- Data Connections (Excel, SQL)
- Filters & Parameters
- Highlight Tables
- Calculated Fields
- Dual-Axis Charts
- Maps & Geo Visualization
- Color Encoding & Tooltips
|
- Pandas
- NumPy
- Matplotlib
- SQLAlchemy
- Scikit-learn
- Flask
- BeautifulSoup
- Requests
- Geoviews
- Keras
- Tensorflow
- Nueral Networks
- Streamlit
- JSON
- APIs
- PPrint
- PySpark
|
- SELECT, JOIN, GROUP BY, ORDER BY
- Aggregate Functions (COUNT, SUM, AVG)
- Subqueries & CTEs
- CASE WHEN Logic
- Table Creation & Keys
- Data Insertion & Updates
- PostgreSQL, MySQL, SQLite
- SQL with Python (SQLAlchemy)
|
- MongoDB & Firebase
- Document-Based Schema Design
- CRUD Operations
- MongoDB Queries & Filters
- JSON Structure & Parsing
- Embedding vs. Referencing
- MongoDB Compass
- PyMongo (MongoDB in Python)
|
- DOM Manipulation
- Event Handling
- Functions & Loops
- Array & String Methods
- Fetch API & JSON Parsing
- D3.js Visualizations
- Plotly.js Graphing
- Interactive UI Logic
|
- Semantic HTML5 Structure
- Forms & Input Elements
- Tables & Lists
- Anchor Links & Navigation
- Meta Tags & Viewport Setup
- Image & Media Embedding
- Accessibility Practices
- External Resources & Fonts
|
- Flexbox & Grid Layout
- Responsive Design (Media Queries)
- Styling Tables & Forms
- Hover & Focus Effects
- Typography & Color Themes
- CSS Transitions & Animations
- Bootstrap & Tailwind CSS
- External Stylesheets & Google Fonts
|