Guru-G

1. Business Problem Client seeks to establish a franchised Asian restaurant in a Toronto neighborhood. Which neighborhood would appear to be the optimal and most strategic location for the business. A client seeks to establish a franchised Asian restaurant in a Toronto neighborhood. Which neighbourhood would appear to be the optimal and most strategic location for the business operations? The objective of this capstone project is to locate the optimal neighborhood for operation. Our foundation of reasoning would be based off of spending power, distribution of ethnic group, and competition, across each neighbourhood. We will mainly be utilizing the Foursquare API and the extensive geographical and census data from Toronto's Open Data Portal. 2. Data We are going to extract Datafrom multiple sources mentioned below along the data fields being extract from each source Neighbourhood names, alongside their corresponding boroughs and postal codes, scraped from Wikipedia: ( https://en.wik...

Often times, when you get data from a source, there will most probably be something incorrect that needs to be fixed using an ETL process of Power Query. And most of those transformations would require either Replacing or Removing string's that are not necessary. For example, if you extract any financial data from a source which has multiple currency symbols, there's a chance that the numbers get extracted along with the currency symbols like "$700"/"€700" instead of 700. And these type of cases makes it tough to Transform the Data to our wish as the value will be considered as a text instead of a number. In those type of cases, we would most likely have to create multiple steps to remove the multiple currency symbols from the Column. But thanks to the solution provided by Marcel for one of the questions posted on Stack Overflow, with a little manipulation of the Query language (M), we can replace/Remove multiple strings in one step using the List. ...

You might have seen moving spotlights in a lot of videos. How cool would it be if you can do that in Powerpoint for one of your presentations in School/Office? The above GIF is a fast-forwarded recording of PowerPoint slides. You can replicate this effect using a combination of Crop and the Transitions feature of the powerpoint. Below is a video which explains that process to achieve the above result.

    With the addition of Windows Ink Workspace in Windows 10, we can now take screenshots and draw over the screenshot easily. You can simply click on the Windows Ink Workspace button in the taskbar or press Win+W shortcut to open the Windows Ink Workspace and click on "Screen Sketch" to take a screenshot and start editing it.    But if you would like to have a shortcut to open screen sketch directly without having to open the Ink workspace, you can create one manually using the following simple steps as suggested in the following link : Go to your PC Desktop Right Click and select New > Shortcut In the Next window that appears, copy and paste the following text and click Next ms-penworkspace://Capture Choose a name for the shortcut in the next window and click finish Now, right-click on the shortcut that is created on the desktop and select Properties. Go to Web document tab in the properties window and choose your desired shortcut in the "shortcut ke...

    Windows Ink Workspace is a new feature added in Windows 10, which allows us to take screenshots, sketch on whitespace and draw or take notes in sticky notes. We can have the Windows Ink Workspace button handy in the taskbar notification area. If you don't see the button on your taskbar, you can right click on the Taskbar and check the option that says "Show Windows Ink Workspace button". To open the Windows Ink workspace, you can click on this button or use the shortcut Win+W. The tools available in the Ink Workspace are Sticky Notes, Sketchpad & Screen Sketch. Sticky Notes :     Sticky notes have been available in Windows for very long. The Sticky Notes in the Ink Workspace are the same. You can also open sticky notes simply by searching for it in the windows search. Sketchpad :     Sketchpad is simply a whiteboard feature which allows you to sketch anything you want and save it in your PC/Tablet. It has various tools...

     While you are in a presentation or hosting a webinar, you might want to write/highlight a part of your screen to draw the attention of your audience on something important. Although you can use the tools from powerpoint to scribble in the PPT file, you might want to write something on other apps as well.      That's where these awesome apps come into play. Although these apps have similar features, you might prefer one above the other. ZoomIt :       ZoomIt is an application developed by Microsoft which can be installed from the following link . It is a free tool with features like Text, Shapes, whiteboard, blackboard, zoom . When activated, the tool converts the current screen into a static image and allows you to draw/write on it. One the tool is activated, you can also choose to create a whiteboard/blackboard screen on your PC to draw on. Although the colors are limited to 6 colors: Red (R) , Green (G) , Blue (B) , Orange (O...

    If you have a small set of files in a SharePoint Library, which has too many folders, using MS Flow to copy all files from one specific folder is easy. But if you want to pick a small set of files from multiple folders and copy them all using one Flow, it might be tricky. If you open any document from SharePoint in a web-browser, you'll notice a text like " Listitemid = #### " where #### is a number. That is a unique ID of that file in that SharePoint. You can use this to get the details of that file. Example: https://testsite.sharepoint.com/:x:/r/sites/test123/_layouts/15/Doc.aspx?sourcedoc=%7Bb8exxx66-2f8a-486a-9426-6cd93abcd22097b%7D&action=default&uid=%7BB8EFG30666-2F8A-486A-9426-6CD93A22097B%7D& ListItemId=671204 &ListId=%7B7BDD3AD3-36BCDE-4E43-BB21-9B68136E8091%7D&odsp=1&env=prod You can store a set of those values as an array variable in the Initialize Variable step (blue box in below screenshot) in MS Flow and use those ...

