What is SQLAlchemy?Python has many libraries to connect to SQL databases. SQLAlchemy is a Python SQL toolkit that allows developers […] November 12, 2024 in Python tagged data / database / python / SQLAlchemy by Mike
SQL Server to PythonHow would you connect Microsoft SQL Server to Python so that you could pull data into Python? Perhaps […] November 12, 2024 in Uncategorized tagged sql / import / table / python / connect / data / server by Mike
SQL Script into SQLiteDo you have a SQL script that you want to run against a SQLite database file? Perhaps you […] November 11, 2024 in Database tagged data / import by Mike
From CSV to SQLiteHow do you get your CSV data into a SQLite database? Here is an article from Towards data […] August 6, 2024 in Excel tagged python / sqlite / integration / data / import / csv / SQLite by Mike
Data Visualizations Saved LivesFlorence Nightingale saved lives by creating revolutionary visualizations of statistics. Yes, data visualizations are that powerful. They are […] July 16, 2024 in Data Visualization tagged data / visualization / chart / graph / health by Mike
Tableau’s Data GuideData Guide in Tableau provides helpful information about dashboards and insights about the data behind them. It allows […] July 14, 2024 in Data Visualization tagged description / data / notes / guide by Mike
The Visualization’s ContextWhat is the context of a data visualization? What this refers to is the audience of the visualization […] June 13, 2024 in Data Visualization tagged data / visualization by Mike
The Data Visualization ProcessWhat are the steps in designing an effective data visualization? Is there a methodology for that? What are […] May 25, 2024 in Data Visualization tagged steps / lesson / data / visualization / methodology / Storytelling with Data by Mike
Storytelling with DataThe book Storytelling with Data by Cole Nussbaumer Knafflic is the title of a very popular book. It’s […] May 25, 2024 in Data Visualization tagged visualization / chart / graph / story / telling / storytelling / data / Storytelling with Data by Mike
2 Anscombe’s QuartetWhat is Anscombe’s Quartet? It has four datasets with nearly identical summary statistics. It underscores the limitations of […] May 23, 2024 in Data Analytics tagged data / visualization / statistics / EDA / quartet by Mike
The Growth of DataIt’s necessary to discuss some computing history to be able to understand the big data landscape and where […] May 19, 2024 in Data Science tagged big / parallel / data / history / growth / Big Data by Mike
Data Governance IntroductionWhat is data governance? There are several definitions of data governance available from various sources. According to Wikipedia, […] May 18, 2024 in Data Engineering tagged data / management / procedure / governance / policies by Mike