Đã Đóng

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

Kĩ năng: Power BI

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Sandy, United States

ID dự án: #29479161

23 freelancer chào giá trung bình$523 cho công việc này

(32 Nhận xét)
6.5
(6 Nhận xét)
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 Thêm

$556 USD trong 7 ngày
(6 Nhận xét)
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 Thêm

$500 USD trong 15 ngày
(13 Nhận xét)
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 Thêm

$250 USD trong 7 ngày
(13 Nhận xét)
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 Thêm

$600 USD trong 15 ngày
(6 Nhận xét)
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 Thêm

$300 USD trong 5 ngày
(7 Nhận xét)
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 Thêm

$500 USD trong 5 ngày
(1 Nhận xét)
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 Thêm

$650 USD trong 16 ngày
(1 Nhận xét)
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 Thêm

$278 USD trong 3 ngày
(1 Nhận xét)
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 Thêm

$750 USD trong 7 ngày
(0 Nhận xét)
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 Thêm

$500 USD trong 5 ngày
(0 Nhận xét)
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 Thêm

$600 USD trong 7 ngày
(0 Nhận xét)
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 Thêm

$556 USD trong 7 ngày
(0 Nhận xét)
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 Thêm

$500 USD trong 7 ngày
(0 Nhận xét)
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 Thêm

$500 USD trong 3 ngày
(0 Nhận xét)
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 Thêm

$600 USD trong 7 ngày
(0 Nhận xét)
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 Thêm

$500 USD trong 10 ngày
(1 Nhận xét)
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 Thêm

$500 USD trong 5 ngày
(0 Nhận xét)
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 Thêm

$444 USD trong 5 ngày
(0 Nhận xét)
0.0