Analytical Readiness
Understand the question, the measurement, the context, and the decision.
Why Information Thinking Matters Now
Technology Is Expanding Faster Than Anyone Can Master It All
Today's information environment spans databases, SQL, spreadsheets, data engineering, statistics, visualization, governance, security, machine learning, generative AI, and many other specialties.
People do not need to become experts in every field. They need enough understanding to recognize what they know, what they do not know, and where a technology fits within the larger information process.
The more sophisticated the technology becomes, the less realistic it is for one
person to understand every technology involved. That makes understanding the
information itself even more important.
You don't have to know every technology, but you need enough information
understanding to recognize when there is something you don't understand.
What does this data represent?
What makes a record unique?
What does missing information mean?
When is a duplicate really a duplicate?
What population are we measuring?
How are different sources related?
What business rule produced this number?
What does the measurement actually mean?
Can the information be trusted?
What decision does the information support?
A Foundation for Responsible AI Use
The Three Readiness Layers
The Data Competency Path is built around a practical progression. Analytical Readiness helps people ask better questions. Data Readiness helps people evaluate whether the information can support trustworthy analysis. Together, they strengthen AI Readiness.
Data Readiness
Understand the source, structure, quality, relationships, and business rules.
AI Readiness
Use AI with the judgment needed to clarify, correct, verify, or reject results.
Analytical Readiness
- What problem are we solving?
- What question should we ask?
- What does the number mean?
- What variability or context matters?
- What decision are we supporting?
Data Readiness
- Complete, accurate, current information
- Consistent and structured information
- Awareness of blanks, duplicates, and assumptions
- Traceable transformations and business rules
- Connected sources and meaningful relationships
AI Readiness
- AI-assisted analysis and decision support
- Prompt development grounded in context
- Evaluation of generated results
- Knowing when clarification is needed
- Knowing when correction or verification is required
From Source to Decision and Back Again
The Information Lifecycle
The information lifecycle does not end with a chart, dashboard, or AI-generated answer. Decisions lead to actions. Actions change conditions. Those changes create new data.
Data is collected.
Information is derived.
Decisions are made.
Actions change the data.
Trustworthy analytics begins before the analysis
Before sophisticated analytics can produce trustworthy information, enormous work may be required to make source data understandable, consistent, connected, and analytically useful.
Real organizational data may be fragmented across systems, maintained under different business rules, shaped by different business cultures, stored at different levels of detail, or interpreted differently by different departments. Technology can process those differences. Technology cannot make those differences disappear.
The Learning Journey
Understanding Information Across SQL, Excel, Power BI, and AI
The technologies change. The information concepts continue. Learners examine how the same ideas appear across sources, transformations, calculations, models, reports, decisions, and AI-assisted reasoning.
SQL: Understanding the Source
SQL teaches how information is defined, related, filtered, summarized, and validated.
- Tables, records, fields, and keys
- Relationships and joins
- Population and inclusion rules
- Filtering and aggregation
- Information quality and validation
Excel: Understanding the Information
Excel makes data, formulas, measurements, and business rules visible in a familiar analytical environment.
- Workbook and table design
- Formulas and traceable calculations
- PivotTables and comparisons
- Variability and measurement
- Decision-support analysis
Power BI: Understanding the Analysis and Decision
Power BI extends those concepts into data shaping, semantic models, measures, filter context, visualization, exploration, and distribution.
- Power Query and data shaping
- Relationships and semantic models
- DAX measures and business rules
- Visualization and analytical questions
- Reports, dashboards, Teams, and PowerPoint
AI-Assisted Tools: Extending Human Thinking
AI can extend analysis, explanation, exploration, and productivity. The quality of the extension depends on the quality of the thinker and the information.
- Prompt context and clarification
- AI-assisted reasoning and analysis
- Verification of claims and calculations
- Recognition of missing information
- Human judgment and responsibility
Source Data → Preparation → Relationships → Business Rules → Measurement → Analysis →
Visualization → Decision → Action
Flexible Learning Options
Learners may study SQL, Excel, or Power BI as focused courses. Learners may also complete the broader Data Competency Path and examine how information moves across the full analytical lifecycle.
Shared concepts provide continuity as learners move from one technology to another.
The Intended Outcome
Move Beyond Software Proficiency Toward Data Fluency
The Data Competency Path focuses on the skills that make other skills more valuable: analytical thinking, information understanding, systems thinking, curiosity, adaptability, and technological literacy.
Understand Meaning
Recognize what rows, fields, keys, relationships, measurements, and missing values represent in context.
Apply Business Rules
Understand how organizations define, include, exclude, classify, calculate, compare, and decide.
Evaluate Results
Examine assumptions, populations, transformations, measurements, variability, and the information that produced an insight.
Make Better Decisions
Connect analysis to explanation, communication, discussion, decisions, actions, and measurable outcomes.
The Data Competency Path is about understanding your numbers well enough to make
better decisions.
Durable Principles
Information Thinking Provides the Connective Framework
Understand the business rule before you understand the technology.
Business rules are the language of intent.
Technology executes the rule. Understanding the rule remains the human responsibility.
You cannot properly evaluate an insight without understanding the information that
produced it.
The technologies are temporary. The relationships between ideas are durable.
About
Teaching Software Through the Lens of Information
Roger Steinbronn is a professional educator specializing in technology and information, helping organizations and individuals adapt to change through practical, connected learning.
The Data Competency Path grew from a simple observation: most jobs are information jobs. People make decisions from information every day, yet training often treats SQL, Excel, Power BI, SharePoint, and AI as disconnected technologies.
The curriculum reconnects those subjects through durable ideas such as information quality, business rules, meaning, measurement, relationships, analysis, traceability, and decision support.
I teach software through the lens of information.