Power query and power pivot excel dashboards jobs

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

...database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability a...

I need a...-replacement of a double front door with glass block sidelights to a single pivot door with larger glass sidelights with new header to carry load of second floor above. Window and door manufacturer to supply engineering specs to engineer -removal of upstairs fireplace and replace with wall and new opening to primary bath (non-load bearing) -re-framing of shower wall to accomodate bench (non-load bearing) -additional items to be discussed. I have already met with the city and they are satisfied with my electrical and plumbing drawings that will be stamped by an electrical contractor and a plumbing contractor to be included in my submission. I would like to work with a structural engineer who can work with me on my submission a...

...talented graphic designer to create a captivating book cover for my dystopian political satire novel. The design should resonate the genre's essence, laced with a streak of dark humor. The EMBRACE novels explore various "viruses," both literal and figurative, that plague society: Key Requirements: - Experienced in book cover design, preferably in political satire and dystopian genre. - Skilled in graphic design software, especially Photoshop and Illustrator. - Must be able to work swiftly, as the project completion is needed ASAP. - Creativity and the ability to weave subtle humor into the design is paramount. - This will be a minimum of a 3-book series, so factor that in the design. - Main character is Noah Philter: A Dictator in W...

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I s...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...of visitors, page load time, conversion rate, bounce rate, and traffic sources from search engines and other platforms. - Insightful monthly reports: I'd like to receive these reports on a monthly basis. The primary goal of my website is to generate leads. I'm keen on understanding how various aspects of my website are contributing to this goal. Ideal skills for this project include: - Proficiency with Matomo and similar analytics tools - Experience in setting up and interpreting website performance dashboards - Ability to analyze data and provide actionable insights - Strong communication skills, especially in translating data into reports that are easy to understand. If you have what it takes to help me set up a robust and...

I'm in need of a qualified Electrical Engineer, specifically with a PE license to assist with the design of a 20-unit ap...multi-dwelling residential projects. Project requirements include: - Lighting: Design needs to incorporate energy-efficient lighting, dimmable lighting options, and outdoor lighting. - Power outlets: Accurate estimation of the number of outlets per room, inclusion of USB outlets, and GFCI outlets in the design - HVAC System Wiring: Appropriate designs for efficient air conditioning and heating across all units. The project involves 3-4 typical units' designs - each featuring a kitchen, dining area, toilet and 2 bedrooms with bathrooms. Your knowledge of local and state electrical code regulations is essential, ensur...

I'm looking for an experienced fr...Sisense. Requirements: - Creation of specific widgets: Charts, Tables - Charts: Line charts, Bar charts, Pie charts - Tables: Data tables, Summary tables, Pivot tables These widgets will a show the following: - Top ten Selling Items (# units sold and $) - Upsells (# units sold and % of overall sales) - Modifiers (# units sold and % of overall sales) - Daily specials ($ sold and % of overall sales) The ideal candidate should have: - Proven experience in developing widgets for Sisense - Proficiency in creating various types of charts - Strong understanding of data table structures - Ability to design and implement effective summary and pivot tables I'm looking for a committed freela...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

Creating a comprehensive dashboard for our POS (Point of Sale) system involves several key components and technologies. Here’s a detailed outline of the project requirements and the ideal skills needed to build the solution: Project Overview The goal is to develop a dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with ...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and ...

I am looking for a creative and professional logo designer who can create a logo that will evoke trust, event planning, excellency, ease, power, and simplicity. The colors are up to you, but I would like the design to integrate elements that symbolize a sun, the "E" ampersand, and a symbol of excellence such as a grade. Key requirements are: - Ability to create a logo that evokes specific emotions and feelings - Understanding of the event planning industry - Proficient in symbol integration within logo design - Prior experience with corporate branding is a plus In order to be considered, we provided our Home Page With the a DUMMY LOGO placeholder. We will decide based on the proposed logo that makes this Home Page looks best so you must submi...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can crea...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of da...

...of a seasoned and results-oriented freelance Project Manager. In this role, you'll be the cornerstone of our client engagement process, responsible for leveraging your extensive experience in marketing projects to manage and assist in sales improvement. Key Responsibilities: - Attend Zoom calls with clients to meticulously understand their needs and requirements. - Act as a pivot in the client engagement process, effectively promoting our services to close deals. - Utilize your expert knowledge and experience in marketing projects to drive sales. Key Requirements: - Previous experience managing marketing projects is essential. - Exceptional communication skills, specifically through Zoom calling. - Proven track record in driving sales and...

I'm in need of a highly skilled AI developer with expertise in natural language pro...developer with expertise in natural language processing (NLP), computer vision (CV), and machine learning. The core objective of the project is to develop an AI-based recommendation system. Key Tasks: - Implement NLP techniques - Develop CV application - Integrate robust machine learning algorithms A significant aspect of this project is UI design – specifically the construction of user-friendly dashboards. I am looking at someone who can visualize the machine learning processes and outputs in an engaging manner. Desirable Skills: - Expertise in AI technologies (NLP, CV, ML) - Experience in building AI-based recommendation systems - Proven ability in creating user-cen...

