Skip to main content

Posts

Showing posts from 2016

DataZen Syllabus

INTRODUCTION TO DATAZEN PRODUCT ELEMENTS ARCHITECTURE DATAZEN ENTERPRISE SERVER INTRODUCTION SERVER ARCHITECTURE INSTALLATION SECURITY CONTROL PANEL WEB VIEWER SERVER ADMINISTRATION CREATING AND PUBLISHING DASHBOARDS CONNECTING TO DATASOURCES DESIGNER CONFIGURING NAVIGATOR CONFIGURING VISUALIZATION  PUBLISHING DASHBOARD WORKING WITH MAP  WORKING WITH DRILL THROUGH DASHBOARDS

Transposing data from table with two columns

Query to create table and insert data CREATE DATABASE [MYTEST] USE [MYTEST] GO /****** Object:  Table [dbo].[MANYTOMANY]    Script Date: 3/21/2016 2:02:11 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[MANYTOMANY]( [SUBJECT] [varchar](100) NOT NULL, [TEACHER] [varchar](100) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO INSERT [dbo].[MANYTOMANY] ([SUBJECT], [TEACHER]) VALUES (N'A', N'AB') GO INSERT [dbo].[MANYTOMANY] ([SUBJECT], [TEACHER]) VALUES (N'A', N'BC') GO INSERT [dbo].[MANYTOMANY] ([SUBJECT], [TEACHER]) VALUES (N'A', N'CD') GO INSERT [dbo].[MANYTOMANY] ([SUBJECT], [TEACHER]) VALUES (N'B', N'BC') GO INSERT [dbo].[MANYTOMANY] ([SUBJECT], [TEACHER]) VALUES (N'B', N'CD') GO INSERT [dbo].[MANYTOMANY] ([SUBJECT], [TEACHER]) VALUES (N'B', N'EF') GO QUERY TO TRANSPOSE DATA with cte as ...

Power BI Report Access to External Users

Steps for creating a public access link for a power bi report @ powerbi.com  Login to powerbi.com and navigate to your workspace.  Clicking on the file menu we get below options. Click on publish to web option and the below window appears. Click on the "Create embed code" option, we get below window. Click on publish to get the link for the report. You can copy the link from first text box which contains encrypted URL and that does not require and login to view the report. Now if we want to embed the report in a website then we need to copy the iframe code and paste in our application.