r/dataanalytics • • 12h ago

I built a free .pbix viewer that opens your file locally. Nothing is uploaded

Thumbnail
powerbireader.app
1 Upvotes

Select a .pbix file and it runs entirely in your browser. The file is never sent to a server, all information is kept locally.

Features:

- Lists tables, columns and relationships

- Export tables to CSV/XLSX

- Shows all DAX measures with their expressions

- No install and no account

Feedback and suggestions are very welcome!


r/dataanalytics • • 14h ago

Proposed "governance" abbreviation: gov'c

0 Upvotes

As in **Data Gov'c**. Idk why I care, it just seemed so obvious to me.

Do y'all abbreviate?


r/dataanalytics • • 19h ago

How do you handle this?

3 Upvotes

Hi,

I have been doing data analysis for quite some time now, and notice a common theme of issue I have had when working across departments in my company, as the dataset may vary the knowledge required to understand is always different, hence getting the time to sit down and study them, is near impossible.

In some cases, values in columns don't make sense, objectives aren't properly defined, or important information is scattered across questionnaires, documents, emails and conversations with the people who collected the data.

And of course, the people who have that knowledge aren't always available when you need clarification.

I want to understand how other people deal with this, particularly those working across multiple projects or departments in a company or organisation.

I have been trying to tackle this issue by using a plugin (currently still in the work, but getting good result so far), to assist me . With it, I am able to simultaneously connect the spreadsheet I'm analysing to a shared project space containing uploaded contextual documents or files that contains information and knowledge related to the spreadsheet, so I can find information without having to search through everything manually again. So when going through the dataset, I can click on a variable and it searches the documents and find information on it that are presented in those saved documents.

But nonetheless, I'm interested in how you approach these problems, especially those working in different industries or with larger datasets.

Would love to hear about your experiences.


r/dataanalytics • • 1d ago

Can anyone guide me with project execution ? how do i approach it ? Created a Guide but didn't worked out well

3 Upvotes

Hii everyone,

I was a digital marketer executive in an agency, after i quit my job i started learning tech stack for data analysis i am finished with learning and currently on project i started my project last week its a cart abandonment analysis from GA4 dataset on big query whole plan is to analyze using creating a funnel than using python perform statistical tests ( hypothesis testing and ab testing ) and present my findings through power bi.

ideation part was done now i actually had to do project so i asked claude to create a guide for me to follow, a project guide and another solution guide to it.

But the guide's language was tuff it gave me ques and was done with i didn't knew what to do or how to do to it fast forward to today i have improvised and created 4th version of that guide with improved language better guidance but there is always something missing a vague question important information being left out for my sake i created an excel with imp fields out of 108 columns.

Today after writing a 50 line query to create a session table i was confused like why am i doing this i couldn't ans why i need this table it doesn't look like the funnel i thought it would be, mind you i have created funnels before in sheets for campaign analysis from top of the funnel metrics to the bottom of funnel from cpm cpc ad spend to order initiated order completed and all the steps in between so i asked chatgpt about the funnel part of my project ( which i thought i was working toward bcz of all the steps in between ) how is it related and it couldn't ans probably or give me reason which makes sense i wanted an industry level project and it told me that we will prove that shoppers are dropping and at what stage like wtf we already know shoppers are dropping and told me to analyze by device and demographics which still falls under EDA what realistic problem finding is that and what realistic solution can i provide ?

I am facing too much time reading that guide and going back and forth with GPT/claude to understand things and actual process because of the confusion caused by guide and even the solution fields don't match, can anyone help me with execution how do i execute and create portfolio projects i tried looking up DA projects of people on GitHub but didn't find anything useful i don't know how to even represent a project.

