Ssis data microstrategy trabalhos
For AdventueWorks add summary for people with sales. Determine which people will be of most interest to managers, export those records to excel, summarize the records, add the people to the people table to retain sales data. Total sales by person for the end of the day. Use T-SQL to add sales for the end of the day to the Data-Warehouse Show changes from day to day, record the changes in a changes by day table. AdventureWorks2008R2 and AdventureWorksDW2008R2 Visual Studio 2022 Sql Server 2019 You can message me if you want the links for the AdventureWorks datbases on the Microsoft Website Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login remote and...
Add data cleansing to T-SQL scripts for peoples demographic data. Some examples to check for are format for zip code, email address, and proper capitalization. For records with errors add those to the table for InValid records with a comment of what the error is. You can add a column to that table to add the error type. For records that are valid add those to a table for valid records. I have created the tables and have the create scripts for those. I have also created some data cleansing like checking for duplicates. Make recommendations on what further data cleansing should be added. There might be a data cleansing project for AdventureWorks on the web or github you could use that and make any comments on it you think wold be better. Message me and I wi...
Remote help with Data Cleansing, Data Transformation, Data De-normalization. I'm doing that now with T-SQL and want to know if there's a more automated way. The database is a test database on my local machine from AdventureWorks. I will send you the script I'm writing for De-normalization and data cleansing if you message me. You can consider the project complete when you are able to create a SSIS, and SSAS project and it compiles and works and if you can recommend a few ways to automate de-normalization and data cleansing other than writing a T-SQL script. Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. Do you speak English? Are you available to login re...
Add data cleansing to T-SQL scripts for peoples demographic data. Some examples to check for are format for zip code, email address, and proper capitalization. For records with errors add those to the table for InValid records with a comment of what the error is. You can add a column to that table to add the error type. For records that are valid add those to a table for valid records. I have created the tables and have the create scripts for those. I have also created some data cleansing like checking for duplicates. Make recommendations on what further data cleansing should be added. There might be a data cleansing project for AdventureWorks on the web or github you could use that and make any comments on it you think wold be better. Message me and I wi...
Create a data warehouse for the AdventureWorks Person tables. Make recommendations on what the best fact table and dimension tables will be. I'm using AdventureWorks2008R2 and AdventureWorksDW2008R2 from the Microsoft downloads. I will send you the download link if you message me. Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada. When you can complete the project? I need the project complete in 48 hours. Confidentiality. a) No Use. Recipient agrees not to use the Confidential Information in any way. b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof. c) Protection of Secrecy. Recipient agrees to take all steps reasonably...
I am seeking a freelancer to design a betting website, specifically a straightforward lottery system, with a substantial emphasis on security. It's crucial to engage with a professional who possesses deep knowledge and experience in the field. The visual appearance (front end) of the site will be straightforward and uncomplicated. Howev...efficient and secure. My topmost priority is to ensure the site's operability, speed, and above all, security. It's paramount that client funds remain unhackable, and all aspects related to the database, login, and payment methods are safe for users. Necessary requirements: HTML NoSQL Couch & Mongo XSS (Cross-site scripting) PostgreSQL Database Development Web Security API Azure Cloud Security SSIS (SQL Server Integration Ser...
I am looking to hire experienced candidates with specific technical skills for Microsoft D365 developer. Ideal candidates must have SQL Server Database, writing SSIS Packages, Integration of D365 with third party applications. This will be a good opportunity to earn good income.
I am looking for a skilled SQL Server developer for a project involving database design and development. The ideal candidate should have experience in query optimization and performance tuning, as well as data migration and integration. Tasks: - Database design and development - Query optimization and performance tuning - Data migration and integration Setup: - I need a new SQL Server setup Technologies: - Proficiency in Transact-SQL is required If you have experience in SSIS and SSAS, it would be a plus. Please provide examples of your previous work in SQL Server.
I am looking for a freelancer to help me create a dashboard using Microstrategy. I'm targeting this dashboard to be viewed solely on a web interface, and only 1-10 users will be able to access it. I need the dashboard to have data visualization capabilities, interactive filters, and real-time data updates. To sum it up, I want to be able to have comprehensive and up-to-date insights on whatever data I choose, all on a web layout.
SQL, SSIS, PowerBI Trainer I am looking for a trainer who can provide training on SQL, ssis, powerbi to an audience with an intermediate level of understanding. The training sessions should be 2 hours long. Requirements: - Expertise in SQL, powerbi and a strong understanding of its various aspects - Proven experience in training individuals on SQL - Ability to explain complex SQL concepts in a clear and concise manner - Familiarity with intermediate-level SQL topics such as joins, subqueries, and optimization techniques - Strong communication and presentation skills Ideal Skills and Experience: - Extensive knowledge and experience in SQL - Previous experience in training individuals on SQL, ssis - Proficiency in using training tools and resources to enhance the lear...
Project Description: Revisión y correcciones de código SSIS (un ETL) I am looking for a skilled professional who can help with the revision and troubleshooting of SSIS code for an existing business. The ideal candidate will have experience in working with SSIS packages and resolving any issues that may arise during the process. Key Requirements: - Expertise in SSIS (SQL Server Integration Services) - Ability to troubleshoot and resolve issues in existing running packages - Strong knowledge of ETL (Extract, Transform, Load) processes - Familiarity with project management practices Responsibilities: - Review and analyze the existing SSIS code - Identify any errors or inefficiencies in the code - Troubleshoot and resolve issues in running pa...
SSIS, SQL Job - Data Integration I am looking for a freelancer who can help me with a data integration project using SSIS and SQL Job. Purpose: - The purpose of this project is to integrate data from various sources into a database. Existing Data Source: - Yes, I have an existing database that needs to be integrated with other data sources. Data Type of Source: - The data type of the source is a database. Ideal Skills and Experience: - Strong knowledge and experience with SSIS and SQL Job. - Proficient in working with databases and integrating data from various sources. - Familiarity with data integration best practices and techniques. - Attention to detail and ability to troubleshoot and resolve any ...
Database-SQL server 2022 4 Database-SSIS 3 Database-SSAS trainer need to make the syllabus based on this topic need minimum 8 year experience daily 4hr of class
I have a University practical work, regarding data warehouse, I have to do that; ----------- Propose a topic, preferably linked to a real need that can be resolved through a data warehouse exploited through OLAP tools. The analyzed problem must have at least two measures, a maximum of ten dimensions, of which at least three must be hierarchical dimensions. Among the work deliverables are: 1) Presentation of the work carried out, which must include: Description of the organization and the context of the business. Description of the need or problem to be solved. Existing data models (OLTP). Multidimensional Model (Star Diagram). Data mapping. Design decisions, both at the data model, technology and ETL level. 2) Demo of the solution. Put together a vi...
WorkiFicient is an IT Software company focusing on working in Business Intelligence (BI) & Data Analytics. We have a strong team who can help our clients on end-to-end analytics implementations. We have a team of engineers who work on inhouse as well as clients’ offshore analytics projects. Apart from these engineers there are some technical consultants who got deployed at our different clients' projects from Pan India, US & UK and working with us remotely. We have expertise in various niche technologies such as; MicroStrategy, Power BI, Tableau, Data Analytics, Data Engineer, Cloud (AWS & Azure). Apart from this, we cater Hiring & Professional Services. We provide end to end recruitment solutions to leading organizations, whether th...
DTSX Package for SQL Server Data Transformation and Flat File Destination I am looking for a freelancer who can create a DTSX package for me. The source of the data is SQL Server, and I require data transformation or manipulation within the package. After processing, the destination for the data is a flat file. I need a professional to modify an existing dtsx file for me and amend it in SSIS so that the flat file output each time has a different time / date stamp and then return to me the finished product as a dtsx file which I am then able to call within an SQL Job. Ideal Skills and Experience: - Proficiency in SQL Server - Experience with creating DTSX packages - Knowledge of data transformation and manipulation techniques - Familiarity with ...
DTSX Package for SQL Server Data Transformation and Flat File Destination I am looking for a freelancer who can create a DTSX package for me. The source of the data is SQL Server, and I require data transformation or manipulation within the package. After processing, the destination for the data is a flat file. I need a professional to modify an existing dtsx file for me and amend it in SSIS so that the flat file output each time has a different time / date stamp and then return to me the finished product as a dtsx file which I am then able to call within an SQL Job. Ideal Skills and Experience: - Proficiency in SQL Server - Experience with creating DTSX packages - Knowledge of data transformation and manipulation techniques - Familiarity with ...
I want to zip files from a path eg "C:UserspcDesktoptesting" - zip them according to date name e.g if files = , , - result : testingJan ; testing =April -The files should be deleted once zipped Filenames should be extracted from the path. When re-executing the job it should ignore the zipfiles and only focus on other file types, in order to not reZip. This shouldn't take much time if you an expert in C#, with experience in , forEach loop
I want to zip files / folders in a network drive using SSIS and C# script task. The directory information as well as whether the directory contains file or folder is extracted from a sql table (execute sql task must be used) eg if directory has files then DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles zip to : DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles2022 if directory has folders then DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles20230103 zip to: DESKTOP-AN1Q4ROUserspcDesktopSampleDirAppleImportFiles2023 20230103 All 2023 Jan files or folders in that directory should be zipped in one file After zipping delete the files folders I already have scripts to zip files and zip folders
I am looking for a freelancer who can help me with a project that involves data integration, using SQL and SSIS (SQL Server Integration Services). I will need this freelancer to help me integrate data from database tables into my project. Additionally, they will need to have experience performing complex transformations and cleansing of the data. This project must be completed with the utmost accuracy and attention to detail, as the data is extremely important to me. Experience with SQL Server Integration Services is a must. If you believe you can successfully complete this project, please contact me and we can discuss the details further.
I am looking for a skilled freelancer to assist me with a SQL, SSIS and SSRS project. The main goal of the project is to perform complex data analysis on a Microsoft SQL Server database. The ideal candidate will have experience with data aggregation and analysis, as well as the ability to create SSIS packages and SSRS reports. The scope of the analysis will involve complex queries and filtering to provide insights into a large dataset. Strong skills in SQL, SSIS and SSRS are required to successfully complete this project.
...Familiarity with AWS S3 regions, specifically Asia Pacific (Sydney) I am looking for someone to help me with Microsoft SSIS, .Net integration with S3 bucket. My requirement is integrating Source System which sends flat files to S3 bucket. I got an SSIS job scheduled on a daily basis to read from the S3 bucket and download the files to local folder location and consume the files for further processing. My requirement is, I need someone with SSIS knowledge and AWS knowledge, and .Net c# Delete the files from the landing folder Read the S3 bucket location and download the file(fresh set) to a landing folder. The upstream system sends files as Zip Unzip the files Ideally, this SSIS package should have a script component, which is written in .Net C# and should...
I am looking for an Azure Data Engineer to provide job support for my data solution. Specifically, I need support with Azure Data Factory, Azure Databricks, Azure Stream Analytics, EDW, Python, SQL Server, SSIS, Oracle, Power BI, API, CRM, ERP, and DevOps. The ideal candidate should be able to design, develop, and maintain the Azure data solution. Currently, the data solution is in development and I need support to ensure its success.
SSIS Integration project for SQL Server database to Salesforce - The project involves integrating data from SQL Server database to Salesforce - Duration of the project is 2 months - Ideal skills and experience include: - Proficiency in SSIS and SQL Server Integration Services - Experience with data integration from multiple sources. Atleast 5+ yrs of experience. - Knowledge of SQL Server databases and data transformation techniques
...reliability of our data integration processes. You will collaborate closely with cross-functional teams to design and execute comprehensive testing strategies, identify and resolve defects, and optimize ETL workflows. The ideal candidate will have a strong background in data validation, ETL testing methodologies, and a passion for delivering high-quality data-driven solutions. Responsibilities: 1. Develop and implement comprehensive test strategies and plans for ETL processes, ensuring end-to-end data quality and accuracy. 2. Collaborate with cross-functional teams, including developers, business analysts, and data engineers, to understand data requirements and translate them into test cases. 3. Perform functional, integration, regression, and p...
I am looking for tutor who is Microsoft product expert, like azure, SSIS, data factory etc.
I am looking for an experienced SQL DBA who can assist me with SSIS DB restore and PowerBI. The database size is between 1GB-10GB and I need default settings for the restored database. The main purpose of the PowerBI report is for sales and revenue analysis. The ideal candidate should have the following skills and experience: - Expertise in SQL DBA and SSIS DB restore - Familiarity with PowerBI and its features - SQL and SSRS have been restored Need for urgent help. If needed we can utilize ongoing but for now, I am only looking for short-term assistance to work with our DBA. Thank you
The Exam is Only 15 Question and has a time limit of 20 minutes.
Sql Developer Experience-5+ years Major experience in Sql,TSQL,SSIS and SSRS. Remote
I am looking to hire a Freelancer to develop an SQL SSIS SSRS project. The project will involve using data from SQL Server databases as data sources. Additionally, I need the project to have ETL (Extract, Transform, Load) capabilities and reporting or analytics capabilities.
I'm looking for an expert who can help me troubleshoot an SSIS ERROR. The version of SSIS I'm using is 2019. I'm encountering a connection error when I try to execute the package. The data source being used is SQL Database. If you have experience and knowledge in solving this issue, I'd like to hear from you. Please let me know your rate and the timeline for completion. Thanks for your time.
We need Power BI, SSIS, SSRS, Data modelling, Stored Procedures experienced developer to work for 2 hours a day remotely. We will give 25 to 27k per month
We need to develop 50 SSIS packages and 50 Power BI reports
I am looking for a SQL SSIS ETL expert who can fix a package execution failure error that I am experiencing. I am not sure if there are any custom components involved, but my SSIS version is SSIS 2016 or later. The ideal candidate should have: - Extensive experience in troubleshooting and resolving package execution failure errors - Proficiency in SSIS 2016 or later - Knowledge of custom components and their potential impact on ETL processes.
...Business Intelligence Analyst to help me with important data analysis work. I need someone who has comprehensive knowledge in business analysis and can compare different sets of data to uncover trends, dependencies, and correlations. This is a critical role, as the insights and knowledge gleaned from the analysis will inform strategic decisions. The analyst should have a strong background handling large datasets. The ability to visualize results, create meaningful and actionable reports, and work with SQL to query and process data would be advantageous. Moreover, the analyst must also have a strong understanding of Business Intelligence techniques and highly developed skills in presenting analytical data. The ability to incorporate data and informa...
...and writing the data correctly. Brief to know: -Connected to Shopify as a private app -Reads Orders from the Shopify Store -Calculates Order fees -Writes Products in a list -Finance, etc. I only need someone to: 1- help fix the minor bugs in the system that the Original Developer cannot fix. 2- Allow Connection from the system to the Store's Products where I can modify the product's prices, SKU, etc., from the system and Vice versa. 3- Automatically upload products to the system, NOT manually. Like uploading, deleting etc. All of the Above has errors which is why the features are not working and need to be fixed. Your Qualifications: -Must be professional and familiar with MicroStrategy -Long track with working in this field -Previous projects in Shopify and ...
Problems statements are: 1. MS SQL server weekly scheduled index rebuilding Jobs are failing and even failed on manual run 2. unable to access SSIS package to check at which steps jobs are failing 3. only below error is showing on log: Error,[000] JobManager tried to run a non-existent step (2) for job RebuildIndex_job_name
...and writing the data correctly. Brief to know: -Connected to Shopify as a private app -Reads Orders from the Shopify Store -Calculates Order fees -Writes Products in a list -Finance, etc. I only need someone to: 1- help fix the minor bugs in the system that the Original Developer cannot fix. 2- Allow Connection from the system to the Store's Products where I can modify the product's prices, SKU, etc., from the system and Vice versa. 3- Automatically upload products to the system, NOT manually. Like uploading, deleting etc. All of the Above has errors which is why the features are not working and need to be fixed. Your Qualifications: -Must be professional and familiar with MicroStrategy -Long track with working in this field -Previous projects in Shopify an...
I need to create a new variable and add into the existing variable
Hi there, I'm looking for help getting up to speed on SSIS with a basic overview. I need to be fully trained and ready to use SSIS within a week, so the training needs to happen quickly. I need the training to be specifically tailored to the 2014 version of SQL Server. As a part of the training, I'd like a solid foundation of SSIS's capabilities, and some basic tutorials providing me with hands-on experience. This way I can learn the concepts and get comfortable with the platform before taking on more advanced techniques.
i am looking for a couple of skilled online tutors eloquent in English to teach Python, SQL, and Power BI , SSRS, SSIS, SSAS, SAP HANA , SAP BOBJ, DBT , SNOWFLAKE.
we are developing and providing support work with logistics company, we need the resource who is having more than 3 years experience in SQL, SSRS and SSIS. Ability to interact with client for requirement gathering. Work time : 4.30 am IST to 12.30 pm IST Location : Chennai Language: Tamil , English Share your CV
HI ALL, looking for sql server and ssis developer on 10-20 hours a week basis, i can pay 500 INR for an hour. have to work on in between IST 8 pm to 12 night as per EST time wia screen sharing. looking for only Indian region.
...right implementation approaches can be chosen. -Lead reimplementation of business data workloads currently running in SSIS to run in a cloud native way in Azure. - Provide knowledge and expertise in data engineering concepts (ETL, near-/real-time streaming, data structures, metadata and workflow management) - Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.. - strong team player with a can-do attitude. - Have excellent verbal and written communication skills to interact with client Requirement: - Minimum 10 years of experience in data engineering in Microsoft ecosystem (Azure/SQL/SSIS). - Expert working SQL knowl...
Project will be operated from United states in USA timezone only. All the task will be related to Power BI and SQL server SSRS, SSIS.
help with daily tasks, design data warehouse , use the data integration tools like SSIS and create cube in SSAS. Help with Data modeling tasks
• Participate in data migration activities • Creation of transformation scripts and tasks • Consult with various stakeholders including subject matter experts to understand the source and target data models • Develop a detailed understanding of data models for projects that are part of current and future migrations • Execute data extraction, cleansing and loading from various systems. • Adhere to company and best practice security standards • Participate in data quality and reconciliation activities Skills and experience • Experience with analyzing data models in both source and target system landscapes and defining appropriate mappings and transformations necessary to successfully migrate the relevant dat...
...Candidate will have a minimum of five years of experience and the following skills: • Experience working with large scale relational database & Data Modelling experiences. • Should have experience in data analysis & improvise Microsoft SQL queries/views/complex stored procedures. • Experience in migrating data from other data sources to SQL Server database • Performance optimization. • Should have knowledge in ETL Process (SSIS) to perform load & extract operations. • Ensuring improvisations in quality of data & no data slippage. • Embraces teamwork & possesses ability to effectively work cross functionally • Work with the Data team to understand client data and mi...
this is initial project. If you can get this going we are pitching for about 200 hrs of work for a larger SSIS package
