Basic arithmetic operations

0s

Logical functions (IF, AND, OR, NOT)

0s

Text functions

0s

CONCATENATE, LEFT, RIGHT, MID

0s

Date and time functions

0s

TODAY, NOW, DATEDIF

0s

Lookup functions

0s

VLOOKUP, HLOOKUP, INDEX, MATCH

0s

Statistical functions

0s

AVERAGE, MEDIAN, MODE, STDEV

0s

Removing duplicates

0s

Handling missing data

0s

Text to Columns

0s

Find and replace

0s

TRIM, CLEAN, SUBSTITUTE functions

0s

PivotTables and Pivot Charts

0s

Data tables

0s

Conditional formatting

0s

What-If Analysis

0s

Goal Seek, Data Tables, Scenario Manager

0s

Creating and customizing charts

0s

Bar, line, pie, scatter

0s

Sparklines

0s

Heat maps

0s

Creating dashboards

0s

Array formulas

0s

Advanced lookup (XLOOKUP)

0s

SUMIFS, COUNTIFS

0s

Data transformation

0s

Merging and appending queries

0s

Advanced data manipulation

0s

Creating data models

0s

Using DAX (Data Analysis Expressions) for advanced calculations

0s

Recording and running macros

0s

Basic VBA scripting for automation

0s

Protecting worksheets and workbooks

0s

Sharing and tracking changes

0s

Using Excel online and collaborative features

0s

Password protection

0s

Encrypting workbooks

0s

Using secure connections for data sources

0s

Connecting Excel with databases (SQL)

0s

Importing data from external sources (APIs, web scraping)

0s

Using Excel with BI tools (Power BI, Tableau)

0s

Basic SQL Queries

0s

SELECT statements

0s

Filtering data with WHERE clause

0s

Sorting data with ORDER BY

0s

DISTINCT keyword

0s

LIMIT clause

0s

Aliases (AS keyword)

0s

Aggregations and Grouping

0s

COUNT, SUM, AVG, MIN, MAX functions

0s

GROUP BY clause

0s

HAVING clause

0s

Joins

0s

INNER JOIN

0s

LEFT JOIN (or LEFT OUTER JOIN)

0s

RIGHT JOIN (or RIGHT OUTER JOIN)

0s

FULL JOIN (or FULL OUTER JOIN)

0s

CROSS JOIN

0s

SELF JOIN

0s

Subqueries

0s

Inline subqueries

0s

Correlated subqueries

0s

EXISTS and NOT EXISTS

0s

Set Operations

0s

UNION and UNION ALL

0s

INTERSECT

0s

EXCEPT (or MINUS in some databases)

0s

Data Manipulation

0s

INSERT statements

0s

UPDATE statements

0s

DELETE statements

0s

String functions

0s

CONCAT, SUBSTRING, REPLACE

0s

Date and time functions

0s

NOW, DATEADD, DATEDIFF

0s

Numeric functions

0s

ROUND, CEIL, FLOOR

0s

OVER clause

0s

ROW_NUMBER(), RANK(), DENSE_RANK()

0s

LEAD() and LAG()

0s

Creating and using indexes

0s

Understanding query execution plans

0s

Optimizing queries for performance

0s

Understanding primary keys and foreign keys

0s

Normal forms (1NF, 2NF, 3NF)

0s

Designing relational database schemas

0s

Creating and using views

0s

Updating data through views (when possible)

0s

Creating and using stored procedures

0s

Creating and using user-defined functions

0s

Understanding the differences and use cases

0s

BEGIN, COMMIT, and ROLLBACK

0s

Understanding ACID properties

0s

Managing transaction isolation levels

0s

Managing user permissions and roles

0s

Using GRANT and REVOKE statements

0s

Understanding database security best practices

0s

Common Table Expressions (CTEs)

0s

Recursive queries

0s

Pivoting and unpivoting data

0s

Connecting SQL with BI tools (Power BI, Tableau)

0s

Using SQL in combination with programming languages (Python, R)

0s

Descriptive Statistics

0s

Measures of central tendency (mean, median, mode)

0s

Measures of dispersion

0s

Range, variance, standard deviation, interquartile range

0s

Measures of shape (skewness, kurtosis)

0s

Data visualisation techniques

0s

Histograms, box plots, bar charts

0s

Basic probability concepts

0s

Independent and dependent events, conditional probability

0s

Probability distributions

0s

Normal, binomial, Poisson, exponential

0s

Probability density function (PDF)

0s

Cumulative distribution function (CDF)

0s

Law of large numbers and central limit theorem

