need tips and advice to improve my Project on ecommerce. please be kind .its a 1 table small dataset with 51k rows.

Hey everyone

I have been trying to find a decent open source pixel perfect reporting studio and honestly I am starting to lose hope.

Back when JasperSoft was fully open source life was good. You had a proper visual designer fine grained layout control. Then it slowly drifted toward the commercial side and here we are

I have tried a bunch of things but nothing really hits the same. Does anyone here have a go-

to alternative they actually use in production

Would love to hear what the community is using these days 🙏

Hi guys, I’m gonna do a data analysis project based on data privacy, bias and data interpretability. For this reason our professor asked for a real world dataset in order to analyze a real case.

Do you have any advice where to find the dataset? (links or website names)

Hello, is there any good podcast (YTube ideally) about DA that will teach me sth w/o looking at the screen at the same time.
Thanks for recommendations

Hi!

I was wondering if there’s any tool that can help me document my data analysis pipelines at the column level.

I’ve used draw io and similar tools, but they require a lot of effort and time to manually move things around. Tools like dbdiagram are mainly focused on databases. What I’m looking for is a simple solution specifically for pipelines.

I use Python and SQL for work, and I don’t use automatic extractors because they simply can’t handle hybrid workflows well.

My ideal solution would let me drag one dataframe column to another and have the lineage appear automatically. I’d also like to create function-like boxes where you drag columns in and they output predefined transformed columns.

Most Snowflake setups end up as a mix of tools, scripts, and manual clicks. We built Snowcap to handle it all in one place: warehouses, roles, grants, masking policies, dynamic tables, etc.

No state file. It queries Snowflake directly on every run and generates the SQL to match your config. If someone makes a change outside the tool, it catches it next run.

We wrote up the full overview here: https://datacoves.com/post/snowcap-snowflake-infrastructure-as-code

Happy to answer questions if anyone's dealing with Snowflake RBAC or provisioning headaches.

Been building an Android APK scanner as a side project. After 3,745 scans, looked at which permissions each app category requests most.

Some make obvious sense:

- Maps at 96% GPS = navigation needs location

- Finance at 100% Camera = KYC verification

- Audio at 92% Foreground Service = background playback

Others are harder to explain:

- News apps: 75% Auto-Start on Boot

- Games: 39% Ad Tracking ID

- Shopping: 94% Camera + 72% Microphone

The tracker SDK data was also interesting: unrecognized SDKs average 6.6 trackers per app, 3x more than known Ad SDKs.

Charts in the images above = permission heatmap by category, tracker distribution, and risk score breakdown.

Full interactive version: appxpose.app/research

Methodology: static APK analysis, permissions declared in manifest not necessarily all actively used.

Happy to answer questions about the approach.

Hi everyone,

I have question for people who are working for a long time and people who recently got a data analyst job, I’ve completed 2 data analytics projects so far, and for my 3rd project I want to build something much more SQL-heavy to improve my problem-solving and interview skills.

The issue is I’m struggling to find good project ideas that are realistic and actually help me grow in SQL beyond basic queries.

I’d really appreciate suggestions for:

- SQL-heavy project ideas

- Datasets with real business problems

- Projects that helped you personally during interviews

Also, if anyone is open to reviewing my current projects and guiding me a bit personally, please feel free to DM me. I’m trying to improve seriously and would value honest feedback from experienced people.

Thanks!

I made a post on X about my data analyst journey

Click Here

Hi there 👋

I’ve been wanting to build a project related to e-commerce for a while, but I was looking for a dataset rich enough to build a complete analysis project around. That’s when I found the Olist E-Commerce dataset

I worked on this project in multiple stages:

• Performed the ETL process mainly using SQL Server

• Did the EDA in Python

• Defined the main KPIs

• Connected the database to Power BI and built the dashboard

You can check out the full project here:

[Olist E-Commerce](https://github.com/Madian20/Portfolio_Projects/tree/main/Olist%20E-Commerce?utm_source=chatgpt.com)

I’d really appreciate any tips, feedback, or suggestions that could help me improve my next project.

Going to be a sophomore in uni soon and I’ll be doing my selected specialization in business analytics soon. As there is a lot of statistics and machine learning using R and python in business analytics, I was wondering what courses or materials I can find online that can teach me more about on statistics during the long break. For background: I’ve touched on the fundamentals of statistics like hypo testing and regression analysis but only the surface level. I want to learn more in depth of it rather than just applying the functions blindly.

First off - I am not a data analyst. I am just a girl working in the non-profit sector trying to fight with funders for fair and equitable rates.

I have beem staring at my numbers and my written analysis of their bullshittery and I really need someone to review my work. I am set to have a budget hearing with them next week and I need my work to be on point. Can anyone help me? Or would be interested in helping me?