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

Skills: Power BI

See more: 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

About the Employer:
( 0 reviews ) Sandy, United States

Project ID: #29479161

23 freelancers are bidding on average $523 for this job

(32 Reviews)
(6 Reviews)

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 More

$556 USD in 7 days
(6 Reviews)

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 More

$500 USD in 15 days
(13 Reviews)

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 More

$250 USD in 7 days
(13 Reviews)

Dear Customer, 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 More

$600 USD in 15 days
(6 Reviews)

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 More

$300 USD in 5 days
(7 Reviews)

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 More

$500 USD in 5 days
(1 Review)

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 More

$650 USD in 16 days
(1 Review)

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 More

$278 USD in 3 days
(1 Review)

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 More

$750 USD in 7 days
(0 Reviews)

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 More

$500 USD in 5 days
(0 Reviews)

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 More

$600 USD in 7 days
(0 Reviews)

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 More

$556 USD in 7 days
(0 Reviews)

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 More

$500 USD in 7 days
(0 Reviews)

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 More

$500 USD in 3 days
(0 Reviews)

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 More

$600 USD in 7 days
(0 Reviews)

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 More

$500 USD in 10 days
(1 Review)

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 More

$500 USD in 5 days
(0 Reviews)

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 More

$444 USD in 5 days
(0 Reviews)