Data With Sarah

WELCOME

ABOUT ME

Welcome to Data with Sarah!I’m Sarah, and I’m thrilled you’re here! As a data analyst with a background in Mathematical & Statistical Sciences, I love finding the hidden stories in data and using them to help businesses make smarter, more informed decisions.With over four years of experience in the forex sector, I’ve developed a knack for problem-solving, creating intuitive dashboards, and tracking key metrics that really drive change. Whether it’s diving into large datasets or simplifying complex information for others, I’m always up for the challenge.I’ve worked with a variety of tools like SQL, Power BI, Tableau, Looker, Looker Studio, and Excel to analyze data and uncover actionable insights. The world of data analytics is always evolving, and I am continually learning new tools. That’s one of the things I enjoy most—there’s always something new to learn!If you’re looking for a data analyst who’s eager to help your organization grow, feel free to explore my projects or reach out—I’d love to connect!Thank you for visiting my site!

Data with Sarah

SKILLS

  • Microsoft Excel / Google Sheets: VLOOKUP/XLOOKUP, IF formula, SUMIFS/COUNTIFS, pivot tables and charts, Power Query

  • SQL: BigQuery, MySQL, Microsoft SQL Server

  • Tableau, Power BI

  • Looker (LookML Development), Looker Studio

  • Data Cleaning, Analysis, and Visualization

  • Critical Thinking and Problem-Solving

  • Beginner R and Python skills

  • Statistics (SPSS)

  • Financial Analysis: Jedox tool, Variance Analysis, Commission Calculations, Ad-hoc Analysis, KPI trend analysis and dashboards

EDUCATION & CERTIFICATIONS

FEATURED PROJECT

City of Edmonton Crime Stats - A Power BI Project

  • Used CSV data from Kaggle of Edmonton Neighbourhood Crime Stats from 2009 to 2018.

  • Designed a Power BI dashboard examining crime trends over time, most common types of crime, and crime incidents per neighbourhood.

City of Edmonton Crime Stats - A Power BI Project by Sarah Rajani

EDUCATION & CERTIFICATIONS

EDUCATION

CERTIFIED TREASURY PROFESSIONAL

Association for Financial Professionals

Knowledge and skills related to treasury operations, corporate liquidity, and capital and risk management.

BACHELOR OF SCIENCE

University of Alberta

Mathematical & Statistical Sciences

BACHELOR OF SCIENCE

University of Alberta

Psychology

CERTIFICATIONS

DATA ANALYSIS WITH KUSTO QUERY LANGUAGE

Microsoft

Analyzing data in Azure Data Explorer using the Kusto Query Language.

PYTHON FOR BEGINNERS

Microsoft

Learning to create programs and projects in Python and working with strings, lists, loops, dictionaries, and functions.

INTRODUCTION TO PYTHON PROGRAMMING FOR DATA SCIENCE

Dataquest.io

Developing custom dimensions and measures with LookML and designing insightful dashboards in Looker.

DEVELOPING DATA MODELS WITH LOOKML

Google

Building and maintaining scalable LookML models in Looker, enabling standardized, ready-to-use data for business users.

ANALYZE AND VISUALIZE LOOKER DATA SKILL BADGE

Google

Developing custom dimensions and measures with LookML and designing insightful dashboards in Looker.

PREPARE, CLEAN, TRANSFORM, AND LOAD DATA USING POWER BI

Coursera

Using Power Query to load, clean, and transform data (including merging, appending, and creating aggregations) in Power BI.

DATA ANALYTICS WITH GOOGLE CLOUD BIGQUERY AND LOOKER STUDIO

LinkedIn

Using SQL in BigQuery to analyze data and import for use in Looker Studio.

LOOKER STUDIO FOR BEGINNERS

LinkedIn

Introduction to Google Data Studio.

SPSS STATISTICS ESSENTIAL TRAINING

LinkedIn

Refresher introductory/intermediary course on SPSS fundamentals.

MYSQL DATA ANALYSIS

Maven Analytics

Comprehensive SQL course using MySQL.

GOOGLE DATA ANALYTICS CERTIFICATE

