Erik on Software

Sign in Subscribe

Topic

data

A collection of 171 issues

Community Comment: Part 29 - Usage of normalized versus denormalized data storage is dependent on usage patterns

* Normalized versus denormalized data * Data storage dependent on usage patterns * Denormalized data makes reads efficient * Normalized data makes writes efficient

Community Comment: Part 27 - Assessment is needed when deciding between transactional and analytical modeling

* Transactional versus analytical modeling * Discussion with purported staff data engineer * Making broad generalizations doesn't help * Quoting $ savings in vacuum not advised

Media Query Source: Part 45 - Reworked (US digital magazine); OpenAI & the Databricks-Microsoft AI alliance

* Reworked (US digital magazine) * OpenAI & the Databricks-Microsoft AI alliance * Databricks available on AWS, Azure & GCP * Microsoft providing AI options makes sense My responses ended up being included in an article at Reworked (September 7, 2023). Extent of verbatim quote highlighted in orange, paraphrased quote highlighted in gray. Above

Media Query Source: Part 44 - InformationWeek (US digital magazine); Top Tips for Weeding Out Bad Data

* InformationWeek (US digital magazine) * Best way to weed out bad data * "Bad data": low quality or inappropriate data * Acquire, cleanse, standardize & model data My responses ended up being included in an article at InformationWeek (June 26, 2023). Extent of verbatim quote highlighted in orange, paraphrased quote highlighted

Community Comment: Part 26 - With respect to data normalization, performance is key

* Normalized versus denormalized data * Discussion with purported training firm CEO * Performance is important consideration * More factors involved than just record count

Media Query Source: Part 43 - CNBC (US business news television channel); Benefits of using self-service analytics tools

* CNBC (US business news television channel) * Benefits of using self-service analytics tools * Timely, custom exploratory analyses enabled * Appropriate data governance needed The responses I provided to a media outlet on March 3, 2023: Media: I'm working on an article about the benefits of using self-service analytics tools, and

Counterpoint (7 Years Later) - 20 Questions to Detect Fake Data Scientists

Erik on Software anniversary post #500. Almost exactly seven years ago, I published what was for a long time one of my most popular posts: a counterpoint to a KDNuggets essay entitled "20 Questions to Detect Fake Data Scientists". The original essay to which I had reacted was

Media Query Source: Part 42 - Barron's (US financial news magazine); AI primer for financial advisors

* Barron's (US financial news magazine) * AI primer for financial advisors * Machine learning & deep learning: AI subsets * Model value dependent on data quality The responses I provided to a media outlet on December 5, 2022: Media: AI primer for financial advisors. Media: I'm writing a post

Media Query Source: Part 41 - CIO (US digital magazine); Today's most notable data strategy trend

* CIO (US digital magazine) * Today's most notable data strategy trend * Data lakehouse adoption * Combination of data lake & data warehouse The responses I provided to a media outlet on October 17, 2022: Media: What is today's most notable data strategy trend? Gfesser: Data lakehouse adoption. Media:

Community Comment: Part 24 - Self-service data product use cases exist, with caveats

* Self-service data product use cases exist, with caveats * Users need to know what they're doing * Stakeholders need to be aware of benefits & drawbacks * Some commercial products (e.g. Power BI) introduce unique risks