DEV Community

Anne Musau
Anne Musau

Posted on • Edited on

1

The Ultimate Guide to Data Analytics: Techniques and Tools

I decided to take a bold step and join my first-ever data career boot camp organized by LuxDevHQ. It is a 5 week Bootcamp that equips one with hands-on data skills. The bootcamp aims to expose one to a wide variety of data skills in at least 4 fields of specialization.
The 1st week kicked off with the info session where I went through program orientation and I was introduced to the program and taken through whole program expectations.

During this 1st week, I have learnt a lot of things including:

  1. I have a better understanding of data analysis and the various roles in the different fields of specialization including data analyst, data scientist, data engineer, and analytical engineering.

  2. I have been able to install the systems and tools necessary and create the environment that I will be able to practice in. The systems that I have installed include python-anaconda, D-beaver and Power BI.

  3. I registered on kaggle and imported the weather data to work with. Then I installed the python packages(pandas and numpy) necessary to read and load the data into my jupyter notebook and performed several data analysis activities on the dataset.

  4. I developed a working knowledge and I understand how to use SQL to interact with databases and extract data.

Systems and Tools I have learnt to use

D-beaver - SQL
Jupyter notebook

Data Analysis techniques conducted

a)Load dataset
b)Filter records by condition
c)Count records by condition
d)Check on missing values
e)Rename columns
f)Calculate summary statistics eg find the mean visibility of a dataset.

I am looking forward to learning more about the data collection techniques during the second week of learning. I want to leverage data analysis skills to improve the customer service experience and implement better customer service strategies.

API Trace View

How I Cut 22.3 Seconds Off an API Call with Sentry 🕒

Struggling with slow API calls? Dan Mindru walks through how he used Sentry's new Trace View feature to shave off 22.3 seconds from an API call.

Get a practical walkthrough of how to identify bottlenecks, split tasks into multiple parallel tasks, identify slow AI model calls, and more.

Read more →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay