Data Analysis for the Data Analyst

GUIDELINES - How to use this forum!

Modern Analyst — 2009-10-20T21:39:08Z

Use this forum to post questions and discussions related to: data analysis, data design, data modeling, data management, and related topics. No spam please!

Why is data analytics important in real life?

sanjanaroy — 2024-02-13T10:26:01Z

Data analytics is crucial because it allows businesses to make data-driven choices, increase operational efficiency, find opportunities, and gain a competitive advantage. Data analytics is important for several reasons: Better Decision Making: Data analytics provides insights that can inform better decision making. By analyzing data, organizations can identify trends, patterns, and anomalies, which can help them make informed decisions that are backed by data rather than just relying on intuition. Cost Savings: Data analytics can help organizations identify areas where they can save costs. For example, by analyzing energy consumption patterns, a company might discover that it can save money by adjusting its energy usage habits. New Business Opportunities: Data analytics can help organizations identify new business opportunities. By analyzing customer behavior, market trends, and other data points, companies can develop new products or services that meet the needs of their customers. Competitive Advantage: Data analytics can provide a competitive advantage. Organizations that use data analytics to make decisions can react faster and more effectively to changing market conditions than those that rely solely on gut instincts. Improved Customer Experience: Data analytics can help organizations improve customer experiences. By analyzing customer behavior and preferences, companies can tailor their products and services to meet the specific needs of their customers, leading to higher satisfaction and loyalty. Fraud Detection: Data analytics can help detect fraudulent activities within an organization. By monitoring transactions and identifying unusual patterns, companies can minimize financial losses due to fraud. Cybersecurity: Data analytics can help improve cybersecurity. By analyzing network traffic and system logs, organizations can identify potential security threats and take action to prevent them before they cause damage. Healthcare Improvements: In healthcare, data analytics can help improve patient outcomes. By analyzing medical records, clinical trials, and other health-related data, healthcare providers can identify effective treatments, reduce wasteful spending, and improve resource allocation. Environmental Sustainability: Data analytics can help organizations become more environmentally sustainable. By analyzing energy consumption patterns, water usage, and waste production, companies can identify ways to reduce their environmental impact. Scientific Discoveries: Data analytics can lead to scientific breakthroughs. By analyzing large amounts of data from various sources, researchers can identify patterns and connections that can lead to new scientific discoveries and advancements in fields such as medicine, astronomy, and climate science. You can visit here for more information,

Starting Data Analyst career with an unrelated degree?

OldBeginner — 2022-01-14T23:11:49Z

