Find Jobs
Hire Freelancers

PowerQuery - Dynamic Filtering

€8-30 EUR

Cancelado
Publicado há aproximadamente 1 ano

€8-30 EUR

Pago na entrega
I am seeking a skilled professional with expertise in PowerBI, PowerQuery, and SQL to complete a project for me. Please carefully review the project documentation before applying. Candidates who do not demonstrate a thorough understanding of the project requirements or fail to provide adequate project steps/functions in their application will not be considered. If you do not possess the necessary experience with PowerBI, Excel, PowerQuery, and SQL, please refrain from applying for this position. The end result of the project will be a functional PowerQuery pbix file, and payment will be made upon successful implementation and testing on our side. I am looking for a PowerQuery expert who can assist me with dynamic filtering of an Excel Workbook. The ideal candidate should have experience with data transformation, as the project requires cleaning of the data. The data source for the PowerQuery will be an Excel Workbook. The specific criteria for the dynamic filtering include Date Ranges. The expert should be able to effectively filter the data based on the given criteria. Please only apply if you have relevant experience and skills in PowerQuery and data transformation. Our budget is 40Eur. There is a dynamic filter in Code_management sheet where we can ADD or REMOVE row which will affect count of rows in TLR. Using Code_management we filter out the ROWS from TLR sheet. In [login to view URL] are 2 sheets: Sheet Code_management is group of filters that needs to be applied: -if Code To is not NULL then means RANGE Code -> Code To -if Code To = NULL then it is not RANGE but 1 value only = Code -FC example: Include ALL ROWS where FC except: 1010E, 4143, 3057 -GL example: Include ONLY ROWS where GL in RANGE 30000->99999 AND ROWS where GL = 23400 -PC example: Include ONLY ROWS where PC = 0 -AF example: Include ONLY ROWS where AF in RANGE (one of 26 RANGES) Sheet TLR: col A -> D: Values you need to filter by col J -> M: Evaluation of every column filter 1=INCLUDE, 0=EXCLUDE col N: FINAL EVALUATION = means if any of col J->M = 0 then 0, else 1
ID do Projeto: 36541119

Sobre o projeto

8 propostas
Projeto remoto
Ativo há 1 ano

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

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
Concedido a:
Avatar do Usuário
Hi There, Good evening! I have gone through your requirement. Please ping to discuss more on the project. Below is my intro - "First use then believe". I don't want to mention much here but I have 6+ years of extensive experience in Power BI along with Power Apps, Power Automate, Python & AWS with total 8+ years of IT experience. I am not intelligent, but I try to complete the work ASAP as I don't believe in deadline. I don't believe in saying rather my work speaks. It's our first collaboration that's why I have to describe my proposal or else I prefer not to as it won't be needed next time. ✅ You can go through my profile to see my past works in Freelancer site ==> https://www.freelancer.com/u/Akmanyu
€50 EUR em 1 dia
5,0 (52 avaliações)
5,3
5,3
8 freelancers estão ofertando em média €32 EUR for esse trabalho
Avatar do Usuário
Hello, I am a skilled professional with expertise in PowerBI, PowerQuery, and SQL. I have carefully reviewed the project documentation and I am confident that I can complete the project to your satisfaction. I have extensive experience with data transformation and cleaning, and I am confident that I can effectively filter the data based on the given criteria. I am also familiar with Excel workbooks and can provide you with a functional PowerQuery pbix file upon successful implementation and testing. I understand that your budget for this project is 40Eur, and I am willing to work within your budget. If you have any questions or would like to discuss the project further, please do not hesitate to contact me. Thank you for considering my proposal. Regards, Zafar
€40 EUR em 1 dia
5,0 (6 avaliações)
2,6
2,6
Avatar do Usuário
Hello, I am professional freelancer with a Master's degree in Data analytics making me a suitable person for your project. I have more than 8 years of professional experience in Data analysis. Besides, I have skills in Microsoft PowerBI, Data Processing, Excel and SQL. For your reference, you can check reviews\ portifolio for all the projects I handled so far. Hope to connect with you on personal chat. Regards, Eyan
€45 EUR em 2 dias
5,0 (2 avaliações)
2,3
2,3
Avatar do Usuário
Hi, I checked your requirement, i have Experience in below technical work. Power Bi Desktop & Services With DAX, Power Editor, Excel VBA, Power Query, Power Pivot, Advance Excel, Excel Dashboard dynamically with VBA Codes. Knowledge About Json file, SQL, MS Access with VBA etc. For More Details Check my Portfolio's Sample Work. With Best Regards, Data Analyst/Power bi Specilist Thank you for considering me. I look forward to hearing from you soon.
€40 EUR em 2 dias
5,0 (1 avaliação)
2,3
2,3
Avatar do Usuário
Hi there! As a data entry operator, I specialize in accurately inputting large amounts of data into various computer systems. With my experience in the field, I am confident in my ability to quickly and efficiently enter information into spreadsheets, databases, and other programs. In addition to my strong typing and data entry skills, I am also highly detail-oriented and have a keen eye for errors or inconsistencies in data. I take pride in ensuring that the information I enter is accurate and complete, which helps to avoid any potential issues down the line. As a freelance data entry operator, I am able to work on a flexible schedule and can adapt to different project requirements as needed. Whether you need help entering data into a new system or are looking to clean up and organize existing data, I am here to help. I have experience working with a variety of industries and types of data, including customer information, financial records, and inventory lists. Whatever your needs may be, I am confident in my ability to deliver high-quality work in a timely and efficient manner. If you're looking for a reliable and skilled data entry operator for your next project, please don't hesitate to get in touch!
€15 EUR em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Greetings Dear Client. Welcome to my profile, Home to Professional and Quality services with 100% customer satisfaction guarantee. I'm a Certified & Experienced Expert in the respective project requirements. Dear Client, I take this opportunity to inform you that i have KEENLY gone through all your project requirements as given in your project description and I confirm to you that i can perfectly deliver as instructed. Being in possession of all CLEARLY STATED required project skills (SQL, Microsoft PowerBI, Excel and Data Processing) as this is my area of professional specialisation having completed all Certifications and developed adequate experience in the same area, I hereby humbly request you to consider my bid for Professional, Quality and Affordable services always. STRICT TIMELY DELIVERY & UNLIMITED REVISIONS. Kindly Message Me We Discuss More About The Project and seal the contract. Welcome and Thank-you.
€30 EUR em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have 11+ years Experienced and dedicated Data Analyst with several years of experience identifying efficiencies and problem areas within data streams while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams, including Access, SQL, and Excel data sources. Ability to synthesize quantitative information and interact effectively with colleagues and clients. Proven track record of generating summary documents for senior management for monthly and quarterly audit and compliance reporting.
€19 EUR em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I should be hired for this role because of my relevant skills and passion for the industry. My positive attitude, work ethics, and long-term goals align with the job requirements, making me a committed and valuable intern for the project.
€19 EUR em 7 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) SLOVAKIA
Kosice, Slovakia
5,0
13
Método de pagamento verificado
Membro desde jan. 14, 2013

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.