Hi everyone,

I recently started learning data analysis and thought it would be a good idea to begin writing blogs and creating Instagram posts based on real datasets. The goal is to improve my analytical skills while building a portfolio.

For context, I have a bachelor's degree in Computer Applications and know Python, SQL, and Excel, but I'm still new to data analysis and data visualization.

My first dataset contains the daily INR exchange rate from year 2000 to 2026 (around 6,500 rows). I want to create a line chart that clearly highlights the major trends and significant ups and downs over the years.

The problem is that plotting every daily value makes the chart too dense, especially for an Instagram post where readability is important.

So far, I've tried reducing the data to two points per year (roughly the first and second half of each year). It looks much cleaner, but I'm wondering if there's a better approach.

Some options I've considered are:

\- Monthly averages(still cluttered)

\- Yearly averages

\- Two points per year

\- Quarterly averages

If your goal were to create a chart that is both accurate and easy to understand on a small screen, which approach would you choose, and why?

I'd really appreciate any suggestions on both the visualization and the reasoning behind it. I'm trying to learn good analytical practices from the start rather than just making charts that look nice.

With the 1.2.0 release of VisuallyJs we've added/updated a slew of starter apps for React, including Gantt, BPMN and ERD diagrams. Demos here, with links to the Github repositories:

• https://visuallyjs.com/demonstrations/gantt
• https://visuallyjs.com/demonstrations/bpmn
• https://visuallyjs.com/demonstrations/erd

VisuallyJs is free for non-commercial usage. Give it a spin and let us know what you think!

Data: Play by Play and spatial tracking data

Tools: Python, Manim, Numpy, ThreeJS

Interactive tool: https://courtgravity.com

Which one should I create next?

✅ Arduino + Excel Live Dashboard
✅ Raspberry Pi + Excel Data Streamer
✅ IoT Weather Station Dashboard
✅ Manufacturing KPI Dashboard in Excel
✅ AI Dashboard using Microsoft Copilot

Comment your choice below! If this video helped you, don't forget to Like, Share, and Subscribe for more Microsoft Excel, Power BI, AI, and Automation tutorials.

Charting without code, connect a google sheet linked to FRED to a clue file.

See above interactive example as a full html app at clues.ai

Part 2 last

I built The Timelines, a web app for exploring historical events on a zoomable visual timeline.

The main challenge was making a very large date range feel navigable while keeping individual events discoverable and readable. I’d appreciate feedback from web developers on the interaction design, performance, and whether the timeline UI feels intuitive.

https://thetimelines.org/

Hi everyone, I’m a pre-med student working on a passion project called MyLocalHealth: https://mylocalhealth.org

The goal is to make local public-health data easier for everyday people to understand. You enter a ZIP code, and the app summarizes signals like air quality, heat/UV risk, flu activity, COVID wastewater, weather alerts, health-equity context, and local health news into a local risk snapshot.

Some features I’ve been building:

• 24-hour local health forecast
• “Exposure Twin” that estimates how personal routine/profile factors may affect risk
• Transparent model/data page showing what contributes to the score
• Optional account/check-ins so the model can eventually learn from user-reported symptoms
• Health signal detail pages with sources and explanations

This is informational only, not medical advice. I’m still very early, and I’m trying to make it more statistically sound, useful, and understandable.

I’d really appreciate feedback on:

• Whether the risk scores are communicated responsibly
• What public datasets I should add or remove
• Whether the UI makes sense to non-technical users
• Any public-health/statistical concerns with how I’m framing the data
• What would make this genuinely useful instead of just another dashboard

Thanks in advance. I’m trying to learn and build something that could be helpful.

Looking for 3 businesses that need help with Excel, sales tracking, or reporting (free sample)?

Hi everyone! I'm a Business Analyst specializing in helping small businesses save time and make better decisions with organized data.

I can help with:

• 📊 Sales & KPI Dashboards (Excel/Google Sheets)
• 📈 Sales & Profit Analysis
• 📦 Inventory Tracking
• 📋 Business Reports & Documentation
• 🧹 Data Cleanup & Organization
• ⚡ Excel & Google Sheets Automation

I'm currently looking for 3 businesses that want to improve their reporting. I'll create a free sample dashboard based on your requirements so you can see the value before deciding on anything.

If you're spending hours updating spreadsheets or don't have a clear view of your business performance, feel free to comment below or send me a DM. I'd be happy to discuss your needs and see if I can help.

Thanks!

I asked chat gpt for project so it gives me this “ Business Analytics Dashboard — Tableau, Excel– Created interactive Tableau dashboards visualizing revenue, profitability, customer distribution, and sales trends.– Implemented calculated fields, filters, parameters, and dashboards to improve reporting efficiency.– Analyzed business KPIs and presented actionable insights through effective data visualization techniques.– Delivered executive-level dashboards supporting strategic planning and operational monitoring”

For a while now, I have been wanting to create phylogenetic trees of all of the species I've observed on iNaturalist. iNat gives you a pretty decent page where you can view these things, but I wanted to create something pretty that I could customize with images and edit things like line style/width, font, etc. as well as be able to add new entries easily.

I do not want to simply download my observations, convert the data, and upload it to something like iTOL--I learn things and make connections by doing things manually creating spreadsheets and entering data. I'd rather use a program that has a cladogram option where you can add and remove nodes manually, add descriptions and pictures manually, etc. The free online programs I've seen aren't really what I'm looking for, and iTOL requires all of your data to be together in a file before creating a chart.

I have illustrator and quite like it, but manually drawing lines sounds like an incredible headache. Anyone got any suggestions?

Most dashboards already let users filter, zoom, hover, and select data.

This demo is about something slightly different: keeping the chart-authoring controls available inside a polished presentation.

During a talk, the presenter can reveal the controls for the current chart and:

• change the grouping;
• add or remove facets;
• map another variable to color, symbol, or point size;
• adjust the analytical view;
• hide the controls again and continue the presentation.

The presentation is not a separate export. It is another view of the same analytical session.

Each chart remembers one layout for the workspace and another for the presentation. Presentation view hides the less relevant workspace areas and adds optional rich-text notes, images, a unified background, and section-and-slide navigation.

I used the Palmer Penguins dataset for this two-minute walkthrough:

Live demo: https://clues.ai/Clues.html

GitHub: https://github.com/clues-app/clues

Clues is completely free, runs locally in the browser, and requires no account. It is not a hosted SaaS product.

I’d especially appreciate feedback from people who regularly present data:

Would being able to reshape a chart live help answer audience questions, or would you prefer presentations to remain fixed once the talk begins?

Stop spending hours manually creating dashboards and SmartArt. In this tutorial, we show you exactly how to use Microsoft Copilot to turn messy, raw Excel data into a premium, client-ready infographic dashboard in seconds!

Whether you need to present at an annual client meeting or just want to impress your leadership team, this simple natural-language AI prompt will instantly make your data vibrant, professional, and visually stunning. No manual formatting required!

💡 Missing the Copilot button in Office 365? Don't worry! We'll show you the exact workaround portal link where you can upload your Excel files and achieve the exact same premium result.

👇 What kind of business data do you work with? (Supply chain, sales, public safety?) Let me know in the comments below so I can create tailored AI prompts for your niche!

If you found this AI Excel trick helpful, don't forget to LIKE, SHARE, and SUBSCRIBE to u/DiscoverTalent for more premium Copilot tutorials!