Kapalı

Report Automation: Power Bi

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

Beceriler: Power BI

Daha fazlasını gör: power bi dashboard vs report, create a report in power bi desktop, power bi report server, power bi report examples, power bi report templates, embed power bi report in website, power bi report server limitations, power bi report server licensing, power bi report server download, power bi desktop report server, power bi report server tutorial, power bi report server pricing, what is power bi report server, power bi report server configuration, power bi usage metrics report, create power bi report, power bi report server dashboard, how to create a report in power bi, convert tableau report to power bi

İşveren Hakkında:
( 0 değerlendirme ) Sandy, United States

Proje NO: #29479161

Bu iş için 23 freelancer ortalamada $523 teklif veriyor

(32 Değerlendirme)
6.5
(6 Değerlendirme)
4.8
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 Daha Fazla

$556 USD in 7 gün içinde
(6 Değerlendirme)
4.5
dataguru2110

Hi Please find answers of your questions. SQL: Expert Power BI: Expert Power Apps: Minimal Power Query: Expert Dataverse/CDS: Expert Dataflow: Expert Azure Database: Expert Migration of Excel data: Expert Final questi Daha Fazla

$500 USD in 15 gün içinde
(13 Değerlendirme)
4.3
aimefx

Hi, I am an expert in Excel, Access, Powerpoint, VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interact Daha Fazla

$250 USD in 7 gün içinde
(13 Değerlendirme)
4.4
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 analy Daha Fazla

$600 USD in 15 gün içinde
(6 Değerlendirme)
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 Daha Fazla

$300 USD in 5 gün içinde
(7 Değerlendirme)
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 Daha Fazla

$500 USD in 5 gün içinde
(1 Yorum)
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, econom Daha Fazla

$650 USD in 16 gün içinde
(1 Yorum)
1.9
TeamMisfits

Hello Sir, I have read your requirements and believe to entertain them as per your expectations. I am also a part-time instructor of Power BI. Background: With Cumulative 7+ years of professional experience in develop Daha Fazla

$278 USD in 3 gün içinde
(1 Yorum)
1.8
Hardik1711

Hi, I hope you are safe and healthy. I have gone through your requirement you want a Report Automation: Power Bi. I would like to help you with the same as I have expertise with PowerBI development. Also, I am attac Daha Fazla

$750 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$500 USD in 5 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$600 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$556 USD in 7 gün içinde
(0 Değerlendirme)
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 havin Daha Fazla

$500 USD in 7 gün içinde
(0 Değerlendirme)
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 ca Daha Fazla

$500 USD in 3 gün içinde
(0 Değerlendirme)
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 visu Daha Fazla

$600 USD in 7 gün içinde
(0 Değerlendirme)
0.0
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 sam Daha Fazla

$500 USD in 10 gün içinde
(1 Yorum)
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 abou Daha Fazla

$500 USD in 5 gün içinde
(0 Değerlendirme)
1.4
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 Daha Fazla

$444 USD in 5 gün içinde
(0 Değerlendirme)
0.0