
In Progress
Posted
Paid on delivery
I'm seeking a skilled professional with expertise in Python, SQLite, and SQL databases. The primary task will be setting up a system for daily extraction of inventory data, which will ultimately be visualized in Power BI. Key Requirements: - Establishing a database connection using Python - Extracting inventory data on a daily basis - Ensuring seamless integration with Power BI for future data manipulation and visualization - Include data transformation steps to ensure the data is in the correct format for Power BI ingestion. - Implement data validation rules to ensure the accuracy and consistency of the extracted data. Ideal Skills: - Proficient in Python, SQLite, SQL - Experience with Power BI - Previous work in data extraction Please note, this project focuses on data extraction only. The goal is to have a reliable system in place that can automatically pull this data each day. The inventory data will be sourced from an internal database.
Project ID: 38875439
11 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

I am a skilled Python programmer with extensive experience in SQL databases, including SQLite, and data automation workflows. I specialize in creating robust data pipelines, and I can build a reliable system for daily extraction of inventory data as per your requirements. Here's how I plan to approach your project: Database Connection: I will establish a seamless and secure connection to your internal database using Python. Daily Data Extraction: I will implement an automated script to extract inventory data daily, ensuring reliable and consistent performance. Data Transformation: The data will be transformed into a Power BI-compatible format, following your specified requirements. Data Validation: I will include rules to validate and clean the data, ensuring accuracy and consistency before ingestion. Documentation: Provide detailed documentation for the setup, configuration, and usage of the system. My Strengths: Expertise in Python for database automation and SQLite/SQL for query handling. Familiarity with Power BI and preparing data for visualization. Proven track record in building automated data pipelines. I am confident I can deliver a scalable and maintainable solution tailored to your needs. Looking forward to collaborating with you to optimize your inventory data workflow!
$20 AUD in 7 days
0.0
0.0
11 freelancers are bidding on average $30 AUD for this job

Hello. I read your requirement and also check attachment image i will do that. Please come on chat we will discuss more about this. I will waiting your reply
$30 AUD in 1 day
5.9
5.9

⭐ Hi, My availability is immediate. I read your project post on Python Developer with expertise in Python, SQLite, and SQL databases. We are experienced full-stack Python developers with skill sets in - Python, Django, Flask, FastAPI, Jupyter Notebook, Selenium, Data Visualization, ETL - React, JavaScript, jQuery, TypeScript, NextJS, React Native - NodeJS, ExpressJS - Web App Development, Data Science, Web/API Scrapping - API Development, Authentication, Authorization - SQLAlchemy, PostegresDB, MySQL, SQLite, SQLServer, Datasets - Web hosting, Docker, Azure, AWS, GPC, Digital Ocean, GoDaddy, Web Hosting - Python Libraries: NumPy, pandas, scikit-learn, tensorflow, etc. Please send a message So we can quickly discuss your project and proceed further. I am looking forward to hearing from you. Thanks
$89 AUD in 1 day
4.3
4.3

Hi there, I offer a 20% discount on my services and bring 3 years of experience in Full Stack Development. "I can assist in extracting data from Python, SQLite, and SQL databases for seamless integration with Power BI. My approach will include writing efficient scripts to query, process, and format data for Power BI visualization. I’ll ensure the data extraction process is automated, secure, and optimized for performance to handle large datasets while maintaining data integrity." Let’s discuss your specific requirements so we can make this adjustment efficiently. I look forward to collaborating with you! Best regards, Ahsan Habib
$20 AUD in 5 days
3.9
3.9

Dedicated Freelancer Ready to Elevate Your Project for Python, SQLite, and SQL databases Data Extraction for Power BI. I have a solid background in Python, Power BI, SQL, SQLite and Database Programming, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
$10 AUD in 1 day
3.0
3.0

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 AUD in 1 day
3.2
3.2

I propose creating a Python-based system for daily inventory data extraction from SQLite/SQL databases, ensuring seamless Power BI integration through data transformation, validation, and automation, focusing on accurate and consistent data flow.
$20 AUD in 7 days
0.0
0.0

Hhi I am experienced in this and I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy ! r
$20 AUD in 7 days
0.0
0.0

I have over 6 years of experience in web scraping and data extraction, I have successfully delivered similar projects requiring precise data gathering and robust solutions. I have experience in tools like Selenium, Beautiful Soup, and Scrapy. I can organize and prepare data for use in Power BI dashboards. Please feel free to reach out if you have any questions. Looking forward to collaborating with you on this project!
$20 AUD in 7 days
2.4
2.4

Solution to your project based on my expertise: - Establish a Python-based connection to the internal SQLite database for daily data extraction. - Automate the data extraction process and ensure that the data is properly formatted for Power BI. - Implement data validation rules to ensure accuracy and consistency of the extracted inventory data. - Set up integration with Power BI for seamless data visualization. Hi, Junaid here, Software Engineer, I can help you with this project. From your requirements, I can see you're looking for an automated system to extract and validate inventory data daily for future use in Power BI. I have a few questions to get more clarity: 1. Do you have any specific format or structure for the data required in Power BI? 2. Should I set up any error logging or notifications for failed data extraction? 3. Are there any particular validation rules that should be applied to the data before extraction? Let's have a quick chat or call to discuss things in detail.
$30 AUD in 1 day
0.0
0.0

Dinajpur, Bangladesh
Member since Oct 20, 2024
$10-30 CAD
$10-30 CAD
$10-30 CAD
$10-30 AUD
$10-30 CAD
₹1500-12500 INR
$250-750 USD
$10-30 USD
₹750-1250 INR / hour
₹600-1500 INR
$2-8 USD / hour
$10-30 USD
£3000-5000 GBP
$10-30 USD
$30-250 USD
₹400-750 INR / hour
₹1500-12500 INR
$250-750 USD
$250-750 USD
₹1500-12500 INR
₹12500-37500 INR
₹12500-37500 INR
$30-250 USD
₹12500-37500 INR
₹600-1500 INR