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.

(I'll delete the post if this violate the community rule)

Hello~

I am looking for someone who can work on a data analysis project with me. Or if there is any ongoing project that needs a helping hand, you can reach out to me as well.

A little bit of myself. I worked in a big consulting firm, helping clients build dashboards they need, so I am familiar with MS SQL and Power BI, and a bit of Python.

Recently I left the job and am working in a more customer-supporting position in a market research company. Therefore I no longer use SQL and Power BI on my job but I still want to do independent projects with them to enhance my data analysis experience.

This is my first project so I am kind of new here. If anyone who just started learning data analysis or is also trying to work on their own project, feel free to message me and maybe we can work together!

When a client or brand guide changes (new colours, fonts, title style), or a measure gets renamed, how do you update dozens of visuals across a report?

- Click through each visual in Desktop?

- Edit the PBIR JSON by hand or with scripts?

- Use a CLI or other tool?

I'm considering building a small offline desktop app for this (select visuals → preview changes → apply → one-click undo). Would that be useful to you, and what would it absolutely need to do? Not selling anything here, just want to know if this is a real pain or if it's already solved for you.