Report Automation: Power Bi -- 2

$10-70 USD / hour

Fechado

Publicado

há mais de 2 anos

$10-70 USD / hour

Goal: To fully automate and streamline QC Reports Table Source:100+ SQL Tables. A very sample of three data sets are provided Tables/Columns Structure: All Tables have different columns and potentially different number of records Report Requirements: • Platform: Power BI Desktop and cloud • Automation: Fully automated processes with quarterly updates • Programming: DAX • Due Date: Fully tested and delivered by two weeks from the start date Report Design: • The 1500 unique variables across 100 Tables can be grouped into: o Categorical Variables: Report (Cross tabulation) needs to present basic stats such as Count/Column % and Total by control variable (Site) in an elegant and clean Tables. See Template as an example o Continuous Variables: Report presents basic stats such as Mean, Median, SD, Range followed by BoxPlot of each variable by control variable (Site) in in an elegant and clean Tables o Filters: All report should include at least one common Filter (Will be specified later) o Missing Values: Missing should be excluded from all calculations but should be reported at in the Footprint of the tables • Report Layouts: Since each Table represents an instrument, it would be ideal to combine both categorical and continuous figures together (See template 2) • Navigation: Design should facilitate easy navigation for the large amounts of variable thru many pages. Perhaps a menu driven page at the beginning to list Tables • More details can be discussed when final candidate is hired • Final Step: A complete walk through of the design and formulas

Power BI

Microsoft SQL Server

ID do Projeto: 31205570

Sobre o projeto

36 propostas

Projeto remoto

Ativo há 3 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

36 freelancers estão ofertando em média $35 USD/hora for esse trabalho

@minaximarvaniya

Hello, I hope you're doing really well. I have checked your requirement and my skills are the best fit for it. I have successfully delivered a bunch of projects in this domain. I am excited to know more details about your project. I have 2 years of experience with proven ability to develop and implement BI solutions that drive informed decision-making through deeper business insight and hands-on knowledge of statistical modeling concepts. Developing BI application utilizing Power BI, Excel, and Tableau. Have excellent skills in Relational and multi-Dimensional databases, Data integration, Reporting. -Imported data from SQL Server DB, My SQL to Power BI to generate reports. -Designing and Developing the Dashboard Reports in power BI using advanced DAX. -Built graphs and charts of different datasets using R and Python -Build the data model in Power BI via connect different data sources in direct and import connection. -Proposed solutions in Agriculture Sector that can be solved by AI and ML -Successfully designed web-based dashboard -Analyze massive and highly complex data sets -Active participation in data modeling and data transformation Looking forward to your positive response, and a long-term partnership. Best Wishes, Minaxi.

$15 USD em 40 dias

5,0

(1 avaliação)

4,0

@aminechafai14072

Get your data manipulation and extraction fully automated and make your reporting reliable. I will walk you through specific steps on how I can accomplish that and will adapt to your environment and needs. Please reach out to me if you have any questions or to discuss your requirements in more details.

$30 USD em 40 dias

5,0

(6 avaliações)

4,1

@SGriMats

hey, My name is Stefano Grimaldi Matos, I am an industrial engineer by profession, I have 4+ years of experience in the fields of data analysis, generation of reports for decision-making and management meetings, economic evaluations of projects, process design, solution development of BI, active member of the Power BI community, as an independent consultant for more than 1 year, also a power BI instructor and for other Microsoft products, other experience include managing SQL database, SAP HANA Databases, among others data management skills, Powerapps, Power automate, Power Virtual Agent.

$16 USD em 50 dias

5,0

(7 avaliações)

3,3

@JPAnalytics

