Data Frames in R
Data frames are the data analyst’s default way of interacting with data. The best way to learn data […]
table
SQL Temp Tables
Let’s discuss temporary tables in Microsoft’s T-SQL. Temporary tables have a hash (#) at the start of their […]
T-SQL Tables and Row Count
You are exploring a database in SQL Server using SSMS. You need a script that simply reports the […]
SQL Select Into
The SELECT INTO statement copies data from one table into a new table. Here’s the syntax for copying […]
Excel Slicers
What is a slicer? A slicer is a visual representation of a filter. They are available in Excel […]
Pivot Table Sales Data Example
Let’s look at some Sales data in a simple example and use Pivot Table to summarize the data. […]
Get Data From the Web Into Excel
You can get data from a web page and import it into Excel. It’s easy. You might want […]
Excel Pivot Tables Date Grouping
Dates can be a bit tricky. For the best solution to working with dates in our Pivot Table […]
Excel Table Relationships
Suppose you have two tables of data in Excel that are related. As an example, you might have […]
Create a Pivot Table from Multiple Sheets using Power Query
Do you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […]
Excel Agenda Template
Do you have an event or meeting that you would like to enter into Excel and have Excel […]
Excel Add or Remove Table Rows and Columns
Rows If you have an Excel table, you can easily add rows to that table. One way is […]