Restoring a Backup in SQL Server Management Studio
Before I write tutorials on SQL, the first step is showing how to restore a backup file in SQL Server Management Studio so we can dig into SQL queries and business/data analytics.
Web, UX, Development, Tech, Data, and Business
Web, UX, Development, Tech, Data, and Business
Category Data
Correlation and Causation When Analyzing Data
In most statistics or data analysis books (at least the ones I have), there is always an explanation that states that correlation is not necessarily causation. The misunderstanding or intentional fallacy of the correlation between variables can affect the bottom line of a business.
A Style Guide for SQL Development and Data Analysis
A lot of people without technical backgrounds are learning SQL for data analysis or retrieving data from databases.
Measures of Central Tendency Simply Explained
When we are trying to get insights from the data, one of the first steps to take is summarizing this collection of raw numbers into one number that represents the majority. The way to do this is by getting the mean, the medium, and the mode of the data.
Review of the Google Data Analytics Professional Certificate
This is a great certificate on all levels. I really like the idea of how much the courses try to emphasize the career of the data analyst and make the students “job ready”. It is not only teaching the fundamental concepts but giving an idea of the career path and getting people with this certificate the tools to ace the job interview.
Beware of Misleading Graphs
With little knowledge of statistics or data visualization people would notice that the Y-axis should start at zero because it could have a false visual comparison of the data
Where to Start in Data Science, Data Analysis, and Business Intelligence
Believe it or not, a lot of data analysis can be done with Excel without having to jump into Python or R. Most of the time, a pivot table in Excel can answer the business questions needed by management to make timely decisions.
What Is the Difference Between Database, Database Management System, and Database System?
The importance of the distinction depends on the context. For example, normally this is not very important and most people use database systems, interchangeably with database and DBMS.