Power Query, Power Pivot, Power View, Power BI

Power BI started after the following add-ins for Excel: Power Query - ETL (2010 +) Power Pivot - Modelling and analysis (2010 +) Power View - Interactive reporting and visualization (2013 +) Now Power BI as a stand alone desktop application. Also an Excel Add-in. Power BI Desktop is simply a standalone desktop application bundling … Continue reading Power Query, Power Pivot, Power View, Power BI

Advertisements

Tabbed Report in SSRS using Bookmark

Here we will see how to create tabbed report in SSRS. Step 1: Create following SQL table to work on IF OBJECT_ID(N'dbo.EMPDetails',N'U') IS NOT NULL DROP TABLE dbo.EMPDetails CREATE TABLE dbo.EMPDetails ( EmpId int, EmpName nvarchar(50), Location nvarchar(500), EmpSalary int ) INSERT INTO dbo.EMPDetails VALUES (11,'Emp1','Chennai',1000),(12,'EMP2','Chennai',1000), (13,'Emp3','Bangalore',1000),(14,'Emp4','Mumbai',1000), (15,'Emp5','Hyderabad',1000),(16,'Emp6','Hyderabad',1000), (17,'Emp7','Chennai',1000),(18,'Emp8','Chennai',1000), (19,'Emp9','Bangalore',1000),(101,'Emp1','Mumbai',1000), (111,'Emp11','Hyderabad',1000),(112,'Emp12','Chennai',1000), (113,'Emp13','Chennai',1000),(114,'Emp14','Hyderabad',1000), (115,'Emp15','Bangalore',1000),(116,'Emp16','Chennai',1000), (117,'Emp17','Hyderabad',1000),(118,'Emp18','Chennai',1000), (119,'Emp19','Mumbai',1000),(120,'Emp2','Hyderabad',1000), (121,'Emp21','Bangalore',1000),(122,'Emp22','Hyderabad',1000), (123,'Emp23','Mumbai',1000),(124,'Emp24','Bangalore',1000), (125,'Emp25','Bangalore',1000),(126,'Emp26','Hyderabad',1000), (127,'Emp27','Bangalore',1000),(128,'Emp28','Mumbai',1000), (129,'Emp29','Hyderabad',1000),(130,'Emp3','Hyderabad',1000), (131,'Emp31','Mumbai',1000),(132,'Emp32','Bangalore',1000), (133,'Emp33','Bangalore',1000),(134,'Emp34','Bangalore',1000), (135,'Emp35','Hyderabad',1000),(136,'Emp36','Chennai',1000) Step 2: Create Shared Data … Continue reading Tabbed Report in SSRS using Bookmark

Magic tables in SQL

Magic tables are nothing but the logical tables or temporary objects maintained by SQL server internally. Holds recently inserted values in the case of insert. Holds recently deleted values in the case of delete. Holds before updating values or after updating values in the case of update. We cannot see or access these tables directly, … Continue reading Magic tables in SQL

Retrieving SSIS project/packages from SSIS catalog

There are two ways to export a package from SSISDB to SSDT Export as .ispac from SSMS(SQL Server Management Studio) and save in SSDT (SQL Server Data tools) Export as Zip file from SSMS Export as .ispac from SSMS Step 1: In SSIS Catalog, tight click on the package that has to be exported and … Continue reading Retrieving SSIS project/packages from SSIS catalog

Tips

To compare two cells in a single sheet =IF(Sheet1!A1=Sheet2!A1,"true","false") To compare two cells in multiple sheets =IF(A1=A2,"true","false") To Select a single row in excel Shortcut Key: Shift + End + <Down Arrow> To create a table in excel Select required cells and give Control + T To Split a line in excel into different cells … Continue reading Tips

Importing from CSV data to Excel

Importing multiple CSV files from a source location to a single excel file with each tab named with loaded CSV filename. In this blog, we will go through steps to automate the above task via Windows's Power Shell and via UNIX's Perl scripting. Step 1: Open up a PowerShell console, and navigate to the folder … Continue reading Importing from CSV data to Excel

BIDS – 32-bit Run time

BIDS is a 32-bit run time application (reference can be found here). So, when we are using SSIS we are using 32 bit facilities to build our package. Nowadays, we are using 64-bit OS and other hardware. For Microsoft Jet Driver (MS Access or Excel), there is no 64-Bit version of Jet Driver so any … Continue reading BIDS – 32-bit Run time

Ghost, an Open Source Blogging Platform in Azure

Ghost is an Open Source platform for publishing posts and magazines containing images, videos, codes, etc. It is a simple tool that allows developers to customize their post. Ghost is simple and easy to use when compared to other blogging platforms like Blogger, WordPress, etc.     Ghost allows multiple users to publish their posts in a … Continue reading Ghost, an Open Source Blogging Platform in Azure