CSV Files load to Power BI

EXCEL/VBA expert at you service. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

Hi, I am a SQL Developer with extensive experience in cloud-based Data Integration and Business Intelligence projects and building ETL processes (Extract, Transform, and Load) using open-source tool 'Talend for Data Integration', which is a Java code generator tool that builds programs out of workflow and data flow designs. I also know the challenges involved in the enrichment and merging of raw data (your CSV files problem). My approach: - Use Talend job to capture filename and timestamp as command line parameters, and timestamp each row in file, and rename CSV file as well - Use Talend job to either: -- Copy renamed file to bucket in the cloud (Azure, AWS or Google), or -- Load file into table located in cloud SQL database (Azure, AWS or Google) - For reporting (several options): 1. Create straightforward connection between Power BI desktop and Azure SQL Database, publish workbooks (ONCE only), and have access to live data on the web. 2. Given integration between Azure and Power BI is seamless, we can also use Azure Storage to transfer CSV files. 3. Using Google BigQuery to load files, you can have your first terabyte (1 TB) of data processed each month for free. Combined this with any partner BI tool such as Tableau or Qlik. I could even look out for a suitable Open Source BI reporting tool for your project. Deliverables: - Packaged Java program + Source code - Cloud setup Look forward to hearing from you. Kind regards, Yordan B

A proposal has not yet been provided

I have very good expertise in Excel macros, automation using VBA. Basically I am from the Microsoft background have expertise in Crystal Reporting as well. I can complete the first part within few hours of timestamping Second Part of going through the BI, I have used Excel Graphs, Dashboards, and Crystal reporting tools. I could quickly get on to Power BI learning skills to have your reports from there, being from Microsoft.

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble

Hello, I would love to help you with your project. Your 48 files should be no problem to work with or prepare for Power BI. Regarding the use of Power BI, it all depends what type of data you have and what you need to analyze. If you give me a few more details on your need and/or send me a file I can give you a better recommendation. I don't want to give you a recommendation without knowing all the facts and needs. I personally like very much Powe BI because of its very powerful visualizations but we would have to talk to see if it is your best solution. I have experience making, editing and modifying huge excel files (+1,000,000 cell of information) and loading them to Power BI. Sadly, I can't show you my work with Powe BI because of the confidential agreement signed with the multinational organization I made the project. I also have experience doing VBA programming and have make several programs that rename thousands of files. I am Canadian but was born and raised in Guatemala so I am bilingual. I am currently doing volunteer work in Mexico. Thank you for considering my offer. Milton Mykiwka

I can write a Java program to insert a date column in each file. I can get the date from the file name, user input, or even from the file creation date, whichever you prefer.

Hi, I am a Mac specialist, so if you are based on PCs, then I'm not for you. This is something that can be done in Applescript relatively simply, so I assume C++ or visual Basic for PC would also be straightforward. As to your cloud-based database - I would recommend Filemaker Pro. It's incredibly user-friendly, amazingly scalable, and allows a hugely diverse range of functionality. It's cross-platform, and can be used by remote users on iOS devices, some Androids, and as a Web-based app. I'm a Developer, so I would champion its cause of course! Moving forward, I would love to be involved in setting up and managing this for you, but as mentioned previously, if you aren't Mac based, then I'm probably not the best man for the job. Thanks James

Hi, I could write a Python GUI application, that would ask you to input the file you want to be date stamped and would output the CSV file with all lines within the CSV date stamped depending on the name of the file,

Hello, I will be gladly assisting your project. please visit my portfolio for my previous work and example.

I have knowledge in Power Bi, and medium knowledge with vba, pretty sure I will manage to have a solution for you in a short amount of time. Familiar with all the BI products from microsoft. Hire me please.

I am business intelligence expert and can easily resolve this problem for you. Looking forward to being of help to you.