Terminé

Excel/Power BI integration

I currently do excel exports from our CRM system (Buildertrend), and manually adjust the format and data in order to use the data for forecasting. I would like to automate this process to automatically convert the exported data into the correct format that I need. Updating the format would include, eliminating some columns of data that are not used, creating a calculation to add values from multiple fields, and creating a free form field that I can manually enter forecasting numbers. The updated version would then get updated every month with another excel export from the CRM. The updated sheet would have to be smart enough to keep some data from the previous month and update other data based on the most recent months data. This can all happen in excel or imported in Power BI. I'm open to either.

Compétences : Excel, Traitement de Données, Visual Basic, Architecture Logicielle, Microsoft Access

en voir plus : excel vba odbc access open driver, excel web access aspnet open pivot table, cms integration open realty, analyze in excel power bi, power bi excel tutorial, excel get data from power bi dataset, power bi export to excel, power bi publisher for excel, power bi desktop, is excel power bi free, power bi analyze in excel greyed out, switch excel vb6 app use open sheet, sharepoint word excel power point project workflow zoho, excel macros dont run open office, extra fields oscommerce columns, excel tradestation order integration, data entry excel power point hiring, auto create form fields database columns, ideas final project incorporate word excel power point, google map integration custom fields search

Concernant l'employeur :
( 0 commentaires ) Decatur, United States

Nº du projet : #26848575

Décerné à:

P0L

(422 Commentaires)
7.7

41 freelance font une offre moyenne de $980 pour ce travail

asin1987

Dear Employer, I understand you take export of Excel from your CRM and do some customization for which you are looking for automation. Below are the automation steps that will occur by itself every time: - Auto export Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(240 Commentaires)
8.0
(341 Commentaires)
7.7
(324 Commentaires)
7.8
(152 Commentaires)
7.3
(288 Commentaires)
7.2
(92 Commentaires)
7.2
(59 Commentaires)
6.8
(59 Commentaires)
6.6
(58 Commentaires)
6.3
(165 Commentaires)
6.5
jawadaman

Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then please Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(103 Commentaires)
5.9
(95 Commentaires)
6.4
(13 Commentaires)
5.5
daniyal3214

I can perfectly assist you with that with my expertise in Power BI and Excel. I am a professional Data Analyst, Data Scientist and Data Visualization expert holding years of experience. in Excel, VBA, SQL, Power BI, Ta Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(79 Commentaires)
5.8
(22 Commentaires)
5.3
(15 Commentaires)
5.6
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(27 Commentaires)
4.9
Xichiza

Hi, I am a senior Data Analyst with over 5 years experience with Power BI and I can help you to build your Power BI Project. I am a Microsoft Certified: Data Analyst Associate : [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(9 Commentaires)
4.7
EugeneLebedev

Dear Sir/Madam, It sounds like this is just work in Power Query in Excel - bringing data to the right format for analysis. We have significant experience in Power Query and M language so we can definitely help you in t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(5 Commentaires)
4.3
boomyjee

Hello! I am the head of BI professionals team with extensive experience in reporting and data integration projects for major banks and retail chains. We develop projects in different BI and databases. We have experie Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
5.2