Inferential Statistics
Up to now in our study of the basics of Statistics we’ve covered descriptive statistics. Click on the […]
Blog
Central Tendency
In statistics we want to look at measures of central tendency, asymmetry, and variability. Univariate Measures What is […]
Data Analytics Introduction
What is data analytics? Here is what Wikipedia says about data analysis: “Data analysis is a process of […]
R Language Introduction
What is the R programming language? Wikipedia says: “R is a programming language for statistical computing and graphics […]
Business Intelligence (BI) Introduction
Business Intelligence (BI) is all about gathering and organizing the data your business or organization generates in its […]
Data Model Examples in Excel
Do you want to work with a few small & sample data models in Excel to practice the […]
Tiny MeasuresIMDB
Now it’s time to create some Measures in the Tiny IMDB database. A measure is a DAX formula […]
Get Other Tables
Now we need to get other tables and create the relationships After we’ve imported all of the tables […]
Get Ratings from Tiny
Next we’ll use Power Query to bring in the ratings data into the Data Model. There are no […]
Build the Tiny Data Model
Below is a link to the downloadable Excel file that contains a sheet with the table we will […]
Excel Filter Function
The new Excel FILTER function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel Date and Time
All dates in Excel has an associated date value, which is how Excel calculates the passage of time […]