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

Habilidades: Power BI

Veja mais: 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

Acerca do Empregador:
( 0 comentários ) Sandy, United States

ID do Projeto: #29479161

23 freelancers estão ofertando em média $523 nesse trabalho

(32 Comentários)
(6 Comentários)

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 Mais

$556 USD in 7 dias
(6 Comentários)

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 Mais

$500 USD in 15 dias
(13 Comentários)

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 Mais

$250 USD in 7 dias
(13 Comentários)

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 Mais

$600 USD in 15 dias
(6 Comentários)

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 Mais

$300 USD in 5 dias
(7 Comentários)

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 Mais

$500 USD in 5 dias
(1 Comentário)

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 Mais

$650 USD in 16 dias
(1 Comentário)

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 Mais

$278 USD in 3 dias
(1 Comentário)

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 Mais

$750 USD in 7 dias
(0 Comentários)

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 Mais

$500 USD in 5 dias
(0 Comentários)

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 Mais

$600 USD in 7 dias
(0 Comentários)

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 Mais

$556 USD in 7 dias
(0 Comentários)

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 Mais

$500 USD in 7 dias
(0 Comentários)

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 Mais

$500 USD in 3 dias
(0 Comentários)

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 Mais

$600 USD in 7 dias
(0 Comentários)

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 Mais

$500 USD in 10 dias
(1 Comentário)

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 Mais

$500 USD in 5 dias
(0 Comentários)

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 Mais

$444 USD in 5 dias
(0 Comentários)