...experienced professional in Power Factory and Electronics. The project will involve a mix of tasks such as circuit design, power system analysis, PCB layout design, as well as potentially designing a circuit, simulating power systems, and developing control systems. Ideal Skills and Expertise: - Proficiency in Power Factory and Electronics - Prior experience in circuit design, power system analysis, and PCB layout design - Capability to undertake tasks related to designing circuits, simulating power systems, and developing control systems. - Strong problem-solving ability The task involves working on a project where knowledge and expertise in Power Factory and Electronics is cruci...

...improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use &ldquo...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on...

I am in need of a logo for my business, Warfighter Technology Services. It is essential that the logo conveys a theme of Strength and Power, while utilizing a color scheme that aligns with military aesthetics. Key Points: - Business Name: Warfighter Technology Services - Theme: Strength and Power - Color Palette: Military Colors Ideal Skills: - Experience in designing logos with a focus on conveying specific themes - Proficiency in creating visually appealing designs using military colors - Understanding of the needs and aesthetic preferences of the technology services industry If you are confident in your ability to create a logo that embodies these requirements, I would be interested in discussing this project with you.

I am see...data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to ...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

...be a combination of a Zigzag indicator and a Pivot indicator, which can be tailored based on my specific requirements and trading rules. Key Features: - Custom Zigzag Indicator: The indicator should be able to identify the various price swings in the forex market in a zigzag pattern. - Pivot Indicator: It should also be able to calculate and mark pivot points based on the price action. - Customizable: The indicator should be flexible and adjustable to my specific trading strategies and preferences. - User-Friendly: It should be easy to use and understand for a trader, with clear visual markers and alerts. Skills and Experience: - Proficient in TradingView's Pine Script language. - Strong understanding of...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application will be developed for the verification and testing process...

Please Sign Up or Login to see details.

I'm seeking an electrical engineer skilled in circuit design for consumer electronics. I want to design the schematic for a buck converter based on the Integrated circuit i chosed.

...experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems. T...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

I am looking for an experienced electrical engineer who can perform a load flow analysis using Power Factory with moderate accuracy. Key Responsibilities: - Conduct a comprehensive load flow analysis of the electrical system specified. - Ensure moderate accuracy in the results obtained. - Provide detailed documentation of the analysis and results. Ideal Candidate: - Skilled and experienced in using Power Factory for load flow analysis. - Able to deliver accurate results while working independently. - Strong written communication skills for documentation.

...efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access...

...some thorough editing: • The first task needs precision and attention to detail, as it requires the elimination of obstructive elements in the photo. More specifically, I need the power lines and parking signs removed to highlight the mural. • Secondly, there are missing portions of the sign text that I would like restored. The complete text should read as: [Sharkey Issaquena Medical Clinic]. Freelancers must have excellent photo manipulation skills to integrate the missing text smoothly and convincingly. • Lastly, the picture lacks vibrancy, I want the colors and saturation adjusted for a more eye-catching and dynamic result. Expertise in Adobe Photoshop or similar graphic design software is a must, as well as an eye for deta...

I have an existing Arduino and BBC Micro:bit devices and I'm seeking a skilled freelancer to help me connect them for a home automation project. Key Responsibilities: - Implement a system that can control lighting, monitor temperature and provide security surveillance - Ensure the system can be powered using solar, wind, battery and be connected to the internet. The ideal candidate should have experience in: - Arduino and BBC Micro:bit programming - Home Automation projects - Solar and wind energy integration - Internet of Things (IoT) connectivity - Strong understanding of security surveillance systems Your role will involve setting up a reliable, efficient and user-friendly home automation system. The ability to integrate multiple...

...in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on the specific skills that need to be applied to solve them. - Proficiency in creating detailed digital reports is a must. - You will be required to understand the purpose of the task - to analyze what skills students need to pass these exams. Ideal Candidate: - Experience in educational administration or education itself would be an advantage. - Strong analytical skills and...

...basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss further enhancements and upd...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowl...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm in need of a highly skilled AI developer with expertise in natural language pro...developer with expertise in natural language processing (NLP), computer vision (CV), and machine learning. The core objective of the project is to develop an AI-based recommendation system. Key Tasks: - Implement NLP techniques - Develop CV application - Integrate robust machine learning algorithms A significant aspect of this project is UI design – specifically the construction of user-friendly dashboards. I am looking at someone who can visualize the machine learning processes and outputs in an engaging manner. Desirable Skills: - Expertise in AI technologies (NLP, CV, ML) - Experience in building AI-based recommendation systems - Proven ability in creating user-cen...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

many lesson slides similar to power point created for spelling and reading

...pertinent to my business. This may include sales data, user activity, and website traffic. - **User Management**: While not explicitly stated, I understand the importance of user management in an admin dashboard. Therefore, building a system that allows for user management is a crucial part of this project. - **Role-based Access Control**: I want the dashboard to have role-based access control. This means that users will have different levels of access based on their roles within the organization. Your responsibilities will include the following: - **Data Retrieval and Manipulation**: You will be tasked with retrieving data from a database and manipulating it to be displayed in a meaningful way. - **User Authentication and Authorization**: A key part of thi...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to ...

...assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more intermediate or even advanced functions. Your ability to adapt to vary...