How to query a cube using sqldela

...seeking an experienced business analyst, with a strong background in data analysis, specifically of marketing data. The primary focus of this role will be to mine marketing data, analyse it, and provide clear, actionable insights. The emphasis will be on using these insights to increase sales. Key Responsibilities: - Analyse marketing data to discern patterns and trends - Present insights and make data-driven recommendations that will drive sales performance - Monitoring and forecasting marketing and sales trends Ideal Skills: - Demonstrated experience in Data Analysis, particularly with marketing data - Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with attention ...

...experienced C# developer, backed with a solid understanding of Microsoft SQL Server and API integration, to set up an IVR system to automate customer port-in requests for my project. Project Details: • Align an IVR (Twilio Programmable Voice) using C# with MS SQL Server back-end. • Develop an IVR Menu-Driven system for self-service to guide customers through the port-in request process. Project Flow: Customer will call twilio programmable voice and provide the temporary phone number, IVR will verify and store the phone number being called from. IVR will greet the customer and ask them to press 1 if they want to submit a port in and press 2 if they want to check the status for their port-in request...

For my project, I require a senior MSBI developer well versed in both SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services). The main focus of the project will be: - Data Integration: Consolidating and transforming data from various sources - Data Analysis: Interpreting the integrated data and turning it into insightful information The ideal candidate should have: - More than five years of experience, with specific skills in SSIS and SSAS - A proven track record of handling complex data integration and analysis efficiently - Demonstrated proficiency in translating business requirements into solutions - Excellent problem-solving skills and the ability to work under stringent timelines.

I am looking for a Power Bi integration expert who can create a web application to display power BI sample report which below feature- to create a sample report which can be embed in a html page data can be fetched from a sample sql server db or from a JSON api URL both the cases report should be same but data must be different based on credentials of sql server or json api url credentials we need to send to the report then report should display based on the response data of the API should not ask any type of login credentials however we can internally set power BI pro license credentials some whare in the application

I have a domain with many old non working subdomains. Some subdomains have different pages- all not working if you try to access them. Links to these subdomains and pages are on many websites but they all return 404. For example there are links like this on different external websites: What is needed: If request URL returns 404, display a page with relevant Google search results. Get the results from my API (or your API if the price is good). How to display results: Query API for the request URL Take title (minus subdomain name if exists in title) and query API again for that title Display 4-6 results on this page. Store results in JSON in case this URL is requested again (to avoid API calls for this URL). If Query

...experienced developer in WHM node.js to incorporate a number of functionalities in my project. They are namely: - User Authentication: Ideally, you should be familiar with the design and implementation of robust authorization systems. The specifics of this requirement were not stated. Yet, a flexible approach that can accommodate a range of authentication methods is required. - Server Monitoring: We are interested in developing server monitoring capabilities for this project. While specific features weren't specified, a knowledge of creating monitoring tools that can provide real-time feedback, performance metrics, and monitor resource usage would be greatly advantageous. - Automated Backups: You should be able to integrate automated ba...

I'm on a hunt for an expert DevOps Engineer, with a wealth of experience in Amazon Web Services (AWS), particularly with Elastic Load Balancer (ELB) and EC2 instances. The task here is primarily to establish HTTPS on my EC2 instance, and your tasks will include: - Crafting an HTTPS traffic management system on my EC2 instance with the aid of ELB. - Creating a brand new certificate for the HTTPS setup. Expertise in this will be very essential for the successful completion of this job. The ideal candidate should have a top-notch understanding and hands-on experience working with AWS Certificate Manager, ELB, and EC2. This aforementioned skillset will effectively streamline this process and contribute immensely to the successful completion of t...

We're seeking a skilled Security Researcher/Ethical Hacker to identify and report vulnerabilities in our Jira Cloud application. The ideal candidate will have a proven track record in ethical hacking, with expertise in various security domains including XSS, SQL Injection, SSRF, etc. Responsibilities include conducting thorough security assessments, utilizing the Bugcrowd Vulnerability Rating Taxonomy for prioritization, and providing detailed reports on findings. This role requires a deep understanding of security protocols and a proactive approach to enhancing application security. I will provide link to the cloud application. The aim is to highlight all potential P1/P2/P3/P4. Deadline for assessment 18th March, I wi...

