Joseph NyingiWhat is ChatGPTChatGPT is a chatbot trained using the GPT-3 language model developed by OpenAI. GPT-3, or Generative Pretrained Transformer 3, is a…Dec 10, 2022Dec 10, 2022
Joseph NyingiHow to Access RStudio CloudIn order to use RStudio Cloud, you need stable internet access. It won’t matter what operating system you have because it works in your…Sep 28, 2022Sep 28, 2022
Joseph NyingiUsing SQL JOINs effectivelyIn this Article, is a review of how JOINs are used effectively. A JOIN combines tables by using a primary or foreign key to align the…Sep 27, 2022Sep 27, 2022
Joseph NyingiSQL functions and subqueriesIn this reading, you will learn about SQL functions and how they are sometimes used with subqueries. SQL functions are tools built into SQL…Sep 26, 2022Sep 26, 2022
Joseph NyingiWorking with temporary tablesTemporary tables are exactly what they sound like — temporary tables in a SQL database that aren’t stored permanently. In this reading…Sep 24, 2022Sep 24, 2022
Joseph NyingiTransforming data in SQLData analysts usually need to convert data from one format to another to complete an analysis. But what if you are using SQL rather than a…Sep 23, 2022Sep 23, 2022
Joseph NyingiUsing BigQueryBigQuery is a data warehouse on Google Cloud that data analysts can use to query, filter large datasets, aggregate results, and perform…Jul 5, 2022Jul 5, 2022
Joseph NyingiSecret identities: The importance of aliasesIn this reading, you will learn about using aliasing to simplify your SQL queries. Aliases are used in SQL queries to create temporary…Jun 28, 2022Jun 28, 2022
Joseph NyingiThe structure of dataData is everywhere and it can be stored in lots of ways. Two general categories of data are:Apr 2, 2022Apr 2, 2022
Joseph NyingiLeading great meetings as Data Scientist/AnalystOne day soon, you might find yourself planning a meeting in your role as a data analyst/scientist. Great things can happen when…Mar 24, 2022Mar 24, 2022