About Me
About Me
Embedded Files
My name is Sarah Dark and I am from County Durham. I have spent the past 3-4 years working in the Law field but recently after completing an apprentice with Durham Constabulary decided I wanted to move into the Data field.
I've just finished a bootcamp with JustIT in Data Skills where we covered Excel, Tableau, Power BI, SQL, Azure and Python.
I’m currently focusing on expanding my knowledge Python and Power BI.
Fun fact: I have Dyslexia, a Law Masters degree and I was living in China when Covid broke out.
Excel
Excel
In Excel we spent time doing things such as conditional editing, SUM, AVERAGE, filter and Pivot tables.
This program is one that i am very familiar with, I have used this personally many time and i have also used it in many jobs. In my latest role i was helping to manage a spreadsheet with 5000+ rows. This is also where i started to get familiar with Power BI through using Power Query.
For more information about my Excel work go here
SQL
SQL
During the bootcamp I delved into fundamental database concepts, researching primary and secondary keys, and their relationships with foreign keys. I explored various database relationships, including one-to-one, one-to-many, and many-to-many, and differentiated between relational and non-relational database models, identifying suitable data types for non-relational structures. I investigated SQL join types, such as self, right, full, inner, cross, and left joins. Furthermore, I outlined the steps for database setup and creation, from business requirement analysis to maintenance. I also practiced practical SQL skills, including using COUNT, ORDER BY, wildcards, WHERE, BETWEEN, LIKE, LIMIT, and table renaming, alongside filtering and ID-based queries.
Python
Python
I implemented the FizzBuzz algorithm, iterating through numbers 1 to 100 and outputting "fizz," "buzz," "fizzbuzz," or the number itself based on divisibility. I then transitioned to data manipulation with Pandas, writing code to read CSV files into DataFrames and perform various operations. I displayed initial rows, retrieved DataFrame information and summary statistics, and selected specific columns and rows. I further manipulated the DataFrame by adding, renaming, and dropping columns, grouping and aggregating data, and creating pivot tables. Finally, I applied conditional logic to create a 'grade' column, sorted the DataFrame, and saved it to a new CSV, then performed basic data exploration on a GDP dataset.
I then furthered my knowledge in my own time by creating a basic webcraper which scraped date from the Forbes Global 500 Wikipedia page and presented it in a table format.
Tableau
Tableau
In this section I designed a custom dashboard featuring a bar chart for percentage change and a UK map highlighting impacted cities. I researched and compared various Tableau versions, noting the functional limitations of Tableau Public. Further, I conducted analyses to uncover trends and crucial information, which I then tailored for organizational use in both future projects and support strategies. These analyses aimed to provide actionable insights for strategic decision-making and operational improvements.
PowerBi
PowerBi
I successfully completed a comprehensive skills lab focused on Power BI. I began by mastering the process of retrieving and importing data into Power BI Desktop. I then progressed to transforming and cleaning the loaded data to ensure accuracy and usability. Following this, I designed a visually compelling and informative report within Power BI Desktop. Finally, I consolidated my work by creating a dynamic and interactive Power BI dashboard to present key insights.
In my own time I also created a Power BI dashboard from the data that was scraped from the Forbes Global 500 Wikipedia page.
Azure
Azure
I investigated the real-world applications and business benefits of cloud computing, comparing it to traditional alternatives and exploring major cloud providers, including their IaaS, PaaS, and SaaS offerings, as well as public, private, hybrid, and community cloud models. I researched and summarized key aspects of UK computer law, including the Computer Misuse Act, Police and Justice Act, Copyright, and Data Protection Act, and explored the legal implications of data storage, copyright infringement, and software piracy. I practically applied this knowledge by exploring relational and non-relational data in Azure, delving into Azure data analytics, and completing the DP-900 practice exam. Finally, I analyzed data laws relevant to customer data, recommending suitable Microsoft Azure services for a company's data analysis needs while ensuring GDPR and DPA compliance.
Page updated
Google Sites
Report abuse