I am looking for an expert in Power BI to help me visualize market trading data. SQL Data format in the first screenshot. additionally I have table which summaries trading code to the marketing sectors. I need Power BI visualization. 1) Which will show specificity of the instrument. Like trading candle chart, min max values of the day, some statistics measures. 2) Page that will visualize sector: like oil/gas, banks and so on. 3) Page that will visualize market sector data: like stocks, futures and so on 4) Page that will show general market overview and get main info about all other pages

I'm searching for a Laravel developer to make some upgrades in our API. The project lacks specifics as some initial questions were skipped, however, the core objective is enhancing our API. The possible changes as per initial query comprised: - Adding new features - Improving performance - Fixing bugs The subsequent questions on the specific required changes were also overlooked, so we're open to any enhancements that could be made on your professional perception. Ideal Skills: - Proficient in Laravel framework - Strong experience in API building and optimization - Deep knowledge of web performance and bug-fixing Please, provide your proposal highlighting your previous experience and your ideas on possible upgrades for this API. Let's bring t...

Hi Ahmed H., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...recently through a PHP shell and I urgently need a professional to properly clean and secure it. Key Responsibilities: - Malware detection and removal: The professional should scan every file in my website to identify and remove all the malware scripts planted by hackers. - Firewall setup and configuration: Setup and appropriately configure a strong firewall to prevent future unauthorized access. - Regular software updates and patches: Ensure that all software are up-to-date. This includes underlying server software and any installed scripts, plugins, and themes. Skills & Experience: The ideal person for this job should have: - Prior experience in dealing with hacked websites, especially those infiltrated via PHP shell. - Prof...

I am on the lookout for a Power BI developer who can streamline our processes by automating data integration and generating timely reports. Ideal candidates for this project should have top-notch skills and experience with: - Working with a variety of data sources: Although I did not specify particular data sources, it would be beneficial if you have experience with Excel, SQL databases, and web APIs. - Performing different data transformations: I did not mention specific cleaning processes, but familiarity with data filtering, aggregation, and merging is again a plus. - Reporting in Power BI: I currently do not have a particular reporting template in mind. Therefore, your expertise in creating custom reports that suit different business needs will be h...

I am in need of a machine learning expert who is proficient in Python, to develop an advanced quantitative analysis tool to cater to my specific needs. Key Responsibilities: - The tool should be capable of performing three critical functions: - Data Classification: Classify and efficiently organise the incoming data for easier analysis. - Predictive Modeling: Capability to forecast future patterns based on the present data. - Anomaly Detection: ability to highlight and identify any potential oddities or inconsistencies in the data. - The tool should be compatible with SQL databases, as this will be the primary data source. Ideal Candidate: - Excellent knowledge and experience working with Machine Learning and Python is crucial. -...

I need a professional to create a wireframe for a multifaceted and user-friendly web application payment page. This complex wireframe needs to cater to my specific requirements: The ideal candidate should possess a profound understanding of UX/UI design, wireframing and a strong proficiency in payment gateway integration. to deliver a editable wireframe via , miro , figma details step by step Step 1: Arrival from Merchant Website The user initiates the payment process on the merchant's website by clicking a "Checkout" or "Pay Now" button. They are redirected to the PSP's payment page via a POST request. This request includes the order information (items, amounts),...

I'm seeking a proficient R Programmer who specializes in statistical modeling and inference using regression models. I have a project focused on a thorough meta-analysis of R programming and the programmer must perform sensitivity analysis and meta-regression analysis Key Aspects: 1. Data manipulation and analysis: You should be able to manipulate and analyze data well. You should understand how to prepare data for analysis and interpret results. 2. Statistical modeling and inference: This project heavily revolves around statistical modeling and inference. You should be skilled in regression models specifically meta-regression analysis and sensitivity analysis. To be successful in this job, you should have proven experience ...

I need an experienced Laravel developer who can identify and solve issues with the efficiency...developer who can identify and solve issues with the efficiency of specific database queries and faulty job queues in my Laravel 5.8 project. Key Areas of Concern: - Fixing slow queries: The database query that retrieves user information is running slower than it should. I am looking for a solution to speed up this process. - Resolving queue issues: Job queues are failing to run, causing an operational bottleneck. Your task also includes finding and implementing a fix for this issue. Ideal Skills: - Proven expertise in Laravel, particularly version 5.8 - Good understanding of database query optimization - Familiarity with queue and job execution in La...

