Month-End Data Categorization Improvement

$10-30 USD

Closed

Posted over 1 year ago

$10-30 USD

Paid on delivery

Objective: Ensure current month values (e.g., December) appear in both: Weekly categories ("Last week," "Last 2 weeks," "Last 4 weeks"). Monthly category ("Monthly" for the full month, e.g., November). Current Issues: Values for the current month are being categorized only into the weekly categories and not the Monthly category. The Monthly category is showing as blank for the current month because values are excluded due to overlapping with the weekly ranges. We need a solution that ensures data appears in both categories without duplication or conflicts. Approach: Isolate Current Month Data: Create a separate calculation specifically for the current month (e.g., November). Enhance TimeFrame: Ensure it categorizes data correctly for both weekly ranges and the full month dynamically. Adjust Grid Month : Ensure it displays month names dynamically, including the current month, and works with the isolated current month calculation. Key Requirements: Dynamically handle transitions into new months and years. Ensure consistent categorization across all months and weekly ranges. Avoid data conflicts or blank values for the current month I have written the calculations already see attached workbook just need tweaking. The data is currently in CSV format.

Tableau

SQL

Project ID: 38855896

About the project

9 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

9 freelancers are bidding on average $26 USD for this job

@DevDataAnalyst

With over 10 years of experience in data analytics and visualization, I specialize in R, Power BI, Tableau Desktop/Server, SQL Server, and Data Prep/KNIME. I have a proven track record of developing high-quality, professional dashboards for a diverse range of clients. Let's discuss how I can help you achieve your data-driven goals with custom dashboard solutions tailored to your needs.

$26 USD in 2 days

4.9

(28 reviews)

4.0

@analytics99

Hi There, I would like to work on your project. Also, I can automate your process with my knowledge and expertise. I am an automation expert in the BI domain with 15+ years of experience in BI reporting, automation, and visualization. My expertise includes working with Power BI, Power Automate, and Power Apps. I am proficient in multiple programming languages and platforms, including Power Apps, Azure Data Engineering, ADF, Alteryx, MS Excel, Google Sheets, MS Access, SAS, SQL, SSIS & SSRS, VBA, VB.NET, Python, PySpark, and R. Additionally, I have extensive experience in analyzing large datasets and creating visualizations using Tableau, QlikView, and Power BI. Thank you!

$50 USD in 2 days

4.5

(2 reviews)

3.2

@carlitanjuguna05

Hey! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includes Tableau and SQL, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.

$30 USD in 3 days

0.0

(0 reviews)

0.0

@aryoutomoyunanto

The objective of this project is to streamline data categorization for the current month by ensuring that values are accurately reflected in both weekly and monthly categories, avoiding conflicts or duplication. The primary issue is that data currently appears only in weekly categories, leaving the Monthly category empty due to overlapping entries. To address this, I will focus on isolating the data for the current month, refining the structure, and configuring the Grid Month to dynamically display month names. My proficiency in SQL will enable me to develop precise calculations that ensure consistent and conflict-free categorization.

$15 USD in 7 days

0.0

(0 reviews)

0.0

@pragna757

My expertise in SQL for 25 years. And I can able to work on timely manner on this one. I had a work experience in SQL for 24 years.

$20 USD in 7 days

0.0

(0 reviews)

0.0

@Prabharam1996

have carefully reviewed the requirements for the "Month-End Data Categorization Improvement" project and understand the challenges faced with the current categorization system. Here is my analysis, First let us fetch the current month data, enhancing the timeframe functionality to categorize data accurately, and adjusting the grid month display dynamically to avoid conflicts or blank values for the current month. With my expertise in data analysis and manipulation, I am confident in handling the necessary steps to ensure that values for the current month appear in both weekly and monthly categories. Let's discuss further details and get started on improving your data categorization process. I have written most complex queries during many projects and successfully delivered on time I have around 6 years experience on database coding and data visualisation tools I received multiple client appreciations for my on time work and solving most critical works

$20 USD in 2 days