Oracle BI 11gを使用してダッシュボード作成をしているのですが、初心者のため機能を十分に理解できておらず、効率的に利用できずにおります。 ダッシュボード作成の依頼ではなく、使い方やTipsについて教えて頂きたく存じます。 特に最近のBIツール（TableauやQlik Sense）に見られるような、分かりやすくキレイなUIをOracle BI上で実現するのが目標です。
This is rosemarylaw office, lawyer in Japan. We are searching freelancer of PHP, SSIS, SSRS programer. We are continue to develop CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. and test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program 2005 to 2012 SSIS side is improt form exel to dbo and job lancher is C# based exe. Req Skill C# 2000, SSIS, SQL prototype, ex- version will remained Documets also you need to upgarede customizing and version up job. Becase some field ...
...CS system, MS SQL +SSIS ,SSRS of server side and PHP front with IIS. All MS solution based. We have Server side engineer in house. we have test server with dummy data, you can try from remote. development can do english based with skype, github,mail and so on. We hope to good offshore appications. Thanks now we are searching below project enginner. 1 upgrade SQL server SSIS import program2005 to 2012 SSIS side is improt form CSV to DB, job lancher is C# based. Req Skill C# 2000, SSIS, SQL 2 upgarde SSRS program 2005 to 2012 small customizing upgarde checking. over 100 report should upgarde 3 php with sql add new searching view etc stored exec, view,dbo, will be made by server side so you only made front side. need github and wrike ...
...サービス要件 1. 特定のゲームタイトルに関連する記事を取得すること 2. プログラムの特定の一か所に記述されたゲームタイトルパラメーターを変更するだけで対応したデータが取得できること 3. 海外ゲームタイトルであっても取得可能であること 4. 1日に1回バッチを回した際、以前に取得したことがない記事をリストとして取得できること 5. 記事のタイトル・サムネイル・記事本文の一部を取得すること ■ システム要件 1. PHP + MySQLで構築すること 2. PHP5.3で推奨されていない表現を用いないこと 3. Cronによって動作すること 4. プログラムを動かすサーバー OR dbサーバーに対して必要以上の負荷をかけないこと ■ 納品物については以下の通りとなります 1. プログラム本体の納品（PHP） 2. データの格納先DB-Tableの納品（SQLクエリ） ■ 応募条件 1. 応募時にどのような方法で実現する予定なのかを簡潔に明記してください （Ex. TwitterSerch API と Bing Serch APIを用いて実現します、など） ▽参考Webサイト サイト名：スマートニュース/newspicksなどのバックエンド ▽使用するプログラミング言語/ツール/特殊技術（テクノロジー） ・PHP(5.3） ・MySQL ▽注意点・禁止事項 ※ 他で登録されているデザインや商標の転用など、他社の知的財産権を侵すこと ※ 商用利用できないライセンスのプログラムを用いること ※ ▽その他コメント ※実際のWebサイト開発/アプリケーション開発の進め方・別途詳細は、 クラウドワークスのメッセージでやりとりして決められればと思...
Fix a magento error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction MagentoのSQLをバックアップ後に管理画面にログインしようとすると以下のエラーが表示されてログインできない。 SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction 希望： 問題の解決と原因の究明と説明、今後への対処の説明と実行をお願いします。 緊急です。 重要視する項目：金額、スピード、作業内容及び方法の説明 予想される作業内容：（あくまでも予想です） 未実行クエリの再実行または未実行クエリの削除 innodb_lock_wait_timeoutの値変更 50秒->180秒
1) AutoCAD Programming using LISP 2) Oracle Database 11g/12c 3) Retail Space planning functional experience (nice to have)
現在、弊社ではユーザー直、代理店案件含めまして、受託、常駐案件ともに多数ございます。 PHP、Java、Oracle、C#、Ruby、SAPが中心ですが、事業拡大に伴い現在、パートナーを探しております。 SAP案件、Java、PHP案件、LAMP(Linux、Apache、MySQL、PostgreSQL)案件、VC++、C言語案件、VB、C#.NET、COBOL、Ruby案件、PM(プロジェクトマネージャー)、PL(プロジェクトリーダー)など受託、常駐で開発案件のご協力をして頂ける方の募集で御座います。 制御系・組み込み系から企業の情報システム、基幹システム、業務システム開発、ウェブシステム、サイト構築まで。 現在、ユーザー直の受注案件で具体的な案件内容も提示できますので、宜しければ、一度お会いしてご相談させて頂ければと思っております。
...PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico...
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for...
I require an advanced database to streamline church operations. It must include: - Member management: This involves recording personal details of each member, tracking attendance, and allocating to the right departments. Each member's record should also include household and family details, with specific fields for spouse and children. - Functionalities: Capacity to sort data based on each individual (organize by member). It should also capture other input fields like gender, age, membership status, notes, and whether they serve as workers or ministers. - Financial management: The platform should have capabilities for recording and tracking financial contributions. Ideal freelancers will have experience in building similar database systems, with a keen understanding ...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 3...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. ...
We have a program on C# written on Visual Studio. We want to modify the current program, which read bar codes on a warehouse, for other sections of the company. On this project we will like it to get information from different Oracle tables. Job is to use the original code that we provide and make modifications to adapt to our new requirements.
I am looking for a skilled Elasticsearch expert to help with data indexing and analysis for a large dataset. The data to be indexed is primarily textual and it is sourced from database entries. Experience with database management and textual data analysis is a crucial requirement for this project. The primary tasks include: - Analyzing and indexing a large dataset from database entries - Setting up Elasticsearch for efficient data analysis - Implementing indexing strategies for textual data Proficiency in Elasticsearch, data indexing, and database management is benefit for this project. Familiarity with handling large datasets and textual data is a must.
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 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. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I ...
Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.
Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.
...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report ...
...complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL ...
App para elaborar presupuestos fuera de la tienda. actualmente tengo un sistema de escritorio elaborado en sql server para facturacion. El sistema Funciona perfecto y tiene la opción de realizar cotizaciones pero quiero incorporar una app para realizar las cotizaciones de los clientes foráneos ya que tengo un empleado que los visita semanalmente y me toca estar transcribiendo los pedidos. Seria una app que permita cargar los inventarios y los clientes al momento de estar en la tienda Y luego poder realizar los pedidos o cotizaciones offline cuando se este fuera. Para luego cuando llegue a la tienda hacer la actualización o descarga de pedidos. que tan dificil es hacer la app para android y para ios.
We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.
...standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git. **Why Join Us?** - Flexible working hours and a chance to work in a dynamic, fast-paced environment. - Continuous learning and professional development opportunities. ? **Apply Now!** Send your resume, a cover letter, and work samples/portfolio demonstrating your expertise relevant to the role. ...
...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous tes...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...
...an ER diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database d...
...complex backend development and database integration tasks and run code as offline. Key Responsibilities: Develop, test, and maintain robust, scalable, high-quality software solutions. Design and implement new features and functionality. Write clean, maintainable, and efficient code. Develop RESTful APIs to support front-end functionality. Integrate user-facing elements developed by front-end developers with server-side logic. - In-depth understanding and experience of backend operations using Python Django. - Managing and integration of the database with the application. - Maintenance and improvement of existing codebase for optimal functionality. Desirable Skills: - Proven experience in Python Django for backend development. - Hands-on experience in database ...
I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the...
Commercial real estate agency database of GCC
About Plesk hosting upgrading the database from MariaDB 10.1 to 10.3 i would like to upgrade the database from MariaDB 10.1 to 10.3 for my hosting however, my hosting have a lot of client website in it, just would like to know if this upgrade will not affect the existing database thanks
Self Managed Home Care Providers Database
I'm looking for a seasoned AWS Data Engineer with over 8 years of experience to support me in handling data extraction and transformation tasks. Key Responsibilities: - Data Extraction: The engineer will be responsible for extracting structured data held in SQL databases. - Data Transformation: You will be required to transform the extracted data into a usable format for our analytics and reporting. Skills and Experience: - 8+ years of experience as an AWS Data Engineer. - Proficient in working with structured data, in particular, SQL databases. - Extensive experience in data transformation. - Expertise in AWS services, especially Amazon S3 and Glue. Your support will be essential in ensuring the smooth flow of our data processes. Please provide examples of your past ...
I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.
I'm looking to create a comprehensive database of self-managed home care providers in Queensland and Australia to facilitate networking within the industry. Key requirements: - The database should include the provider's: - Name - Address - Email - Prime contact Ideal skills for this project: - Proficiency in data collection and database creation - Familiarity with the home care industry in Queensland and Australia - Organizational skills, to categorize the data by region - Excellent attention to detail, ensuring accuracy in information provided The data should be organized by region for easier networking. I may also require the database to be updated periodically. The collected information should be reliable, up-to-date, and include a diver...
I am in need of someone who can help me gather email addresses, websites, and phone numbers from the links in the attached spreadsheet. It's crucial that the information you provide is accurate and up-to-date. The test of accuracy will be me sending emails and verifying the company. Any wrong details will need to be collected again unless it is beyond your control (e.g. company has closed down etc.) Automated collection will be erroneous as the data needs to be collected in the following way. use the company names or links from the attached spreadsheet. 2. To copy and paste the company name + UK in the Google search box. The company's operation must be based in the UK as similar names may exist in US as well. 3. Or to click company logo and collect its email addresses, websit...
I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the cu...
We are seeking an experienced Flutter developer to integrate 's video and call streaming services along with Firebase database into our existing Flutter application. The primary tasks include implementing 's features for seamless video streaming and call functionality, as well as utilizing Firebase database for efficient data storage and retrieval. The ideal candidate should have prior experience with SDK and Firebase integration. Additionally, the developer will be responsible for updating the app to meet the requirements for submission to both Apple Store and Android Store. If you have the necessary skills and expertise in Flutter development, we'd love to hear from you.
We need the following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must...
I need a skilled developer to integrate our custom in-house software with Oracle TimeCard. This is to allow for automated time entry. Key Requirements: - The integration should allow for automatic time entry from our custom in-house software to Oracle TimeCard. - The system should also enable the creation, updating, and deletion of timecard information in Oracle TimeCard. Ideal Skills: - Proficiency in Oracle TimeCard integration. - Experience with automated data transfer between systems. - Strong understanding of custom software integration.
I'm currently using Oracle Apex 20.1 and have an issue with Jasper Reports not executing properly. This can be a server side issue in JasperServer because the reports and applications are working fine in our development environment but in UAT are failing. I need a skilled professional who can troubleshoot and fix this issue. Your main tasks will include: - Analyzing the current setup and identifying what's causing the problem with PDF output. - Implementing the necessary changes to ensure Jasper Reports are correctly executed from Oracle Apex The ideal freelancer for this project would have: - Proficiency in Oracle Apex. - Strong experience with Jasper Reports - Past experience in troubleshooting and fixing similar issues, including server side issues. - F...
I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advanta...
...Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowl...
