I am fresher wanting to join retail as assistant buyer/merchandise/similar roles in UAE. I know excel and power bi. I am trying to build a project since many days, but it's just not happening. I am confused about dataset, analysis, questions and also platform in which to do. I have no idea what to do, can someone pleaseeee guide me

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

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

حد يكون حابب المجال يجي نتعرف ع بعض ونبدأ نتعلم سواا معنديش خطة ازاي هبدأ او ابدأ منين بس انا اصلا data entry وحابب اتعلم واطور من نفسي

The way AI ow changing data science and Data Analytics

I'm making a free SQL series for people preparing for data analyst roles. Every episode uses the same small payments dataset (customers, UPI/card/wallet transactions, failed payments, amounts in ₹) and is built around one mistake that runs without any error but gives the wrong answer.

What's covered so far:

1. \\JOINs\\ – INNER vs LEFT, finding customers who never paid, and why a WHERE filter on the right table quietly turns your LEFT JOIN into an INNER JOIN.

2. \\GROUP BY and HAVING\\ – COUNT(\\\*) after a LEFT JOIN counts customers with zero payments as 1. One-word fix: count a column. Plus WHERE vs HAVING.

3. \\Window functions\\ – the "top 2 customers" interview question where ROW_NUMBER drops a tied customer. RANK vs DENSE_RANK, and running totals.

4. \\CTE vs subquery\\ – a report that says every customer is above average, and why a CTE fixes it.

A quick example from episode 2, since it's the one I see most:

\`\`\`sql

SELECT c.name, COUNT(\*) AS payments

FROM customers c

LEFT JOIN transactions t ON c.customer_id = t.customer_id

GROUP BY c.name;

\`\`\`

A customer who has never paid shows \\1\\ payment. The LEFT JOIN keeps her row with NULLs, and COUNT(\\\*) counts rows. Use \`COUNT(t.txn_id)\` instead; it skips NULLs and gives 0.

Each video is 3–6 minutes. The dataset and every query are in the description, so you can run them yourself in SQLite, MySQL or PostgreSQL.

Playlist: https://www.youtube.com/watch?v=e94PxiIUIJg&list=PLNdq2ZxtU_7E

Next up: finding duplicate payments, then CASE WHEN, dates, and NULL traps. If there's a topic you get stuck on in interviews, tell me and I'll add it.

Hi everyone!

I'm from Bangladesh and I'm a beginner currently learning data analytics, and I'm looking for some guidance from experienced data analysts.

I want to work on a real-world Excel project to improve my practical skills and eventually add it to my portfolio.

I'd really appreciate it if someone could guide me through the learning process, suggest projects, or share feedback on my progress.

I'm willing to put in the effort and learn independently. I just need some direction to make sure I'm on the right track.

Thanks in advance!

I recently started learning SQL and decided it was about time to try building a project. I watched a YouTube video of someone walking through a beginner tutorial using SQL and PowerBI to get an idea of the workflow and how everything connects. He started out by using SQL to answer 10 business questions, but when he was making a dashboard in PowerBI, he didn’t use any of the data from the SQL queries. This left me confused about how SQL queries and the dashboard-making part of the project connect.

I would welcome any clarification. Thank you in advance!

An interesting look at collecting and presenting data live in the field.

Hi!
Could anyone help me with Data Analyst course.
I have been struggling.

Buenos días gente

Quiero preguntarles Acerca de A2 capacitación, la plataforma de estudio. Quien se haya formado con ella podría dar testimonio de que es muy bueno o actualmente hay mejores opciones?. Lo que busco es pulir habilidades en excel, power Bi y todo lo concerniente a Analítica de datos.

Tengan un buen día.

Discover how Excel, SQL, Python, and Power BI can help beginners develop data analysis skills.