Hi There, I am about to start my Data Analytics Boot Camp study to get a certificate; but since my degree is not related to this field (Master's degree in Agriculture) I wonder what my chances are to get a job?

Do I need Master Degree in Computer Science to become a Data analyst or work in analytics field

SpecialSpade — 2018-01-24T08:58:03Z

I'm curious as to 'Do I need a degree in Computer Science to become a Data analyst or work in the analytics field. I did Automation Engineering for my Bachelor's Degree (graduated 2 years ago) . I'm working mostly as a QA checking for minor bugs and fixing the software. I feel that I'm eager to work in something more analytical. As I surf through the Internet for jobs on the analytics field, in every job description it states only that graduates from Bachelor in Statistics or Computer Science. So do I need to pursue a Master Degree in Data analytics or Computer Science. What sort of programming tool is required? Python, VBA, SQL?

YTD 2020,2021,2022

ASiuvax — 2022-08-28T12:26:20Z

Hi Everyone, I have a question about YTD for 3 years. I have stock prices from 1st day of 2020 to present day of 2022 for some companies and i have to calculate YTD for these companies. How can i do this? I think that i can do three calculations of YTD for each companies: 1. ((last day of 2020 - first day of 2020) / first day 2020) *100 2. ((last day of 2021 - first day of 2020) / first day 2020)*100 3. ((current day of 2022 - first day of 2020) / first day 2020)*100 Will this calculation be correct to show how the company has changed from early 2020 to today?

Increased Holidays...

Graeme16 — 2022-03-25T10:11:17Z

Hi All Looking for a little bit of help and I think I am probably over thinking the question. It's been proposed that holiday allowance will be increased by 2 days for all employees - the question that I've been asked is what this will do to our headcount, will we lose too many days and need to hire more staff or should we be able to cope with current headcount. Any help would be appreciated! Thanks

Does NoSQL change the way we should think about data modelling?

Ged Dunn — 2022-03-09T10:59:16Z

Like many I have been using ER and/or UML Class Diagrams to model data entities as logical objects before passing those designs to DBAs who build physical schema in a relational database SQL Server/Oracle etc. I haven't until now worked with a NoSQL database (eg MongoDB) as the target implementation and I am just wondering if it changes the paradigm of analysis and design at all? Since with a NoSQL database you can nest document schemas within documents... Name: Gerald Dunn Address: House: 99 Street: Main Street City: London ..is there any difference in the methodology of Data Modelling? In short - is ER data modelling the best practice for all types of target db, or are there alternatives? Any thoughts, recommendations, resources etc would be gratefully received. Thanks Gerald

How to represent and visualize and present data table relationships

Mythbusternz — 2021-12-03T15:25:38Z

Hi Experts, I am working on 100+ reports and used Power Query to create a table that shows each header in the spread sheet is used as data. Here is a sample problem health report say Covid reports. There are 6 spreadsheets with data on Covid, so I got a table which report uses what header (Table) likewise there are other health reports having common headers. I need an idea of what tool and how to co-relate Each of these spreadsheets are output from various systems and databases. Once I get the common links between each of the headers in the spread sheet, I will map them to the systems and create matrix. Further details on Covid spreadsheets Repart 1 1.ID, 2. Place 3. vaccine status 4. Partial flag Report 2: 1. ID 2. Name 3. GP/ Nurse name 4. ID of the GP/Nurse 5. Batch No Repoert 3: 1. ID, 2. Name, 3. Address 1, 4. Address 2, Region, State. etc Now I have a matrix of all the above spreadsheets and who is using what headers,, using power query. I need your help to visualize this into a meaningful story so I can use it for 100s of spreadsheets I need to analyze.

Would-be Student with Questions

harrietthespy — 2017-04-20T20:43:45Z

Hello All, I'm a new member at this website and in the process of applying to go to school and study DA. As part of my application, I need to conduct an informational interview with a professional in my field of interest. It's pretty cut-and-dried; I've got a list of 5 questions to ask. We can interview face to face or by phone (I'll be responsible for any long-distance phone calls of course). Hope to hear from someone soon . . . and, I hope this is an appropriate question for this forum? As mentioned, I am a newb : \ I will also post this in the Getting Started Forum, although I see 'Business Analysis' there more than I see 'Data Analysis.' Thanks very much!

Textbook + Videos for R-based Business Analytics

Adam Fleischhacker — 2021-08-24T18:31:27Z

Hi All: Just wanted to build awareness for a fun and free Bayesian Business Analytics textbook - ';A Business Analyst's Introduction to Business Analytics'; - with great accompanying videos that I authored for students who might be intimidated by other books. Please share this with others who might be interested.

The free book website can be found here: 'https://causact.com/' rel='nofollow'>https://causact.com

Free videos are here: 'https://youtube.com/playlist?list=PLassxuIVwGLPy-mtohX-NXrjD8fc9FBOc' rel='nofollow'>https://youtube.com/playlist?list=PLassxuIVwGLPy-mtohX-NXrjD8fc9FBOc

Full-color printed version on Amazon: https://www.amazon.com/gp/product/B08DBYPRD2 For any profs with questions about adopting it, please reach out. Its well-reviewed on Amazon and has been ranked #1 by bookauthority.com: Thanks, Adam --------------------------------------------------- Adam Fleischhacker J.P. Morgan Chase Faculty Fellow – Inst. For Financial Services Analytics Associate Professor of Operations Management University of Delaware Twitter: 'https://twitter.com/preposterior'>@preposterior

WBS for a data analyst project

MINNI! — 2021-02-25T10:32:07Z