To get a QR Code for a File/Folder/Page in a SharePoint, follow the following steps. Click on any file/folder/page and click Manage Access  (Image 1) . Click on " Advanced " on the next pane to open the Advanced settings. In the next window, click on Grant Permission in the Permissions ribbon to open the share settings window  (Image 2) . In the Share Settings Window, click on " Get Link " and select the desired access level from the drop-down  ( Image 2) . Click on the small mobile icon (Open this link on Phone) beside the Remove button  (Image 3) . A new window pops up with a QR Code for the specified File  (Image 4) . Image 1 Image 2 Image 3 Image 4

One of the shortcomings of Revit is that unlike AutoCAD you can't save multiple UCS to rotate the snap grid based on the orientation of the building. But we can make use of the grid from the workplane to align/snap the elements in whichever angle you want. To see and manipulate the grid in any of the plan views, Go to the plan view. Click on "Show"  button in the "Workplane" toolbar of "Architecture" tab in the ribbon. The grid by default will show up aligned to the screen orientation. You can select the grid and click on rotate to rotate the grid to your desired orientation. Snap Grid

In one of my previous posts, I have explained the  difference between Project North & True North  and how we can use them in any project. In this tutorial, I'll show you how to Set/Change the Orientation of Project North. Unlike True North, rotating a project north is a little different. You can only rotate in 90°/180° or use an existing element to orient. Following are the steps to rotate the Project North. Go to any Plan view.  Go to Manage tab in the ribbon and click on "Position" drop-down in the "Project Location" toolbar. Then choose "Rotate Project North" from the drop-down list. Rotate Project North This will pop up a window that gives you various options for rotating the project north 90° clockwise 90° counterclockwise 180° Align selected line or plane

In any Revit project, the orientation of the North is always set to the top of the screen. But this might not be the case with all the projects. All the projects are not oriented parallel to the North direction, and we might want to orient the project to the true north direction. In one of my previous posts, I have explained the difference between Project North & True North and how we can use them in any project. In this tutorial, I'll show you how to Set/Change the Orientation of True North. Go to any Plan view.  Go to Manage tab in the ribbon and click on "Position" drop-down in the "Project Location" toolbar. Then choose "Rotate True North" from the drop-down list. Rotate True North This will show you 3 different ways to change the orientation of the True North. They are 1. Manual Rotation Upon clicking the "Rotate Ture North", Revit will automatically prompt you for manual rotation of the orientation. You can use...

