Report Automation: Power Bi

$250-750 USD

Suljettu

Julkaistu

noin 3 vuotta sitten

$250-750 USD

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 29479161

Tietoa projektista

23 ehdotukset

Etäprojekti

Aktiivinen 3 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

23 freelancerit tarjoavat keskimäärin $523 USD tätä projektia

@nikhilgupta84

Data Scientist/Analytics Consultant with over 15 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end analytics project execution which involves the following taks: a) Data Management (Processing, Cleaning, Transfomation) b) Data Reporting/Dashboarding (BI) c) Data Analysis/Modeling To accomplish the above mentioned tasks, I am extensively using the following tools: - SAS - SPSS - R - Python - Power BI - Tableau - SQL - MS Excel - MS Access

$556 USD 7 päivässä

5,0

(6 arvostelua)

4,5

@sajidjasi

Dear Customer, https://www.freelancer.com/u/sajidjasi Hope you doing well. I am an expert data analyst. My expertise includes econometric modeling and data analysis using SPSS, Stata, E-Views, for business data analysis and data visualization, I am expert in MS Power BI, Power Query, and MS Excel. Furthermore, I have also worked on Python (pandas), SQL, R, and google sheets. Please consider my proposal. Looking forward to hearing from you. Thanks Regards Sajid

$600 USD 15 päivässä

5,0

(6 arvostelua)

3,6

@Kartheekreddyn

Hi I can help you in building highly insightful dashboards using Power BI. I have experience in writing complex SQL queries, DAX measures, and building Excel models & Power BI dashboards from scratch and also making changes to the existing reports. I am quick at understanding the business context and Problem-solving. The pricing and #of days are PLACEHOLDERS, we can discussing more on this in the chat. Please find my details below. I have 7.4 years of experience in Business Analytics and Data Architecture. I have expertise in Power BI, designed and built multiple executive-level Power BI dashboards for clients across the Retail, Food & Beverage, Entertainment, Fitness industries. Expertise in building end-to-end BI Infrastructure across industries including developing Data Models, Data Warehouses and creating visualizations using SQL server, MSBI stack (SSIS,SSRS & SSAS) and Power BI Expertise in Customer Analytics, Sales Analytics, Pricing, Sales & Operations Planning, Digital Analytics domains across Retail, F&B, Entertainment, Fitness, Health Care, Textile and Manufacturing industries

$300 USD 5 päivässä

5,0

(7 arvostelua)

3,7

@chirag9700

Hi, I hope you are doing well. I have checked your requirements it sounds like you need an expert so I prefer to discuss your project further. I have been working on SharePoint and O365 technologies for about 6 years now. I have about 2 years of experience in PowerApps, PowerBI stuff. I am Microsoft Expert. Highly professional in Web part, SPFx Web Part, XSLT Web part, Custom Web part as Slider Web part, Master Page, SharePoint Creator, Rest API, MS Flow and PowerShell technologies including all related skills: JavaScript, CSS 3, HTML 5. I have experience in PowerAutomate, Nintex Workflows, and Webforms. Let me know if any above looks interesting, and we can set up a time to talk. Thanks, Chirag.

$500 USD 5 päivässä

5,0

(1 arvostelu)

2,8

@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, Deliverables: - Power BI PBIx files and duly documented in each table, field, column, detailed formulas of how they work. - Clear and segmented relationship diagram of the data model created (segmented with a star diagram for each report). - PDF document summary of the work carried out and measurements created in the system with formulas and descriptions. - Report available according to requirements in Power BI Service environment and available licenses. - + other deliverables decided by the client. Availability for initial immediately after the first meeting with the client. the solution time is an estimate considering meetings to validate the project with the client and any possible adjustments that come out after meetings with the client.

$650 USD 16 päivässä

5,0

(1 arvostelu)

1,9

@HiishamM

I am Hisham Mahmoud. I’m a Business Intelligence Analyst, I want to prove myself here. After carefully reviewing the experience requirements of the job description, I’m interested to take the project and feel that I am a suitable match for the job. Thank you for taking the time to consider this application and I look forward to hearing from you in the near future. Sincerely, Hisham Mahmoud

$444 USD 5 päivässä

0,0

(0 arvostelua)

0,0

@ImtiyazAliJafri1

