Dw Bi Projects
Looking for freelance Dw Bi jobs and project work? PeoplePerHour has you covered.
Power BI Developer
Key Responsibilities: Develop functional & operational reports & dashboards. Build automated reports and dashboards with the help of Power BI and other reporting tools. Understand business requirements to set functional specifications for reporting applications. Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX Be able to quickly shape data into meaningful reports and analytics solutions. Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more. Analyse data sources and ensure data quality and integrity. Design and develop efficient data models in Power BI, ensuring optimal performance and scalability. Transform raw data into meaningful insights by implementing appropriate data transformations. Develop visually appealing and user-friendly dashboards, reports, and interactive visualizations in Power BI. Implement complex calculations and custom measures to meet business requirements. Leverage DAX (Data Analysis Expressions) to create advanced calculations. Integrate data from various sources into Power BI, ensuring seamless connectivity and data refresh. Utilize Power Query to clean, transform, and shape data for reporting purposes. Collaborate with cross-functional teams, including business analysts, data engineers, and IT teams, to ensure alignment with overall business goals. Conduct regular stakeholder meetings to gather feedback and make necessary adjustments to BI solutions. Provide training and documentation for end-users to ensure effective use of Power BI reports and dashboards. Monitor and optimize the performance of Power BI reports and dashboards. Ability of learning new tools to enhance the data quality and visualizations. Qualifications and Skills: Bachelor’s degree in computer science, Information Systems, or a related field. Proven experience as a Power BI Developer or similar role. Strong knowledge on Azure Data Lake, Data Factory and other data services Strong proficiency in Power BI, including data modelling, DAX, and Power Query. Solid understanding of relational databases and SQL. Experience in ETL processes and data integration. Excellent analytical and problem-solving skills. Strong communication and collaboration skills. Ability to work independently and as part of a team. Preferred Qualifications: Microsoft Power BI certification. Experience with other BI tools (Tableau, QlikView, etc.). Knowledge of data warehousing concepts. Familiarity with cloud platforms (Azure, AWS) for BI solutions.
14 days ago22 proposalsRemotePower BI Support
Reporting to the Technology Manager, and in collaboration with IT, the BUMs and a team of PowerBI analysts, you will be responsible for: - Follow up on the enhancement and creation of the current company reports, from modeling to the creation of measures in DAX and requested charts. - Improve the connection of PowerBI with different sources (Hubspot, SAP B1, Bizneo, among others), analyzing the information that feeds the different reports. - Analysis of other analyzable business data such as KPI's of solutions or specific areas to create new dashboards, helping to improve the vision to Management for strategic decision making. - Improvement projects of existing reports.
19 days ago23 proposalsRemoteopportunity
Power BI Project & Ongoing Retainer
Dear Sir/Madam, We are a London based professional services firm, seeking to work with a UK based Microsoft Power BI expert in understanding our current Power BI data and how/where we can further use this data to enhance the business analytics of the firm. This will be an initial project, with the option for an ongoing retainer. Please only apply if: a) You are UK based and have clear proficiency in communicating by email and verbally (MS Teams/Zoom). b) Have a detailed understanding of existing (and new new) Power BI model. c) Interested an ongoing monthly work flow. Thanks & Kind Regards,
12 days ago17 proposalsRemotepre-funded
Give us a feedback
Help with Data Science. Business Intelligence. Data Analytics You are working with data. You use data visualisation tool(s) and have something to say about it. Watch our 3-minute video, and have a 30-minute call where you can tell me about the tools you are currently using in your work. Expert Data Visualization Specialist: Power BI / Tableau / Qlick / Klipfolio / FusionCharts / any other. Tell us about your working day, show us a project which you are working on in your current tool
13 days ago15 proposalsRemotePart time Marketing coordinator for B2B tradesman software
The role is to use marketing, across both acquisition and retention, to drive cost-effective subscriptions, upsell opportunities & brand awareness, to put Workever firmly on the map as a field management software solution. It requires a self starter, used to a level of autonomy. About us: We are a growing software startup specialising in field service and job management solutions for service and trade businesses like plumbers, electricians, and maintenance professionals. Our software empowers these companies to efficiently handle their jobs, schedules, invoices, and field operations. Currently, our focus is on the UK market, catering to micro and small businesses with customer sizes ranging from 2-40 staff members. As well as some small paid campaigns in other UK speaking territories such as Australia and New zealand Skills required: - Organised and task driven - Confident in the use of Google Analytics, Wordpress, Intercom, Mailchimp & Meta - Proficient and writing and publishing SEO content - Ability to collaborate effectively with agencies, freelancers and the rest of the team - Understanding of SaaS business to drive subscriptions at a sensible ROI - Nice to have - Ability to design/edit in Figma & experience with Capterra/Google Ads Day to day tasks: - Nurture the current lost leads with offers and upsell opportunities - 2 X Blog posts per month. Writing thought provoking posts and sharing this across social media and trade groups. - Look for opportunities with SEO to create new pages on the website that drive traffic - Look for opportunities to improve current pages conversion rates - Experience with Google analytics to understand data and provide a monthly report on performance - Collaborate with freelancers and agencies - Bi monthly newsletter to upsell our subscriptions, promote new features and ask for referrals - Continuation, review and cascade of NPS surveys & results to drive continual improvement and promote more positive reviews online - Ability to write engaging email content with a focus on conversions.
10 days ago20 proposalsRemoteI need a designer
I seek an experienced visual designer to craft the user interface and experience for a new mobile application. The application will enable users to book appointments with local businesses through an intuitive onboarding process and easy-to-navigate dashboard. Your skills in interaction design, prototyping and visual design will be leveraged to create intuitive app screens, seamless workflows and aesthetically pleasing branding. Key deliverables will include high-fidelity mockups demonstrating the app's core functionality and key screens such as login, signup, appointment scheduling, profile management and payments. You will synthesize user research findings to optimize tasks and create an engaging yet simple UI. Prototyping tools like Figma or Sketch will be used to produce interactive previews for feedback prior to development. Branding guidelines, style tiles and component libraries should also be developed to ensure visual consistency across the app. This is an exciting opportunity to design an application from concept to launch. Applicants should have 3+ years experience designing mobile applications with demonstrable case studies. Proficiency with common design and prototyping tools is essential. The candidate must have excellent communication skills and be able to work collaboratively with stakeholders to refine designs based on feedback. This contract role will last 4-6 weeks with payment issued in bi-weekly installments upon acceptance of deliverables. Please provide relevant work samples and testimonials from previous clients in your proposal if
25 days ago24 proposalsRemote
Past "Dw-bi" Projects
I need help with writing a Power BI dashboard
Salaam Alaikum. I need help preparing data and building a Power BI dashboard. I won't need you to build it all but need some time pairing with me to work through some issues as I am new to Power BI development. I can't tell you up front how many hours it will take but I can pay per hour for the number of hours used. You need to be able to work with me screensharing for the hours needed.
opportunity
Power BI replication of excel spreadsheet
I need a replication of the attached xls into Power BI (columns K:AD). I would also like that the data feed will be automatic into Power BI from web query (https://www.youtube.com/watch?v=o5y0m4zF6VU) via a dynamic stock quote, I will scrape via Yahoo Finance. Thus, the data and statistic analysis will update for whichever stocks I maintain in the backtable/xls. In DoR worksheet, all cells in yellow will feed from the above scraping, the orange cells need to be calculated in the query. For the visual in BI, something close to layout in columns (K:AD) is needed - which includes some statistical calculations (formula shown in xls). Ideally I would be able to toggle between the 3 data sets within the same sheet i.e. calculated for i) close-close returns, ii)high-low returns and iii) open-close returns.
opportunity
I need some drawings for small planning application
We are needing to put in for planning permission to replace a large glass window and replace it with bi folding doors. It is a commercial building in a conservation area but surrounding properties have the same and having spoken to the planning office its a simple application. What I require is some detailed drawings along with measurements that will be acceptable to the planning department. Am looking for this to be done asap
opportunity
Power BI Dashboard Created
I seek a skilled Power BI professional to develop an interactive monthly dashboard reporting on key performance indicators related to group expenditure. The dashboard should provide visual analysis and insights into budget versus actual spending across various cost categories. The contractor may also need to optimize the underlying Excel data model that will serve as the data source for the dashboard. Dynamic visualizations like charts, graphs andmaps should be incorporated to highlight trends, variances or other metrics. Spending data for the past 12 monthsneeds to be presented to facilitate performance comparisons over time. Users require the ability to filter the dashboard by different dimensions such as business unit, project or location. The reporting capability must also support easily configurable time periods so leadership can view KPIs for the current month, quarter or year-to-date. Security is important so access to the live dashboard needs to be restricted to specific users or user groups. Once completed, guidance will be provided on dashboard maintenance so our in-house team can independently refresh the data and customize visuals or metrics as needed. Proficiency with Power BI Desktop and DAX isessential to fulfill thee project objectives within 4 weeks.
Power BI report adaption
I have a power BI desktop report that I can't get the data relationships to work and columns to format correctly. Needs fixing as quick as possible
opportunity
Power BI (5) - P&L Charts
This project requires development of four charts in Power BI based on Profit and Loss data. The client needs visual representations of key financial metrics to gain insights into organizational performance. Visuals should show trends over time in areas like revenue, costs, profit margins etc. through bar, line or other appropriate chart types. Proper filters and formatting is expected to make data easily comprehendible. Development must follow best practices for data modeling and visualization in Power BI. Charts need to be pixel-perfect with labels, legends and titles as per the client's style guide. Interactivity through tooltips and drill-downs/ups would aid analysis. Project involves connecting to an Excel or CSV data source, development of four finely crafted charts presenting interrelated P&L metrics, applying conditional formatting and layout. Testing across desktop and web versions of Power BI is required before delivery. Attention to design aesthetics, usability and client needs is important. Proficiency in DAX and visualized analytics capabilities of Power BI is preferred for this project.
opportunity
Power BI (6) - Balance Sheet Metrics
This engagement requires developing advanced Power BI reports and dashboards to analyze key balance sheet metrics. The client, a mid-sized financial institution, needs customized visuals created to provide insight into trends in their assets, liabilities, and equity accounts over time. The visualizations should enable leaders to make informed decisions by highlighting areas of strength and weakness. The freelancer will be given access to the company's financial database containing historical balance sheet data. Advanced DAX formulas and measures need to be written to calculate critical metrics like current ratios, debt-to-equity ratios, and days of inventory outstanding. Interactive reports and dashboards then must be designed visually compelling and easy to interpret. Conditional formatting and other data bars will aid in comparing performance to internal targets and industry benchmarks. Dynamic tiles and card visuals are preferred to deliver at-a-glance updates of key performance indicators. Line, bar and area charts should be employed to show patterns in accounts over recent years. A fully labeled organizational chart is required to breakdown asset and liability compositions. Roadmaps and planned initiatives need to be integrated to forecast expected impacts to financial health. The end product will be a sophisticated, role-based dashboard delivering transparent insights to aid strategic decision making. Strong Power BI and financial analysis skills are needed to complete this impactful pro bono project.
I need an expert in Data Studio to Power BI develop dashboard
I am seeking a professional who can competently develop a Power BI dashboard. This professional needs to be adept at connecting to data sources, particularly Google Analytics. Primary Responsibilities: - Establish connection to Google Analytics for data retrieval - Design and create bar graphs to represent data. The dashboard should be capable of displaying less than 5 different data metrics. This project is ideal for those having an excellent grasp of Google Analytics & Power BI, along with interactive data visualization skills. Proficiency in creating bar graphs is pivotal.
urgent
Power Bi Dashboard - clean and replace data source
We produce Engagement surveys using Power Bi for the final analysis. Our data analyst is currently overloaded and we need someone to fill in for this project. We have a fully functioning Power BI dashboard of six pages (see screenshots attached) which connects to an Excel workbook stored in the same directory as the Power BI file. I will provide the Power BI file, the original Excel worksheet and the new Excel worksheet. I want the new Power BI file and new Worksheet to be connected in the same directory. We need to replace the current Excel workbook with the new workbook and make sure it works. The structure of the raw survey data is identical. There are only 120 rows in the data. This is not a big data project. The only difference is very minor in the number of statements and the number of demographic scale items. The number of demographics is identical and the layout of the dashboard should be identical (you are welcome to improve some of the slicing visuals but this is not important). It is very straightforward with standard dashboard features with two exceptions: The Cluster analysis - Make sure you are comfortable with this aspect of the analysis The Text analysis - This is not actually very difficult but it does take time. There are almost 200 text statements split into three categories. I would allow at least three hours to work your way through this manually (we usually allocate 50% of the time for this element) We would normally allow 5 hours for this but I am allowing up to 10 hours since there will be some learning for you on this project You must: 1) Convert/clean the new data source to ensure that it works with the dashboard 2) Check that all the logic works as it should including the qualitative (text) analysis. This can be done manually or via an AI device, but must be sense checked by a human being at some point We can discuss how you might wish to improve the design, once the project is complete (it would become another project) I am looking for someone who has: Excellent written and spoken English At least 3 to 5 years in data analysis and Power BI / Excel expertise It would be nice if you had experience with B2B surveys such as Engagement/Satisfaction/Diversity/Inclusion etc Please start your reply with the word "Blackpool" so that I know you have read to the end. I do not waste my time replying to anyone who does not fulfil this. Please DO NOT use AI to autofill your reply(or use it very judiciously) as I am getting very tired of overlong, hyper detailed replies that just waste my time and give me no idea as to how competent you are. Many thanks Chris
Database Management System (DBMS) Migration Specialist
Job Description: We are seeking a skilled Database Management System (DBMS) Migration Specialist to assist in transitioning from Google Sheets to a more robust solution for managing production data. The successful candidate will be responsible for recommending and implementing the migration to a suitable DBMS, such as MySQL or PostgreSQL for structured data, or MongoDB for semi-structured data. Integration with data integration tools like Apache NiFi or Talend will be required to streamline the migration process. Additionally, expertise in utilizing BI tools like Tableau or Power BI for data analysis and visualization is essential to enhance decision-making processes. Consideration of cloud platforms such as AWS or GCP for storage solutions will be part of the project scope. Skills Required: Proficiency in database management systems, including MySQL, PostgreSQL, and/or MongoDB. Experience with data integration tools such as Apache NiFi or Talend. Familiarity with BI tools like Tableau or Power BI for data analysis and visualization. Knowledge of cloud platforms such as AWS or GCP for storage solutions. Expertise in frontend frameworks like React.js or Angular, and backend technologies like Node.js or Django. Experience Level: Intermediate to Expert Budget: To be discussed based on experience and project scope. Timeline: Flexible, with preference for timely completion. Communication Preferences: Regular communication via email, messaging platforms, or video calls as needed. Additional Requirements: Ability to recommend and implement the most suitable DBMS solution based on project requirements. Experience in migrating data from Google Sheets to the chosen DBMS. Proficiency in setting up data integration pipelines and configuring BI tools for effective data analysis. Familiarity with cloud storage solutions and best practices for data management. Strong problem-solving skills and attention to detail. Portfolio or Sample Work: Interested candidates are encouraged to provide examples of previous DBMS migration projects or relevant experience. Terms and Conditions: Terms and conditions will be discussed and agreed upon before the start of the project. Call to Action: Interested candidates are invited to submit their proposals, including relevant experience and proposed approach for the project. Review Process: Proposals will be reviewed based on qualifications, experience, and proposed solutions. Shortlisted candidates may be contacted for further discussion.
Data Visualization project
I seek an experienced data visualization professional to develop compelling visual representations and analyses of a proprietary dataset. The target audience for the resulting data visualization project and report includes non-technical stakeholders. The dataset contains yearly sales, profit, and expense metrics for over 500 companies spanning 10 industry sectors over the past decade. The goals of this project are to identify key trends, patterns, and outliers within the dataset in a visually engaging manner. Visualizations should utilize charts, graphs and interactive dashboards as appropriate to succinctly convey insights and tell a story from the numbers. Proficiency in Tableau, Power BI or similar tools is preferable. The final deliverable will be an polished, informative data report incorporating 5-7 visualization assets along with a 2-page executive summary analyzing findings for leadership. Experience designing data presentations for lay audiences a plus. Creativity and clarity of communication are highly valued. Applicants should demonstrate strong information design skills along with an ability to distill complexity into visual simplicity. A compelling portfolio showcasing past work with diverse datasets through a variety of visualization types1 is requested.
Power bi dashboard
I need dashboard for hr analytics
opportunity
Microsoft BI Dash board for Accounting & Finance Reports
I'm looking for someone to design a company-specific Microsoft BI Dashboard for us to use for our Management Accounts & associated reports. We will provide a brief on what we're looking to achieve from these reports, such as: Monthly Management Accounts KPIs Client Data Sales Data
Azure Data Engineer
Requirement Azure Data Engineer Experience 6+ yrs Project Timing 2 PM – 11 PM (2 nd shift) Skills- Databricks, SQL, Pyspark Databricks Certification- Good to have Good comm's and problem solving skills o Relevant experience in Azure data engineering: 4+ years. o Relevant experience in Databricks (PySpark / Scala / SparkSQL): 2+ years. o Relevant experience in Azure Data Factory (ADF): 2+ years. o Relevant experience in SQL: 2+ years. o Experience leading a small team o Required Skills: Azure Synapse, Azure Analysis Services, Azure Data Lake Storage, and Azure SQL databases. o Good to have: Power BI, Azure IAAS services, Python, and Excel