Excel in Bi

Excel in Bi

  • Home
  • Courses
  • Webinars
  • Articles
Log in

Your cart is currently empty!

Can a non-technical person learn data analytics?

The short answer is: Yes, absolutely.
In fact, many of us already use the basics of data analytics in our daily lives—often without even knowing it.

Think about it:

  • When you compare prices before buying something online
  • When you budget for a family trip
  • Or when you check how your power bill has changed over time

That’s data analysis in action. You’re looking at numbers, spotting trends, and making informed decisions.

But does that mean you need a tech degree to become confident in data analytics? Not at all. With the right approach and a little curiosity, anyone—regardless of background—can learn and apply data analytics in a meaningful way.

At Excel in BI, we believe data skills should be accessible, practical, and empowering. So, if you’re new to the world of data or feel unsure about your technical skills, keep reading. You might be closer to becoming “data-savvy” than you think.


💡 Why Data Analytics Isn’t Just for Tech Experts

There’s a common myth that data analytics is only for software developers, engineers, or people who are “good with computers”. But the reality is that data analytics is more about thinking clearly and asking smart questions than writing complex code.

In fact, some of the best data analysts come from business, accounting, operations, or marketing roles—because they understand the problems that need solving. The technical side? That can be learned step by step.


👣 Your 5-Step Beginner’s Guide to Data Analytics

Here’s a simple roadmap we often recommend to non-technical learners who want to get started.


✅ 1. Start With the Tools You Already Know

If you have a laptop with Excel or access to Google Sheets, you already have the basic tools you need to begin analysing data. You don’t need to download any software or learn programming from day one.

These tools are widely used in businesses and have enough functionality for you to:

  • Organise your data
  • Run simple calculations
  • Build basic visualisations

✅ 2. Learn to Use Simple Formulas

Once you open Excel or Google Sheets, try using a few formulas like:

  • =SUM() — add values
  • =AVERAGE() — find the average
  • =MIN() and =MAX() — identify the lowest and highest numbers

These basic formulas help you calculate and summarise data. As you get comfortable, explore others like =IF(), =COUNTIF(), and =VLOOKUP() to build logic into your analysis.

🧠 Tip: Think of formulas like recipes—each one helps you solve a different type of question.


✅ 3. Work With Real Datasets

Now that you understand basic functions, it’s time to move beyond small examples and start using real-world datasets.

There are free websites where you can download structured datasets to practise with:

  • Kaggle Datasets – A huge library of interesting data
  • Data.govt.nz – Official datasets from New Zealand government agencies

Try importing a dataset into Excel or Google Sheets, and explore it. Look for patterns like:

  • Price changes over time
  • Differences between regions
  • Correlations between columns

📈 Tip: Start with a simple goal in mind, such as finding which suburbs have the highest rent increases.


✅ 4. Try a Real Example: Where’s the Most Affordable City to Live in NZ?

Imagine you’re planning to live in New Zealand for a year. You’re looking for:

  • A place with lower living costs
  • Good internet connection (for remote work or study)
  • Access to healthcare and public transport

Here’s how you could use data to help decide:

🔍 Step-by-step analysis:

  1. Get rental cost data
    • Use MBIE’s Rental Bond Data
    • Download data for different cities
  2. Get regional income or cost of living data
    • Use Stats NZ
    • Look for income, transport, and grocery cost data by region
  3. Compare key cities
    Create a comparison table with:
    • Average weekly rent
    • Average household income
    • Cost of living index (you can estimate this by combining transport, food, and internet data)
  4. Score each city
    Rank each city on affordability by dividing rent by income or by using a cost of living index.
  5. Visualise your findings
    Use a bar chart or map to show which city is the most affordable. You might find cities like Palmerston North, Invercargill, or New Plymouth offer a great balance of cost and quality of life.

📊 Bonus idea: Add filters to your sheet to explore based on internet speeds or proximity to nature—depending on your lifestyle goals.



✅ 5. Use Your Insights to Make a Decision

Take what you’ve found and present it:

  • To your partner or family as part of planning your move
  • To your employer if you’re proposing a relocation or remote work
  • Or for your own confidence that you’ve made a smart, data-backed choice

You’ve just used data analytics to solve a real-life problem.

If you would like to learn how make visuals like this one, check this link

View the official REINZ Heat Map here

🎓 You Don’t Need to Be a Master to Get Value

