Friday , March 22 2019
Home / DIY VIDEOS / Power BI – Do it Yourself Tutorial – Lots of Hands-on Exercises – DIY -39-of-50

Power BI – Do it Yourself Tutorial – Lots of Hands-on Exercises – DIY -39-of-50

Microsoft Power BI – Do it Yourself Tutorial – Lots of Hands-on Exercises – DIY -39-of-50
by
Bharati DW Consultancy
cell: +1-562-646-6746 (Cell & Whatsapp)
email: bharati.dwconsultancy@gmail.com
website:

Power BI – Do it Yourself Tutorial – Lots of Hands-on Exercises – DIY -39-of-50

Hands on – DIY #45
1- Load the Hospital_HR.xlsx File, from the “Lots of Hands on” folder.
You can use the PBIX file for your reference – DIY Hands on.pbix
(Download the file from this location
2- Click on Get Data, and then Select Excel Datasource
3- Verify the data, get all the sheets and click on Load.
4- Verify the join conditions.

Hands on – DIY #46
1- Add a new page, from the bottom of the screen.
2- Focus on “Jobs by Specialization” visualization.
3- Refer to the PBIX file, and create measures and calculations for Count of Closed Jobs, # of Open Jobs

Hands on – DIY #47
1- Similarly focus on Top 10 Recruitment Consultants, # of Closed v/s Open Jobs by Speciality, Conversion Ratio Trend, Conversion by State.
2- Refer to the PBIX file, and create measures and calculations for Speciality Conversion Ratio, etc.
3- Add slicers to the page.

Hands on – DIY #48
1- Add a new page, name it as “Trends”.
2- Focus on “Jobs Trend” visualization. Please see how the values are being calculated.
3- Refer to the PBIX file, and create measures and calculations and properties.

Hands on – DIY #49
1- Similarly focus on Region Wise Conversion Ratio, Conversion Ratio Trend by Specialization.
2- Refer to the PBIX file, and create measures and calculations, properties, trendlines etc.
3- Add slicers to the page.

Hands on – DIY #50
1- Add a new page, name it as “Details Page”.
2- Add all the detailed level data. Preferably in a tabular format.
3- Refer to the PBIX file and add slicers.

Hands on – DIY #51
1- Enable Drill throughs from Main Dashboard page and trends page to the detailed page.
2- Test all the drill throughs.

Hands on – DIY #52
1- Create Tooltips at each level.
2- Refer to the tool tips page and create similar tool tips.
3- Validate the data across all the tool tips pages.

Hands on – DIY #53
1- Publish this PBIX file onto the Power BI Service.
2- Install a gateway and then schedule a data refresh every 2 hours.
3- Create a dashboard onto the Power BI report service and enable Q&A.
4- Create an app and publish it.

Hands on – DIY #54
1- Implement data level Security on the Region.
2- Create security roles for the following.
East North Central
East South Central
Mid-Atlantic
Mountain West
New England
Pacific West
South Atlantic
West North Central
West South Central
3- Validate the security roles based on data across all the pages.

Power BI, Do it Yourself Tutorial, Getting Started, Microsoft Power BI, Maps, Clustered & Stacked Visualization

About admin

Check Also

How To Build a Modern Plywood Media Console // DIY

Today on Modern Builds I’m experimenting with 3/4″ electrical conduit to create a modern TV …

DIY Midsommar Tischdeko: Blumenliebe

Endlich Midsommar. Darauf freuen wir uns das ganze Jahr. Die richtige Tischdeko darf da natürlich …

DIY Pura Vida Inspired String Friendship Bracelets

How to make Pura Vida inspired string friendship bracelets. The only supplies needed are waxed …

9 DIY Back To School Pranks / Funny Pranks! Prank Wars! T-STUDIO

Related

Spray Painting My Own Bike | DIY Rattle Can

I decided to try spray painting my own track bike frame using some special bike …

DIY: USB Spaceship Game Controller

Spacecraft have more degrees of freedom than typical cars or airplanes, making them complicated to …

Origami Pikachu Tutorial ★ Pokemon DIY ★ Paper Kawaii

Watch this video to learn how to make an Origami Pikachu! Add this cute origami …

পাস্তা দিয়ে ইউনিক আইডিয়া | Diy Art And Craft With Pasta

Please watch: “পুরাতন সোয়েটার দিয়ে নাইস ডোরমেট আইডিয়া | Diy Mind Blowing Paposh With Old …

Custom fit DIY Dress Form / NO DUCT TAPE! – part 1

I recently discovered what I think is a brilliant idea – a company that produces …

diy amazing 4 toys. mini car.rc motorcycle. rc airplane

diy amazing 4 toys. 4 toys. diy mini car. diy rc motorcycle. diy rc airplane. …

%d bloggers like this: