
Concluído
Publicado
Pago na entrega
I have a time-sensitive retail analytics assignment that has to be wrapped up within 3 to 4 days. Once we start, I’ll share the raw transactional files and a short requirements brief. You’ll first wrangle the data in SQL , then move into Python for any advanced calculations or feature engineering, and finally present the insights in an interactive Power BI dashboard. NOTE: see the attachments for final task and dataset. Core focus • Clean and model the data so that it is query-ready • Produce a concise Python notebook that documents every transformation • Build a visually polished Power BI report with slicers, drill-downs, and KPI cards Acceptance criteria 1. SQL scripts execute without errors on my side. 2. Python notebook runs end-to-end via a single “Run All” and outputs the final dataset. - Engineer features such as Recency, Frequency, and Monetary value. - Train baseline and advanced models (Logistic Regression, Random Forest, Gradient Boosting). - Perform hyperparameter tuning and evaluate using Accuracy, Precision, Recall, F1, and ROC-AUC. - Interpret model outputs and identify top churn predictors. 3. Power BI file shows no broken visuals and refreshes from the SQL views. 4. A brief Markdown hand-off note summarises assumptions, column definitions, and refresh steps. If everything clicks, I have a queue of similar analytics mini-projects lined up, so this could be the start of an ongoing collaboration. 1. Jupyter Notebook (Single Or Phase-wise) File(s): • [login to view URL], [login to view URL], [login to view URL], [login to view URL] Must include: • Clean, commented code • Plots + metrics • Short insights written in Markdown 2. Power BI Dashboard File: [login to view URL] Should show: • KPIs • Customer Segments • Churn insights • Forecast trends • Any other interesting insights you want to highlight 3. Exported CSV Outputs (for Power BI) Folder: data_visualization/Includes (only the essentials): • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] 4. Final Report (Short Business Summary)
ID do Projeto: 40155589
13 propostas
Projeto remoto
Ativo há 2 meses
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

As someone deeply invested in making your data work for you, my name is Vishruth and I'm a seasoned software developer with over 8 years of experience under my belt. Data Analysis, Data Visualization, MySQL, Python, and SQL are some of my core strengths that align extraordinarily well with the scope of your project. Notably, I take great pride in my ability to automate intricate processes which extends to creating sophisticated yet user-friendly interactive dashboards on Power BI. The clean and concise Python notebook documenting every transformation allows you to recreate and understand the process in the future. My data engineering expertise is bolstered by my proficiency in SQL which ensures seamless scripting from start to finish. Moreover, while handling your retail analytics project I'll utilize machine learning techniques such as Logistic Regression, Random Forest, Gradient Boosting accurately to identify top churn predictors using relevant performance metrics like Accuracy, Precision, Recall. Outperforming these measures would give us insightful information to predict customer behavior and explore retail trends. Why choose me? Simply put - I turn ideas into code effectively, efficiently, and ahead of schedule. Let's get started on this important project together and open up new horizons for potential future collaboration!
₹11.000 INR em 2 dias
6,3
6,3
13 freelancers estão ofertando em média ₹9.192 INR for esse trabalho

As a seasoned developer with an extensive background in crafting dynamic web and app solutions, I am confident in my ability to handle all phases of your Retail Analytics Project. With the proficiency I've gained over 8 years, I can comfortably clean and model your data using SQL, perform advanced calculations and feature engineering using Python, train various models for churn prediction as stated, and present these insights using Power BI. In addition to a successful completion of your assignment within your provided time frame, you can expect me to produce quality work that aligns with your specified acceptance criteria. I have a meticulous approach to coding, ensuring that my Python notebook not only executes flawlessly but also documents every transformation accurately. With strong proficiency in MySQL and SQL, you can be confident that all my scripts will run smoothly on your end. Moreover, I understand the value of collaboration and long-term relationships. Hence, if everything goes well with this project, I can assure you of high-quality performance on ongoing analytics mini-projects. In summary, my expertise, technical skills in areas including Python, SQL, MySQL and Power BI coupled with a proven record of delivering timely results make me the ideal candidate for your project. Let's get started
₹7.950 INR em 7 dias
4,2
4,2

Hi, I am confident about delivering your retail analytics project within the 3 to 4 days you mentioned. With a strong background in SQL, Python, and Power BI, I will ensure that the data is cleaned and modeled correctly, followed by building a detailed Jupyter Notebook documenting every step. My experience with advanced modeling techniques ensures insightful predictions and analyses. Additionally, I will deliver a polished Power BI dashboard with all necessary features, ensuring smooth execution without errors. Best regards,
₹8.745 INR em 1 dia
4,1
4,1

