LadyBamie

[LadyBamie @LadyBamie]

Celebrating a major accomplishment today! After a challenging journey, I am thrilled to announce that I have completed the Data Analyst in SQL course. A huge thank you to @datacamp, ⁦@Ingressive4Good⁩ for their support throughout this amazing journey https://t.co/kJzajo1yOJ

[Mufti Menk @muftimenk]

Not everyone wants the best for you. Not everyone who criticizes you wishes well for you. Don't let others influence your mind and dictate how you should live your life.

[Mufti Menk @muftimenk]

People will speculate, they’ll think the worst of you, they’ll judge, assume, gossip & backbite. When told the truth, most won’t even bother to correct themselves. Such is the state of humankind today. Protect yourself. Stay away from such sinful acts.

[Fola Aina @folanski]

Be trustworthy. It will open more doors to you and grant you greater access.

[LadyBamie @LadyBamie]

The last chapter is on working with dates and timestamps. I learnt how to aggregate date/time data by hour, day, month, or year and practice both constructing time series and finding gaps in them.

[LadyBamie @LadyBamie]

I just completed Exploratory Data Analysis in SQL https://t.co/iZvf2Y4zeN

[LadyBamie @LadyBamie]

The course is divided into 4 chapters
First Chapter is on how to explore a database by identifying the tables and the foreign keys that link them. Learning about coalescing and casting data.

[LadyBamie @LadyBamie]

Third Chapter is on exploring categorical data and unstructured text. I learnt how to deal with inconsistencies in case, spacing, and delimiters and how to use a temporary table to recode messy categorical data to standardized values you can count and aggregate.

[LadyBamie @LadyBamie]

Second Chapter is on summarizing and aggregating numeric data. I learnt how to use functions like min and max to summarize numeric data in new ways and how to truncate and round numeric values. Building complex queries and saving the results by creating temporary table

[Orange Book 🍊📖 @orangebook]

A small circle of friends with whom you can regularly openly talk about anything without ever feeling judged, does so much for your peace of mind and mental health.

[Orange Book 🍊📖 @orangebook]

How to know you are on the right path in life, a few indicators.

[LadyBamie @LadyBamie]

In the fourth chapter, the OLAP extensions in SQL are introduced and applied to aggregated data on multiple levels. These extensions are the CUBE, ROLLUP and GROUPING SETS operators.

[LadyBamie @LadyBamie]

I just completed Data-Driven Decision Making in SQL. https://t.co/iGq65n2jHH

[LadyBamie @LadyBamie]

The course is divided into four chapters. The first chapter is an introduction to the use case of an online movie rental company, called MovieNow and focuses on using simple SQL queries to extract and aggregated data from its database.

[LadyBamie @LadyBamie]

In the third chapter, the concept of nested queries and correlated nested queries is introduced and the functions EXISTS and UNION are used to categorize customers, movies, actors, and more.

[LadyBamie @LadyBamie]

The second chapter explained how complex queries like GROUP BY, LEFT JOIN and sub-queries are used to gain insight into customer preferences.

[LadyBamie @LadyBamie]

The fourth section is learning about simple techniques to structure a presentation, communicate insights, and inspire your audience to take action. I also learnt how to improve your communication style and prepare to handle questions from your audience.

[LadyBamie @LadyBamie]

https://t.co/EOrM6BbVDw

[LadyBamie @LadyBamie]

I have completed Data Communication Concepts Course. It was an awesome learning experience. This course is divided into four sections.

[LadyBamie @LadyBamie]

The third section is about how to structure reports. The importance of reproducibility (work smarter, not harder) and how to get to the point when describing findings was taught.

[LadyBamie @LadyBamie]

The second section, I learnt how to avoid common mistakes when telling stories with data by tailoring your presentations to my audience. Then I also learnt the best practices for including visualizations and choosing between oral or written formats to make a good presentation.