Find Jobs
Hire Freelancers

Power BI Report Optimization - Sales Funnel

$25-50 USD / hour

Terminado
Publicado hace más de 5 años

$25-50 USD / hour

Project Overview Liquid Web adopted Power BI approximately 2 years ago. The very first report we built has grown in complexity and importance during that time. We are now to the point where we understand how to optimize this report, the problem is we lack the capacity to break down this report into smaller chunks. I am looking for additional capacity to help us clean up this report and data model to improve our ability to maintain this report in the future. This critical report currently pulls data from Salesforce, excel sheets, and our data warehouse. It then does a large amount of filtering and data manipulation within Power Query and Dax, then represents the data in ~90 different report pages. We now have all of the SFDC data in our data warehouse. I need someone who can move as much of the data manipulation as possible into SQL queries to reduce the complexity in the report. It seems likely that separating this one PBIX into multiple files will be helpful and is a very acceptable outcome of this project. If this project goes well, future projects are very likely to continue. I am looking for someone who is interested in continued projects to add capacity for our team. Below is an overview of the current data model: Expectations The primary deliverable from this project will be a PBIX file that meets the following requirements: All facts, numbers, and data either: Match the current version of the report. Or have an explanation of how the current report was showing data incorrectly. Reports are consistent, readable, and tell the story of the data (We rely on the underlying data, but are not attached to the current format of the reports) Is refreshable through our enterprise gateway. Is maintainable and extensible I believe the majority of the work to meet those requirements lies in writing SQL, reducing complexity in the data model, and changing the source of some of the data from excel / SFDC to the data warehouse. All of that said, I am very open to the experience of whoever takes the job, and am very open to other approaches. As long as the requirements above are met, the project will be considered a success. Timeframe I am ready to tackle this project immediately. I am open to how long you expect this to take. I don’t expect the project to be huge, maybe a week or two.
ID del proyecto: 17904909

Información sobre el proyecto