...elements concerning a small foundation. Adherence to the SMM7 standards is vital. It is also required for it to be done on the traditional dimension paper. Your key tasks will include: - Accurately determining the area, volume, and depth of the foundation - Assessing the excavation of top soil for preservation - Moving on to the excavation of foundation trenches starting at Reduced level - Accounting for the volume of the plain concrete foundation (1:3:6) mix - Considering the 225mm cavity brickwork wall up to and including the (dpc) damp proof course - Evaluating concrete cavity filling (1:6) mix - Analyzing requirements for site protection from water from any source - Evaluating a 200 mm thick hardcore filling and any treatment required - S...

I am looking for a skilled developer to create a mobile application suitable for both Android and iOS platforms. The app is envisioned to have a corporate and professional user interface. Key Features: - The application should interface with a locally hosted SQL Server 2005 database. - It should allow the user to perform CRUD (Create, Read, Update, Delete) operations on price, cost and inventory quantity. - Despite the sensitive nature of this data, there should be no login required for data access. This means the app should be accessible to anyone without restrictions. Skills and Experience: - Proficiency in a cross-platform mobile development tool or language, such as React Native, Flutter, Xamarin, etc. - Experien...

As part of my project, I am in need of a skilled professional with hands-on experience in utilizing the mySQL Workbench R Package to perform statistical analysis. -Core Tasks: R program financial analysis and metrics -Expected Output: My SQL Workbench CSV Format -Priority Stats: I'm particularly interested in an expert interpretation of these statistics: 1. Rate of Return (ROR) 2. Correlation (CORR) 3. Standard Deviation (ST DEV) 4. Money Flow Index (MFI) The ideal candidate is proficient in using mySQL Workbench R package and knowledgeable in these areas of statistical analysis. Only serious and committed freelancers with a knack for accurate data interpretation are requested to respond.

Note : Accepting ad managers who bids less than 5000. I run a small startup business named veggieexpress where we deliver farm fresh vegetables and healthy drinks. I'm in need of an experienced professional to handle my metaads, with the primary goal of scaling B2C sales for my physical product line. I'm interested in boosting engagement, reaching out to a broader consumer base, and, most importantly, driving up sales. since it's an early startup the budget for managing is less. As the sales grows we want to work with them for longer period of time.. Here is what I'm looking for: - Expertise in Facebook Ads Manager - Strong background in consumer marketing - Experience in advertising physical products - Proven track record of improvi...

Note : accepting ad managers who bids less than 5000. I run a small startup business named veggieexpress where we deliver farm fresh vegetables and healthy drinks. I'm in need of an experienced professional to handle my metaads, with the primary goal of scaling B2C sales for my physical product line. I'm interested in boosting engagement, reaching out to a broader consumer base, and, most importantly, driving up sales. since it's an early startup the budget for managing is less. As the sales grows we want to work with them for longer period of time.. Here is what I'm looking for: - Expertise in Facebook Ads Manager - Strong background in consumer marketing - Experience in advertising physical products - Proven track record of improvi...

My website is currently experiencing issues due to the deletion of the original PHP admin, and though a new one was created in its place, complications have arisen. At this point, I'm uncertain whether I have a backup for the website. What I require is a professional who can effectively handle: 1. Recovery of Lost PHP Admin Data: - I need you to recover the lost data from the previous PHP admin. Knowledge in PHP, SQL, and database recovery will be crucial in this phase of the project. 2. Review and Optimization: - Once the data has been successfully retrieved, I would appreciate if you could review the current PHP admin, identifying any potential issues and optimizing it if necessary. A strong background in PHP development a...

I need complete 2 small projects done. The data needs to be pulled from API using python. The pulled data needs to be unnested, then transformed to answer some insights with medallion architecture. Here, you need to showcase SCD-type 2 ingestions, incremental joins, managing PII information, aggregation. Final deliverable needed for 1st project (databricks): Data model designed and architecture overview Notebooks of transformations in Python and PySpark/Spark Scala Final deliverable needed for 2nd project (dbt): Data model designed and architecture overview dbt sql and yaml files