Hi there, Whilst I am new to Freelancer, I have 14 years of experience in process automation, reporting and data visualisation and specialise in Excel, Power Query and Power BI. Emigrating from the UK 9 years ago, I spent 7 years at Queensland Rail working directly with the 2011 and 2016 Census information to create insights into what type of demographics were within catchment areas of Queensland railway stations. I then merged this information with internal operational, people and safety metrics to get a gain powerful insights into how to maximise potential within the business. I have also completed work for ASX listed companies for the last two years in Geospatial, Census, Financial, Operational, People and Safety reporting. I would love the opportunity to do this piece of work for you and feel I can bring a wealth of experience from a technical perspective. I can also provide a sample report that could give you an idea of how a bland excel spreadsheet could be presented. I have put 7 days just to be safe as I am not sure how much work is involved but I am confident I could do it in less based on what you have said. Look forward to hearing from you.

$85 USD em 20 dias

5,0

(2 avaliações)

3,3

@chirag9700

Hello, How are you? I have read your project description carefully and I have rich experience in this type of work. Let me tell you about my expertise. I am Microsoft Expert. I have more than 7 years of experience in SharePoint, .NET and O365 technologies. Also 3+ years of experience in PowerApps and PowerBI. Expert in design and development. I have developed more than 30 Intranet, 15+ PowerApps and Several Reports in various domain. Looking forward to discuss your requirement further. Regards, Chirag.

$15 USD em 40 dias

5,0

(1 avaliação)

2,8

@ankitshah304007

*************************** SharePoint & Office 365 Architect ******************************** Hello Sir/Ma'am, I am a SharePoint & Office 365 Architect, Administrator, Analyst, Development Lead, and migration expertise with 15 years of experience on MS Office 365, SharePoint, and other Microsoft technology and have a Migration specialist with 10+ years of experience with silver partners with QUEST. Hands-on experience to work as a Solution Architect, a built-up development team with the strategic thinking of executing server migration plan and for SharePoint versions from 2010/2013 to Office 365 and on-prem 2019 release in the large organization across multiple farms. As a Migration Specialist Upgraded all legacy SharePoint versions to the latest available version of SharePoint on-premises 2019 as well as Office 365 including exchange and One Drive. Do Feel free to contact me if you have any queries for me and let's discuss more in detail about your project in a Private Message. I will provide you long-term support even after complete your project. Look forward to working with you on this project. Regards, Ankit Shah

$40 USD em 40 dias

5,0

(1 avaliação)

2,7

@devendrathakur12

Hi, your job posting (Report Automation: Power BI) has caught my attention, and I wish to have a conversation about the project. I read and understand your job post. With reference to that, I'm Power BI expert and using a wide platform. I guarantee that if you hire me, you will be impressed with the job that I do. Hiring me will be a great decision not only for the job but for future work as well. I am a high achiever, and I do not stop until the job is done right. I am committed to making my clients happy and content with the outcome of the job. check out my profile to see my expertise Please reach out with any questions and I'd be happy to have a chat with you. I hope to hear back from you. Best regards, Devendra Singh

$50 USD em 40 dias

4,0

(2 avaliações)

2,9

@VBAautomation

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010.I can handle your project in a very prudent manner. I read your project and after reading this i can say that i can fulfill your all requirements and i can handover this project to you by two weeks from the start date. Thank you

$60 USD em 40 dias

5,0

(1 avaliação)

1,6

@freelancer96500

Hi, I checked your requirement. I have experience in different types of dashboard & Automation using VBA CODE, Advance Excel, EXCEL Dashboard, POWER BI VISUALIZATION WITH DAX, Power query knowledge about Tableau ( database JSON file,CSV,MYSQL,SQL SERVER,EXCEL,CRM) please check my portfolio for more details Thanks TANVEER SINGH Individual Freelancer

$44 USD em 24 dias

5,0

(2 avaliações)

1,3

@DigitalStarDust

Hello Greetings for the day, We are team of freelancers expertized in various Microsoft tools, with hands-on experience in different segments of business, we will help you to fully automate your QC using Power BI. Requesting to open chat for further discussions. Regards, Team Fourty Fourty!

