Power query in Excel data from SQL, and statistical distributions

Databases & SQL, Desktop Apps — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original There is a ready xlsm file that pulls data from a csv file through PowerQuery queries and fills distributions across different datasets. Following the example of the existing process, data from an SQL DB file needs to be added. The connection between the two tables is based on 3 key fields. The XLS table needs to be populated from the DB and distributions need to be made following the example of the existing data. In other words: There is a database with all alerts for deals. There are parameters that I need to see distributions for. I want to place a statistics file and an alerts.db file in the stat folder and get a page where a chart is displayed, with fields from the database outlined in red rectangles. The key fields for connection are: exact date and time match, exact coin name match, and if necessary, the algorithm name will also be an exact match. There may be differences like underscores or dashes. Upon clicking the update data button, everything is consolidated into one xls table on the statALL sheet. The Kratr sheet will be filled based on the selected distribution strategy across 9 columns from the SQL. If no match is found, ignore the data, do not fill, do not add new rows to Excel, etc.

Proposals 2 Rejected 1

Oleksii D.

1 1

Projects -
Rating -
Rating -124

Budget: 2000 UAH Deadline: 2 days

Hello. I will do what needs to be done. But we need to look at the created process and data to understand exactly what needs to be done.

Yuliya Karmazina

22 0

Projects 21
Rating -
Rating 340

Budget: 1000 UAH Deadline: 1 day

Hello. Interested in the project. I will be glad to cooperate. Contact me.

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 16 proposals 31 July

Not specified
Construction of an automatic scheme for the movement of goods and monetary flows

35 proposals 30 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 41 proposals 27 July

178 USD
Development of an analytical system with a dashboard

Enterprise Resource Planning (ERP) 43 proposals 20 July

Not specified

Viktor Komarov
Odessa, Ukraine

Projects 2
Rating -
Rating 84

Power query in Excel data from SQL, and statistical distributions

Oleksii D.

Yuliya Karmazina

Proposals are currently absent

Vladislav S.

Current freelance projects in the category Databases & SQL

Development of the CRM module "Requests" in custom 1C (bus center)

Construction of an automatic scheme for the movement of goods and monetary flows

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Development of an analytical system with a dashboard