Saturday , February 23 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

Making a Kitchen Drawer Organizer | DIY Hand Tool Woodworking Project

I needed to make a Kitchen Drawer Organizer of r the silverware drawer int he …

[ Paper Craft ] Origami Dinosaurs (2) – DIY Fun Toys for Babies, Kids and Children

For beginners, step-by-step photo instructions are available on our website. https://www.lucasplayhouse.com/2018/09/21/303/ #kids #dinosaurs #origami #PaperCraft …

How to Make a Skater Dress Easy | DIY Circle Skirt Dress for Beginners

Learn how to make a basic skater dress with sleeves in this step by step …

How to Sew a DIY Duvet Cover

Learn how to sew a DIY duvet cover with cozy fabric and a button closure. …

新年手作襪子娃娃 – 年年有魚 【做吧!噪咖】DIY Socks Fish

簡單幾步驟 襪子變身手作娃娃 更多做吧!噪咖系列►► 生活小巧思讓生活更有趣;美味小廚娘你我輕鬆當! 看似簡單的物品重新利用超聰明;普通的食材讓你吮指回味~ 材料 : 襪子、棉花、針線、不織布、保麗龍膠、剪刀、新年裝飾 做法 : 1. 襪子翻面,塞入棉花 2. 縫起襪子開口,剪出魚尾巴 3. …

DIY VLOG: Painting YouTube Studio Wall

#nosmallcreator #DIY This video is document my struggles with painting! Enjoy! IF you want the …

Free energy wireless device for lights _ DIY science experiment

Free energy wireless device for lights _ DIY science experiment Related

DIY Homemade Batch Solar Hot Water Heater

A video describing a batch solar hot water heater I built. The water heater is …

Life Hacks Girl DIY! 5 HACKS THAT WILL SAVE YOU A FORTUNE #2

presents super cool diy videos which you can create at home. Simple, quick and fun …

TOP 20 Home Decor Ideas You Can Easily DIY | DIY Room Decor

Check out these creative decor tips and ideas! Recycling old bottles, wall decor, glitter mason …

%d bloggers like this: