ITDA - Western Technical College

Posts about Donald Wheeler written by giantknave

Process behavior charts are tools used in quality control and statistical processes. The charts help graph the process behavior at the end...

Fair Use

When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.

This article provides a step-by-step practical example on how to create a dimensional modeling with MySQL for analyzing sales data.

Useful queries for popular relational databases to explore schema.

Learn to comment & uncomment code, indent text, filter objects, access error logs, & find SQL Server instance names with SQL Server Management Studio.

Create interactive, responsive & beautiful data visualizations with the online tool Datawrapper — no code required.

This article presents the key differences between a public and private IP address, and answers some FAQ related to the topic.

A guide to making visualizations that accurately reflect the data, tell a story, and look professional.

Covariance vs correlation both assess linear relationships between two continuous variables, but there are stark interpretation differences.

TDWI Online Learning offers self-paced, in-depth courses on the hottest skills in analytics and data management.

Unlock the power of your data with interactive dashboards and beautiful reports that inspire smarter business decisions.

Decipad enables individuals and teams to craft compelling stories with data. It's a document with spreadsheet-like capabilities to bring numbers to life.

Enrich your stories with charts, maps, and tables.

I've tried to look on Google about a decent explanation of weak and strong entity type, but I haven't fully understood them. Could someone give me an example of a strong and weak entity type?

Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using just keyboard

All aspects of organisational analysis: business analysis | enterprise architecture | quality

Database normalisation is a concept that can be hard to understand. But it doesn’t have to be. In this article, I’ll explain what normalisation in a DBMS is and how to do it, in simple terms.

Quickly learn UML Activity Diagram. Read this UML guide for everything you need to know about Activity Diagram.

This section illustrates the powerful features Excel has to offer to analyze data. Learn all about conditional formatting, charts, pivot tables and much more.

Data set information and access from the Climate Data Online (CDO) web access application.

Learn about America's People, Places, and Economy on the official United States Census Bureau data platform. Explore, customize, and download Census data tables, maps, charts, profiles, and microdata.

In the contemporary business landscape, the terms “process mining” and “data mining” are often mentioned in discussions surrounding…

This guide will help you to unravel the confusion of whether to use a tabular or a multidimensional model for your business intelligence semantic layer.

A blog about databases and data architecture