As an esteemed data analyst with significant experience in both SQL and Python, I am deeply experienced in preparing raw, transactional data for a range of sophisticated analyses and creating polished, informative dashboards. My proficiency in these two languages is crucial in ensuring all of your project's needs are met: delectably clean SQL scripts, a succinct and well-documented Python notebook, plus an informative Power BI dashboard that extracts data from the relevant SQL views without any hitches. I'm no stranger to developing models that matter; so applying such predictive models as Logistic Regression, Random Forest and Gradient Boosting as well as performing hyperparameter tuning to achieve optimum performance genuinely excites me. Further, once the models are developed, I use various performance metrics to ensure top-notch results such as accuracy, precision, recall, F1 score and ROC-AUC are achieved. I would like to warmly reiterate my commitment to excellent value delivery and timely job execution. Additionally, my smart insights from over 9 years of hands-on experience across different industries including e-commerce and CMS particularly equips me for projects within your line of work. Olympusat0019 is committed to actualizing your ingenious ideas – let's get started on this analysis project without delay; other equally captivating ones lie in wait!
₹15.000 INR em 7 dias
3,8
3,8

Hello there, I am excited about the opportunity to work on your time-sensitive retail analytics assignment that requires data wrangling in SQL, advanced calculations in Python, and building an interactive Power BI dashboard. I am confident in my ability to clean and model the data effectively, document all transformations in a Python notebook, and deliver a visually appealing Power BI report with necessary functionalities. I look forward to collaborating with you on this project and exceeding your expectations. Please refer to the attachments for the final task and dataset. Regards, anilptk
₹8.770 INR em 4 dias
3,2
3,2

Hi, I am Sean, an AI & Full-Stack Developer with over 5 years of experience specializing in analytics and business intelligence (Python, SQL, Power BI). I have successfully delivered multiple analytics projects that refined data for actionable insights. With my strong background in SQL and Python for data processing and feature engineering, I can do this project perfectly. I will ensure your datasets are clean, well-documented, and ready for analysis, effectively utilizing Power BI to visualize the insights and drive key business decisions. I typically deliver this scope in 4 days, including comprehensive documentation and interactive dashboards that meet your criteria. My coding follows clean practices, ensuring tests and evaluations are securely managed, providing transparency and reliability to your analytics outputs. Are there specific KPIs or metrics you'd like highlighted in the Power BI dashboard? Thanks,
₹10.900 INR em 4 dias
1,4
1,4

Hi, I’ve delivered intuitively similar retail analytics assignments where raw transaction data had to be cleaned fast, modeled rigorously, and turned into decision-ready dashboards under tight academic or business deadlines. I’m confident with this project because I regularly work across SQL, Python, and Power BI in one clean pipeline, making sure each layer feeds the next without friction or rework. I’m comfortable producing error-free SQL scripts, a fully reproducible Jupyter workflow with clear feature engineering (including RFM), and well-evaluated models with interpretable results rather than just scores. I also enjoy polishing Power BI reports with strong KPIs, drill-downs, and slicers so the insights are immediately obvious to a non-technical reviewer. The structured deliverables you listed—phase-wise notebooks, curated CSVs, and a short business-facing report—fit very naturally with how I document and hand off work. Given the 3–4 day window, I can work efficiently and transparently, and if this clicks, I’d be happy to treat this as the first of many similar analytics projects together.
₹5.000 INR em 1 dia
0,0
0,0

As an interdisciplinarian with a diverse skill set, I'm confident in being your best choice for this retail analytics project. My extensive experience in Full-Stack Engineering and Data Analysis stretches over 10 years, equipping me with the ability to handle the complex tasks you've outlined. Having used SQL and Python extensively (including Pandas, Numpy, Scikit-Learn), I'll deftly clean and model your data for SQL queries, conduct advanced calculations in Python, implement FMCG specific features (Recency, Frequency, Monetary value), train baseline and advanced models to identify churn factors, and create refreshing Power BI dashboards. Over the years, my expertise has grown from building production-ready software solutions to integrating AI/ML into intelligent systems like the one we're discussing here. Employing these very skills, I can ensure that my Python notebook executes flawlessly and produces outputs essential for your Power BI workflow. I understand the significance that models hold in retail analytics and guarantee that my work will not only include model training but also hyperparameter tuning and substantial evaluation of accuracy, precision, recall, F1 score, and ROC-AUC to bring forth valuable insights. What truly sets me apart is my ability to go beyond technical requirements when delivering projects. I complement my work with detailed documentation (as demanded) and ensure a smooth transition of the final product with a thorough Markdown hand-off note summarizing assumptions, column definitions, and refresh steps. I have no doubts about meeting every acceptance criterion stated. Let's make this retail analytics project impactful together, which could open vistas of collaboration for future mini-projects on similar lines. My commitment to stability,sicherheitnergizes productivity - Vorsprung durch Technik!
₹7.000 INR em 5 dias
0,0
0,0