I need a framework on how to create a project i am not copying from anywhere just need guidance, looking for advice on how should i approach project creation even ready to pay ( although i don't have much money tbh but still )

I am seconding guessing that i should just create project with ai ideation would be mine and i can just understand the code and project ( practise SQL and pandas daily and DAX few times a week ) that way i will have coding syntax in mind and create projects more and faster which will get me interviews real learning is on the job anyways i have forecasting, data cleaning and time series projects in mind as well i am short on savings money as well


r/dataanalytics • • 2d ago

Has anyone built or come across genuinely innovative and realistic AI agents in the data or analytics space? I’d love to hear about real-world implementations, interesting use cases, or people who are pushing the boundaries of what AI agents can achieve in data-related fields.

4 Upvotes

Has anyone built or come across genuinely innovative and realistic AI agents in the data or analytics space? I’d love to hear about real-world implementations, interesting use cases, or people who are pushing the boundaries of what AI agents can achieve in data-related fields.


r/dataanalytics • • 2d ago

How to start freelancing

6 Upvotes

Im 23. curretly pursuing Msc in Data Science and Analytics in Bangalore. I have worked as a data analyst in Airtel. i want to start working as a freelancer for some sort of income as well as exp. I have a portfolio with 5-6 projects including automated pipeline, python analysis, dashboards etc.
What all should i do to kickstart freelancing.


r/dataanalytics • • 2d ago

Question for experienced data analyst

10 Upvotes

Howdy people!!

I have been a data analyst for about half a year now and has experienced few issues when it comes to handling and processing data for reporting; some due to departments giving dataset that aren't clear, some due to report requirements or objectives not being definitive and some may be due to unavailability of higher ups who have key knowledge of the data, as of course they are busy people, and so the report you will write is highly dependent on the source data. Aside this as I grow in my data analytics career what problem could one also face, or even better what problem or experience have you faced or is common in your own area of work or environment as a data analyst.


r/dataanalytics • • 3d ago

Finding churned customers in SQL: why NOT IN can return zero rows

8 Upvotes

"Which customers placed an order last quarter but none this quarter?" is one of the most common analyst SQL questions, and there's a trap in the obvious answer.

SELECT customer_id
FROM orders_last_quarter
WHERE customer_id NOT IN (SELECT customer_id FROM orders_this_quarter);

If orders_this_quarter contains even one NULL customer_id, this returns nothing at all. x NOT IN (1, 2, NULL) is never true, it's unknown, so every row is filtered out.

Safer options:

-- anti-join
SELECT l.customer_id
FROM orders_last_quarter l
LEFT JOIN orders_this_quarter t ON t.customer_id = l.customer_id
WHERE t.customer_id IS NULL;

-- or NOT EXISTS, which also handles NULLs correctly
SELECT l.customer_id
FROM orders_last_quarter l
WHERE NOT EXISTS (
  SELECT 1 FROM orders_this_quarter t WHERE t.customer_id = l.customer_id
);

If you want to practice the LEFT JOIN version on a dataset, I made a free site with PostgreSQL running in the browser and row-by-row checking against the expected result. This problem is exactly that pattern, no account needed: https://dbexercises.vercel.app/exercise/dormant-customer-churn-detection

What other churn / retention patterns come up in your interviews or at work?


r/dataanalytics • • 3d ago

I’m looking for job- Data Analyst role(USA) any suggestions please

0 Upvotes

r/dataanalytics • • 3d ago

GraveTrail Lineage tool

1 Upvotes

Hi All

As a data engineer i spent a lot of annoying time understanding the table Lineage in a prehistoric legacy system.

Based on my hardships and understanding I've built this Lineage tool

https://sahasilak.github.io/GraveTrail/

I would appreciate it if you can spend some time trying it out by sharing feedback like

Good, bad, need improvements , something like this already exists


r/dataanalytics • • 4d ago

"Do you see the pattern?"

Post image
22 Upvotes

r/dataanalytics • • 5d ago

Job suggestions

2 Upvotes

I am so lost right now. I am pursuing bachelor's in mathematics with minors in statistics and computer science. I don't want to get into the rat race of government job entrance exams right now because it's India, everybody wants a govt job, it'll probably take me years. I do want a good paying job. Is data analyst a good career path to get into or are there any other career paths to consider? I'd like some options.


r/dataanalytics • • 5d ago

anyone moved from hospitality to DA?

0 Upvotes

would like to know how you switched over from hospitality/foodservice and what sort of jobs did you start with.

Thanks!


r/dataanalytics • • 6d ago

ALGUN ANALISTA DE DATOS EN ARGENTINA?

0 Upvotes

Quisiera poder charlar con un analista para hacerle unas preguntas sobre el oficio, desde ya muchas gracias


r/dataanalytics • • 6d ago

Best FREE Python course for Data Science / Data Analytics with certificate?

5 Upvotes

Hi everyone,
I want to learn Python specifically for Data Science / Data Analytics.
I'm a complete beginner in Python. I don't want a general Python course, I want one that focuses on data: Pandas, NumPy, Matplotlib, data cleaning, etc.
Is there any FREE online course that gives a certificate at the end?
I know about Coursera / edX / Kaggle, but most of them charge for the certificate.
Any recommendation for a beginner like me?
Thanks!


r/dataanalytics • • 6d ago

Data analytic internship

2 Upvotes

Hello, I got an opportunity to work at a company for an internship for data analytics for four months. I wanted a brief idea on how it would look like from the experienced ones.

For those who have completed a similar internship, I’d like to know a few things:
-What did your day-to-day responsibilities generally look like?
-What kind of tasks or projects were you assigned?
-Were you mostly working with Excel, SQL, Python, Power BI/Tableau, or a combination of these?
-How much guidance and mentoring did you receive?
-Were you given actual company data and expected to work on real projects, or was it more of a learning-based experience?
-What skills would you recommend brushing up on before starting?

I just wanted to know how a typical day to day goes for this particular job.
Would appreciate hearing from you guys.
Thanks!


r/dataanalytics • • 6d ago

Junior DA - Question?

6 Upvotes

How do you generate Insights?

I have been doing it for a while and it seems they want to seek more? what key questions would you answer in your insights for insights on a 3 year historical sales data?

We use MAT (Moving Annual Total), Rolling QTR and YTD for time intelligence, on a sales data for 3 - 4 manufacturers including us, where I present answers mainly on the above Time Intelligence and 'Same period Last Year' with growth based on the 2.

Given this scenario, how would you generate insights and what key questions would you aim to answer for this case?

Thanks in Advance.

Edit - I am the only DA in my team, its a small startup.


r/dataanalytics • • 7d ago

How do you convince people of your test results?

1 Upvotes

Hi,
Our GoTo mechanism to analyse effects of tests we did is Dif-In-Dif. However we have lots of people in (senior) management who are not that data literate and even though they nod along we get request after request to find different ways to analyse.

Anyone else facing that problem / how do you handle it?


r/dataanalytics • • 7d ago

Foundation for Analytics Role

1 Upvotes

I am trying to get into the Analyst career; Data, BI, Business, etc. I am currently doing bachelor's and my uni provides 2 degrees that are closely related. First is bachelor of commerce majoring in business analytics and second is bachelor of IT majoring in data analytics. I would like to know everyone's thoughts which degree should I go for to build my foundations in. I am currently in first year so it is easy for me to switch. Should I have commerce/business as my foundation or IT as my foundation for my first year. Also my uni seperates CS and IT, so IT foundations would be about general IT, computer systems, networking, security (which I personally don't think an analyst need), but let me know your thoughts! Thanks!


r/dataanalytics • • 7d ago

Where do I begin?

2 Upvotes

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

وابدا مع مين


r/dataanalytics • • 8d ago

Seeking advice from people working in IT, Data Analytics and Data Science. I am a 30 year old male with Matric (Grade 12) and I'm considering starting a career in the IT/data field through Coursera Professional Certificates.

4 Upvotes

Seeking advice from people working in IT, Data Analytics and Data Science.

I have Matric (Grade 12) and I'm considering starting a career in the IT/data field through Coursera Professional Certificates.

I'm looking at programmes in:

- Data Science

- Machine Learning

- Data Analytics

- Business Intelligence

- IT Project Management

My question is: Can someone realistically build a career and get employed in these fields using Coursera Professional Certificates, practical projects and demonstrable skills, without having a university degree or diploma?

I understand that these certificates are not equivalent to a bachelor's degree. However, I would like to know whether employers in South Africa actually consider candidates with these certificates and practical experience, particularly for entry-level positions.

For those already working in the industry:

  1. Have you or someone you know secured employment through this route?

  2. Which of these fields offers the most realistic entry point without a degree?

  3. Would you recommend investing time and money in Coursera, or should I rather pursue a formal qualification first?

I'd genuinely appreciate honest advice from people who recruit, work in or have entered the industry through a non-traditional route. I don't want to invest in certificates that won't meaningfully improve my employment prospects.

Thank you.


r/dataanalytics • • 8d ago

Australia - Upskill or Pivot?

1 Upvotes

At a crossroad in my career where I have had ~3 years of data analytics experience. Trying to aim for a senior role, but feel like every employer wants SME experience for an industry I don't have or some absurd amount of work experience (like 7 years+).

Wondering if there's any upskilling I can do outside of work to make myself more 'hire-able' or make a pivot out of data analytics.


r/dataanalytics • • 8d ago

Australia - Upskill or Pivot?

1 Upvotes

At a crossroad in my career where I have had ~3 years of data analytics experience. Trying to aim for a senior role, but feel like every employer wants SME experience for an industry I don't have or some absurd amount of work experience (like 7 years+).

Wondering if there's any upskilling I can do outside of work to make myself more 'hire-able' or make a pivot out of data analytics.


r/dataanalytics • • 8d ago

Foundation For Analytics Role

3 Upvotes

I am trying to get into the Analyst career; Data, BI, Business, etc. I am currently doing bachelor's and my uni provides 2 degrees that are closely related. First is bachelor of commerce majoring in business analytics and second is bachelor of IT majoring in data analytics. I would like to know everyone's thoughts which degree should I go for to build my foundations in. I am currently in first year so it is easy for me to switch. Should I have commerce/business as my foundation or IT as my foundation for my first year. Also my uni seperates CS and IT, so IT foundations would be about general IT, computer systems, networking, security (which I personally don't think an analyst need), but let me know your thoughts! Thanks!


r/dataanalytics • • 8d ago

I decided to take DA as a serious career path and wanna start as early as i can to learn. What is the best, well structure, comprehensive paid course (reasonably priced) out there?

3 Upvotes

A course that will teach me everything i need to know in excel, SQL, power BI, Python (for da purposes). Teach me by seeing, listening, and most importantly DOING. i hear DataCamp is good since it also provides 50% discount on Microsoft PL-300 certificate/Exam but i don't know how to start on that site, and i cant find a Youtube guide on how to navigate learning data analytics on that site. Help me please.