Google

Foundational data analytics training program covering Google Sheets, SQL, Tableau, and R programming.

21 DAYS TO DATA CHALLENGE

Data Career Jumpstart

Introduction to SQL, Tableau, and Python.

PROJECTS

City of Edmonton Crime Stats - A Power BI Project

Power BI

  • Used CSV data from Kaggle of Edmonton Neighbourhood Crime Stats from 2009 to 2018.

  • Designed a Power BI dashboard examining crime trends over time, most common types of crime, and crime incidents per neighbourhood.

City of Edmonton Crime Stats - A Power BI Project by Sarah Rajani

Analysis of British Airways Customer Reviews - A Tableau Project

Tableau

  • Used CSV data for customer reviews and country mapping to develop an interactive dashboard in Tableau.

  • Created a filter based on review categories such as food and beverages, entertainment, cabin staff, and ground service.

Analysis of British Airways Customer Reviews - A Tableau Project by Sarah Rajani

Hospital Patient Waitlist Analysis with Power BI

Power BI, Power Query

  • Cleaned and prepared hospital patient waitlist data using Power Query to allow for analysis and visualization in Power BI.

  • Created a dynamic dashboard using custom DAX measures to answer questions related to average and median wait lists between inpatients and outpatients.

Hospital Patient Waitlist Analysis with Power BI by Sarah Rajani

Cleaning, Preparing, And Analyzing IMDb Box Office Data in Power BI

Power Query

  • Cleaned and prepared IMDB Box Office data from 2019 and 2020 using Power Query in Power BI so that a cursory analysis could be made.

  • Renamed columns, amended data types, appended the two datasets, and performed aggregations on the appended table.

Cleaning, Preparing, And Analyzing IMDb Box Office Data in Power BI by Sarah Rajani

How to Create a Dynamic Dashboard in Excel Using Call Center Performance Data

Excel

  • Created an interactive dashboard in Excel using Call Center Performance data.

  • Calculations include the use of SUMPRODUCT, XLOOKUP, and IF formulas.

  • Dynamic dashboard shows data by week, by clicking on a scroll bar and selecting the KPIs of interest.

How to Create a Dynamic Dashboard in Excel Using Call Center Performance Data by Sarah Rajani

Global COVID-19 Death and Infection Rates, Visualized - A Tableau Project

SQL, Tableau

  • Used SQL queries in BigQuery to analyze global COVID-19 death and vaccination data.

  • Tables from SQL queries were exported as CSV and then uploaded into Tableau to create visualizations and a final dashboard of global infection and death rates.

Global COVID-19 Death and Infection Rates, Visualized - A Tableau Project by Sarah Rajani

COVID-19 Data Exploration Using BigQuery - A SQL Project

SQL

  • Used SQL to analyze global COVID-19 death and vaccination data.

  • Exploratory data analysis using BigQuery to compare stats across countries.

COVID-19 Data Exploration Using BigQuery - A BigQuery Project by Sarah Rajani

Analyzing the MavenMovies Dataset: A SQL Project Using MySQL

SQL

  • Used SQL to analyze the MavenMovies dataset.

  • Provided actionable insights to the insurance company and business prospects regarding the company's processes, inventory, and customers.

Analyzing the MavenMovies Dataset - A SQL Project using MySQL by Sarah Rajani

Google Data Analytics Capstone: Bike Share

Excel | SQL | Tableau

  • Analyzed the data of a bike-sharing company and created visualizations to identify historical trends in annual and casual ridership.

  • Used Excel, SQL, and Tableau.

  • Provided actionable insights to help convert casual riders into annual members.

Google Data Analytics Capstone: Bike Share by Sarah Rajani

21 Days to Data Challenge: What I've Learned

SQL | Python | Tableau

  • Analyzed a subset of the NYPD crime complaint data from 2018 to help identify the areas and types of crime in the different boroughs.

  • Used SQL, Python, and Tableau.

  • Proposed solutions to the high crime rates by determining where and when more officers should be deployed.

21 Days to Data Challenge - What I've Learned by Sarah Rajani