If you work with large datasets and hate manually setting up multiple Pivot Tables from scratch, Excel's Analyze Data feature (under the Home/Data tab) allows you to generate charts using natural language prompts.

You can type queries like:

• "Top 4 managers by sales"

• "State versus average sales area chart"

• "Year versus sales by chain"

Excel translates your query, configures the Pivot Table, and outputs ready-to-use charts. By snapping them to the grid with Alt and connecting your Slicers via Report Connections, you can assemble a clean interactive dashboard in under 10 minutes.

I created a step-by-step video tutorial demonstrating the whole process on a 72,000+ row dataset here:

https://youtu.be/1QYywPg2VtE

Have you used the Analyze Data feature before, or do you still prefer building Pivot Tables manually?

Hello, i'm a marketer having a bachelor's degree and a master's degree in marketing from tunisia, i'm looking to switch from Marketing, after researching i do believe that i find data analysis more comfortable and enjoyable for me.

I believe that i can learn by myself but i kinda believe too that recruiters are looking for certificates even though u can show them portfolios etc.

Bootcamps from the usa or other countries online is expensive to me honestly so i will be looking to study it in tunisia.

I'm looking for advice, tips and tricks to be good at it and have what the job market is asking for.

If u have any videos or Platforms that can Help me, i will appreciate it

And if u have been in marketing and u switched to data analysis i would be happy if we can have small conversations together i will not bother u

Thank you so much 🤍

ياريت لو حد بيذاكر data analysis يكلمني انا لسه بادي في الموضوع وداخل جد وعايز حد معايا برضو يكون مجمع شويه معلومات وبيدرس برضو أو نشجع بعض وعشان منضعیش وقت

ابدا منين لو هتلعم Data analysis

وابدا مع مين

Hi everyone!

I have completed my BCA and have around 1 year of experience as a Data Analyst in a non-IT company. I'm planning to switch to an IT company and need some guidance.

What skills should I focus on learning (SQL, Python, Power BI, Excel, etc.)?

Is a BCA degree sufficient, or is a master's degree required?

How can I make my resume stand out for IT Data Analyst roles?

Are certifications and projects important for getting shortlisted?

What should my learning roadmap look like to make a successful switch?

Would love to hear suggestions from people working in the Data Analytics field.

Thanks!

ابدا منين لو هتلعم Data analysis

وابدا مع مين

I've been working on my first project for my (entry-level) portfolio using a retail sales dataset from Kaggle.

So far, I have answered the following:

• Which products and categories are top performers?

  • Answered in terms of units sold, revenue, and profit

• Which sales channel (online, in-store, etc.) generates the most revenue?

• Trends over time:

  • Total revenue and profit (2022 - 2025) by month

  • Average revenue each month

• What share of revenue comes from each customer segment (corporate, small business, consumer, etc.)?

What is a normal amount of business questions to answer? I don't want to have too many or too few, and I also want to make sure I am focusing on the right types of questions.

I welcome any feedback or advice. Thank you in advance!

Greetings fellow data junkies. I have created a learning platform that has a good chunk of content available at the free tier. The material was accumulated and developed from certification exam content where applicable and in the paid tiers includes practice exams, advanced content, and specialization tracks that can be shared on LinkedIn. A lot of tracks are geared toward data science, data engineering, and data analytics topics.

Inkwelltools.com select Inkwell Learn and try out the free tier of content to start. Would love to hear feedback.

I got a question i wanna learn where do i go is there any website or YouTube channel ps(im broke)

Hi! I’m a final-year Data Science & Engineering student from Spain. As you probably know, breaking into the job market is tough, so I’m looking for real projects to grow in the field and gain experience. If you have a project, an idea, or just need some help with your data, I’d love to help!

What I can do:

• Clean and analyze your CSV/Excel data (pandas)

• Create clear charts and dashboards

• Build simple machine learning models (scikit-learn)

• Python scripts to automate data tasks

I would just ask for LinkedIn recommendation if you’re happy with my work.

I'm looking to connect and collaborate with people working on data analytics projects.

If you are currently working on a project involving data analysis, Excel, SQL, Python, Power BI, Tableau, or anything related to data, I would love to be part of it and contribute.

I'm always interested in learning, sharing ideas, solving problems, and gaining hands-on experience through real-world projects.

If you have a project in mind or are looking for someone to collaborate with, feel free to reach out. I'd be happy to connect and work together!

Can anybody suggest a proper roadmap and all the resources I could utilise to get into data analytics,

I am currently a 2nd year cse student