Data Analytics program
-
68 learners
Enrolled -
4 hours
Video duration -
27 hours
Course duration -
4 Ebooks
Free of charge
What tools you will work with & Learn
Advanced Excel
- FlashFill
- Data Validation
- Filtering and Sorting
- Conditional Formatting
- Charts
- Dashboarding
- Vlookup
- XLookup
- Match & Index
- Text Formulas
- Date & Time Formulas
- Statistical Formulas
- Forecasting Formulas
- Pivot Tables
- Formulas
Advanced SQL
- Joins
- Window Functions
- Subqueries
- Case Handling
- Temp Tables
- Indexing and Schema building
- System Design
Data Cleaning
Data Standardisation
- Data Transformation
- Data Enrichment
- Types of Data Standardisation
- General Data Standards
PowerBI
- Data Sources
- Data Transformation
- Custom Visuals
- Drill-Through and Drill-Down
- Bookmarks and Selections
- Tooltips
- Data Sensitivity Labels
- Data Classification
- Aggregations
- Composite Models
- Pivoting and Unpivoting
- Relationships
- Data Modeling
- DAX
- Row-Level Security
Data Storytelling
- Storytelling Frameworks
- Why Storytelling is Important
- Narrative Arc
- Analogies and metaphors
- Contextualisation
- 5 Step Framework
- Data Driven Framework
- The Story-circle Framework