Hello, I have gone through your project and interested to work with you. Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation. Expert in creating and developing Power BI Dashboards into rich look. Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week. Have expertise with:- - Designing and Developing the Dashboard Reports in Power BI using DAX. - Migration of the project from Microstrategy to Power BI. - Implementing Agile methodology. - Developing the reports using POWER BI, Power Pivot and SSRS. - Implementing Drill Through & Hyperlinks in Power BI report. - Adding the feeds and Scheduling the jobs Also can show you a demo of some past work. Looking forward to more discussion. Imtiyaz

$750 USD 7 päivässä

0,0

(0 arvostelua)

0,0

@Hajer92

Hello Thank you for such detailed specification. I will keep it brief. I plan to deliver initial results within 24h of starting. I plan to model the data per specification and required reporting use cases. and I can provide fully interactive and visually attractive dashboard with drill down/across options. If you are interested to work with me, you know where to find me Thanks Hajer

$500 USD 3 päivässä

0,0

(0 arvostelua)

0,0

@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.

$500 USD 5 päivässä

0,0

(0 arvostelua)

1,4

@schoudhary1553

Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

$500 USD 10 päivässä

0,0

(1 arvostelu)

0,0

@Hrtechllc

Hello, I have more than 3 years of experience with Tableau and PowerBI. I have done my Masters in Data Science from George Washington University, Washington D.C. I can identify and create efficiencies through data visualization. I can convert raw data into more meaningful data. Areas of expertise and analytical services I can provide to you and your team: ---> Tableau dashboard development & training ---> Data analytics (regression modeling, statistics) ---> Python (pandas, tensorflow, numPy, keras, openCV beautiful scoup, matploblib, etc.) ---> Microsoft databases (Excel, SQL, Access) ---> Data gathering and cleansing (ETL - Extract, Transform, Load) ---> Predictive Modeling ---> AWS (lambda, EC3, etc) I can perform predictive, prescriptive. time series and statistical analysis using Power BI and Tableau. If given an opportunity, I will provide you quality services along with maintaining a long-term relationship. Thanks & Regards Pranay

$600 USD 7 päivässä

0,0

(0 arvostelua)

0,0

@okwarobarry

Dear, I correspond in the interest of applying for the subject roles in response of the recent advertisement. I come from a solid technical background in Business Intelligence, Data Analytics and Machine learning having previously Implemented solutions across North America, Eastern and Southern Africa while serving various roles as outlined in my resume herewith attached. My interest in securing the subject role at your organization is to further build my competency in analytical aptitude and purview of ever-changing client’s standpoint which I believe your organization’s environment shall provide me, while I bring onboard my specialized professional experience in preparing and delivering the Business Intelligence, Data Analytics and Machine Learning strategy and the necessary roadmaps that support broader business strategy in different industries. I would appreciate the opportunity to interview with your organization to further discuss how my capabilities could benefit your organization and vice versa. I look forward to hearing back from you in kind anticipation. Thank you Sincerely, Stephen Barry Okwaro

$500 USD 7 päivässä

0,0

(0 arvostelua)

0,0

@VEERA3141

MS Power BI Certified (DA-100) PROFESSIONAL SUMMARY Having 4+ years of experience in designing & developing business intelligence reports using POWER BI and 2 years of experience in IT. EXPERIENCE SUMMARY Over 4+ years of extensive experience in business intelligence applications design, development and maintenance of SQL Server Analysis Services Tabular Models, Power BI Reporting Server and Power BI Service Skills in Power BI visualization, high-quality Power BI reports, and dashboards. Experience in developing Power BI reports and dashboards from various Data Sources like Cube, Databases, Excel files, flat files...etc knowledge in SQL Server Analysis Services (SSAS Tabular Model) and good SQL Server Management Studio(SSMS) Hands-on experience in Creating Star Schema and Snow Flake Schemas and understanding of SSAS, OLAP cube, and Architecture. Practical understanding of data modeling (dimensional and relational) concepts like star-schema modeling, snowflake schema modeling, and fact and dimension tables. Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules. Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging, and Data split.

$556 USD 7 päivässä

0,0

(0 arvostelua)

0,0

@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 (DOW equivalent) 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.

$600 USD 7 päivässä

0,0

(0 arvostelua)

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 Microsoft 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

$500 USD 5 päivässä