Blog

No More BI

12-November-2019  0 Comment(s)


Add Video to Power BI Dashboard

09-November-2019  0 Comment(s)

In order to add Vimeo or YouTube video to the existing Power BI dashboard, please click on the Add tile button

Clicking on the Add tile button will open the f



TSQL a new approach

08-November-2019  0 Comment(s)

A transaction is a group of database commands that are treated as a single unit. A successful transaction must pass the "ACID" test, that is, it must be
A - Atomic
C - Consistent
I - Isolated
D - Durable

Atomic - All state



MDX ParallelPeriod Function

06-November-2019  0 Comment(s)
PARALLELPERIOD( Level_Expression, Member_Position, Member_Expression)

Member_Expression: Any Multidimensional Expression that returns valid Member.

Level_Expression: Please specify the level you want to navigate



MDX and DAX topics

05-November-2019  0 Comment(s)

The Currency Data Type and VertiPaq Caching

It’s been a while since I published my last blog post. That’s not for lack of topics to write, but rather for lack of spare time. I switched from a developer role to a development lead role a year and a half ago, while life has a



Azure SQL Data Warehouse Destination

04-November-2019  0 Comment(s)

Give Segment access to your SQL Data Warehouse

First, create a server login for Segment to use. This can be accomplished by running the following SQL command on your SQL Server’s master database.

CREATE LOGIN Segment WITH PASSWORD = 
										


Window frame with implicit RANGE option

03-November-2019  0 Comment(s)

Our first pitfall involves the computation of running totals using an aggregate window function, where you do explicitly specify the window order clause, but you do not explicitly specify the window frame unit (ROWS or RANGE) and its related window frame extent, e.g., ROWS UNBOUNDED PRECEDING. Th



ETL in the Cloud

02-November-2019  0 Comment(s)

Mapping Data Flows include built-in data transformations to address common ETL activities like join, aggregate, pivot, unpivot, split, lookup and sort data. In the event that the out-of-box capabilities don’t address an organization’s requirements, an expression builder can be used th



Export PowerQuery query to CSV

