In PowerBI there is a nifty trick where you can pivot or unpivot your data in the Query Editor. This saves you from having to do this in SQL or which ever source you are using for your data. There are just 4 simple clicks to pivot your data! First you need to select the column you want to…
SQL Scalar functions UCASE() – Converts a field to upper case LCASE() – Converts a field to lower case MID() – Extract characters from a text field LEN() – Returns the length of a text field ROUND() – Rounds a numeric field to the number of decimals specified NOW() – Returns the current system date and time FORMAT() –…
What is Stored Procedure? A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it. You can also pass parameters…
SQL Server Reporting Services(SSRS) is a solution that customers deploy on their own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways, whether that’s viewing them in web browser, on their mobile device, or as an email in their in-box. How does SSRS work? Below is the reporting life cycle follow by…
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data integration and data transformation tasks. It is basically an ETL tool part of the Microsoft Business Intelligence suit that is mainly used to achieve Data Integration. What is Data Integration ? Data integration…
Comments in SQL There are two ways in which you can comment in SQL, i.e. either the Single-Line Comments or the Multi-Line Comments. Single-Line Comments The single line comment starts with two hyphens (–). So, any text mentioned after (–), till the end of a single line will be ignored by the compiler. Multi-Line Comments The Multi-line comments start with /* and end with */….
Q1. What is the difference between DELETE and TRUNCATE statements? DELETE TRUNCATE Delete command is used to delete a row in a table. Truncate is used to delete all the rows from a table. You can rollback data after using delete statement. You cannot rollback data. It is a DML command. It is a DDL command. It is slower…
Top 11 Business Intelligence Certifications Certified Business Intelligence Professional IBM Certified Designer: IBM Cognos Analytics Author V11 MCSA: BI Reporting MCSA: SQL 2016 BI Development MCSE: Data Management and Analytics Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist QlikView Business Analyst QlikView Data Architect SAP Certified Application Associate: Business Intelligence with SAP BW 7.4 & SAP BI 4.1…
1.Business Intelligence Analyst A BI analyst is responsible for drilling down into large sets of relevant data, including KPIs, that a business or organization uses in relation to the development of various processes, initiatives, and departments. A BI analyst assists in strategic thinking, and the discovery of new, valuable insights. What makes a good BI analyst? Let’s take a…
The Two Types of Decision-Making In Our Brain Chess prodigy Joshua Waitzkin writes about this distinction in The Art of Learning: A Journey in the Pursuit of Excellence. In his book, Waitzkin states that the best chess players are those that can take in the most information in a short span of time. They do so using the “fast thinking”…
