Coding Interview Resources

Data Analyst INTERVIEW QUESTIONS AND ANSWERS 👇👇 1.Can you name the wildcards in Excel? Ans: There are 3 wildcards in Excel that can ve used in formulas. Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc. Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin. Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~. Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard. 2.What is cascading filter in tableau? Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source. 3.What is the difference between .twb and .twbx extension? Ans: A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset. 4.What are the various Power BI versions? Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subscription while workspaces are at Premium capacity. ENJOY LEARNING 👍👍

Make sure no one is stealing your Wi-Fi When someone else is using Wi-Fi, the Internet on your device is slower. You pay for the connection, and someone else uses it for free, while also degrading the signal quality: Isn't that a shame? If you want to find out who's using your internet, download the Who's On My WiFi program and you can change the password to prevent the thief from accessing your device. It will show you the IP address, MAC address and names of all the devices connected to your Wi-Fi.

Business Analyst Interview Questions and Answers 👇👇 1. What is analysis in tableau? Ans: Tableau comes with inbuilt features to analyze the data plotted on a chart. We have various tools such as adding an average line to the chart which tableau calculates itself after we drop the tool on the chart. Some other features include clustering, percentages, forming bands of a particular range and various other tools to explore and inspect data. All these tools are available in analyze tab on each sheet used to create any chart. The features become visible only when they are applicable to the worksheet. 2.How to create sets in tableau? Ans: Sets are custom fields used to compare and ask questions about a subset of data. For creating a set on dimension, right-click on a dimension in data pane and select create -> set. In general tab select the fields that will be considered for computing the set. Specify the conditions to create set in conditions tab and you also have the option to select top N members in dataset based on any field in the top tab. When a set is created it divides the measure into two parts namely in and out of the set based on the conditions applied by the user. 3.Why and how would you use a custom visual file? A custom visual file is used when none of the pre existing visuals fit the business needs. Custom visual files are generally created by Developers which can be used in the same way as prepackaged files. 4. What are the various type of users who can use Power BI? Ans: PowerBI can be used by anyone for their requirements but there is a particular group of users who are more likely to use it: Report Consumers: They consume the reports based on a specific information they need Report Analyst: Report Analysts need detailed data for their analysis from the reports Self Service Data Analyst: They are more experienced business data users. They have an in-depth understanding of the data to work with. Basic Data Analyst: They can build their own datasets and are experienced in PowerBI Service Advanced Data Analyst: They know how to write SQL Queries and have hands-on experience on PowerBI. They have experience in Advanced PowerBI with DAX training and data modelling.

A bit obvious, but really useful advice Avoid posting your cell phone number on social networks and other open sources, if you don't want to receive spam calls and SMS. Such numbers are collected by parser programs, and then used to form databases for calls and mailings.

The WWW and the Internet Well, what is the difference between the World Wide Web and the Internet? Let's get rid of a common misconception: the Internet and the World Wide Web (WWW) are not the same thing. The Internet has been around much longer, and the term applies to any networked computer. The World Wide Web is the specific way we access information stored on the Internet by connecting to sites through the HTTP protocol. #SomeTheory

A list of resources in different fields of Computer Science. #list #awesome #python #course #science #database #network #algorithm #cryptography https://github.com/the-akira/Computer-Science-Resources

Introduction to Machine Learning (Fall 2020) By Massachusetts Institute of Technology, MIT Length: 13 weeks 🔗 Course Link #ml #machinelearning #datascience #MIT ➖➖➖➖➖➖➖➖➖➖➖➖➖