Chidinma Okeh

Data Analyst Who Builds Smart Solutions from Data Insights || Data engineer

[Chidinma Okeh @_Datalady]

How do you turn raw transactional data into insights a business can actually act on?

I show exactly how in this end-to-end ELT pipeline using Python, dbt, and Snowflake:

https://t.co/fjbw72ndSz

#AnalyticsEngineering #DataPipeline #DataEngineering

[Chidinma Okeh @_Datalady]

https://t.co/ktlv3yxUO7

[Joseph Opene @Joseph_opene]

⚙️The day I stopped manually sending reports

Every Monday morning used to start the same way:
Open Excel → Refresh data → Export → Attach to email → Send to 7 managers.

By Wednesday, someone would reply, “Can you resend last week’s version?”

By Friday, I was already dreading next Monday.

That’s when I realized something:
If a process feels robotic, you shouldn’t be doing it - Power Automate should.

�� The Real-World Case
You generate a weekly sales report in Excel, refresh the data from SQL or Power BI, and need to email each region their own version automatically.
Manual effort = repetitive errors, missed attachments, and wasted time.

So here’s how automation fixes it👇

🔧Step 1: Prepare the Excel file
- Store your report on OneDrive or SharePoint.

- Convert your data to a Table (Ctrl + T) for structured reference.
- Refresh logic: connect via Power Query or Power BI Dataset if needed.
- (Optional) Use filters or a Region column to segment your recipients.

⚙️Step 2: Create a Power Automate Flow
Trigger:

Recurrence → set it to run every Monday 8 AM

Actions:
1️⃣Excel Online (Business) → Refresh a dataset or run script
- Select workbook location
- If using Office Scripts, reference a script that updates pivots and exports to PDF.

2️⃣Filter array / Apply to each
- Split by region or stakeholder group.

3️⃣Send an email (V2)
- Dynamic subject line: Weekly Sales Report - @{items('Apply_to_each')?['Region']}
- Attach file from OneDrive/SharePoint.
- Body: include KPIs dynamically using variables or expressions

4️⃣(Optional) Move file / Archive report
- Rename and move to a “History” folder with current date.

💡Advanced Variations
- Power Automate Desktop → If Excel macros must run locally (e.g., VBA).
- Office Scripts + Cloud Flow combo → For pure online Excel automation.

- Dataverse trigger → Automate reports when new records are added.
- Adaptive Cards in Teams → Deliver visual summaries instead of attachments.

⚠️Problems This Solves
Before | After
- Manual refreshes & forgotten recipients | Scheduled, error-free delivery

- Inconsistent naming (“Sales_v4.xlsx”) | Versioned archive with timestamps

- Reports delayed when someone’s on leave | Runs independent of staff

- Human error in filters | Logic-based segmentation from validated data

🧠Why It Matters
Automating report distribution doesn’t just save time, it creates reliability.
Executives stop chasing reports. Analysts focus on insights.
Dashboards stay consistent.

Once the pipeline runs itself, your role evolves from report sender to process designer.

💬If you still spend hours sending recurring reports manually, that’s your biggest automation opportunity.

Start with one Excel file. Build one Power Automate flow. Watch how your Mondays transform.

What’s one Excel process you wish could run without you?

[Joy Victor @Jhoie__]

This weekend, I tried to simulate what @shoptemu’s pre-launch data preparation (in Nigeria) might have looked like.

I built a system that generates 2.1M synthetic e-commerce events per run, modeling realistic Nigerian user behavior across the full customer lifecycle.

Here is what it looks like on a high level
•Terraform provisions all required AWS resources (EC2 instance, IAM role, security group, key pair, instance profile, and S3 bucket)
•EC2 executes the event generation logic written with Python
•Event logs are written to S3 in chunked Parquet files
•Outputs are designed for consumption by downstream pipelines

Big thanks to @najeebsulaiman_, @The_Ajayi, and @akinyele_mayowa for all their help! 

Medium Article: https://t.co/KDbcvz3Brm

[Chidinma Okeh @_Datalady]

https://t.co/EdcBS2YOFQ

[Chidinma Okeh @_Datalady]

Small data lesson from real work:
What looks empty isn't always missing to a system.

Details like this are how data issues slip into production.
Shared the full story on LinkedIn 👇

https://t.co/EdcBS2YOFQ

[Chidinma Okeh @_Datalady]

AnalystChidinma/bash_etl_pipeline: Bash-only ETL pipeline that extracts, transforms, and loads CSV data.

[Chidinma Okeh @_Datalady]

Just completed an end-to-end Automated ETL Pipeline project using native Linux tools and Bash scripting.

The pipeline handles:
• Data Extraction, Transformation & Loading
• Automated Scheduling with Cron
• File Management & Archiving
• Competitor Data Integration

[Chidinma Okeh @_Datalady]

Proud of the engineering effort behind building a reliable workflow from scratch.

[Chidinma Okeh @_Datalady]

https://t.co/pFg99JIq7P

[Chidinma Okeh @_Datalady]

@iam_Uchenna Hi @iam_Uchenna . I have requested to be added on the WhatsApp group. please accept my request.

[Chidinma Okeh @_Datalady]

@iam_Uchenna yes, I am in 100% agreement with you @iam_Uchenna

[Chidinma Okeh @_Datalady]

I am excited to share that I have completed the Oracle AI foundation Associate learning path.

Extend your skills! Check out"Complete" https://t.co/a5fJc4oBZP #LearnOracle #OracleUniversity #Oracle via @Oracle_Edu

[Chidinma Okeh @_Datalady]

I just published Automating Pipeline Health Evaluation with Python: A Data Engineer’s Approach to Monitoring Data… https://t.co/oJXBGFZKks

[Chidinma Okeh @_Datalady]

It's a dirty lie

[Kelvin @Yesitiskelvin]

For those dragging us on Twitter saying we won’t get our miracles
Let me tell you something : IT IS A DIRTY LIE 🔥🔥🔥🔥🔥🔥🔥🔥🔥
WE ARE MOUNTING PRESSURE PRESSURE ‼️‼️‼️‼️‼️‼️‼️
#HallelujahChallenge
#HallelujahChallengeOCT2025

[AdaezeLynn @LynnAdaeze1]

@Yesitiskelvin Whatever the devil says upon me it’s a dirty lie

[Kelvin @Yesitiskelvin]

For those dragging us on Twitter saying we won’t get our miracles
Let me tell you something : IT IS A DIRTY LIE 🔥🔥🔥🔥🔥🔥🔥🔥🔥
WE ARE MOUNTING PRESSURE PRESSURE ‼️‼️‼️‼️‼️‼️‼️
#HallelujahChallenge
#HallelujahChallengeOCT2025

[Dr Oludayo Sokunbi @Oludeewon]

No closing time today o.

RT IF you agree with me😂

[Chidinma Okeh @_Datalady]

@thejavabeast let's do this together sis

[Chidinma Okeh @_Datalady]

@thejavabeast @BloombergAfrica Amen. I believe. There is nothing God cannot do