NEAK task 1.

Your task is to analyse the historical data of pharmaceutical products subsidized by the National Health Insurance Fund of Hungary (Nemzeti Egészségbiztosítási Alapkezel, NEAK). Find trends and tendencies based on the data provided. The imported data warehouse consists of four tables that are to be linked by appropriate identifiers to make it possible to generate multiple Power Pivot reports and charts. When creating pivot table reports, use both time and regional hierarchies, as well as DAX functions in the analysis. Use Excel Power Pivot Add-in for analysis, as the data is in the Business [login to view URL] file repository.

1. Learn about the data warehouse in Business [login to view URL] file that contains the first half-year 2013 data of pharmaceutical companies and the tables Dates, Regions and Monthly_Turnover. Study the contents of the four tables and the record description.

2. In Monthly_Turnover table, create a field that is suitable for identification. Create properly the relationships between the tables.

3. Calculate the total turnover of the given period by a DAX function.

4. What hierarchies would you use in Date and Region tables?

5. Make reports on consumer prices using the established hierarchies. What conclusions can you draw from the results obtained?

Make a presentation on the completed analysis and upload it along with the calculations to the available online learning management system. The formal requirements of the presentation are the following: 10-15 slides, presentation of your findings and conclusions with illustration, design, animation, transition, including the date of creation, page numbers, author name in the footer.

Source: Business [login to view URL]

You can find information about the extension here:

Microsoft (2018) Start the Power Pivot add-in for Excel. Available from: [login to view URL] [Accessed: 5th January 2018]

Microsoft (2018) PowerPivot for Excel Tutorial Introduction. Available from: [login to view URL](v=sql.110).aspx [Accessed: 5 January 2018]

Microsoft (2018) Power Pivot: Powerful data analysis and data modeling in Excel. Available from: [login to view URL] [Accessed: 5th January 2018]

Microsoft (2018) Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX. Available from: [login to view URL] [Accessed: 5th January 2018]

Evner: Dataindførsel, Databehandling, Excel, Powerpoint, Statistisk analyse

Se mere: design your logo from $5, design your logo from 5, academic ielts writing task 1, writing task 1 map, ielts writing task 1 academic, ielts writing task 1 general, ielts mentor writing task 1, ielts writing task 1 bar chart, ielts writing task 1 sample answer, ielts writing task 1 tips, ielts writing task 1 academic band 9, academic writing task 1, free ielts academic writing task 1 test, how to write an ielts writing task 1, how to write task 1, ielts academic writing task 1, ielts academic writing task 1 vocabulary free downlaod, ielts academic writing task 1 vocabulary free download, ielts exam writing task 1, ielts general writing task 1

Om arbejdsgiveren:
( 0 bedømmelser ) Budapest, Hungary

Projekt ID: #19329448

5 freelancere byder i gennemsnit $16 på dette job


Hi,. I have more than 10 years of working experience in the industry. You must visit my profile and see the level of customer satisfaction through my ratings and reviews. I can provide you 100% quality even in a shor Flere

$10 USD på 1 dag
(8 bedømmelser)

Hi,. Since functioning from 2008, I have accomplished hawk eye for the requirements, and I have all the aptitudes to produce showpiece as per your anticipations. Creating a masterpiece is an art, and I am a master in i Flere

$10 USD på 1 dag
(1 bedømmelse)

Hi, interested inthis opportunity, have experience in Data processing jobs, can share sample of projects completed. Delivery would be of high quality and within given timeframe. Customer satisfaction is consider in hig Flere

$20 USD på 1 dag
(4 bedømmelser)

Hello sir I would love to assist you regarding your Data entry work and I hope that you will also satisfy with my work. I have experience. I read your requirements and shall complete the task on your given time but Flere

$22 USD in 2 dage
(0 bedømmelser)
$20 USD in 2 dage
(0 bedømmelser)