31-October-2019  0 Comment(s)
Let
     // reference to a query you wish to export to CSV
    Source = ReferenceToYourTableOrQuery,
     // demote headers to have headers in resulting CSV
     // if you don't need headers, remove Table.DemoteHeaders
     Json = Text.FromBinary(Json.FromValue(Table.ToRows(Table.Dem
										


T-SQL best practices

29-October-2019  0 Comment(s)

Our first pitfall involves the computation of running totals using an aggregate window function, where you do explicitly specify the window order clause, but you do not explicitly specify the window frame unit (ROWS or RANGE) and its related window frame extent, e.g., ROWS UNBOUNDED PRECEDING. Th



SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring

28-October-2019  0 Comment(s)

SQL Server Performance Baselining is important?

  • Performance is relative – DBAs, Consultants and Support team often get called in a situation when the business application running on SQL Server is running slow. Before troubleshooting,


MDX ParallelPeriod Function

25-October-2019  0 Comment(s)

The MDX ParallelPeriod Function is used to return member from a prior period in the same relative position as a specified member. For example, If you want to navigate to particular member then we can use this ParallelPeriod function.

MDX ParallelPeriod Function Syntax

The ba



CDM folders and the Common Data Model

23-October-2019  0 Comment(s)

Point #1: CDM is a metadata system

The Common Data Model is a metadata system that simplifies data management and application development by unifying data into a known form and applying structural and semantic consistency across multiple apps and deployments. If you&rsq



Create OLAP Cube in SQL Server Analysis Services

22-October-2019  0 Comment(s)

Select Creation Method

Within the cube wizard this page will give you 3 options to choose

  • Use Existing Tables: If you select this option, then cube will use the existing tables in the Data Source View.
  • Create an


Exporting Power BI Data to SQL Server

21-October-2019  0 Comment(s)

To make this method work you need to:

Latest version of Power BI Desktop, you can download it from here
Have access to an instance of SQL Server, either on your own machine or on a server in your local network to export the data to
Either install R for Windows, you can dow



Using Regular Expressions With T-SQL: From Beginner To Advanced

17-October-2019  0 Comment(s)

We can use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. In this tutorial, we will practice using these expressions (referred to as regular expressions in the context only of T-SQL) for filtering price phrases in



Data model in Azure Analysis Services

16-October-2019  0 Comment(s)

Azure Analysis Services is a new preview service in Microsoft Azure where you can host semantic data models. Users in your organization can then connect to your data models using tools like Excel, Power BI and many others to create reports and perform ad-hoc data analysis.

To understand



Azure Data Lake Storage to the next level

14-October-2019  0 Comment(s)

Analytics solutions such as Hadoop have been designed assuming they run on scale out file systems. Other cloud providers shoehorn these solutions using a combination of client-side file system emulation and feature-deficit object stores resulting in poor performance and inconsistent reliability,



Azure Data Factory- a way to integrate the batch

13-October-2019  0 Comment(s)

Big data requires service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load-transform (



Star schema and Snowflake schema in SSAS

12-October-2019  0 Comment(s)
  • Star Schema: Each and every dimension present in the Data Source View (DSV) is directly linked or related to Fact or measures table.
  • Snowflake Schema: Some dimensions present in the Data Source View (DSV) are linked directly to the fa


Cancel your Power Query refreshes fast in Power BI

11-October-2019  0 Comment(s)

you’re working with large data or complex queries that take a long time refresh, cancelling one of those refreshes can even take longer time, especially, if the query has run for quite some time already.

Luckily, there is an easy trick to cancel refresh without loosing the work yo



Turn a Slicer into a Drop-Down List

09-October-2019  0 Comment(s)

First up, let’s discuss what a slicer does. It provides a way for your end user to filter a Power BI report or dashboard on the fly. It’s visual and intuitive, and it will affect everything on the screen.

For example, slicing on Package Type will affect Quantity and Unit Pri



Azure Data Factory

08-October-2019  0 Comment(s)

Azure Data Factory (ADF) is a cloud integration system, which allows moving data between on-premises and cloud systems as well as scheduling and orchestrating complex data flows. ADF is more of an Extract-and-Load and Transform-and-Load platform rather than a traditional Extract-Transform-and-Loa



Azure Integration

07-October-2019  0 Comment(s)


Microsoft Integration Services is a platform for building  enterprise-level data integration and data transformations  solutions.Basically: A data migration and ETL tool.It is a component of SQL Server that has existed since SQL  Server 2005.

Inside Azure integrat



How to Rename Column Names in Power BI

05-October-2019  0 Comment(s)

Generally, when you load the data from a data source, you get the column names that are available in a data source. While you are designing the report, you might need names that are more meaningful. In these situations, you can use Power BI rename column option. In this article will show you, How



Power Query/M Queries To ODC Files In Excel 2016 Get & Transform

04-October-2019  0 Comment(s)

A really useful new feature was added to Get & Transform (the functionality previously known as Power Query) in the latest updates for the Office 365 click-to-run version of Excel 2016: the ability to export and import ODC files containing M queries. This makes sense given that Get & Tran



IF Functions in Power Query Including Nested IFS

02-October-2019  0 Comment(s)

Using And and Or in your If Statements

You may have used the AND and OR functions in your IF formulas before in Excel to create more complex logic. This can be difficult when users are just beginning with formulas.

Well the good news is that it is actually easier in Power Qu



Useful Data Analysis Expressions (DAX) Functions for Power BI

01-October-2019  0 Comment(s)

LOOKUP( )

The LOOKUP function is pretty similar to Vlookup in Microsoft Excel.

The third table in our dataset contains the details of all the managers per region. Now here is where LOOKUP comes in hand. We can perf



Azure SQL Database vs. Azure SQL Data Warehouse

30-September-2019  0 Comment(s)

Azure SQL Database is one of the most used services in Microsoft Azure, and I use it a lot in my projects. It is basically SQL Server in the cloud, but fully managed and more intelligent. There is another service in Azure that is kind of similar, but not quite: 



Start and stop Integration Runtime in ADF pipeline

28-September-2019  0 Comment(s)

 Azure Automation Runbook
If you already have the two Runbooks that pauses and resumes the IR then you could skip step 1 to 8 and only do step 9 (create webhook) for both scripts. But then make sure to delete, disable or unlink the schedule of the two Runbooks and remove the optional



MDX ParallelPeriod Function

26-September-2019  0 Comment(s)

The MDX ParallelPeriod Function is used to return member from a prior period in the same relative position as a specified member. For example, If you want to navigate to particular member then we can use this ParallelPeriod function.

 

The basic syntax of the MDX Parallel



SQL Server Integration Services

25-September-2019  0 Comment(s)

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server



Snowflake’s cloud-built architecture, instant elasticity, secure data sharing, and per-second-pricing

24-September-2019  0 Comment(s)

 customers choose Cloud for their data is to understand that their focus is on DATA and not on the infrastructure. Customers are focussed on digital transformation of their businesses and they don’t want to spend time on managing their infrastructure. And so having a managed service in



MDX PeriodsToDate Function

23-September-2019  0 Comment(s)

The MDX PeriodsToDate Function is used to navigate between same level members and returns the set of sibling members from First Sibling to the specified member. For example, If you want to list the members from one position to particular member then we can use this MDX PeriodsToDate function.



Cube Performance Tuning Lessons

21-September-2019  0 Comment(s)

A recent project has forced me (which is a good thing) to learn both the internals of SSAS 2005 as well as various performance tuning techniques to get maximum performance out of the OLAP server. It goes without saying that the grain of both your underlying data warehouse's Dimensions & F



Azure Data Lake to copy data from CSV file to a SQL database

19-September-2019  0 Comment(s)

Great, but what is Azure Data Lake?

Azure Data Lake includes all the capabilities required to make it easy for developers, data scientists, and analysts to store data of any size, shape, and speed, and do all types of proces



Azure Data Lake to copy data from CSV file to a SQL database

19-September-2019  0 Comment(s)

Great, but what is Azure Data Lake?

Azure Data Lake includes all the capabilities required to make it easy for developers, data scientists, and analysts to store data of any size, shape, and speed, and do all types of proces



RELATED, IF, and CALCULATE: DAX Functions for the PowerPivot Beginner

18-September-2019  0 Comment(s)

PowerPivot is an incredible, under-appreciated tool for data analysis. But using such a robust program can be intimidating at first. This article will cover some basic DAX functions to get you started on the way to becoming a PowerPivot legend: RELATED, IF, and CALCULATE.

 



Azure Database for MySQL

16-September-2019  0 Comment(s)

Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service. The MySQL Community edition helps you easily lift and shift your on-prem MySQL Database to the Azure Cloud, using languages and frameworks of your choice. On top of that, you get built-in high



Optimizing Large Distinct Counts in Analysis Services Tabular

13-September-2019  0 Comment(s)

The most glaring hole in the Tabular Performance Guide is information about tuning the performance of distinct counts. In fact I don’t believe distinct counts are even mentioned once in the whole whitepaper. (Since I helped author that whitepaper, visualize me hanging my head in shame and h



Bulk Loading from Microsoft Azure

11-September-2019  0 Comment(s)

This set of topics describes how to use the COPY command to load data from an Azure container into tables.

Note that:

  • Snowflake currently supports loading from/unloading to Blob storage only. Snowflake supports the following types of storage account



SQL Server Performance Baselining Reports

10-September-2019  0 Comment(s)
  • Performance is relative – DBAs, Consultants and Support team often get called in a situation when the business application running on SQL Server is running slow. Before troubleshooting, one of the first question to ask is how slow is slow and how fast is fast?.


SQL Server 2019

05-September-2019  0 Comment(s)

consider when you deploy SQL Server 2019, you are also gaining new capabilities from the amazing work of SQL Server 2012, 2014, 2016, and 2017 including but not limited to:

Performance

  • Query Store
  • Adaptive Query Processing
  • Automatic Tuning


Connect to On-premises Data in Azure Data Factory with the Self-hosted Integration Runtime

04-September-2019  0 Comment(s)

The self-hosted integration runtime is a service running in Azure Data Factory, but you can add local compute nodes on local servers in your on-premises network. A connection is created between the nodes and the integration runtime within your Azure Data Factory (ADF) in Azure. Through this conne



x

03-September-2019  0 Comment(s)

x



SSIS Tasks Types

03-September-2019  0 Comment(s)

 

In SSIS tool, you can add a task to control flow. There are different types of tasks which perform various kinds of works.

Execute SQL Task As its name suggests, it will execute a SQL statement against a relational database.

SSAS Tabular Time Intelligence

02-September-2019  0 Comment(s)

Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, othe



choose for performance - SubQueries or Joins

31-August-2019  0 Comment(s)

According to MSDN, in sql server, in most cases, there is usually no performance difference between queries that uses sub-queries and equivalent queries using joins. For example, on my machine I have
400,000 records in tblProducts table
600,000 records



Modern Data Warehouse with Azure Analysis Services

28-August-2019  0 Comment(s)

 Microsoft Azure and all its PaaS components such as Azure Analysis Services, I was routinely sticking to Microsoft’s on-premises BI stack. With this constrained view on technologies, also some restrictions in terms of cloud-based technology re-interpretations came along.

&nb



DAX and it's tall tales

27-August-2019  0 Comment(s)

DAX was first invented by Jeffrey Wang, Principal Architect of Data,, Richmond, Microsoft. in 20th Aug 2009.

It was Jeffrey Wang's modesty that he never shared his name yet some people took out the unusual advantage of that modesty and made money.

The simplest way to



Azure Integration with script files

26-August-2019  0 Comment(s)

Things are changing fundamentally in the world of integration. A decade, there were architects and integration specialists who had integration as their primary job. Now, things are transforming in the integration space and it is being driven by the need to increase the rate of change of business



Azure Analysis Services objects from Azure Data Factory v2 using a Logic App

23-August-2019  0 Comment(s)
  1. Create App Registration (application service principal) in Azure Active Directory
  2. Grant App Registration permissions to process your Azure Analysis Services model
  3. Create the Logic App that will communicate with the Azure Analysis Services REST API to process a m


SQL CONTINUE

22-August-2019  0 Comment(s)

The SQL Continue statement is very useful to control the flow of a SQL While loop. Generally, we use this statement inside the While loop, and if the execution finds the SQL continue statement inside the While loop, it will stop executing the current loop iteration and starts the new iteration fr



Columnstore indexes - Data loading

20-August-2019  0 Comment(s)

Options and recommendations for loading data into a columnstore index by using the standard SQL bulk loading and trickle insert methods. Loading data into a columnstore index is an essential part of any data warehousing process because it moves data into the index in preparation for analytics.



Insights with Azure SQL Data Warehouse

19-August-2019  0 Comment(s)

We know that data makes every decision better, but decisions need to be timely to be competitive in the market. Fast decisions need a fast data warehouse. United Airlines differentiates itself in a highly competitive market by making its sales analytics widely accessible across the organization.



Drillthrough Filter In Power BI

16-August-2019  0 Comment(s)

In all the time that I have been using PowerBI, I noted that the reports were always filled up with data and there was little to no space to add details about any sort of entit



Count Rows using Power Query

14-August-2019  0 Comment(s)

Power Query or Get & Transform (In Excel 2016) lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to count the number of rows in your query.

And with just one step, you can get the count very easily!

Select 



FILTER context in Power BI(DAX)

13-August-2019  0 Comment(s)

the expression FILTER('InternetSales_USD', RELATED('SalesTerritory'[SalesTerritoryCountry])<>"United States") returns a table that is a subset of Internet Sales minus all rows that belong to the United States sales territory. The RELATED func



Top 10 Reasons Snowflake Rocks!

12-August-2019  0 Comment(s)

Using the following SQL statement on Snowflake, I managed to stand up a 4 node (MEDIUM) virtual compute cluster, fully installed, and ready to accept queries against an existing multi-petabyte data warehouse.

Snowflake create warehouse size medium

Azure SQL Database DTU Calculator

09-August-2019  0 Comment(s)

 Azure SQL Database. If so, you've probably asked yourself, "which service tier and performance level should I use and how many database throughput units (DTUs) am I using now?" This calculator will help you determine the number of DTUs for your existing SQL Server database(s)



MDX FirstChild Function

08-August-2019  0 Comment(s)

The MDX FirstChild function will return the First Child member belongs to the specified member. For example, If you know single customer name and if you want to find the Sales of a first customer then you can use this FirstChild function.

SELECT 
  [Measures].[Reseller Sales Amount
										


Indexed views in sql server

06-August-2019  0 Comment(s)

standard or Non-indexed view, is just a stored SQL query. When, we try to retrieve data from the view, the data is actually retrieved from the underlying base tables. So, a view is just a virtual table it does not store any data, by def



clean data efficiently, and perform fuzzy matching

05-August-2019  0 Comment(s)

The above diagram shows how to clean data efficiently and pefrom a fuzzy matching. While much of data cleaning is performed before loading data in a database (especially for one-time, ad hoc analyses), there is a way to do it, continuously (like once a week or once a day), once the data is i



Setup a tabular data model in SSAS Azure

04-August-2019  0 Comment(s)

SQL Server Data Tools and SQL Azure can be used to quickly setup a tabular model in SSAS Azure. First you need to setup a SSAS Azure server by logging on to your Azure portal. The Analysis Services Preview menu option is available in the Intelligence + Analytics section of the new resources menu.



Expression to account for weekends through SSIS

03-August-2019  0 Comment(s)

when outputting to excel. How can i get this to be just the date like 20150429 instead of the full start time.

((DT_I4)DATEPART("weekday",@[System::StartTime]) ==2 ? 

Replace((DT_STR, 20, 1252)(DATEADD( "D", -3,@[System::StartTime])),":&



Data Mining on SSAS

01-August-2019  0 Comment(s)

Microsoft SQL Server Analysis Services makes it easy to create data mining solutions using wizards and integrated visualizations. Particularly if you are new to machine learning, the tools in Analysis Services are an easy way to design, train, and explore data mining models. The data in your mode



Azure SQL DB

31-July-2019  0 Comment(s)

When choosing to create the database from a sample, the Collation cannot be changed. You can only provide a Collation when creating a blank database. A Collation is used to specify the language characters used in char and varchar datatypes. It also specifies sorting rules, case, and accent sensit



The Logic behind the Magic of DAX Cross Table Filtering

28-July-2019  0 Comment(s)

Automatic cross filtering between columns of the same table or related tables is a very powerful feature of DAX. It allows a measure to evaluate to different values for different cells in a pivot table even though the DAX expression for the measure does not change. Filter context is the underlyin



Accessing virtual machines behind Azure Firewall with Azure Bastion

26-July-2019  0 Comment(s)

Azure Virtual Network enables a flexible foundation for building advanced networking architectures. Managing heterogeneous environments with various types of filtering components, such as Azure Firewall or your favorite network virtual appliance (NVA), requires a little bit of planning.



Power BI assistant troubleshouting

25-July-2019  0 Comment(s)

Open only ‘Power BI assistant’ report and make it work with itself

If you get some issue, don’t open any other Power BI report. Power BI assistant may analyse its own tables. Once it works with itself, you may open an other report and analyse it.

The Window



MDX OpeningPeriod Function

23-July-2019  0 Comment(s)

The basic syntax of the OpeningPeriod in Multidimensional Expression is as shown below:

OPENINGPERIOD (Level_Expression, Member_Expression)

 

 

Following screenshot shows the List of Calender Years inside the Date Dimension

 <



MDX Siblings Function

22-July-2019  0 Comment(s)

The MDX Siblings function will return all the Child members that belongs to the parent of a specified member OR We can simply say, Siblings function will return all the Siblings of a specified member. For example, If you know single customer name and if you want to find the Sales of all the custo



SSMS Tips and Tricks to boost your Productivity

20-July-2019  0 Comment(s)

Use custom colors to differentiate between environments

During our day to day work in SSMS, generally we have to shift between different environments – Local/DEV/QA/MOCK/PROD, resulting in the creation of multiple query tabs – with each query tab connected to different env



SQL Unique Constraint

18-July-2019  0 Comment(s)

SQL Unique Constraint will ensure that no duplicate values are inserted into the SQL table columns. For example, if we want to make sure that the Employee, or a customer has to login using single email address then we can assign a Sql Unique Constraint to that column.

In this article we



Power BI performance best practices

15-July-2019  0 Comment(s)

The more data that a visual needs to display, the slower that visual will be to load. While this principle seems obvious, it can be easy to forget. For example: suppose you have a large dataset. Atop of that, you build a report with a table of the table. End users use slicers on the page to get t



MDX LastPeriods Function

13-July-2019  0 Comment(s)

MDX LastPeriods function is used to navigate between same level members and returns the set of members up to the specified position including the given number itself. For example, If you want to list the members from one position to particular member then we can use this MDX LastPeriods function.



smarter transformation and integration of enterprise data with Power Query and Data Integration Platform

12-July-2019  0 Comment(s)

Power Query is being dramatically enhanced with market-leading Smart Data Preparationexperiences, including:

  • Data extraction from semi-structured sources like PDF files.
  • HTML pages.
  • Fuzzy-matching algorithms to rationalize and normalize data b


SQL Server Analysis Services and Big Data

09-July-2019  0 Comment(s)

The Klout data warehouse, which relies on Apache Hadoop-based technology, exceeds 800 terabytes of data. But Klout doesn’t just crunch large data volumes; Klout takes advantage of Microsoft SQL Server 2012 Analysis Services to deliver reliable scores and actionable insights at the speed of



How to Remove or Reorder Columns in Power BI

08-July-2019  0 Comment(s)

Clicking Edit Queries option will open a new window called Power Query Editor.

From the below screenshot you can see there are State codes, country codes, which are not required for the analysis purpose. So, let me remove those columns fr



Visualising Tabular Object Dependencies in Power BI

06-July-2019  0 Comment(s)

After importing the custom visual put it on the page then put “Referenced Object” to “Source”, “Object Name” to “Target” and “Object Count” to “Weight”. Depending on how big your model is and the number of model dep



Cube Dimension in SSAS

03-July-2019  0 Comment(s)

Within the Dimension Pane, Right-click on the Cube Name will open the Context Menu to choose the options. Since we are adding the Cube dimensions click on the Add cube dimension option

Clicking on the Add cube dimension option will o



Microsoft SQL Server to MySQL Migration

25-June-2019  0 Comment(s)

SQLines provides tools and services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Microsoft SQL Server to MySQL.

We also help convert embedded SQL statements in C/C++ (O



SQL SELECT DISTINCT

23-June-2019  0 Comment(s)
-- SQL Select Distinct on Single Column Example
USE [SQLTEST]
GO
SELECT DISTINCT [Education]
  FROM [Employees]

SQL Select Distinct Multiple Columns

When we use the SQL Select Distinct multiple columns, the SELECT Statement returns the unique combination of multipl



Difference between Database Dimension and Cube Dimension in SSAS

12-June-2019  0 Comment(s)

In SQL Server Analysis Services, there are Two types of Dimensions

Database Dimension
Cube Dimension
Database Dimension in SSAS
All the dimensions that are created using the Dimension Wizard of the Solution Explorer are treated as database dimensions. In other words



Drillthrough Filter In Power BI – A Quick Guide

09-June-2019  0 Comment(s)

In all the time that I have been using PowerBI, I noted that the reports were always filled up with data and there was little to no space to add details about any sort of entit



USING A MODEL DRIVEN APP ON YOUR SMARTPHONE

08-June-2019  0 Comment(s)

In Dynamics 365, there are mobile apps you can download and use for your tablet and phone. To download the apps, head to the app store for your device



Power BI - dataflows

07-June-2019  0 Comment(s)

Solution
According to Microsoft this new addition is for self-service ETL by business annalists and BI professionals. A minor addition from our side: especially business annalists that are skilled with tools like Excel and BI professionals with already a focus on Power BI will probably be



SQL Default Constraint

05-June-2019  0 Comment(s)

SQL Default Constraint is used to assign default values to the SQL table columns. In general, every column accepts either Nulls, or a Value. If the user forgot to enter the value then SQL Server will assign NULL value to the column. In



Drill Down Reports in SSRS

04-June-2019  0 Comment(s)

The Drill Down Reports in SSRS means allowing Users to Show or Hide the Column Data by providing plus and minus symbols on a text box (In short, Providing Interactivity to the Users).

In this article, we will show you, How to Create Drill Down Reports in SSRS with an example.



Write CSV in R

03-June-2019  0 Comment(s)

I often write to CSV with R in order to save data and share files with others. One way to output a csv from R is with the command write.csv. Here is an example of how to write CSV in R:

# Write CSV in R
write.csv(MyData, file = "MyData.csv")

The above writes t



ETL Testing

01-June-2019  0 Comment(s)

Usually in Data Warehousing/Business Intelligence projects ETL (Extract, Transform, Load) tools like Informatica, Datastage, Talend etc are used to design ETL Jobs. Some companies still use scripting to develop ETL Jobs.

 

ETL Testing can be as simple as

 <



Installing Power BI On-Premise Server

31-May-2019  0 Comment(s)

The Power BI On-Premise server is a real and true BI report Portal is a tried and proven reporting portal solutions for your organization. Coming from a long history of enterprise reporting from the SQL Server Reporting Services reporting portal, Microsoft has done a great job by improving SSRS w



R With PowerBI: A Step-by-Step Guide

30-May-2019  0 Comment(s)

There's been a lot of interest everywhere on how to integrate R scripts with Microsoft PowerBI dashboards. Here is a step by step guide to this.

Lets assume that you have some readymade R code available, for example, with the ggplot2 



Memory management will blocks of code

16-May-2019  0 Comment(s)

A solid understanding of R’s memory management will help you predict how much memory you’ll need for a given task and help you to make the most of the memory you have. It can even help you write faster code because accidental copies are a major cause of slow code. The goal of this cha



R Interface to TensorFlow

14-May-2019  0 Comment(s)

TensorFlow™ is an open source software library for numerical computation using data flow graphs. Nodes in the graph represent mathematical operations, while the graph edges represent the multidimensional data arrays (tensors) communicated betwe



DATEADD() and other Date Tips for Filtering Data in Power BI

13-May-2019  0 Comment(s)

While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the function works and the parameters you pass to it in order to shift a date forward or backwards. However, t



CALCULATING QUARTILES WITH DAX AND POWER BI

12-May-2019  0 Comment(s)

The PERCENTILEX.INC function returns the number at the specified percentile. So for example, if I had numbers 0 and 100 in my data set, the 25th percentile value would be 25. The 50th percentile value would be 50 and the 75th percentile value would be 75, and you can figure out what the 100th per



Common Data Analysis Pattern with a Simple Solution in R

08-May-2019  0 Comment(s)

It seems that much of the data analysis work I've done over the last few months has followed a "script". First, identify data, often government-sponsored and freely-available, that's of keen interest. Next, find the websites that house the data and download the relevant files to



Date Dimension Using Computed Columns

07-May-2019  0 Comment(s)

Use this script below to create a Date Dimension for a data warehouse that is based off of computed columns. The only column that needs to be populated is the CalendarDate column.

 

CREATE TABLE [DimDate](
[DateKey] [int] IDENTITY(1,1) NOTNULL,
[CalendarDate



SSIS Data Conversion

06-May-2019  0 Comment(s)

Drag and drop the data flow task from the toolbox to control flow and rename it as SSIS Data Conversion Transformation.

Drag and drop EXCEL Source, Data Conversion Transformation from toolbox to data flow region.

Double click on Excel source in the data flow region will open t



Split function in SQL Server Example: Function to Split Comma separated (Delimited) string in SQL Server

01-May-2019  0 Comment(s)

 



SQL Server - How to Create Multiple Instances on Single Server

29-April-2019  0 Comment(s)

When you install SQL Server, the installation creates an instance of SQL Server. But how to create more instances?After you have installed SQL Server and have the default (or named) instance, start the setup again to create a new instance.

For example, when



Building a time tracking flow

28-April-2019  0 Comment(s)
  1. Save the file (Save as) with the name Timesheet.xlsx.
  2. Let’s create


DAX Measure Dependencies in SSAS Tabular and Power BI

27-April-2019  0 Comment(s)

This method is fairly simple, you just need to run the following DMV on top of your SSAS Tabular model or your Power BI Desktop file and Import the results in Power BI.

SELECT * FROM $System.DISCOVER_CALC_DEPENDENCY

For Power BI you’ll need to 

SSIS packages to import MS Excel data into a database

26-April-2019  0 Comment(s)

Inserting the data in the database table can be hard and can take a long time. Especially today when the databases becoming bigger and bigger. Automated data importing is possible using different methods, depending on source file type and data organization inside 
 

The



DAX Measure Dependencies in SSAS Tabular and Power BI

24-April-2019  0 Comment(s)
  • Open Power BI Desktop
  • Select “SQL Server Analysis Services database” then click “Connect”
  • Enter the “Server” and “Database”
  • Make sure you select the “Import” mode
  • Expand “MDX or D


Power BI Dataflows

23-April-2019  0 Comment(s)

Data is loaded via a web-based version of Power Query, which is why this capability is referred to as self-service data prep. The resulting data is stored in Azure Data Lake Storage Gen 2. Once in the Common Data Model in the data lake, it can be reused among various Power BI datasets -- allowing



How to find a Dataset ID in Power BI

22-April-2019  0 Comment(s)

Today, I had to get a single dataset ID from a report I had deployed to the Power BI Service. I quickly realized I had no idea where or how to get it! Turns out, it’s super easy to find – if you know where to look :)

Since I had to click around for a bit, do some searches, a



SQL Server 2019 Analysis Services CTP 2.3

20-April-2019  0 Comment(s)

We find great pleasure in announcing the public CTP 2.3 of SQL Server 2019 Analysis Services. New features detailed here are planned to ship later in Power BI Premium and Azure Analysis Services.

Calculation groups

Here is a question for seasoned BI professionals: what is th



PowerApps Coding for the image screen

16-April-2019  0 Comment(s)

There’s two ways you can approach this.

The first way is to group controls then assign click events to the group’s OnSelect event.

The second way is to lay a transparent rectangle on top of the group and use the rectangles OnSelect event.

I prefer the sec



PowerApps Coding for the image screen

16-April-2019  0 Comment(s)

There’s two ways you can approach this.

The first way is to group controls then assign click events to the group’s OnSelect event.

The second way is to lay a transparent rectangle on top of the group and use the rectangles OnSelect event.

I prefer the sec



Merge Operations in Power BI / Power Query

14-April-2019  0 Comment(s)
  • then we find the file that we downloaded (with the name of Sample Data.xlsx). We then select the option to “Select multiple items” and we select both the ExportedData and ExclusionTable tables:
  • ExportedData – similar to the previous post,


SQL Server deadlock victim selection

13-April-2019  0 Comment(s)

How SQL Server detects deadlocks
Lock monitor thread in SQL Server, runs every 5 seconds by default to detect if there are any deadlocks. If the lock monitor thread finds deadlocks, the deadlock detection interval will drop from 5 seconds to as low as 100 milliseconds depe



PowerApps vs. Traditional App Development Approach

10-April-2019  0 Comment(s)

As developers begin to use PowerApps for development, questions arise in their minds as to the differences between Traditional App Development Approach vs. using PowerApps. This article summarizes some of the differences between these approaches. The following categories are a good way to compare



SSAS Named Calculations

09-April-2019  0 Comment(s)

In SQL Server Analysis Services, a Named Calculation is nothing but creating new column and add it to a Table or View in Data Source View. Named Calculation is created based on the expression or some static value or combination of existing columns. Following are the important features of the Name



SQL server Capacity Limits by Edition of SQL Server

08-April-2019  0 Comment(s)
  • A thread or logical processor is one logical computing engine from the perspective of SQL Server, the operating system, an application or driver.

  • A core is a processor unit, which can consist of one or more logical processors.

  • A physic



Create Project Status Report in Project Online automatically using Microsoft Flow

06-April-2019  0 Comment(s)

Build yo



Create Project Status Report in Project Online automatically using Microsoft Flow

06-April-2019  0 Comment(s)

Build yo



DataOps is NOT Just DevOps for Data

04-April-2019  0 Comment(s)

One common misconception about DataOps is that it is just DevOps applied to data analytics. While a little semantically misleading, the name “DataOps” has one positive attribute. It communicates that data analytics can achieve what software development attained with DevOps. That is to



Power BI and PowerShell - Update Dataset

03-April-2019  0 Comment(s)

Power BI offers a REST API for embedding, administration, and user resources. In this post I walk you through how to refresh a dataset with PowerShell. 

 

Prerequisites

To be able to run a PowerShell script to update a Dataset in Power BI you have to



SSIS Foreach NodeList Enumerator

02-April-2019  0 Comment(s)

The SSIS Foreach NodeList Enumerator is useful to enumerate the XML nodes. For example, you can traverse to any node in a XML file using this enumerator. In this article we will show you, How to use this SSIS Foreach NodeList Enumerator with example.

Before we start demonstrating the Fo



SQL Server 2019 Analysis Services CTP 2.3

01-April-2019  0 Comment(s)

Calculation groups

Here is a question for seasoned BI professionals: what is the most powerful feature of SSAS multidimensional? Many would say the ability to define calculated members, typically using scoped cell assignments. Calculated members in multidimensional enable complex calc



Creating a simple stored procedure without any parameters:

31-March-2019  0 Comment(s)

his stored procedure, retrieves Name and Gender of all the employees. To create a stored procedure we use, CREATE PROCEDURE or CREATE PROC statement.

Create Procedure spGetEmployees
as
Begin
 



Counting and correlating pairs of words with the widyr package

30-March-2019  0 Comment(s)

Tokenizing by n-gram is a useful way to explore pairs of adjacent words. However, we may also be interested in words that tend to co-occur within particular documents or particular chapters, even if they don’t occur next to each other.

Tidy data is a useful structure for comparing



Control access to forms

29-March-2019  0 Comment(s)

Applies to Dynamics 365 for Customer Engagement apps version 9.x (on-premises)

There are two ways you can control access to main forms:

  • Make a main form inactive

    You can set an active or inactive state to main forms. This feature was i



w

28-March-2019  0 Comment(s)


Microsoft Flow Smart Light Automation with IFTTT

28-March-2019  0 Comment(s)

What is IFTTT?

IFTTT stands for If This Then That (clever huh?).  It is another automation tool, similar to Flow but more focused on the consumer side.   IFTTT is free and has many native connectors to various smart home devices including:  NEST, WEMO, Phillips Hue



Relationships with a many-many cardinality in Power BI Desktop

22-March-2019  0 Comment(s)

With the relationships with a many-many cardinality feature in Power BI Desktop, you can join tables that use a cardinality of Many to Many. You can more easily and intuitively create data models that contain two or more data sources. The relationships wi



Reporting Services (SSRS) OR Filter Logic

21-March-2019  0 Comment(s)

 I am working on having a sales meeting and want to include the local sales people along with some of my top performers.  I would create a report with two parameters, one to filter the report by state and the other based on the sales amount like the following:

In order to reso



For Loop Container in SSIS

20-March-2019  0 Comment(s)

The For Loop Container in SSIS will repeat the SQL Integration Services tasks for given number of times, until the given condition is False. This is same as the For Loop in any programming language. In this article we will show you the step by step approach to configure the For Loop in SSIS with



Global References in SSRS

19-March-2019  0 Comment(s)

The Built-in Fields Collection includes the Global references in SSRS and the references include the global variable which is pre-defined by the Microsoft. These are the common variables that are used in every report that we design such as Page Numbers, Total Page Numbers etc.

We are go



3 major components of Microsoft Flow

18-March-2019  0 Comment(s)

 the three fundamental blocks (components) of Microsoft Flow

  1. Triggers
  2. Actions
  3. Conditions

trigger is something that triggers or starts the wor



Update Statistics in SQL Server

16-March-2019  0 Comment(s)

If you care about SQL Server performance you need to take SQL Server Statistics into account. Statistics are lightweight and small objects which describe how data in SQL Server tables are distributed. The query optimizer uses them to create query plans that improve query performance.



PowerPoint presentations from R

15-March-2019  0 Comment(s)

Regardless of the tools used for data analysis, normally the way to display the results is a Word document or a PowerPoint presentation.

 PowerPoint presentation and insert a series of graphics and text programmatically, using the OfficeR and rvg&



Yammer Analytics In Power BI

12-March-2019  0 Comment(s)

Let’s imagine your organization is using Yammer as an internal platform for digital collaboration, engagement, knowledge sharing etc.

It is a large international organization with employees around the globe (think big).

I have access to Yammer in one of such organization



Parameter Tables in Power Query

11-March-2019  0 Comment(s)

The way to make a dynamic Power Query solution is to make sure that it can be easily customizable and, at the same time, be able to work as more of a pattern rather than just a unique one off solution to a single file, table or whatever it is that your query works against. This is exactly where P



Control flow of R

10-March-2019  0 Comment(s)

The basic form of an if statement in R is as follows:

if (condition) true_action
if (condition) true_action else false_action

If condition is TRUEtrue_action is evaluated; if condi



10 reasons why Power BI

09-March-2019  0 Comment(s)

1)     Unlimited access to on-premise and in-cloud data

2)     Interactive and stunning visualisations you can share with wide audiences

3)     Immediate and fr



Column Chart in SSRS

08-March-2019  0 Comment(s)

SSRS Column charts are good for comparisons. By seeing the Column Chart one can understand the business without any further concerns.

For example, compare product Sales of this year with the previous year, Monthly / Yearly performance of an employee, customer orders compared to last yea



Flow is a workflow automation tool

07-March-2019  0 Comment(s)

For those of you unfamiliar, Flow is a workflow automation tool that is very easy to use and allows you to build an automated (if this, then that) scenario extremely quickly. In fact, this being my first foray into Flow, it took me less than an hour to get my scenario up and running – it do



Power BI Basic Filters

06-March-2019  0 Comment(s)

Visual Level Filters: This includes Filters on Dimension, Filters on Measures, Basic Filters, Advanced Filters, and Top N filters
Page Level Filters: Theses Page Level Filters will apply to all the visuals present in the current page.
Drill through Filters: This Drill through Filter



Different ways to replace NULL in sql server

05-March-2019  0 Comment(s)

Replacing NULL value using ISNULL() function: We are passing 2 parameters to IsNULL() function. If M.Name returns NULL, then 'No Manager' string is used as the replacement value.
SELECT E.Name as Employee, ISNULL(M.Name,'No Manager



10 Reusable Components: tab control, calendar, dialog box, map control and more

27-February-2019  0 Comment(s)

Before I delve into individual components, I would like to share 2 guiding principles we used as much as possible when building these controls.

1) A reusable control should offer a degree of customization and flexibility so that consumers of the controls do not need to delve into the co



SQL server featuers

26-February-2019  0 Comment(s)

Top new Features:

     1. Adaptive query processing

     2. Resumable online index rebuild

     3. Automatic database tuning

     4. New G



Power BI Dataflows

25-February-2019  0 Comment(s)

One of the compelling features of dataflows is the ease with which any authorized Power BI user can build semantic models on top of their data. Because dataflows already store data in CDM folders, the integration between Power BI and Azure Data Lake makes it possible for any authorized person or



How to create an R Script

24-February-2019  0 Comment(s)

We first need to write the R script before we import it into Power BI. Power BI only gives a minimal scripting area so it is much more easier to use an IDE to development the script. If you don’t have R setup on your computer then please read How to Setup Power BI to Use R Scripts. Open R S



What is Filter Context?

22-February-2019  0 Comment(s)

There are a couple of fundamental concepts that one must learn in order to build effective reports in Power BI and Power Pivot. One of the core concepts is filter context. What is filter context? It is a little confusing if you are coming from an excel background. The easiest way to think about i



What is Filter Context?

22-February-2019  0 Comment(s)

There are a couple of fundamental concepts that one must learn in order to build effective reports in Power BI and Power Pivot. One of the core concepts is filter context. What is filter context? It is a little confusing if you are coming from an excel background. The easiest way to think about i



How to Write CSV in R

21-February-2019  0 Comment(s)

 CSV with R in order to save data and share files with others. One way to output a csv from R is with the command write.csv. Here is an example of how to write CSV in R:

# Write CSV in R
write.csv(MyData, file = "MyData.csv")

The above writes the data dat



Interpreting machine learning models with the lime package for R

20-February-2019  0 Comment(s)

Many types of machine learning classifiers, not least commonly-used techniques like ensemble models and neural networks, are notoriously difficult to interpret. If the model produces a surprising label for any given case, it's difficult to answer the question, "why that&nbs



How to convert ‘20140620’ date to ‘DD-MM-YYYY’ format – MSDN TSQL forum

18-February-2019  0 Comment(s)

I have data for date fields like “20140620”(YYYYMMDD) while inserting into the table it should be in the format “DD-MM-YYYY

Can any one please help me to achive this.

SELECT FORMAT(CAST<



Power BI Gateway Connection and Managing Gateways

16-February-2019  0 Comment(s)

1. PowerBar Web will schedule the refresh of the screen (automatically can define defined in the hours that we set as data sources to increasingly data update.) Report DATA SETS menu ... clicked section and RENEWAL of TIME (Schedule Refresh) is selected.

If you want to update the data m



PowerApps vs. Traditional App Development Approach

15-February-2019  0 Comment(s)

As developers begin to use PowerApps for development, questions arise in their minds as to the differences between Traditional App Development Approach vs. using PowerApps. This article summarizes some of the differences between these approaches. The following categories are a good way to compare



What are button trigger tokens

14-February-2019  0 Comment(s)

Peek code in no code platforms. Of course LogicApps has had this peek code for a while. But this is new to Flow.When you click on the peek code option for an action or a trigger, you will find the json that was used to behind the pretty interface of Microsoft Flow.This is a great step forward tow



POS System Backup Made Easy

13-February-2019  0 Comment(s)

POS System backup
Why should you take a POS system backup?
Like we’ve mentioned already in our article’s header, the reason why this should be treated with utmost importance is that, as you already know, sales data needs to be reported to government authorities and can a



Custom Visuals For Power BI

11-February-2019  0 Comment(s)

The Custom Visuals in Power BI are considered as one of the prominent factors for awesomeness in Power BI. As a developer you can create your own Custom Visuals here, and publish them to AppSource (aka the marketplace).

Report producers can load Custom Visuals into their Power BI report



Creating a Hybrid Dataset

09-February-2019  0 Comment(s)

For the first part we need to start in Power BI, which can be found at https://powerbi.microsoft.com. Power BI uses workspaces to organise datasets, reports and dashboards, with a free license you will only have access to My Workspace, that will work for this exercise.


Click on



Keep Headers Visible While Scrolling in SSRS

08-February-2019  0 Comment(s)

Keep Headers Visible While Scrolling in SSRS Reports. Please refer to SSRS Table Report, Data Source and Dataset articles to understand the creation of Data Source, Dataset and Table report.

From below screenshot, you can see, It was a normal Table report with Product Name, Color, Sales



ETL- The next gen working with data transformation

07-February-2019  0 Comment(s)

ETL stands for Extract, Transform and Load. ETL is one of the main components in a BI Solution backed by a Data Warehouse. ETL is also used in other projects like Data Migration and Data Integration projects. ETL flows/jobs can be built by scripting or by using ETL Tools. Most of the companies cu



Import Power BI Desktop Model to SSAS Tabular 2016

06-February-2019  0 Comment(s)

How it works?

The idea is to

  1. Connect to Power BI Desktop model from SSMS 2016
  2. Script the model
  3. Modify the script
  4. Execute the scripts on your on-premises instance of SSAS Tabular 2016
  5. Open the new SSAS Tabular database in SS


New memory options for Analysis Services

05-February-2019  0 Comment(s)

IsAvailableInMdx
The IsAvailableInMdx column property is available in Azure Analysis Services and SQL Server Analysis Services 2017 CU7.

It prevents building attribute hierarchies, reducing memory consumption. This means the column is not available for group-by queries to MDX cli



BI Structure

02-February-2019  0 Comment(s)

Business intelligence and data warehousing teams are constructed differently, but most are placed within the IT department and include some basic, common roles.

nested data structures, how they are represented in different databases, and the benefits and challenges of using nested dat



FIND_IN_SET Function - How to find position of string in Comma separate values list

01-February-2019  0 Comment(s)

FIND_IN_SET function is used to find the position of string in list of comma separated values. FIND_IN_SET can return depending upon the searched value and values present in comma separated list.

 

Syntax:
FIND_IN_SET( StringtoFind,Comma_Separated_String_List);



One-way Analysis with Permutation Test

31-January-2019  0 Comment(s)

Permutation tests are non-parametric tests that do not assume normally-distributed errors.  However, these tests may assume tha



Automate a flow in Microsoft Flow

30-January-2019  0 Comment(s)

In flow.microsoft.com, select My flows in the top navigation bar, and then select Create from blank.Select the Search hundreds of connectors and triggers box at the bottom of the screen, enter Twitter in the box that says Search a



Refresh date\time in a Power BI report and dashboard

29-January-2019  0 Comment(s)

Show last refresh date\time

To show the date and time of the refresh we need to store the date and time of the time refresh runs in the model itself so we can show it in a visual.

One of the easiest options is to use Power Query to store the current date\time as a table. I s



Statistics of Dispersion

26-January-2019  0 Comment(s)

Measures of dispersion—such as range, variance, standard deviation, and coefficient of variation—can be calculated with standard functions in the native stats package.  In addition, a function, here called summary.list, can be defined to output wh



Print a Form in PowerApps with flow

25-January-2019  0 Comment(s)

will need to generate a Printable view of your Form from HTML.  You can use any HTML tool to do this (You can even copy and paste the HTML Code from InfoPath if you are migrating a form, and you had a printable view in there).  For this example, I created a simple 2 Column HTML Table, a



Conditional Column in Power BI

24-January-2019  0 Comment(s)

Power BI Conditional column generate a new column based on the condition that we specify. For example, creating an appraisal column based on the employee performance etc. In order to add conditional column, please click Edit Queries option under the Ho



What are Data Flows

23-January-2019  0 Comment(s)

The new Azure Data Factory (ADF) Data Flow capability is analogous to those from SSIS: a data flow allows you to build data transformation logic using a graphical interface. A really interesting aspect about ADF Data Flows is that they use Azure Databricks as the runtime engine underneath -- howe



Add Total and Subtotal to SSRS Report

22-January-2019  0 Comment(s)

To explain the steps involved to add Total and Subtotal to SSRS Report, We are going to use  below shown DataSet. Please refer to Embedded Data Source and Dataset articles to understand the steps involved in creating Embedded Data Source, and Dataset that we used for this report. <



DAX Measure Dependencies in SSAS Tabular and Power BI

21-January-2019  0 Comment(s)

DAX measures are the heart of every SSAS Tabular model, Power BI and Power Pivot solution. You write lots of DAX measures and you potentially reference some of them in other measures. So the number of DAX measures you write and reference them via other measures grow very quickly. Especially in co



SSAS: Utility to check you have the correct data types and sizes in your cube definition

20-January-2019  0 Comment(s)

 it is often necessary to use the SQL CAST or CONVERT operation to change the data type to something more appropriate for SSAS.  This is particularly important when your cube is based on an Oracle data source or using custom SQL queries rather than views in the relational database. &nbs



Integration of Microsoft Flow and Power BI

19-January-2019  0 Comment(s)

Microsoft Flow is a SaaS offering for robotizing workflows over the developing number of utilization and SaaS administrations that business clients depend on. With Flow, you can robotize assignments by coordinating your most loved applications and administrations (counting Powe



Canvas Apps helps to build the apps

18-January-2019  0 Comment(s)

Creating a simple canvas PowerApp is easy. But as the complexity of your app increases, care must be taken to keep your apps maintainable and performant. Across the web there is such great information available about PowerApps, both from within Microsoft as well as a vibrant maker community, yet



Snowflake schema on List

17-January-2019  0 Comment(s)

If you want to group by another column, you can add the WITHIN GROUP clause. For example, return a list of concatenated employee names per department.

Since SQL Server 2017, you have the sting_agg function, which has almost the exact same syntax as its Snowflake counterpart. There are t



SQL Script for creating Structure from SQL Tables

14-January-2019  0 Comment(s)

ADF is available on the Azure portal, and you can use it to create pipelines to move data to and from other cloud based data stores and on premise data stores using Data Management Gateways.
There is a lot of documentation and info about ADF online. If you are brand new to it, I’d re



DAX Measure Dependencies in SSAS Tabular and Power BI

13-January-2019  0 Comment(s)

DAX measures are the heart of every SSAS Tabular model, Power BI and Power Pivot solution. You write lots of DAX measures and you potentially reference some of them in other measures. So the number of DAX measures you write and reference them via other measures grow very quickly. Especially in co



Creating a Hybrid Dataset

12-January-2019  0 Comment(s)
  1. Click on My Workspace and then Datasets.
  2. In the top right hand corner, click +Create and select Streaming Dataset.
  3. Choose API as the source of the dataset and click Next.
  4. Enter in a name for the dataset.
  5. Enter in the value names and data types.<


InfoPath alternatives and the potential of PowerApps

11-January-2019  0 Comment(s)

we dig into the all the details, here’s a higher level rundown of how these features fit together. We’ve focused on the following key priorities:

Quality, quality, quality. PowerApps is now faster and more reliable than ever before, with continued investments in core platfor



PBI Report Template With Custom Calendar

10-January-2019  0 Comment(s)

Power BI report templates are amazing as starter reports. They can be built with or without data sets. Design practices such as a standardized calendarcompany logo, visualization arrangement, backg



Create Cube Dimension in SSAS

09-January-2019  0 Comment(s)

 

STEP 1: Within the Dimension Pane, Right click on the Cube Name will open the Context Menu to choose the options. Since we are adding the Cube dimensions click on the Add cube dimension option

Clicking on the 



Difference between a Heap table and a Clustered table

08-January-2019  0 Comment(s)

Heap table is a table in which, the data rows are not stored in any particular order within each data page. In addition, there is no particular order to control the data page sequence, that is not linked in a linked list. This is due to the fact that the heap table co



bcp Utility (bulk copy program) in SQL Server

07-January-2019  0 Comment(s)

The Bulk copy program aka bcp is the console application used to export and import data from text files to SQL Server or vice versa.

It is very popular because it is fast and easy to download.

This tool is installed by default with SQL Server. It is usually installed in the fo



qwe

03-January-2019  0 Comment(s)

qwe



Creating shared datasets in SSRS

28-December-2018  0 Comment(s)

In SSRS, Dataset is an SQL Command used to retrieve the data from Data Source for Report creation. Dataset consists of SQL Command, parameters, filters etc. SQL Server Reporting Services supports two types of datasets: Shared Dataset and Embedded Dataset. In this article, we will show you, Steps



PowerApps updates to many new features

23-December-2018  0 Comment(s)

Before we dig into the all the details, here’s a higher level rundown of how these features fit together. We’ve focused on the following key priorities:

  1. Quality, quality, quality. PowerApps is now faster and more reliable than ever before, with


New connectors from Flow

22-December-2018  0 Comment(s)
  • Imprezian360 – A comprehensive suite of integrated technologies for sales-leads, order management and inventory designed for Quickbooks Desktop Editions.


SQL Server Health Check

21-December-2018  0 Comment(s)

Why do we need SQL Server Health Check?

Here we are going to highlight two crucial point capacity planning and reaction time. Now let’s dig deeper and say a few words about each of them.

Capacity Planning


Why SQL Server Performance Baselining is important?

20-December-2018  0 Comment(s)
  • Performance is relative – DBAs, Consultants and Support team often get called in a situation when the business application running on SQL Server is running slow. Before troubleshooting, one of the first question to ask is how slow is slow and how fast is fast?.


Add Date Range Dataset in Reporting Services

19-December-2018  0 Comment(s)

1. Under Report Data on the Left-hand side of the report designer, Right-click on Datasets:

2. Click on Add Dataset and enter the following information:

  • Name = DateRange
  • Select "


80% to work hard and 20% PowerBI

18-December-2018  0 Comment(s)

POWERBI has 80% to work hard and 20% to see has made one of the best in Business Intelligence.

 



How to Create Multiple Instances on Single Server

15-December-2018  0 Comment(s)

When you install SQL Server, the installation creates an instance of SQL Server. But how to create more instances?

After you have installed SQL Server and have the default (or named) instance, start the setup again to create a new instance.

For ex



SSAS Dimensions Work around

14-December-2018  0 Comment(s)

Use Member Properties

Sometimes in a dimension we will have attributes that are important to view as details of another attribute but by themselves these attributes are not all that important for slicing and dicing. The Adventure Works Employee dimension has many attributes configured



effectiveness in advanced analytics & data science

13-December-2018  0 Comment(s)

Both R & Python should be measured based on their effectiveness in advanced analytics & data science. Initially, as a new comer in data science field we spend good amount of time to understand the pros and cons of these two. I too carried out this study solely for “self” to de



What is Common Data Service for Apps

12-December-2018  0 Comment(s)

Common Data Service (CDS) for Apps lets you securely store and manage data that's used by business applications. Data within CDS for Apps is stored within a set of entities. An entity is a set of records used to store data, similar to how a table stores data within a databa



Introduction to vector calculus and partial derivatives

11-December-2018  0 Comment(s)

Neural network layers are not single functions of a single parameter, f(x). So, let’s move on to functions of multiple parameters such as f(x,y). For example, what is the derivative of xy (i.e., the multiplication of x and y)?

Well, it depends on whether we are changing x or y. We



Use custom colors to differentiate between environments

10-December-2018  0 Comment(s)

During our day to day work in SSMS, generally we have to shift between different environments – Local/DEV/QA/MOCK/PROD, resulting in the creation of multiple query tabs – with each query tab connected to different environments. This often becomes unmanageable and difficult to keep tra



POWER BI Slicer vs Filter

09-December-2018  0 Comment(s)

Although very basic but many folks are not able to answer this in the interviews, which is better Filter or Slicer? 
 
Answer is it depends, a slicer is an alternate way of filtering but you do not have to pick one from slicer or filter, both complement each other that is



SQL MIN() and MAX() Functions

07-December-2018  0 Comment(s)

The MIN() function returns the smallest value of the selected column.

The MAX() function returns the largest value of the selected column.

SELECT MIN(column_name)
FROM table_name
WHERE condition;

 

SELECT MAX(column_name)
FROM tabl



MODEL-DRIVEN Powerapps

06-December-2018  0 Comment(s)

Go https://admin.powerapps.com/ and select New Environment. We will call ours Sample Apps Environment:

Click to Create Database:

Enter  &qu



Error Handling in SSIS

05-December-2018  0 Comment(s)

errors might occur when we are extracting data from a source, or loading data into a destination, or when you are performing a transformation. This is because of the unexpected data, and it is a bad practice to fail the package.

To handle these situations, SSIS introduced the concept ca



PowerBI-The game changer

04-December-2018  0 Comment(s)

Power BI is made up of various technologies and has developed slowly. Microsoft uses confu



3 Major Fundamental blocks in Flow

03-December-2018  0 Comment(s)

There are three major components that make up the Flow. Of course, there is a lot for you to learn about the new application, but what I am covering below are the nitty-gritty fundamentals one must know and understand to be able to create workflows using Flow



Remove errors with Power Query

02-December-2018  0 Comment(s)

Are you experiencing an issue when unpivotting Excel data?

Unfortunately as soon as you try to Unpivot a table of data containing a #DIV/0 or #/NA you get a very strange warning….

This is totally misleading, however the “More Details:” part of the message do



Moving Excel or other files using MS Integration Services (SSIS)

01-December-2018  0 Comment(s)

The Discerning Analyst always have, and will always need integration as part of his skill sets in his craft. To be able to move data automatically, by database trigger, scheduled task or scheduled SQL Jobs from whatever format excel, text file, xml etc etc to a destination database,shared folder



FLOW – GET A PUSH NOTIFICATION WHEN YOUR BOSS SENDS YOU AN EMAIL

26-November-2018  2 Comment(s)

 

Go to My Flows and Create From Template:

 

Search for “email boss”. You will see there are a few templates, including “Get a push notification when you receive an email from your boss”, “Get a text when you receive an email f



COMMON DATA MODEL AND COMMON DATA SERVICE

26-November-2018  0 Comment(s)

Microsoft has released the Common Data Model currently as part of its PowerApps suite. The Common Data Model and Common Data Service are a “Microsoft Azure–based business application model and storage mechanism for the Microsoft business application platform”. It allows for the



Calculate Working Days without Holidays for specific states in country

26-November-2018  0 Comment(s)

Recently I have a task to modeling for “Client Turnaround Report”. In this report, I need to calculate turnaround duration by counting all working days between appointment’s event date and finalization date. The problem is that working day is defined by:



Counting active products/clients/specialist over related dimensions

23-November-2018  0 Comment(s)

There is a simple question that could be asked in any industries for business understanding: how many active products so far? or how many new/active clients we have in this year/month?. Active products/clients is a term to describe the clients/products that is appeared in recently transactions. I



Relationship views

23-November-2018  0 Comment(s)

 

This will be simple task if customer’s age is calculated by current yea



WE ALWAYS WORK WITH :



Sam Analytiks is all about discussing the data, automation and business intelligence. Coming from the German Word "Wennschon Dennschon Rigtig". We share experience, knowledge, and data. The data operation from Sam Analytiks will give a new version, goals to the ongoing industrial projects and work on the mission to safeguard the human lives while achieving maximum efficiency.

CONTACT US:

Blusczowa 5, 00-234 Warsaw, Poland.
5 Brooke Road, Kenilworth CV8 2BG, United Kingdom