This paper provides a brief insight into two Microsoft tools for data analysis, Excel and Microsoft SQL Server. The functionalities of each of the tools are presented in the theoretical and practical parts of the paper. The paper uses the same data set to display the practical use of the tool. In the first part of the paper, Excel is presented through its most important features when it comes to data analysis, namely built-in formulas, pivot tables and pivot charts. In this part, the new functionality of the Excel program, Power Query, is presented. The second part refers to Microsoft SQL Server, as one of the most important tools for analyzing data stored in databases. This section provides a brief overview of SQL development, statement types, and function types. BI and data warehouses are described before the practical part. The main differences between the OLTP system and the BI system and the organizational chart of the data warehouse are presented. In the practical part, a database was created, and the associated tables were filled using another Microsoft tool, SQLServer 2019 Import Export Data. Data analysis has been done through queries and the obtained results are explained in detail. The paper ends with a conclusion on the advantages and disadvantages of the mentioned tools.