Power query and power pivot excel dashboardsdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

...of dropdown menus. - Charts should be easy to understand and navigate. Ideal Skills and Experience: - Proficiency in Tableau: The ideal candidate should have a strong background in creating Tableau dashboards with complex data sets and interactive elements. - Data Visualization: A good understanding of how to present data in a visually appealing way is crucial. The ability to communicate complex data effectively is a plus. - User Experience (UX) Design: A good understanding of how the end user will interact with the dashboard is key. The freelancer should be able to design a user-friendly interface that enhances data exploration and understanding. This project is a great opportunity for someone who is skilled at data visualization and dashboa...

...admin dashboard for a Flutter app backed by Firebase. The dashboard should have a clean, minimalist design and robust functionality to manage the platform. Core Features: - Firebase Integration - Comprehensive Data Visualization - Content Management (Articles, Quizzes, Categories) - Feedback Management - Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing admin dashboards - Expertise in Flutter, Firebase, PHP - Strong design sense for c...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around a circuit using the least amount of power in a given time, by calculating the forces acting on the vehicle at any point. The forces have been identified to be: Drag, Rolling resistance, Incline, Wind & Motor thrust. Rolling resistance, wind (set to 0 in data should ...

I'm in need of a skilled circuit board designer that can create the and design the Greber file for me, I need to send the files to the manufacturing compony. My project contains few components only. SAM D11C 14-pin chip, 3 LEDS, Battery holder, and a reset switch. The "j2" pads are for programming the chip, Gnd, power, and clock. The 2 antennas traces are connected to analog pins A2 and A4. LEDs are connected to digital pins 24,25,31. the reset button to RST pin of course. For the 4 programming pads. Gnd and Power goes to Gnd and VDD pins in the chip, For the clock, I'm not shire which pins. layout size : 10 cm by 5.398 cm

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking for someone to integrate an existing machine learning model into a Di...cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient ...

...automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics to...

I'm in need of a skilled web developer to set up a secured tutoring scientific website. This platform will facilitate online classes, between Students, Instructors and Schools (the field of study will be discussed personally) Student Privileges Student, Instructor and School Registration phase. Where they can setup their accounts and generate their Profile Cards. There are two categories of Student Accounts (School Registered or Free) New Session page: where the student can select Subject & Topic, and mention questions if required. Then, Instructor Selection Phase: An interface to let students select a suitable instructor, for their subjects based on the instructor's predetermined disciplines, then select date/time according to Instructor's ...

Beginner level freealancer to create an mcq list for moodle quiz website...the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example ...

...interactive dashboards and geospatial maps. Though the data is of moderate size and complexity, it's essential that the visualizations are effective and easy to understand. The ideal candidate will be responsible for designing, developing interactive dashboards and reports using Apache Superset. You will work closely with data analysts, data engineers, and business stakeholders to understand data requirements and translate them into visually compelling and actionable insights. Key Requirements: - Proficient in working with MSSQL databases - Solid experience with Apache Superset - Proven track record in crafting effective data visualizations - Familiarity with creating various types of visual representations including ...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...bandwidth /frequencies restricted to less then 1000 hz by hardware RC anti aliasing filter to avoid aliasing 3. Following Digital in sequence to be applied to raw signal . a. low pass filter 0-170 hzs ( to remove high frequency random / white noise b. High pass filter 1 hz to 400 hz (to remove low frequency dur DC signal coupling ) c. Very steep(narrow band) notch filter at 50 hz / 60 hz to remove power line interference a & b can be combined as band pass filter if possible also a , b & c can also be combines a single filter algorithm to obtain desired frequency response frequency response of all three signal enclosed 4. A 32 bit ARM processor of - 100 mhz / 186( mhz both option aval) with FPU & DSP instruction set will be used . b. processor progra...

...monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate for non-technical users. It is essential that this application runs efficiently on a Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL ...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong atte...

Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.

I'm looking to sell a residential solar photovoltaic (PV) system that stands out for its energy storage capabilities and off-grid independence. The estimated space for installation is a medium-sized residence (1,000 - 2,000 sq ft). Ideal skills include: - Expertise in solar panel design and installation - Knowledge of battery energy storage systems - Understanding of off-grid solar systems - Experience with residential projects - Ability to estimate solar power needs based on space size Offer your skills to make this solar PV system stand out in the residential market.

...involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for us...

I am looking for a professional developer to create a comprehensive and user-friendly dashboard for tracking my crypto investments. This won't be a public app. It's for my personal use only. I will provide the front-end elements (React) most of the work is for adding functionality and back-end. Key Features (I have API from CoinStats for these): - Real-time Price Updates: The dashboard should provide real-time updates on the prices of various cryptocurrencies. - Portfolio Balance Overview: I need to have a clear overview of my overall portfolio balance. - Transaction History Tracking: This feature will allow me to keep track of all my transactions in the crypto market. Additional Pages: - Indicator Tracking: An essential feature that should provide insights into...

...video series, "Productivity Power Hour". The series is all about boosting productivity and efficiency, so I'm looking for a design that effectively represents this theme. Key Points: - Use the slogan Lead Smarter: Rise Above the Grind! - The logo should be minimalist in style - It should be bright and vibrant in color, to grab attention online - The slogan for the series is "Lead Smarter: Rise Above the Grind!" - this can be incorporated creatively into the design The intended use of this logo will be primarily for online purposes such as websites, social media channels, and emails. It needs to be easily recognizable and memorable, even at smaller sizes. Ideal Freelancer: - Graphic designer with experience in minimalist desi...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

I'm on a quest to flatten my company's efficiency curve and reduce the hours we spend on manual tasks. I need a savant familiar with Power Apps to help me achieve this. Skills Required: - Proficient in Power Apps, preferably with experience in teaching others. - Able to develop advanced, customized solutions tailored to my business. - Expertise in leveraging Office 365 integrations within these solutions. - Proficiency in constructing complex, efficient databases. The ideal candidate should have a comprehensive grasp of Power Apps and a passion for education. Seeking to build a one-on-one relationship that will deliver measurable results on the path to automation.

Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.

I am looking for a specialist who can effectively write a RAK 4630 firmware with an emphasis on energy optimization. You should focus on minimizing power consumption when the device is in sleep mode. Key tasks include: - Implement changes in the RAK 4630 firmware to optimize its energy usage. - Concentrate on reducing power consumption when the device is in sleep mode. The ideal freelancer would have: - A comprehensive understanding of the workings of RAK 4630 firmware. - Proven experience in firmware development with a focus on energy optimization. - Familiarity with device sleep modes and their impact on power consumption. Your goal is to maximize efficiency while ensuring uncompromised performance. Please provide evidence of related past projects in ...

...spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the us...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

...adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for refer...

...in Figma and current design trends wanted to work on a web app project. KEY RESPONSIBILITIES: - Design up to 20 standalone desktop screens or 30 mobile screens monthly - Convert sketches and wireframes into finished mockups - Create visually stunning and intuitive interfaces that enhance user experience - Collaborate with the team to brainstorm ideas then turn concepts into user-friendly interfaces - Redesign desktop screens for mobile responsiveness - Proactively provide creative solutions and improvements to existing designs and user flows - Please include the key word 'Lavender' in your bid to indicate you actually read the brief CANDIDATE REQUIREMENTS: The candidate should... - Be creative - Have strong Figma skills for the design ...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independ...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

...routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The final deliverable should be...

I'm in need of a Power BI expert with solid experience in AI integration and advanced dashboard development. The project has multiple facets, including: - Data Cleaning and Transformation: The ideal candidate will have experience in working with large and complex databases. You should be able to clean and transform the data efficiently for integration into the dashboard. - Dashboard Design and Development: An eye for design is key. You will be creating a visually appealing and user-friendly dashboard, with the ability to customize as needed. - AI Model Integration: Extensive experience with AI integration is a must. You should be able to develop and integrate advanced AI models within the dashboard effectively. The main source ...

Start your offer with the word in the attachment, otherwise we d...Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 ...

...expertise in both electrical and mechanical engineering. Our aim is to design a high-power attachable biking dynamo/alternator for bicycles. The primary objective of this project is to create a device that can generate and store significant power for storage in high-capacity batteries. This dynamo/alternator should deliver a high power output, mainly focusing on efficiency, ease of use and weight. Key requirements: - Designing a high-power dynamo/alternator that can support extensive power needs. - The device should be attachable to a standard bicycle without impacting its performance or aesthetics. - Prioritizing power output over size or weight, meaning the final product can be robust as needed. Your role will be to: -...

We are looking for a reliable, dedicated and knowledgeable VA on a long term basis. Our company operates within cryptocurrency and finance, making it highly beneficial that the selected VA has a strong understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collabora...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I'm in need of a skillful social media savant with e...a skillful social media savant with extensive experience in managing Facebook and Instagram platforms. The primary aim of this project is to generate leads, thus beneficial conversions for my business. For this role, the perfect fit would be someone who: - Is adept at curating and generating engaging product-promotion posts - Is proficient at managing and encouraging user-generated content - Can align content strategy and posts with our lead generation goal - Has a broad range of experience in increasing visibility and follower engagement - Is knowledgeable in social media analytics to track performance and conversion rates. Ultimately, I hope to leverage the power of social m...

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommo...secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Pro...

...proficient dashboard developer to create a comprehensive and professional stock dashboard that will provide me with updated, real-time data and historical performance of approximately 50 stocks from both US and European markets. This dashboard will serve as my principal tool to track and manage my portfolio. Key Features: - Real-time stock data updates - Historical performance analysis for all stocks - Portfolio tracking for about 50 stocks Visual Design: - The design should be corporate and professional. I'm open to vibrant colors or minimalistic elements in order to easily visualice limit alerts. Ideal Skills: - Experience in both front-end and back-end development - Knowledge in financial markets, specifically NYSE, NASDAQ, and...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including tr...