Ms Bi Projects
Looking for freelance Ms Bi jobs and project work? PeoplePerHour has you covered.
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.
7 days ago36 proposalsRemoteopportunity
Data Extraction and Input
Hi all, I am looking for help to pull some price modelling data from an website and place it into an excel file that replicates how it is shown on the web page. There is a lot of data and I do not think it can be exported, it needs to be done manually. I do not think it is viable to scrape the data. Once we have pulled the data we then need to build charts / data filtering to display the data correctly. My feeling is that the freelancer that does the job will need to be an expert an MS excel. It would be easier to do a Zoom call to show the freelancer the system and explain fully what is required so the price below is a placeholder. Thanks!
4 hours ago45 proposalsRemoteI 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.
23 days ago27 proposalsRemoteopportunity
Read/write data via GraphQL API to MS Access/Sql Server
"read/write data via GraphQL API to MS Access/Sql Server" We're a children's nursery, in the process of moving to a Nursery management service hosted on web We are a childrens' nursery using a web-based nursery management software called Famly. They use GraphQL for their api. We currently use MS Access DB but planning to move to SQL Server or similar. I need a set up for me to pull various sets of data via their api provided as e.g. row/column data to write/update our database. I also want functionality to write key information to Famly via their API by providing row/column data etc. The work would consist of configuring API access to our data in Famly with functionality to read and write data to/from Famly from our database.
11 days ago28 proposalsRemoteDatabase 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.
18 days ago15 proposalsRemoteAzure 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
16 days ago13 proposalsRemoteopportunity
Help writing & designing a Research Consultancy Proposal/Pitch
I need someone experienced with writing investor pitch packs or research/management consultancy pitch packs who can help me with the creation of content and designing a 8-10 slide MS PowerPoint presentation to pitch my research consultancy project. efining the Brief: Please help me produce a Compelling Narrative: Weave a story around the problem and solution, engaging the audience with the importance of the research. Pitching the Research Problem: Leveraging my initial write-up to create a strong problem statement. Use data and industry trends to illustrate the criticality of understanding AI's impact on banking business models. Frame the research as a strategic opportunity to gain a competitive edge. I can offer a capped price and can provide 7 days as a timeline however I will need to see a draft by Day 3 (even if it is just a start).
11 days ago32 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
a day ago17 proposalsRemoteSeeking Experienced Freelance Administrative Assistant
Are you a detail-oriented administrative professional with a knack for organization and exceptional communication skills? I am currently looking for a freelance administrative assistant to support my business. As a key member my team, your primary responsibilities will include managing client correspondence, handling incoming mail/messages, and efficiently scheduling online meetings. This freelance position offers a competitive hourly rate of $20 and provides an excellent opportunity to work directly with my finance team. Please note that this is not an outsourcing project. - Responding promptly and professionally to client inquiries via email and phone - Managing and prioritizing incoming mails. transferring to appropriate team members when necessary - Coordinating and scheduling online meetings, ensuring all parties are informed and prepared - Providing administrative support to the finance department as needed, including data entry, file organization, and document preparation Requirements: - Proven experience as an administrative assistant or similar role, preferably in a finance or business setting - Excellent communication skills, both written and verbal, with a professional demeanor - Strong organizational skills and attention to detail, capable of multitasking and prioritizing tasks effectively - Proficiency in MS Office Suite (Word, Excel, Outlook) and familiarity with online meeting platforms - Ability to work independently with minimal supervision, while also collaborating effectively with team members
a month ago44 proposalsRemoteSpanish-Speaking Video Editor Wanted for Crypto YouTube Channel
Hello to all video editors! We are on the lookout for a Spanish-speaking editor to join us in our exciting mission to create Spanish-language video content that serves as a true atlas for the crypto world. We aim for our videos to be not just informative but also entertaining and accessible to Spanish-speaking audiences everywhere. What Are We Looking For? We seek a creative and technical editor, experienced with Premier, Davinci, or Final Cut Pro and possessing a strong interest or curiosity in cryptocurrencies. Fluency in Spanish is a must, as our content will cater specifically to Spanish-speaking audiences. If you have a portfolio that showcases your ability to create dynamic and appealing content, preferably for YouTube, and in Spanish, we'd love to see it! Your Role on the Team: Work with us to make our Spanish-language cryptocurrency videos easily understandable and visually appealing. Use the provided editing instructions as a starting point, but feel free to bring your experience and creativity into the process. Collaborate on our first project: an introductory video about "What is Bitcoin" in Spanish. How to Apply? If you are interested in this opportunity, please send us a message with examples of your previous work that reflects the style and quality we are looking for, especially in Spanish. Make sure to include any relevant experience in editing videos for digital platforms, especially YouTube, in Spanish. Please review the following material before sending us your application: Link to sample/raw video: https://drive.google.com/file/d/1cVEmvBn5ZbWKHfL02CdutsmK482qLPu1/view?usp=drive_link Link to editing instructions: https://docs.google.com/document/d/1czpimIB1TLXLNDqfG40nQz6HMGhZYckrdvnoEbbnApU/edit?usp=sharing We're eager to see how you apply your skills to transform this content into something dynamic, educational, and entertaining for Spanish-speaking audiences. Selection: We will start with a paid trial task editing the "What is Bitcoin" video in Spanish following our specific instructions. This will be a crucial step in choosing our long-term collaborator, so we are looking for candidates who are open to ongoing engagement and fluent in Spanish. Compensation and Deadlines: The trial work will be compensated. Compensation for ongoing work will be discussed later, based on experience and the quality of work delivered. We aim to publish a Spanish-language video weekly/bi-weekly and would like to have an estimate of your availability and delivery times. Apply Now! Send us your application. We're excited to see your creativity and skill in action and potentially welcome you to our team, specifically focusing on engaging our Spanish-speaking audience.
18 days ago11 proposalsRemoteopportunity
Marketing Expert for Client Acquisition in Data Analytics Sector
We are a startup data analytics company seeking a highly skilled marketing expert to help us find new clients. Our services are centered around providing top-tier data analysis solutions to mid and large market businesses, utilizing the most advanced tools and AI techniques available. The successful candidate will be responsible for developing and implementing a comprehensive marketing strategy aimed at generating leads and facilitating meetings for our sales team. Key Responsibilities: - Design and execute a marketing plan that effectively targets our ideal customer segment. - Experience in using lead generator tools to build a robust list of potential clients. - Conduct outreach to generate leads and arrange sales meetings. - Analyze the performance of marketing initiatives to continually refine our strategy. Freelancer Requirements: - Expertise in lead generating tools to find the targeted clients needed for our business. - Proven ability in crafting and implementing innovative marketing strategies in the B2B space, ideally within the tech or data analytics domain. - A portfolio demonstrating previous marketing successes, particularly in lead generation and customer acquisition. - Strong communication skills for creating impactful marketing content and outreach communications. - Knowledge of data analysis tools would be a plus but not required (e.g., Tableau, Power BI, Adobe Analytics, HubSpot, Salesforce). We use these tools to provide data analysis services. Project Goals/Objectives: - Position our company as a go-to solution for businesses seeking advanced data analysis services. - Deliver a consistent flow of qualified leads to our sales team, driving customer acquisition and business growth. Timeline: Immediate start, with the goal of achieving measurable results. There will be opportunity for ongoing work for a talented freelancer.
a month ago19 proposalsRemote
Past "Ms-bi" Projects
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
Website Design for MS Excel Consultancy Business
I need an attractive website designed for an MS Excel Analyst contractor. Created in Wordpress. I will supply the content but need relevant images sourcing and adding. Feel free to get these from AI generation, images like Excel screenshots of data, Excel Icon, anything related to data and data analysis that looks effective. Each page will have text on and multiple images. The main links across the top will be About MS Excel Services VBA Experience Contact Us Within each link this will then bring up a page with the content i will supply and with the strategically places images you will source and add. I will need the SEO plug in adding to the site and anything else that will make it look effective. Please can you supply me with some examples of sites you have created. Thanks,
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.
opportunity
Short Wordpress project
Looking for someone to create a quick wordpress website that will utilize an MS Word document as a source for all the content and pages for the website. Could lead to other projects.
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
Edit PowerPoint Slides to match Company Website Branding
Hello, I would like a MS PowerPoint designer to edit this ppt. file: https://we.tl/t-We5GkV95ye You would need too match the colours, add logo's and images to match the look and feel of this website please: https://matthampsonfoundation.org/ Many thanks, Dan
Design MS Word Document Template
I need a designer who could build out a word document template. The template should contain: - A cover page (With space for a company logo to be added and document title) - A contents page - Designed headers and footers - Example sections / titles / text - Font / colour / size for each element It should use this logo as an example.
Convert the PDF attached into an MS form with scoring
Convert the PDF attached into an MS form with scoring for each answer given. Create a form that can be completed in MS Forms - note the score attributed to each answer.