Data Analysis + Science (Updating)
-
Data Entry and Management
-
Formulas and Functions
-
Data Cleaning with Excel
-
Data Analysis using Excel
-
Visualization
-
Advanced Functions
-
Power Query
-
Power Pivot
-
Macros and VBA
-
Collaboration and Sharing
-
Data Security
-
Integration with Other Tools
-
SQL
-
More on SQLDISTINCT keyword0sLIMIT clause0sAliases (AS keyword)0sAggregations and Grouping0sCOUNT, SUM, AVG, MIN, MAX functions0sGROUP BY clause0sHAVING clause0sJoins0sINNER JOIN0sLEFT JOIN (or LEFT OUTER JOIN)0sRIGHT JOIN (or RIGHT OUTER JOIN)0sFULL JOIN (or FULL OUTER JOIN)0sCROSS JOIN0sSELF JOIN0sSubqueries0sInline subqueries0sCorrelated subqueries0sEXISTS and NOT EXISTS0sSet Operations0sUNION and UNION ALL0sINTERSECT0sEXCEPT (or MINUS in some databases)0sData Manipulation0sINSERT statements0sUPDATE statements0sDELETE statements0s
-
Advanced SQL Functions
-
Window Functions
-
Indexes and Performance Optimization
-
Database Design and Normalization
-
Views
-
Stored Procedures and Functions
-
Transactions and Concurrency
-
Security
-
Advanced Topics
-
Integration with Other Tools
-
Statistics
-
Probability Theory
-
Inferential Statistics
-
Hypothesis Testing
-
Correlation and Regression Analysis
-
Analysis of Variance (ANOVA)
-
Non-Parametric Tests
-
Time Series Analysis
-
Bayesian Statistics
-
Multivariate Statistics
-
Statistical Process Control
-
Experimental Design
-
Survival Analysis
-
Data Ethics and Interpretation
-
Power BI
-
Data Preparation
-
Data Modeling
-
DAX (Data Analysis Expressions)Basics of DAX syntax and functions0sCreating calculated columns and measures0sUnderstanding row context and filter context0sCommon DAX functions (SUM, COUNT, AVERAGE, MIN, MAX)0sTime intelligence functions (DATEADD, DATESYTD, SAMEPERIODLASTYEAR)0sAdvanced DAX functions (CALCULATE, ALL, FILTER, RELATED)0s
-
Visualization
-
Advanced Visualization
-
Reports and Dashboards
-
Power BI Service
-
Power BI Embedded
-
Security
-
Performance Optimization
-
Advanced Analytics
-
Power BI Integration
-
Power BI Administration
-
. Power BI Community and Resources
-
Python