28 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014 certificate, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, data warehousing, and Business Intelligence related projects and tasks. I am a near-native English speaker, currently available, and results oriented. I am an expert SQL developer, who also have experience designing and building reports using tools such as Power BI, Qlikview, SSRS, and many others. I've read your requirement, and I can deliver what you require, with database analysis, report design and construction, and writing robust, efficient, and easy-to-understand SQL queries and DAX code. Also, I think this project shouldn't take more than 10 working days (if less). I've finished similar projects before. Finally, I am located in the Central Timezone (GMT -5h). We can discuss details over chat, if you like. Thanks!
$35 USD en 40 días
4,9 (23 comentarios)
5,9
5,9
28 freelancers están ofertando un promedio de $39 USD /hora por este trabajo
Avatar del usuario
Hello! My name's Sandeep and I was glad to see that you're looking for help for project Power BI Report Optimization . Please let me know when you need this project to be completed and your minimum budget. I've delivered more than 400 projects in the last 3 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I have more than 5 years of experience in Business Analysis, Data Processing, SQL, Statistical Analysis I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Please find my portfolio link below for your review: https://www.freelancer.in/u/schoudhary1553 Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon to discuss more details related to project.
$44 USD en 40 días
5,0 (275 comentarios)
8,0
8,0
Avatar del usuario
Hi there,I am Miljan,Power BI expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$29 USD en 40 días
4,9 (109 comentarios)
7,4
7,4
Avatar del usuario
Hello, I am an experienced Power BI developer with over 8 years in the field. I can deliver you quality work in this project. Please check my portfolio to see my work. Thanks!
$50 USD en 40 días
4,9 (56 comentarios)
6,9
6,9
Avatar del usuario
Hello! I’m experienced Python developer, and data processing is one of my main fields of knowledge, so I’m 100% confident that I can complete your project. I've strong knowledge in SQL and different BI programs. Please contact me to discuss project details, Best regards, Vlad
$45 USD en 40 días
4,9 (40 comentarios)
7,1
7,1
Avatar del usuario
Hello Sir, I am an expert in PowerBI and would like to discuss this project with you. Thanks Aanvik
$35 USD en 3 días
5,0 (44 comentarios)
6,6
6,6
Avatar del usuario
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$50 USD en 40 días
4,6 (126 comentarios)
7,1
7,1
Avatar del usuario
Hi, I am highly interested in assisting you. I am a professional Data Analyst holding years of experience in utilizing various data analytics, and automation softwares to optimize, calculate, analyze and automate various process to perform financial analysis and business analysis. I will be happy to discuss in detail how I am highly suitable for this project.
$25 USD en 10 días
4,8 (84 comentarios)
6,4
6,4
Avatar del usuario
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 10 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
$41 USD en 40 días
4,7 (50 comentarios)
6,1
6,1
Avatar del usuario
Hi Based on your problem statement 90 page report seems very high and my approach would be to do the following 1) Identify the areas of the report that can be broken down into different reports 2) Re look at your Data warehouse design and data manipulations done in Dax. Based on the feasibility of doing as much as possible before the data hits the Dax layer would like to move the logic to data integration part or data preparation part. This will reduce complexity of the reports. I have excellent experience in database design and writing complex queries. I have nearly about 5 years of experience working in BI and related areas using Microsoft stack of products. I have extensive experience in Analytics and Visualization. I have worked in analytics for the past 3 years . I was in Infosys for more than 16+ years and as part of this i was managing analytics projects for more than 3 years. I have worked on different data analysis problems such as Churn, Forecasting problems etc. I have also developed many dashboards for our customers to provide meaningful insights for them. Have used technologies such as Excel, Power BI, Tableau As part of my Infosys tenure i have been working with Microsoft as customer delivering projects in MS technologies. I would like to assess the complexity of the project and come up with a time frame for executing the project. May be once we agree on the approach etc i can even suggest a fixed price bid. Thanks Regards Vaidy
$32 USD en 40 días
5,0 (12 comentarios)
5,2
5,2
Avatar del usuario
As a specialist in creative business accounting, writing, the multitude of services I provide my clients, truly knows no bounds. In fact, you might say I am a jack of all trades ,I can provide successful solutions for anyone seeking out Business Plan, Business Proposal, Business Writing, Business Report, Market Research report etc. For Complete Business Plan you will need to provide me :: Business Name, CEO Name, Partner Information, Business Address, Website Address, Is it to finance from Bank or investor?, Business Logo, the amount you want to finance, Startup Cost. Similar Business Name By using my services you will improve your chances of success!! Solid Skills and Writing Capabilities That Meet Your Every Need!! I haven't met a topic that I'm not comfortable writing about. I've written for many niche topics, and have done extensive copywriting work
$41 USD en 40 días
5,0 (2 comentarios)
3,9
3,9
Avatar del usuario
Freelancer content We are an established Certified Public Accountants firm since 2008 based in India.  We are a team of two CPA's & six Chartered Accountants.  We currently offer services to overseas clients based in USA, Australia, Canada, UAE, UK & Singapore.  We have an extensive experience of providing the following services:   Management Consultancy Business Analytics (Power BI, SAP BOBJ etc.) Bookkeeping Services using Intuit Quickbooks Financial statements preparation Financial project report writeup Financial Projections General ledger maintenance Accounts payable Accounts receivable Bank Reconciliation Payroll processing Sales & use tax compliance Tax returns Other than the above mentioned services we can customize our services as per your requirements.  We have a very strong team and good number of professional head counts who can consistently provide you with real time assistance. You will get to see 3 qualities in our services- Timely completion Qualitative work Data security  We are looking forward to speak with you for your requirements and assist as appropriate.  Sincerely, Dev Kothari -- Sincerely, CA Dev Kothari ‪+91 9428079401‬
$27 USD en 3 días
5,0 (3 comentarios)
3,7
3,7
Avatar del usuario
Hi, I've been developing reports in Tableau and PowerBI for last 4 years. I am very good at data transformation using Excel, Access, SQL and SAS. I can definitely help you with this work. Please contact me. Thanks, Amit +91-9958735585
$27 USD en 50 días
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
Hi, i have been working with power bi for the past 3 years, yet i have done so many similar work before that on excel all the time during my line of work, i am an IT Quality manager. and process improvement engineer. i took a look at your data model which is i trust needs simplification. i hope i can work with you on this project it seems challenging and it requires utilizing all our power bi skills. yet, from what i read from you job description/requirements we will surely need to apply a lot of power query and do a lot of data mash up. this is is my area "ETL" and all around data cleansing and data modeling, so i hope i can be of help. looking forward working with you. i dont have history of achieved work on freelancer yet i have done similar work i will be happy to show you
$41 USD en 40 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
Hi , I have more than 10+ years of experience in Reporting (Business Intelligence/operations-MIS), excel based dashboard, data analysis, data management, report automation etc. Pls. message me to discuss it further. Timing mentioned is approximate, will commit once i go through all raw files. Thanks,
$41 USD en 40 días
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Dear Recruiter, We are a CA-based in-house Web/App Designing and Development Agency. We are a full stack team of website designers and developers having expertise in Designing, Developing Creating Database and Maintaining websites and applications using modern HTML, CSS, JavaScript, Bootstrap, JQuery, PHP, CakePHP, Shopify, Joomla, Laravel, Javascript, jQuery, Yii2, Woocommerce, WordPress and are skilled enough to work on various Frameworks. We can efficiently implement payment methods like PayPal pro, API Integrations, Stripe, Amazon Pay, Google checkout, Shipping and many more integrations for payment processors. We always regard the requirements of the project and guarantee to provide the outcome as required. Looking forward to hearing from you. Regards iGeekTeam LLC.
$44 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Write an SQL query to bulkcopy the relevant data out in to a file in the desired format.
$41 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Have been in consulting role for more than a decade and working on BI and datawarehousing /migration projects for big enterprises for both OLTP and OLAP structures with millions of records.
$83 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, As per the description of the project, I get that you have some prebuilt Power BI reports, data coming from multiple sources. Now, you want to optimize those reports. I had worked on this kind of project in my job for Coretech (a WPP Company). They had the same issue with their Power Bi reports where data comes from 3-4 different sources. First, I optimized those reports and then automated all the steps. so that they can have all the real-time reports with all the security features they require. Also developed some general reports with relevant filters so that they can filter data as per requirement and directly export from Power BI service in PPT format to use in their governance meetings. All these reports were used by CXO's of the company so quality was the test & I passed with distinction & got nominated for different awards in the organization. For your consideration, I can share some of the reports & dashboards with dummy data. As per your requirement, I can work for the long-term or short-term. If you like I can work on a pilot project just to make you understand how I can go further in this project. Looking forward to work on this project. Thank you Best Regards, Ashish Gupta Int. Master Science. Applied Mathematics IIT Roorkee.
$41 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have done this type of requirement in my projects. I used conga composer to generate report. We can use merge field to bind data into excel, word and pdf files. We can manipulate data in excel as per business requirement. I know SOQL query very well . I have 3+ year of experience in SFDC and reporting tools. We can also schedule the report generation using conga composer and set the time to generate mail with file in attachment. We can talk further in chat if you are ready to work together.
$33 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a UK-based Senior BI Developer in Manufacturing and Supply Chain for a global firm. I use SQL daily and I have created numerous Power BI dashboards that link directly to it. Relevant Skills and Experience Microsoft Certified Professional in T-SQL Querying and regular user of Power BI, cresting dashboards based upon SQL data for Senior Management.
$31 USD en 20 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Lansing, United States
5,0
3
Forma de pago verificada
Miembro desde oct 5, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.