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

Fähigkeiten: Power BI

Mehr darüber 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

Über den Arbeitgeber:
( 0 Bewertungen ) Sandy, United States

Projekt-ID: #29479161

23 Freelancer bieten im Durchschnitt $523 für diesen Job

(32 Bewertungen)
(6 Bewertungen)

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 Mehr

$556 USD in 7 Tagen
(6 Bewertungen)

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 Mehr

$500 USD in 15 Tagen
(13 Bewertungen)

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 Mehr

$250 USD in 7 Tagen
(13 Bewertungen)

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 Mehr

$600 USD in 15 Tagen
(6 Bewertungen)

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 Mehr

$300 USD in 5 Tagen
(7 Bewertungen)

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 Mehr

$500 USD in 5 Tagen
(1 Bewertung)

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 Mehr

$650 USD in 16 Tagen
(1 Bewertung)

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 Mehr

$278 USD in 3 Tagen
(1 Bewertung)

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 Mehr

$750 USD in 7 Tagen
(0 Bewertungen)

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 Mehr

$500 USD in 5 Tagen
(0 Bewertungen)

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 Mehr

$600 USD in 7 Tagen
(0 Bewertungen)

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 Mehr

$556 USD in 7 Tagen
(0 Bewertungen)

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 Mehr

$500 USD in 7 Tagen
(0 Bewertungen)

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 Mehr

$500 USD in 3 Tagen
(0 Bewertungen)

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 Mehr

$600 USD in 7 Tagen
(0 Bewertungen)

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 Mehr

$500 USD in 10 Tagen
(1 Bewertung)

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 Mehr

$500 USD in 5 Tagen
(0 Bewertungen)

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 Mehr

$444 USD in 5 Tagen
(0 Bewertungen)