oxbar Goto Github PK

I'm an educational professional expanding my skills in data analytics, python, SQL and dashboards. I wanted to maintain a record of everything I've used on the journey, not just for my own benefit, but to help others that are embarking down the same path!

• Skills
• Courses and Education
• Projects
  • Large Case Studies
  • Small Case Studies
  • Personal Projects
• Resources and Setup
• Stats
• Courses I'm Considering

• Python
  • pandas, NumPy, API Scraping
• SQL
  • SQLite, DB Browser for SQL, Python integration, Jupyter Notebooks integration, PostgreSQL
• R
• Tableau
• Power BI
  • Power BI Desktop
• Software
  • Conda, Git, R, RStudio, Jupyter Notebooks, PyCharm, DB Browser for SQLite, Visual Studio Code

Back to the Top

Here you will find repositories of my online courses (visualisations, code, etc.):

• Dataquest - Career Path - Business Analyst

  • MS Excel; SQL; Power BI; Dashboards; Data cleaning, analysis and visualisation

• Dataquest - Career Path - Data Analyst in Python

  • Python; pandas; NumPy; SQL; API and web scraping; Data visualisation; Statistics; Git

• Dataquest - Career Path - Data Scientist

  • Python; pandas; NumPy; SQL; API and web scraping; Data visualisation; Statistics; Git

• Coursera - Google Data Analytics Professional Certificate

  • MS Excel; Google Sheets; Data cleaning and analysis; SQL; Sampling; Tableau; R Programming

Back to the Top

• Bellabeat Capstone Project - Analysing FitBit health and fitness data
  • Analysed daily and hourly health and fitness data to identify trends and inform marketing strategies.
  • R; RStudio; Data cleaning and analysis; SQL; Tableau

• Analysing Android and iOS app store data

  • Analysed Google Play Store and iOS App Store application data to identify trends and provide insight on categories and genres likely to draw high traffic with little saturation.
  • Python; pandas; Data cleaning and analysis

• Exploring and analysing Hacker News forum categories and hourly traffic data

  • Analysed categorical posts and identified hourly trends in traffic to inform users of efficient practices.
  • Python; pandas; Data cleaning and analysis

• Analysing Customer Sales and Product Data

  • Analysed sales data, stock levels, product performance to drive customer retention, marketing strategies and inventory.
  • SQL; SQLite; DB Browser for SQL; Data analysis; Python

• Modelling Store Sales Data in Power BI

  • Visualised sales data using Power BI to determine the biggest global markets and profit summaries for a range of office supplies.
  • Data visualisation; Power BI; DAX Functions

• Visualising Life Expectancy and GDP Variation Over Time

  • Visualised life expectancy, population and GDP per capita between regions, countries and income classes from 1800 to 2010 to determine trends.
  • Power BI, Data Visualisation

• Basic First Budget

  • A simple one year budgeting spreadsheet to plan forward and track spending.
  • Excel

• Shopping List Generator

  • A recipe bank and interactive weekly planner to automatically fill a shopping list.
  • Excel; Google Sheets

Back to the Top

Here you will find information on how I set up my workspace and links to various resources, sites, social posts and guides I've found useful. Might be helpful if you're starting out, like it was for me!

Back to the Top

Back to the Top

• Coursera - Google IT Automation with Python Professional Certificate

• Coursera - IBM Data Analyst Professional Certificate

• Coursera - Data Science Fundamentals with Python and SQL Specialization

• Coursera - Business Analytics Specialization