I am looking for a talented designer who is very good using AI photo/video creator. I want to make a video clip for my new song called the "The first and the last one". I attached couple of files: 1.) a slovak to english translation of lyrics, so you can understand the meaning of the song more closely. 2.) slovak (original) lyrics to match the text lyrics with the voice, like in this song: 3.) a graphic idea that I generated from some AI tool. 4.) logo of my band - feel free to change the letters to fit the collors of the videoklip, just keep the cherries in the color that they are. 5.) Song in mp3. --> I can send it to you later in wav. The song is about realizing after some time after a...

Learn us how to rank a Website, will be a project for several months 1-5 hours per week. Teach us SEO und how we can rank our website.

...require your expertise in Natural Language Processing and Machine Learning specifically for Biomedical Named Entity Recognition (BioNER) using Language Model (LLM). Your tasks will be: 1. Comparing and Evaluating Two LLM Models * Should have an understanding of various LLMs and their working principles. * Will need to implement two LLM models. * Evaluate, compare, and select the most effective one. As the evaluation criteria have not been provided, your professional judgement through your past experiences and industry knowledge will be expected. 2. Integration with UI * Post evaluation, integrate the best-performing LLM model with a user interface. * Although programming languages or frameworks for implementation and integration were not...

I need a proficient and reliable SQL, PHP, and WordPress specialist to solve an issue I'm currently facing. My primary requirement is for assistance with my WordPress admin login. Despite having the correct credentials, I am unable to access the admin page. This issue is impacting my ability to manage my website and needs an urgent solution. The chosen freelancer should be able to: - Diagnose the potential reasons why I'm unable to access the admin page - Determine the most efficient fix for this problem - Apply said solution and, if necessary, guide me through the steps - Perform necessary adjustments in the SQL database if required - Ensure similar problems do not occur in the future The ideal candidate will have: - P...

...seeking a highly skilled PostgreSQL Database Administrator (DBA) with particular expertise in performance optimization. The focus of this job will be to revamp and optimize our database schema. Roles & Responsibilities: - Specifically, this task involves enhancing the performance of our highly complex queries such as stored procedures, functions, and logical conditions. - You should be able to ensure data integrity and the highest levels of performance and security for the databases. Ideal Skills & Experience: - Strong DBA experience, especially within PostgreSQL. - Proven skills in managing complex SQL queries. - Deep understanding of Database schema optimization. - Familiarity with data backup processes and security management. - Strong problem...

I need SQL server Export, Store Procedure expert developer

I am looking to take an exisiting Github Project and bring it up to date with a Web App Gui that can be self hosted. Current project is here : This project was originally written in Go and I want the new version to be self hostable. Functionality needed 1. Query DB for latest titles 2. User Can specify location of files 3. Using DB App will sort files / updates int sub folders etc. 4. Further functionality to be added later on.

I am seeking an instructor who can provide beginner-level classes in Data Analytics - SQL, R, and Power BI. I'm looking for a commitment of 8 hours per week. Ideally, the candidate should have: - Previous experience in teaching or tutoring, particularly with beginner students - Proficiency in SQL, R, and Power BI - The ability to tailor lessons to my progress while also following a structured curriculum I speak Spanish and basic English ( So preferably someone who speaks spanish)

I'm seeking a skilled Python programmer to turn my code into an application. Key Specifications: - The purpose of this coding task is to create a software application specifically tailored for data management. - Applicants should have comprehensive knowledge and applied experience with Python programming. - As the main objective is to develop a software application, freelancers should also possess a strong background in software development to ensure an efficient and robust system design. Ideal Skills and Experience: - Python Programming - Software Development - Data Management Systems - SQL - Building Robust Secure Systems - User Management - API knowledge Interested freelancers should explain their experience wi...

...Custom Software solutions. I need you to generate a thorough report documenting the findings. Key Tasks: - Perform penetration tests on my Windows VPS - Conduct vulnerability tests on installed Database systems and Custom software solutions - Compile a comprehensive report explaining test results Ideal Skills - Excellent knowledge and experience with Windows VPS - Proficiency in penetration and vulnerability testing - Proficient understanding of SQL Server - Proficiency with compiled ms access applications I'm open to working with professionals who have a methodical yet efficient approach to accomplishing these tasks. An ideal candidate would be receptive to my inputs, and meticulous in explaining complicated security j...

