Questions tagged [data-analysis]
Data Analysis involves extracting meaning and insights from raw data. It involves methods and algorithms that examine, clean, transform and model the data to obtain conclusions.
data-analysis
4,896
questions
0
votes
0
answers
7
views
Data analysis of JSON: Time vs Memory Optimization (Python)
I had a task about analysing data in a newline delimited JSON, using Python. I was asked to give 2 approaches, one that optimizes time spent, and one that optimizes memory used.
Each line of the JSON ...
-1
votes
0
answers
20
views
Seeking Techniques to Automate Transformation of Irregular Excel Layouts to Structured Datasets
I am facing a challenge with automating the transformation of irregular Excel layouts into structured datasets. These Excel files often contain:
Merged cells
Hierarchical columns
Annotations and notes ...
-5
votes
0
answers
18
views
Mongo DB visualization [closed]
I need help currently I'm using mongo DB and wanted to fetch live data to the power BI
My client wanted to see current data in dashboard if you have any ideas please feel free to mention any other
...
0
votes
0
answers
18
views
Navigate to a different page after login streamlit
I am building a data analysis and visualization web app using streamlit with firebase authentication. The login is successfully but it has failed to switch to the main dashboard page.
Here is the code....
0
votes
0
answers
5
views
Creating a Comparative Performance Analysis Table with Filters in AWS QuickSight
I am a beginner in using Amazon QuickSight, and I have a dataset containing information about tasks performed by groups, including a performance score for each task. My goal is to create a table that ...
1
vote
1
answer
17
views
Power BI Remove year in Chart visual x-Axis but sort by month and year
In my data I compare the sales amount of diferent years but to show them in the same chart, I faked the year in my data. It always start in 2000.
The legend shows the name of the SalesEvent.
My ...
-1
votes
0
answers
44
views
What would be the first things someone should learn to get used to R? [closed]
I am working on bolstering up my data analytics skills, and I am working through a course. I will soon be learning R. And I figured before I get to it, I wanted to at least hear what some of the most ...
0
votes
0
answers
13
views
Filter rows with same values for two specific columns in R? [duplicate]
I have a tibble in R like:
df1<-tibble(student=c("John", "John", "John", "Mark", "June"),
grade=c("A", "A", "A&...
0
votes
3
answers
69
views
Selenium isn't recognizing a button on my webpage
I am trying to automate the data entry for a project I'm working on by making a selenium code to pull all of the data from a survey report page. My current issue is that for some reason one of the ...
-1
votes
0
answers
12
views
how to deal with state feture while performaing ml/time series task
I am working on a revenue prediction model where the state is one of the key factors. I initially applied one-hot encoding to the state variable, but I am not getting the desired accuracy and my model ...
2
votes
2
answers
31
views
Strange behaviour of Functions with Dates
I am having a brain freeze.
I imported SampleA.csv and then I tried the below on a date field
EOMONTH(SampleA[Date],0)
And
ENDOFMONTH(SampleA[Date])
They both should give me the same value. However, ...
-2
votes
0
answers
32
views
How make a predictive Model to predict demands of different products [closed]
I am working on a supply chain problem where i need to predict how much material will be required in each quater to meet the demand .
For each product we know what operation needs to be performed in ...
1
vote
1
answer
20
views
How is offset able to go to prior year data without using having to explicitly to remove the filters from Date table?
DEFINE
MEASURE DimProduct[CurrentYearSales] = SUM(FactInternetSales[SalesAmount])
MEASURE DimProduct[PreviousYearSales] = CALCULATE(SUM(FactInternetSales[SalesAmount]), OFFSET(-1, , ORDERBY(DimDate[...
1
vote
1
answer
24
views
Is DAX EARLIER equivalent to using variable to hold the outer context value?
EARLIER(<column>, <number>)
Is EARLIER technically equivalent to using a variable to hold the value?
For example: if I have a table called Products, then using EARLIER returns the value ...
1
vote
1
answer
22
views
What's the difference between using ALL vs VALUES in MAXX table parameter?
MAXX(<table>,<expression>,[<variant>])
What's the difference between using ALL(Product['Name']) vs VALUES(Product['Name']) in the above DAX?