$57 USD em 40 dias

5,0

(2 avaliações)

1,4

@kavisilambarasan

Data Analyst with experience in Power BI, Excel, Python, MySql. Utmost care I read your project description. I can give the exact result as per your specification within the specified time. Always happy to hear from you.

$21 USD em 40 dias

0,0

(0 avaliações)

0,0

@diegochinchillab

Hello hope you doing well. i am a system engineer recently graduated and i have 6 months experience with power bi and i am about to take the certification da-100 exam, if i haven't lose you up to here i feel confident i can help you with your project with a low price but good quality.

$17 USD em 30 dias

0,0

(0 avaliações)

0,0

@vkavitha

Hello there, Thanks for submitting the project. Myself Kavitha working with one of the big 4 as Analytics manager, with 10+ years of experience. Highly skilled in building operational & quality reports, KPI Reporting , power query Automation, data mining, data model, VBA automation, dashboard building. If interested in my profile, can share some sample work. Looking forward for your reply. Thanks, Kavitha M

$30 USD em 40 dias

0,0

(0 avaliações)

0,0

@Dazlefreelancer

Dear Client, I gone through the detail requirement on Report Automation: Power Bi. I am pretty sure to deliver this on time as I am quite expertise on SQL server and Power BI dashboard. Regards Sewli

$19 USD em 40 dias

0,0

(0 avaliações)

0,3

@Alecito55

I like this job. I have a lot of experience in the development and administration of mssql and Microsoft power Bi, I would like to help. greetings and thanks.

$40 USD em 40 dias

0,0

(0 avaliações)

0,0

@nikhil0201b

Hi , I have good experience in power bi. I can help you on this project. I will update you my progress and , I will get confirm by you whether i am going in correct direction or not, based on your feedback I will work .

$40 USD em 40 dias

0,0

(0 avaliações)

0,0

@bdrudra

Hi, I have gone through your requirements and I am absolutely sure that I can do the project very well. I have 8+ years of experience in Relevant Technologies so I would be a good fit for this position. I am always trying to find best solution for client about price and quality. I am looking for long term contract and relation. I provide realistic deadlines that I always met. I’m fulltime freelancer and available on daily basis. Regards, Hina

$23 USD em 40 dias

0,0

(0 avaliações)

4,2

@hlambert4

Dear Sirs, I am expert in the following areas: 1) Excel, Macros and VBA, I have done different large jobs operating on tables larger than 10,048,756 rows. Combining with MSFT Access tables. Today I am migrating this data to PowerBI. 2) I have strong skills in database design, modeling and structure, including SQL language. 3) Microsoft Power BI, with advanced skills and preparing the official certification exam. Learning Power BI has been very fast and natural for me, since I have mastered the first two topics that I mention. I was in senior management positions, this makes me understand perfectly the managing information needed, outside the classic systems approach. I also combine this with my verbal and written communication skills and knowledge of Sales and Management in General. At time to greet you very kindly, I remain at your disposal. Hugo Lambert

$40 USD em 40 dias

0,0

(0 avaliações)

0,0

@rajeshchonde16

Hi, I have gone through your requirements and I am absolutely sure that I can do the project very well. I have 8+ years of experience in Power bi and dot net Technologies so I would be a good fit for this position. I am always trying to find best solution for client about price and quality. I am looking for long term contract and relation. I provide realistic deadlines that I always met. I’m fulltime freelancer and available on daily basis. Regards, Rajesh

$40 USD em 40 dias

0,0

(0 avaliações)

0,0

@ThiagoDuarteBR

Hello! I'm a quality engineer at a world scale multinational. I have developed the dashboards we use to monitor our process and produced parts in real time. I developed it from a SQL database with over 50 tables. I have a lean six sigma green belt certification. I'm used to apply statistics in my daily job. I have some experience in R programming (integrated with power BI)

$20 USD em 20 dias