Calculated Fields in TableauIn Tableau, a calculated field performs calculations that may be based on other fields. Think of a spreadsheet […] April 20, 2024 in Data Visualization tagged detail / field / aggregated / table / column / basic / calculated / level by Mike
Titanic Logistic RegressionThis post will discuss the building of a logistic regression model on the Titanic dataset provided by Kaggle. […] March 18, 2024 in Data Analytics tagged regression / impute / logistic / Titanic / table / pivot by Mike
Pandas DataFrame IntroductionA Pandas DataFrame is a two-dimensional data structure, with “rows” and “columns”, like a two-dimensional array, or a […] April 27, 2023 in Python tagged data / table / analysis / frame / pandas / pd / dataframe / pandas DataFrame by Mike
Add a Column to Data Frame in RThere are three common ways to add a new column to a data frame in R: the $ […] March 28, 2023 in R Language tagged table / add / column / alter by Mike
Table Function in RThe table() function in R can be used to quickly create frequency tables. You have rows and columns […] March 28, 2023 in R Language tagged table / R / histogram / frequency / function by Mike
Data Frames in RData frames are the data analyst’s default way of interacting with data. The best way to learn data […] March 11, 2023 in R Language tagged data / table / frame / R Data by Mike
SQL Temp TablesLet’s discuss temporary tables in Microsoft’s T-SQL. Temporary tables have a hash (#) at the start of their […] February 10, 2023 in SQL tagged sql / temporary / table by Mike
T-SQL Tables and Row CountYou are exploring a database in SQL Server using SSMS. You need a script that simply reports the […] January 10, 2023 in SQL Server tagged exploration / table / row / explore by Mike
SQL Select IntoThe SELECT INTO statement copies data from one table into a new table. Here’s the syntax for copying […] January 8, 2023 in SQL Server tagged backup / table / copy / into / select by Mike
Excel SlicersWhat is a slicer? A slicer is a visual representation of a filter. They are available in Excel […] November 19, 2022 in Excel tagged slicer / table / filter by Mike
Pivot Table Sales Data ExampleLet’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […] November 11, 2022 in Excel tagged data / excel / table / summarize / pivot / Excel Pivot Tables by Mike
Get Data From the Web Into ExcelYou can get data from a web page and import it into Excel. It’s easy. You might want […] November 6, 2022 in Excel tagged data / Google / import / sample / table / web / page / sheets / Northwinds by Mike