Adatmodellezés Jobs

I manage a product team that logs every engineering and analytics task as a Jira ticket. I need a reliable specialist who can step in on a ticket-by-ticket basis and close work related to both AWS data engineering and Power BI dashboard development. On the AWS side the tickets you will pick up revolve around building or extending data pipelines and handling the transformation / ETL layers that feed our analytics stack. Expect hands-on work with typical services—think S3, Glue, Lambda, Redshift or Athena—and plenty of Python or SQL scripting to keep things automated and testable. Once the data is landed, many tickets jump straight into Power BI. Your focus there will be on stitching new data sources into existing models and turning those datasets into polished, well-documented...

I want to turn our sales figures into a clear, interactive story in Power BI. Right now there is no central data source, so the first step will be helping me collect and structure the raw sales data—whether that means pulling CSV exports from our ecommerce platform, connecting to our CRM API, or setting up a small database that we can refresh automatically. Once the data is in place, you’ll handle the cleaning, transformation and modelling in Power Query and DAX, then design an engaging report that lets managers spot trends, compare product lines and track performance over time. I’m open to whichever mix of bar, line, pie or other visuals best conveys the insights, and I value your creative recommendations here. Deliverables I need from you: • A refreshable d...

I need a production-ready dashboard built in SAP Analytics Cloud that pulls live data from our SAP HANA system. In addition, the design should allow me to enrich those HANA figures with supplementary feeds coming from a couple of REST APIs and a small relational database we already maintain, so please keep connectivity flexible. The finished story must present our KPIs through interactive charts, clean tables and an intuitive map view. Think drill-down, filter panels and responsive layouts that look just as good on a laptop as on the SAC Mobile App. Performance is critical; the dashboard should open quickly and refresh without noticeable lag, even when running live against HANA. I will provide access to the HANA views, API endpoints and a sample of the external database. You will model t...

Developed a Pharmacy Management System using SQL to design and build a relational database for managing essential pharmacy operations and data. The project includes tables for Suppliers, Drug Categories, Medicines, Pharmacists, Invoices, and Invoice Details, with properly defined Primary Keys, Foreign Keys, and relationships between tables. Implemented data insertion, retrieval, filtering, sorting, and modification using SQL queries, including Aggregate Functions, GROUP BY, JOINs, and Subqueries, as well as INSERT, UPDATE, and DELETE operations. Technologies: SQL Server, Database Design, Relational Databases, SQL Queries.