Wednesday , November 21 2018
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 make a Parol (DIY) | Philippine Christmas Lantern

How to make a Parol – DIY – Tutorial with lights | Philippine Christmas Lantern …

DIY Dollar Tree Christmas Ornaments 2018 – Dollar Tree Christmas Decor

DIY Farmhouse Christmas Ornaments In this video I share how to make 2 different style …

5 Amazing ideas DIY TOYs

5 or 6 Amazing ideas DIY TOYs How to make a car, helicopter ➤ My …

DIY THRIFT FLIP / Clothing Transformation / リメイクファッション / Costura / Sewing Tutorialㅣmadebyaya

Easy Sewing + Refashion Upcycle DIY – Old Blanket Scarf to Fringe Hem Wide Leg …

imitando o tutorial de maquiagem da Barbie DIY

hoje tentei imitar um tutorial de maquiagem que a barbie fez no canal dela, o …

DIY miniature BEDROOM for dolls

how to make a dollhouse bedroom with working lights… Hi everyone, thank you very much …

Dollar Tree DIY – Christmas Farmhouse Decor – Rustic Christmas decor

#dollartree #christmas2018 #dollartreediy Spend $25 and get your $5 bonus HERE This offer is available …

Homemade New Science DIY project experiment – Free energy generator light bulbs easy

Homemade New Science DIY project experiment – Free energy generator light bulbs easy All of …

DIY Dollar Tree Home Decor Candle Holders| Mirrored Home Decor DIY ideas for Christmas

DIY Elegant Christmas Home Decor Ideas Using Dollar Tree Items. In my First DIY I …

Lights On: Basic Tools You’ll Need for Simple DIY Solar Power

Join Jeffery Yago, author of “Lights On: The Non-Technical Guide to Battery Power when the …

%d bloggers like this: