3. Gerard Verschuuren
Verschuuren assisted scientists and engineers in using computers for data analysis, statistical analysis, and regression analysis. He became a Microsoft Certified Professional and was an official adviser on Excel’s latest statistical functions
If you are one those who likes to work with command prompt. Then this article will help you to get started.
Method 1 :
Open the command prompt (OR) press CTRL+R and type CMD it will open the command prompt.
Once you opened the command prompt type SQLCMD. If you have default instance it will open the SQLCMD utility to work with SQLServer otherwise, you will get an error.
Method 2 :
Now you can use
SQLCMD -S Servername\Instancename -E
In the above command -S(Capital Letter) to specify the Server name and Instance name , -E is the default option to login with the windows authentication.
If you want to run as the SQL Server authentication. then, you can use the below command
2. Changing database ownership
when we create the database on SQL Server instance, SQL Server engine sets the login that created the database as the default database owner. This gives the user full control on the database, meaning he/she can do whatever they like on that particular database. According to the SQL Server security best practice document, we should grant login with the least amount of privileges. Therefore, it is recommended to set built-in sa account as an owner of all databases on SQL Server instance. This will make database and server more secure.
3. Show specific sheets in excel
In a workbook with lots of worksheets, you can have a hard time finding the sheets that you need, to do a specific task. Instead of scrolling through all the sheet tabs, or using the popup list of worksheets, use a drop down list to show specific sheets in Excel. Also, all other sheets are hidden, and you’ll be able to focus on what you need to do, and ignore everything else.
5. Fetching first N rows
using FETCH FIRST n ROWS syntax to get a subset of the rows from what would normally be a larger resultset. for those who have experience in working with python pandas library. it is like head()
If you are new to Google spreadsheets. Then, it is bit different to use Vlookup to pull data from one workbook to another than in Microsoft Excel.Please read this article for those who need an introduction to ImportRange.
For suppose,if you have employee details and which you are using for marketing.Recently, a friend of yours has shared a file with you to check how many employee details has existed in your records. The file which you have is Employee Details for marketing and the file your friend shared with you is Check Details. For your reference have a look at below image.
Insert the below formula after adding the new column in the Employee Details for Marketing workbook. whenever there is match you see an employee name from another workbook. Use the filter to find out how many employees has matched.
Microsoft Access is a Relational Database Management System(RDMS).which can organise information entity wise and provide efficient retrieval with the help of queries.
In this article, we will practice how to export data from Access to Excel. For that,we downloaded some dummy data from generatedata website.The dummy data has the following fields Name, Email, Company, OrganisationNumber, Phonenumber
In the Ribbon,you can click External Tab and then click Excel under Export group. ( Don’t confuse with Excel under Import group. this option is for importing data from Excel to Access).
Now, It will open the Excel export wizard,and select the required options as per below image to export the data.
Finally, you will see a wizard confirming whether you want to save your export steps.
When to use Save Exports :
A simple case study to explain the save exports scenario. For suppose,If you are working as an analyst and handling Operational database which includes data regarding business activities.every day , if you want to forward the category wise data in the operational database to concerned manager.
write a query against the operational database as per the requirements from the concerned manager. and then,save export steps option. which will automate your exports by running macros.
If you want to export data to existing workbook.please close the preferred workbook and then run the above steps. the name of workbook should be the name of the Access table or Query.
Be an Analyst is weekly series which aimed to enhance skills beyond beginner level.These topics are composed of the most popular articles, as well as articles demonstrating new or updated features.
1. Best python pandas features
A quick starting guide to those who want to learn pandas.Pandas is the most widely used tool for data munging. It contains high-level data structures and manipulation tools designed to make data analysis fast and easy.