In the capacity of an experienced ERP developer, your task will be to create an engaging and user-friendly ERP system that meets our specifications. Key Features to Implement: - Accounting - Payroll management - Stock maintenance - POS system - Manufacturing management - Customer tracking - Employee tracking As the backbone of our business operations, the ERP system you create must resonate with our desire for a user-centric interface. Your prowess in transforming complex processes into fluid and intuitive experiences will be integral to the success of the project. Moderate customization of the ERP system will be necessary, as we need our platform to have a mix of standard and custom features. This will ensure it aligns with our operation'...

...HTML, CSS, C# and SQL for a web development project. The primary purpose of this project is to create a fully-functional, dynamic website that requires: - User authentication to control access to certain pages or features, - API integration to streamline functionalities and work with other applications, - Dynamic content update capabilities; changes to the web contents should be easy and efficient. The ideal candidate would be someone with a significant amount of experience navigating both back-end (Xamarin, Blazor, C#, SQL) and front-end (HTML, CSS) development in .NET environment. I need someone who can transform complex functionality needs into practical, efficient web solutions. Your understanding of user inte...

...box is a component, equipped at the front end of a car, and is one of the most important devices for crash energy absorption. For example, we would like to investigate the following shock absorbing materials. ・Crash box made of high strength steel plate of 780MPa class or higher ・Structure in which a steel crash box is equipped with an aluminum front integrally cast part. <<NOTICE>> The target car brands in this search are limited to US, Japan, European, Chinese, and South Korean brands. <Requirements for Payment> ・Submit documentary evidence that clearly states the details of the subject product, the name of the company selling the product, and the company that plans to sell the

I need support for a task converting Crystal Reports into Telerik Reports in ASP.NET. I have all necessary Crystal Reports files (.rpt) on hand. Need atleast 2 years of experience in Telerik Reporting Key Components: - The original Crystal Reports contain complex formulas that must be fully incorporated during conversion. - The current data source for these reports is MS SQL Server and this needs to remain consistent. Ideal Experience and Skills: • Expertise in ASP.NET • Advanced knowledge of Crystal Reports and Telerik Reports • Understanding of complex report formulas(a must) • Experience with MS SQL Server. For a successful deliverable, all converted Telerik Reports should function identically to original Crystal ...

Requiero una aplicación para manejar una base de datos en sql, que pueda hacer consultas y modificar valores. Sería una base de datos principal de 10 columnas y otras pequeñas anidadas, se trata de datos obtenidos automáticamente en una línea de Produccion. El programa es libre, puede ser una aplicación web o en .Net por ejemplo.

I'm seeking a freelancer skilled in Power Query for some targeted tasks. These tasks include: 1. Data Cleaning and Transformation: I need assistance to clean and transform my data ensuring its integrity, relevant, and useful for further analysis. 2. Data Merging and Consolidation: I have different datasets that need to be merged and consolidated. The goal is to improve data accessibility and usability in analysis. 3. Data Modeling and Analysis: After cleaning and consolidating, I would like the freelancer to insights from the data through data modeling and analysis. 4. Custom Functions: Alongside the tasks above, I require help in creating custom functions in Power Query to make the process more streamlined and ef...

I'm in need of a tech-savvy freelancer to manage my blog website, utilizing the AI tools I subscribe to including Reword, Jasper, Tailwind and Blaze. Your tasks will involve the following: - Proofreading posts: Ensure each post is error-free using the AI proofreading tools. Ensure they sound less robotic and more humanized - SEO Optimization: Improve the visibility of each blog post by boosting its SEO. Experience with AI-based SEO optimizer tools will be a strong advantage. - SEO inputs: input targeted keywords, SEO titles, meta descriptions (using yoast SEO) alt descriptions (using bitalty) & back links (reword suggestions in “statistics reader may be interested in”) to improve search engine optimization - Sch...

...issues with my SQL database and Windows-Based POS system which resulted in a loss of connection between the two. Your main task would be to restore this essential connection, thereby enabling the smooth functioning of the system. • Identify and fix connection issues: My POS system and SQL database are not communicating as they should. Your priority will be to identify what's causing this and to implement a solution. • Handling pertinent data: The SQL database in question manages both customer purchase information and Inventory records. Possessing experience with or knowledge of these data types will significantly aid in this task. The ideal candidate for this project should be proficient with Windows-based POS s...