Becoming an expert takes time and practice, but you don’t need to reach that level to benefit from data analytics. Even with just a few key skills, you’ll be better equipped to:

  • Make smarter decisions
  • Communicate with confidence
  • Spot opportunities others might miss

No matter your background—whether you’re an accountant, engineer, cleaner, or student—you can learn data analytics. It just takes the right support, clear explanations, and a few hands-on projects to get you started.


🚀 Ready to Learn With Us?

At Excel in BI, we run free fortnightly online workshops to help people like you get started. We focus on simplifying data concepts and showing you practical tools you can use straight away.

We also offer structured online courses where we guide you step-by-step through:

  • Data cleaning
  • Excel and Google Sheets
  • Power BI dashboards
  • Storytelling with data
  • Automation tools and more

💬 You’ll never feel left behind—and you’ll walk away with real skills you can use in your job or your personal life.

👉 Join our next free session
👉 Explore our beginner-friendly courses


Final Thought

If you’ve read this far, you’ve already taken your first step toward becoming data-literate.
Now let’s keep the momentum going—because data is not just for techies. It’s for everyone. Especially you.

Categories: Data Analytics Tips
Ramon Zamorano

Latest Posts

  • Why Data Analytics is an important skill to know today? No matter Your role.
  • What is the true value of Data?
  • How Data makes You more Proactive instead of Reactive
  • Why is star schema preferred in Power BI?
  • Will AI Replace Data Analysts?

Categories

  • Data Analytics Tips
  • Excel Tips
  • Power Bi Tips
  • Python Tips

Excel in Bi

We are empowering businesses with simplified data analytics solutions. We provide tailored Data Workshops, Masterclasses, and Consultancy to help teams unlock the full potential of their data.

We specialise in simplifying the use of Data

Company

  • Home
  • Courses
  • Free Webinars
  • Articles

Services

  • Data Visualisation Training
  • SQL and Power BI Training
  • Dashboard Development
  • Data Strategy Plans
  • Business Intelligence

Contact Us

contact@excelinbi.com

Book a discovery call

  • Facebook
  • LinkedIn
  • YouTube
  • TikTok

✅ Additional FAQ Suggestions:

1. How long will I have access to the course materials?

You’ll have access to the pre-recorded videos for 6 weeks from the moment you click the “Start” button.
You can buy the course now and choose when to begin — your 6-week access starts only when you’re ready.

Live Q&A sessions are available during the first 4 weeks after you start the course.

2. Is there a certificate of completion?

Yes! Participants who complete the course will receive a certificate, which you can share on LinkedIn or with your employer.

3. What kind of support will I get during the course?

You’ll have access to weekly live Q&A sessions, and you can also email us your questions anytime during the 4-week period.

4. How is this course different from free YouTube tutorials?

Our training is structured, practical, and focused on real-world business problems. You get guidance, feedback, and live support, which you don’t get from random tutorials.

5. Can I take the course if I’m working full-time?

Absolutely. The course is designed with flexibility in mind. You can watch the pre-recorded sessions at your own pace, and attend the weekly Q&A at a time that suits you.

6. What industries is this course relevant for?

Our bootcamp is ideal for professionals in finance, operations, marketing, HR, and any field where data is used to improve performance and make better decisions.

7. Is the course beginner friendly?

Yes. We start from the basics and gradually move to intermediate topics, with hands-on examples and easy-to-follow steps.

8. Can my employer pay for the course?

Yes, we can issue an invoice if your employer is covering the cost. Just contact us for details at contact@excelinbi.com

Time Zones alternatives for Live Q&A Sessions:

Region City Option 1 Option 2
New Zealand Auckland Wed, 6:00–7:00 PM Fri, 7:00–8:00 AM
Australia (AEST) Sydney / Brisbane Wed, 4:00–5:00 PM Fri, 5:00–6:00 AM
Singapore Singapore Wed, 2:00–3:00 PM Fri, 3:00–4:00 AM
India (IST) Mumbai Wed, 11:30 AM–12:30 PM Fri, 12:30–1:30 AM
UK (BST) London Wed, 7:00–8:00 AM Thu, 8:00–9:00 PM
USA (ET) New York Tue, 2:00–3:00 AM Thu, 3:00–4:00 PM
USA (PT) Los Angeles Tue, 11:00 PM–12:00 AM (Wed) Thu, 12:00–1:00 PM
Chile (CLT) Santiago Tue, 1:00–2:00 AM Thu, 2:00–3:00 PM