0s

Population vs. sample

0s

Sampling methods (random, stratified, cluster)

0s

Sampling distributions

0s

Estimation (point estimates, confidence intervals)

0s

Null and alternative hypotheses

0s

Type I and Type II errors

0s

P-values and significance levels

0s

Common tests

0s

T-test, chi-square test, ANOVA, z-test

0s

One-tailed vs. two-tailed tests

0s

Pearson and Spearman correlation coefficients

0s

Simple linear regression

0s

Multiple linear regression

0s

Assessing model fit (R-squared, adjusted R-squared)

0s

Residual analysis

0s

One-way ANOVA

0s

Two-way ANOVA

0s

Assumptions and interpretation of results

0s

Mann-Whitney U test

0s

Wilcoxon signed-rank test

0s

Kruskal-Wallis test

0s

Chi-square test of independence

0s

Components of time series

0s

Trend, seasonality, cycle, irregular

0s

Moving averages and exponential smoothing

0s

Autocorrelation and partial autocorrelation functions

0s

ARIMA models (Auto-Regressive Integrated Moving Average)

0s

Bayesian theorem

0s

Prior, likelihood, and posterior distributions

0s

Bayesian inference and credibility intervals

0s

Principal component analysis (PCA)

0s

Factor analysis

0s

Cluster analysis

0s

Discriminant analysis

0s

Control charts (X-bar, R-chart, p-chart)

0s

Process capability analysis

0s

Principles of experimental design

0s

Randomization, replication, blocking

0s

Completely randomized design

0s

Randomized block design

0s

Factorial design

0s

Kaplan-Meier estimator

0s

Cox proportional hazards model

0s

Hazard functions and survival functions

0s

Understanding the ethical considerations in data analysis

0s

Avoiding common pitfalls and biases

0s

Ensuring transparency and reproducibility of results

0s

Getting Started with Power BI

0s

Understanding Power BI Desktop, Power BI Service, and Power BI Mobile

0s

Understanding Power BI Desktop, Power BI Service, and Power BI Mobile

0s

Basic navigation and interface of Power BI Desktop

0s

Data cleaning and transformation using Power Query Editor

0s

Merging and appending queries

0s

Data types and error handling

0s

Creating relationships between tables

0s

Understanding and using star and snowflake schemas

0s

Managing relationships (one-to-one, one-to-many, many-to-many)

0s

Using calculated columns and tables

0s

Basics of DAX syntax and functions

0s

Creating calculated columns and measures

0s

Understanding row context and filter context

0s

Common DAX functions (SUM, COUNT, AVERAGE, MIN, MAX)

0s

Time intelligence functions (DATEADD, DATESYTD, SAMEPERIODLASTYEAR)

0s

Advanced DAX functions (CALCULATE, ALL, FILTER, RELATED)

0s

Creating and customizing basic charts (bar, line, pie, scatter, etc.)

0s

Using slicers for filtering data

0s

Creating and customizing tables and matrices

0s

Using maps and geographical data visualizations

0s

Custom visualizations from the marketplace

0s

Using bookmarks and selections for interactive reports

0s

Creating drill-through and drill-down reports

0s

Implementing conditional formatting

0s

Designing report layouts and themes

0s

Creating and managing dashboards in Power BI Service

0s

Pinning visuals to dashboards

0s

Using Q&A feature for natural language queries

0s

Publishing reports to Power BI Service

0s

Understanding workspaces, apps, and content packs

0s

Managing datasets and data refresh schedules

0s

Sharing reports and dashboards with stakeholders

0s

Collaborating with team members

0s

Integrating Power BI reports into applications

0s

Using Power BI REST API for automation

0s

Implementing row-level security (RLS)

0s

Managing roles and permissions

0s

Understanding and applying data protection and compliance measures

0s

Optimizing data models for performance

0s

Using the Performance Analyzer tool

0s

Best practices for efficient report design

0s

Using AI visuals (Key Influencers, Decomposition Tree, Q&A Visual)

0s

Integrating R and Python scripts in Power BI

0s

Implementing what-if parameters for scenario analysis

0s

Connecting Power BI with other Microsoft services (Excel, Azure, SQL Server)

0s

Integrating with third-party tools and data sources

0s

Using Power Automate for workflow automation

0s

Managing Power BI gateway for on-premises data sources

0s

Monitoring usage and performance

0s

Implementing governance and best practices for organization-wide usage

0s

Participating in Power BI community forums and events

0s

Utilizing Power BI documentation and learning resources

0s

Staying updated with new features and updates

0s