Power BI
11 USD In the application, there are sales data for 2 years in one Excel file. Sales are divided into three tables, separately for the actual data for 2023 and 2024, as well as product data (name and price).
Task:
- Load all tables into Power BI using Power Query.
- Combine them into one table:
- Merge the actual data for 2023 and 2024.
- Attach the product name and its price to them.
- Load this single table into the Power BI data model (unnecessary tables can be deleted or set not to load).
- Add a calendar table to the model and create a relationship between these two tables.
- Build a chart with sales in monetary units for the entire period (you can create the total sales in monetary units either in Power Query or as a calculated column in the data model, or calculate it using a measure in DAX, whichever you prefer).
- Add a slicer (filter) to the chart with the option to select the product name.
Applications 1
Client's review of cooperation with Andrii Panichuk
Power BII am very satisfied with the work! The performer quickly handled the task and did everything well. Provided screenshots! I recommend!
Freelancer's review of cooperation with Yevhen Inchevsky
Power BIGreat client, I recommend to everyone!
Clear brief, quick review.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 13 hours 51 seconds back ∙ 3 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 14 hours 52 minutes back ∙ 31 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 15 hours 58 minutes back ∙ 16 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 7 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 3 days 12 hours back ∙ 35 proposals |
Odessa