Ernest Appiah
Available

Ernest Appiah

Data AnalystLondon, United Kingdom
+ Info

2

Connections
shreya kanungo
Pip Jamieson
Ernest Appiah
Available

Ernest Appiah

Data AnalystLondon, United Kingdom
About me
As a Data Analyst Trainee with Generation UK & Ireland, I was selected into a highly competitive DA programme. I have gained expertise in data analytics tools such as Excel, SQL, Power BI, and Python, with proficiency in using formulas, pivot tables, and charts to develop interactive dashboards. Gained hands on experience with independent data analytics projects (same data analytics tools used plus Tableau) before being apart of Generation’s programme.
Projects
  • Which non-Tesla model of EV can rival the best-selling Tesla Y, in terms of range, price and top speed
    Which non-Tesla model of EV can rival the best-selling Tesla Y, in terms of range, price and top speedComparing the chosen two electric vehicles by certain attributes in Power BI.
  • Heathrow 9% forecast in passenger numbers
    Heathrow 9% forecast in passenger numbersWith a 9% increase, how many passengers are expected in total during next summer. Python utilised to discover this number also displayed in a line chart.
Work history
    G
    G
    Data Analyst TraineeGeneration
    London, United KingdomInternship
    ● Using various functions in Excel; formulas, pivot tables and conditional formatting, to create charts to display the findings. Filtered data to easily view, use and manage data faster. Power BI was utilized to clean and transform data via Power Query. These tools were used to build reports and interactive dashboards. ● SQL: Using MSSQL to do projects in Microsoft SQL Server. ● Python: proficient with NumPy and Pandas for data wrangling, cleansing and transformation. Skilled in creating visuals using Matplotlib.
Skills
  • Advanced Excel
  • SQL
  • Tableau
  • Python
  • Time Management
  • Data Analytics
  • Data Visualisation
  • Data Insights
  • Data Entry
  • Data Analysis