Data Analyst I-II (Power BI)

17 Oct 2024

Vacancy expired!

Role Description

(90% PowerBI & SQL / 10% Python & Stats)•

PowerBI Experience - Advancedo Level of Detail (LoD) Calculationso Utilizing variables within measureso Should be able to define and utilize the following DAX functions:§ Date/time functions§ Aggregation functions§ Filter functions§ Logical functions§ Information functions§ Parent and Child functions§ Relationship functions§ Table Manipulation functions§ Time intelligence functions

•

Oracle SQL (PL-SQL) – Intermediate to Advancedo Must be able to write complex queries utilizing the following:§ Multiple joins (complex join logic)§ Common Table Expressions (CTE's)§ User-defined functions§ Converting data types

o

Understanding of data normalization§ Dimension Tables vs. Fact Tables

•

Python experience – Basic to Intermediate o Basic Descriptive Statistics§ Averages, Standard Deviation, Control Limits, etc.§ Normalizing sample statistics

o

Predictive Modelling§ Forecasting§ Anomaly detection§ Heat Maps

  • ID: #21274084
  • State: Georgia Atlanta 30301 Atlanta USA
  • City: Atlanta
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-10-17
  • Deadline: 2021-12-09
  • Category: Et cetera