In the very first post of my Revit-Coordinate System series, I've explained the difference between the Project Basepoint and Survey base point, and in the third post , I've explained how to manipulate/change the values of the Revit Coordinate system. This tutorial shows you how to set the real world elevation values to be reflected in the Levels of a project. Open the project where you want to change the settings and go to an elevation view. Select a level. (Check my following post if you can't see any levels in the view) Click on edit type in the properties window. In the Windows that pops up, look for the option called "Elevation Base" and choose either "Project Base Point" or "Survey Point" Edit Properties Window

If you're using the default templates provided by Autodesk, then in any plan view after  unhiding the SBP & PBP , you can observe that both PBP & SBP are at the same location and overlapping each other. If you select either of the base points, you can see the information of the Point and also a Gizmo that allows us to move the selected base point in the 2D plane. But the orientation of the Gizmo for both the points might be different depending on the Orientation of Project North and True  North . Before moving either of the points, notice a clip shaped icon when you select either of the points. This icon denotes the clipped/unclipped state of the respective point, which says how moving the point would affect the entire project. Clip/Unclip the Base Points If you move the points using the Gizmo, you'll notice that moving the Project Base Point moves the whole project i.e., all the elements modeled, while moving the Survey Base Point doesn't do anything. B...

In the first post(01 of 07) of the Revit-Coordinate System Series, I've explained what are the different coordinate systems(ProjectBase Point and Survey Base Point) in Revit and how all the elements in Revit take a relative reference to Project Base Point(PBP) and Survey Base Point(SBP). This tutorial explains how to properly manipulate/move those points Follow the following steps to properly Change/Manipulate these points: Go to a plan view where you feel comfortable with the orientation of the project. You'll need these points to be visible in the plan view to make any changes to them. You can either use the Reveal Hidden Elements button or Change the Visibility Graphics settings . To unhide Project base point & Survey base point, press "VV" to open Visibility/Graphics Override window. Look for "Site" and expand it to find "Project Base Point" & "Survey Point" Visibility/Graphics Override Select the point that yo...

With the default setting of Revit, you always model the elements parallel to the screen orientation. But have you ever wondered why is the orientation like that or what is the actual orientation for the project and how to reflect it in the model? Well, the simple answer is, the default plan orientation is set parallel to the screen for the user's convenience. So, how to set and display the actual orientation of the site? To do that we need to understand the 2 different Orientation in Revit, Project North & True North. These two orientations of the project are associated with the 2 different coordinate systems in Revit, Project Base Point & Survey Base Point (respectively) which I've explained in detail in my other post. By default, all the plan views(except site plan) are set to orient to Project North. You can change the settings in the Properties tab(shortcut - CTRL+1) > Graphics > Orientation. Site Plan vs Level 1 So the basic difference between T...

In any project, one of the most important information is the base elevation. For any typical project, we usually use "0.00" as the Base level/Level 1. But there might be a time when you might need to find the actual elevation of an element or you might want to reflect the actual elevation values that you got from your site survey. So to accomplish that, you need to understand 2 hidden elements and their properties in Revit - Project Base Point and Survey Base Point . Survey Base Point vs Project Base Point Project Base Point A Project Base Point can be considered as the origin point(0,0,0) of your project. All the elements that you model take the project base point as the origin and get their coordinates.  But it is not necessary that the value of the Project Base Point is (0,0,0). In large-scale projects where multiple RVT project files are linked using  Shared coordinates , each of the linked files has their own projects base point whose locations are in ...

The coordinate system in Revit is not as simple as it is Autocad, where there is just one Origin and all the elements are associated with that. In Revit, there are basically 2 Origin points that we can set the elements to take reference from - 1. Project Base Point(PBP) PBP can be considered as the Origin of the Revit Project. But it is not necessary that the value of the Project Base Point is (0,0,0). In large-scale projects where multiple RVT project files are linked using Shared coordinates , each of the linked files has their own projects base point whose locations are in reference to the PBP of the parent file which has all the linked files. 2. Survey Base Point(SBP) SBP is the real world location of the project that is usually calibrated on the site using survey tools. Unlike PBP, the Survey Base Point will be the same for the entire project and for all the individual linked Revit files in large-scale projects. To view the Project Base Point and Survey Base Poi...

Excel Macros in VBA are really a great way to do repetitive or an automated task. So if you have a specific macro that you'd like to be run every time a specific file is opened, then you need to write the VBA code for that macro in the Workbook_Open() procedure. Follow the following steps to do that: Open the Visual Basic editor from the Developer Tab. (Go to the following link if you can't see the Developer Tab ) Look for "This workbook" in the Project Explorer and double-click it. Select Workbook from the 1st drop-down Select Open from the 2nd drop-down for excel to automatically create a procedure for Workbook_Open(). Insert the VBA code that you want to run every time the specific excel file is opened. Microsoft Visual Basic for Applications There are many other similar procedures that you can add in "This Workbook" like BeforeClose, BeforeSave, Sheet Change etc..,