Does anyone have a skeloton Work Breakdown Structure with key tasks for a Data analysis project including the typical tasks involved in a little detail. This would include from Discovery tasks through to UAT and sign off please? Or is there anywhere on here with examples? I have tried to seach.

Mix Analysis FC v Actual

AshleyWatson — 2020-10-09T11:42:29Z

Hi All I am trying to understand mix analysis properly and how to calculate variances from FC to Actuals. This example is based on services, this could be any service but we will go with Car Sales being the Product and the service being a car wash taken out at the time of purchase. There are 3 variables. Price, Volume of cars sold and Uptake of the service. Price, volume and uptakes could change from FC to Actuals through several means but the variance analysis is the key point here. I have attached a google sheet an example of how I can get from FC to Actual Income through 4 different methods, all of which I believe are wrong. I'm looking for a solution to properly perform variance analysis for these 3 variables from FC to Actual Income. Let me know if you can help! Thanks https://docs.google.com/spreadsheets/d/1qAk3J-NjNIDJbny_xqyZQBiDh5DhuMOd/edit#gid=1014107644

Being creative with Optimization

Sal82 — 2020-07-17T18:01:19Z

Hi Guys, new to the site. I am a data analyst for a supply chain company operating in Oil and Gas, with only one SKU. I have recently gotten promoted to this role, and everything is a bit fluid. I am being asked to identify opportunities in our operations to find efficiencies which can be used to find savings. What i am really struggling with is a way to look at my operations and find projects to uncover efficiencies. Can you recommend strategies for improvement? Thanks

Role of Data Science

jhonylevis — 2019-04-17T17:11:51Z

Data science encourages the customers to take right choices from right data brought out of a tremendous measure of chaotic data. Data researchers utilize their impressive aptitudes in science, business, programming and measurements to clean and sort out data into helpful data and uncover concealed examples, patterns and connections

data analysis retail

ste 01 — 2020-04-16T08:34:35Z

Urgent help needed for a little university project. I need to do:

Sales trends
Sales € by month
Sales pz by month
# Orders by month (optional)
Market Share
Sales Insights (by month)
Pz/order
Average sales price
Cart penetration (# of cart containing “Birillo” items / # total cart) by month (optional) about a brand, I have all the data but for me it's very difficult. Maybe you can help me in few minutes. Thanks

BA Role in Data Migration

Omar — 2019-08-30T05:05:55Z

Guys - Please let me know your thoughts on what the responsibilities of a BA are in terms of data migration? What sorts of documentation does the BA take care of (which the Data analyst doesn't)?

Data Migration Strategy

Ash 02 — 2019-05-12T23:16:20Z

Hi, I am looking for some data migration approaches from business perspective. Following are few I have started with more topics will help: - Missing data approach - Reconciliation approach - Dual Transition apprroach Please share your thoughts. Regards, Ash

Data migration user story writting

Ash 02 — 2019-04-23T04:59:24Z

I have recently started working as a BA, my role is to capture user stories related to data migration from legacy to new. I need help with some sample user stories for data migration. For example if abc screen data from legacy system is migrated and as new system user i want to view the transferred data on xyz screen. Note: the purpose right now is to view the migrated data. so i am confuse with how to write what benefit the user story will add. Thanks in Advance!!

How to analyze data model

Ruth_Kimberly — 2018-07-26T08:43:56Z

Hi,

I have been assigned a task to analyze the existing data model.

So I would like to know

1. What are the Best Practices to be followed for creating new Data Model? 2. If existing Data model needs to be analyzed, What are the areas that needs to be given attention? Any suggestion, guidelines are very much appreciated. Thanks Regards,

Sarika

Should I do ccba orc ecba+ BA certification?

happykp — 2018-11-24T03:54:29Z

Hi All I am senior software engineer and I wish to switch to role of business analyst. I have no prior BA exp. I know CCBA certification needs 5-7 years practical experience but can I just fake it and appear for CCBA exam and obtain certification? Or only ECBA+ certification is the only option? What value ECBA+ certification has in market?