Responsibilities:
* SQL and Data Mining: retrieving data from different sources using SQL.
Loading data into database, developing ER-diagrams, accomplishing practical
tasks to learn queries: join, except, CTE, view, window function, subqueries,
etc.)
* Analytics and Statistics for Business: basic statistics and analytical tools for
analysis, formulating and testing hypotheses.
* Big Data: general familiarization with noSQL solutions - Hadoop, MongoDB.
Studying and accomplishing practical tasks using such Python libraries as
Pandas and PySpark.
* Metrics, Hypotheses, Growth Points: understanding of Financial, Sales &
Marketing metrics hierarchy and their impact on different types of business.
Familiarization with Google Data Studio and Power BI for reporting.
* Power BI: Data Analysis and Visualization. Working with Power Query, DAX
language and Power BI on real business tasks: importing data from different
sources, data transforming and cleaning, constructing interactive reports and
dashboards for customers.
Key achievements:
* On-time and 100% completion of assigned tasks.
* Receiving excellent marks on diploma projects with the use of SQL, Python
and PBI tools.
Industries of BI projects: sales & marketing, e-commerce, restaurants, airport,
aviation