I am looking for a proficient WordPress developer to create web pages for a new website, the theme of the website brand is American cyber security. Ask for the website for review. Key Responsibilities: - Design and build an attractive, user-friendly website page on WordPress with a 90+ Rank Math Score - Establish more than 30 unique pages, ensuring each is SEO friendly using Rank Math. Each Page must: 1. Use the main focus keywords that we will give you. 2. Review competitor links for recreating a new page, which we will give you. 3.1100 words copyscape free per page, have content created in ChatGpt using Rank Math feature. Must have experience in SEO prompts and have your own ChatGPt account to work with us. 4. Two CTAs with ...

I need an experienced developer to implement MySQL database management using Python. The selected professional will utilize the python connector 'mysql-connector-python' to establish a connection with the database and do two tasks of a project. The database management includes: - Creating an efficient system design - load, extract and manipulate the data Key skills required for the job include: - Strong Python programming skills - expertise in SQL and specifically working with MySQL databases - Experience with 'mysql-connector-python' - Knowledge of data management best practices Previous work with user data management would be a plus.

...experienced SQL Server DBA to perform several critical tasks for us: I'm a database designer with 20+ years experience, but we need a dba to compliment my skills. - Security and Access Control: We have a user creation bug I cannot solve. - Troubleshooting and Performance Tuning: We have intermittent record locking which we need to fix. - XML Parsing: We have a 10 year old xml parsing codebase, which causes serious performance issues when there are hundreds of fields, we need a way to speed this up. - Converting SQL Server to MySQL: We also need to convert the entire codebase to mysql so we can run on both database engines and keep them syncronised. This is a nice to have...

I need a capable and experienced PHP/MySQL developer to create an interactive historical results report for me. The report will be generated based on user-selected parameters in a web page. Data to be arranged in tables, generally organized like in the attached image. A list of departments is in another of the attached images. User should be able to click to hide/display prior years and click to hide/display min/avg/max values as well. At the bottom of the report, a grand total section that includes all departments should be displayed in a similar fashion as the departments. The MySQL query that is used to obtain a given total from the data is: ------------------------ SELECT SUM(llx_facturede...

I'm in desperate need of assistance with a database management assignment. The tool of choice for this project is MySQL, necessitating an expert familiar with the specifics of this particular database system. With an urgent closure time frame of 2 hours, you will need to hit the ground running. The assignment centers on two key areas: 2. Understanding Database Concepts - In addition to query writing, a solid understanding of core database concepts is necessary. Part of the task may involve explaining these database concepts to me, so clear communication is important.

Merhaba, Windows işletim sistemine sahip bilgisayarımda çalışacak bir SQL Server yedekleme programına ihtiyacım var. Bu programın öncelikle aşağıdaki özelliklere sahip olmasını istiyorum: - SQL Server veritabanımın otomatik olarak yedeklenmesini sağlayabilir. - Firebase veritabanı veritabanımın otomatik olarak yedeklenmesini sağlayabilir. - Yedeklerin belirli bir zaman aralığında alınmasını sağlayabilir. - Yedeklemeyi başarısız durumda, hata bildirimleri gönderebilir. Bu projenin bir ay içerisinde tamamlanmasını istiyorum. İdeal adayın SQL Server, veritabanı yönetimi ve Windows programlama konularında deneyime sahip olmasını tercih ederim. Ayrıca c# veya .Net dillerinde yazılım geliştirme deneyimi de büyük bir avantaj olaca...

I need to setup latest mysql (v8.x) on C++ on my windows 64. The C++ is installed using Msys64 (not visual studio). I need you to figure out how set up the mysql for this c++ for me on my computer. Before I hire you, you must provide a video demonstrating the installation steps successfully on your own computer, and showcase a test by writing c++ code to run a basic mysql query. If the video convinces me that you can do the job correctly, then I will hire you so that you do it on my computer. I will give you control thru anydesk, and you will have to repeat the installation steps on my computer too. And after that, I will do the steps from scratch once again while you watch me, and you troubleshoot me if I get stuck...

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