Post in 1 month ago

Power BI Developer/Expert

Summary

The client already has a Power BI environment connected to a SQL database. However, the existing environment contains outdated custom transformations, manual records, and other interventions that are no longer maintained. The company is creating a new SQL server with fresh raw data and wants to build a cleaner, more reliable Power BI environment from scratch. Most existing reports and models are no longer used, so the client does not want to migrate everything. Instead, they want to rebuild the reporting system around updated financial data and newly defined corporate and functional metrics. Main objectives - Establish a best-practice data-source architecture. - Connect Power BI to the new SQL environment. - Develop reliable semantic data models. - Redefine financial and business KPIs. - Build new dashboards and reports. - Improve data consistency and reporting quality. - Reduce dependency on manual data interventions. - Create a maintainable reporting environment. The client will provide an initial roadmap describing reporting priorities and requirements for individual measurements and reports.

  1. Expected deliverables
  2. 1. Data-source architecture: Plan how Power BI will connect to the new SQL server.
  3. 2. Data transformation: Use Power Query to clean and prepare raw data.
  4. 3. Semantic model: Create tables, relationships, measures, and reusable business logic.
  5. 4. Financial metrics: Develop calculations for the newly defined financial reporting requirements.
  6. 5. Corporate and functional KPIs: Implement the agreed business measurements.
  7. 6. Dashboard development: Build reports based on the client's roadmap.
  8. 7. Data validation: Compare dashboard figures with source data and confirm calculations.
  9. 8. Documentation: Document data sources, transformations, models, and measures.
  10. 9. Maintainability: Organize the solution so future updates can be handled without relying on undocumented manual changes.
  11. The exact number of dashboards, tables, and reports has not been specified.
$2,000.00
Medium
Remote Job
Ongoing project

Skills and Expertise

Essential skillsMicrosoft Power BIPower BI DevelopmentPower QuerySQLData ModelingSemantic Model DevelopmentData AnalysisData VisualizationDashboard DesignBusiness IntelligenceMicrosoft ExcelData EngineeringKPI DevelopmentFinancial ReportingData TransformationData ValidationAdditional useful skillsDAX (Data Analysis Expressions)SQL ServerMySQLif used by the client's database environmentStarschema modelingFact and dimension tablesRowlevel securityPower BI refresh configurationData governance and documentationFinancial data reconciliationMost important skills: Power BIDAXsemantic modelingand financial reporting.

Activity on this job

Proposals:0 to 2
Last viewed by client:1 month ago
Interviewing:0
Hired:0

Explore similar jobs on Working Trust

Posted 10 days agoMedium
Proposals:0 to 2

Data Analyst for Business Insights

The client is looking for a data analyst who can help the business make better decisions through data. The freelancer will work with internal teams to understand business requirements, process and analyze datasets, identify patterns and trends, and communicate findings in a clear and practical way. The main focus is not just preparing spreadsheets. The client wants someone who can translate raw data into useful business insights. The work includes: - Understanding business requirements. - Reviewing and cleaning business data. - Identifying trends and patterns. - Checking data quality and accuracy. - Building dashboards. - Preparing clear business reports. - Presenting findings to internal teams. - Providing recommendations to improve operations.

UB

UK Business Insights & Data Analysis Client

Verified client

United Kingdom

$30.00 fixed price

Mandatory skills listed:Data Analysis+19 Skills

$ 450 spent

Payment Verified

Posted 30 days agoMedium
Proposals:0 to 2

A Website for Local Company Handling Water Supply

The client wants a website for a local water supply company in Riyadh, Saudi Arabia. The website should present the company's services, allow customers to contact the business, and support card payments. The client has provided two reference websites: - Fresh Water Supplier - Water Tanker Supply in Riyadh The references should help establish the desired design, layout, and water-supply service features. The client has not specified whether the website needs online ordering, delivery scheduling, customer accounts, or an administrative dashboard.

WC

WorkingTrust Client

Riyadh, Saudi Arabia

$200.00 fixed price

Required skills: Web DesignWeb Development+11 Skills

$ 450 spent

Payment Unverified