Dear Client, Good morning . How are you? I hope this proposal finds you well. I'M A CERTIFIED & EXPERIENCED EXPERT This is to inform you that I have KEENLY gone through your project description, CLEARLY understood all the project requirements as instructed in your project proposal and this is to let you know that I will perfectly deliver as desired. Being in possession of all stated required skills, (MySQL, Python, Power BI, Data Modeling, Business Intelligence, Data Visualization, Data Analysis, SQL, Analytics and Statistics), as this is my field of professional specialization having completed all certifications and developed adequate experience in the respective field, I hereby humbly request you to consider my bid for professional, quality and affordable services that meet all your requirements. I always guarantee timely delivery and unlimited revisions where necessary hence you are assured of utmost satisfaction when working with me. Please send me a message so that we can discuss more and seal the project. THANK-YOU & WELCOME.
₹10.900 INR em 1 dia
0,0
0,0

Hi, I hope you are doing well. Very happy to bid your on project because my skills are fitted in your project. I have strong experience delivering end-to-end retail/customer analytics pipelines using SQL + Python (RFM/feature engineering, churn modeling with LR/RF/GB, tuning, ROC-AUC/F1) and building polished, refresh-safe Power BI dashboards. I will first clean, validate, and model your raw transaction data in SQL (views/tables that run error-free), then produce a fully reproducible Jupyter notebook that runs “Run All” to generate the final Power BI-ready datasets (model_input, cluster_summary, forecast_results, association_rules) with clear Markdown insights and metrics/plots. I will build a professional Power BI report (KPIs, slicers, drill-downs, customer segments, churn drivers, and trend/forecast pages) connected directly to the SQL views, and finish with a short Markdown hand-off note covering assumptions, column definitions, and refresh steps. If you send the message , we can discuss the project more. Thanks.
₹5.000 INR em 3 dias
0,0
0,0

Hi there, I’ve reviewed Retail Analytics Project-2 and I’m confident I can deliver a clean, repeatable workflow within 3–4 days. I bring 6+ years in retail BI: turning raw transactions into query-ready data, robust Python feature engineering (Recency, Frequency, Monetary), and polished Power BI dashboards with slicers, drill-downs, and KPI cards. Plan: - Phase 1: SQL data wrangling and views to ensure clean, reusable data. - Phase 2: Python notebook with documented transformations; engineer RFM features; train/baseline and advanced models; hyperparameter tuning; report metrics (Accuracy, Precision, Recall, F1, ROC-AUC). - Phase 3: Power BI report connected to SQL views; include KPIs, segments, churn insights, and forecasts; deliver required CSV exports and a Markdown hand-off. Deliverables align with acceptance criteria; I’ll share a kickoff plan within 24 hours and set clear milestones for fast feedback. Would you prefer the project delivered in a single notebook run or as phase-wise deliverables with checkpoints, and are there any domain-specific churn predictors you want included? Talk soon, Best regards,
₹10.900 INR em 6 dias
0,0
0,0

Petaling Jaya, Malaysia
Método de pagamento verificado
Membro desde fev. 12, 2024
$30-150 USD
₹12500-37500 INR
₹600-1500 INR
₹600-5000 INR
₹750-1250 INR / hora
€12-18 EUR / hora
₹600-1500 INR
$100 NZD
€8-30 EUR
£20-250 GBP
$2-8 USD / hora
$2-8 USD / hora
$200-400 NZD
₹750-1250 INR / hora
₹12500-37500 INR
₹12500-37500 INR
€250-750 EUR
₹600-1500 INR
₹12500-37500 INR
$15-25 USD / hora
₹12500-37500 INR
₹600-1500 INR