Are you over 18 and want to see adult content?
More Annotations
A complete backup of https://webkamerton.ru
Are you over 18 and want to see adult content?
A complete backup of https://redfieldplugins.com
Are you over 18 and want to see adult content?
A complete backup of https://mlmlaw.com
Are you over 18 and want to see adult content?
A complete backup of https://bh90210.ru
Are you over 18 and want to see adult content?
A complete backup of https://onlinefootballmanager.it
Are you over 18 and want to see adult content?
A complete backup of https://politwitter.ca
Are you over 18 and want to see adult content?
A complete backup of https://eldergym.com
Are you over 18 and want to see adult content?
A complete backup of https://laposada.org
Are you over 18 and want to see adult content?
A complete backup of https://fstravels.com
Are you over 18 and want to see adult content?
A complete backup of https://edremitmehmetakif.com
Are you over 18 and want to see adult content?
A complete backup of https://metrotix.com
Are you over 18 and want to see adult content?
A complete backup of https://yogatreesf.com
Are you over 18 and want to see adult content?
Favourite Annotations
Varvet: Software developers and designers — Gothenburg, Stockholm
Are you over 18 and want to see adult content?
یزد وب هاست – ارائه خدمات هاستینگ و سرور
Are you over 18 and want to see adult content?
ECO.MONO | Ethical Fashion & Accessories Australia | Shop Online – ecomono
Are you over 18 and want to see adult content?
скачать бесплатно на Interesno-tyt.ru - Сайт о самом интересном в мире фотошопа и дизайна!
Are you over 18 and want to see adult content?
Minecraft PE Maps, Mods, Servers, Skins, Texture Packs and more! • UTK.io
Are you over 18 and want to see adult content?
CTW-Academy-Home - Tom Avery Tennis | CTW Academy
Are you over 18 and want to see adult content?
Learning shall never stop..!!! – Ruby, Javascript and fun
Are you over 18 and want to see adult content?
Honest Marijuana - Organic Marijuana Grown In Colorado
Are you over 18 and want to see adult content?
Text
PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if CREATING POWER BI LAYOUTS USING POWERPOINT To start the creation of a layout, open PowerPoint with a blank side and add a rectangle. Next, add glow to the rectangle, glow is found in the drawing ribbon under shape effects. Repeat the process of adding rectangles with glow and lay them out so the visuals will fit. If there is an important visual that needs to be a certain size you can CAPTURING INSERT AND UPDATE COUNTS FROM MERGE There is a limitation, though, you can’t aggregate the table. So if we want to summarise the actions into a single row of insert, update and delete counts, we have to use a temporary table such as in the sample code below. CREATE TABLE #MergeActions ( VARCHAR (10)) INSERT INTO #MergeActions ( ) SELECT FROM ( MERGE.
LOOKUPS AND IF CONDITIONS IN AZURE DATA FACTORY V2 (ADFV2 Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. This WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
MAP POSTCODES IN SSRS REPORTING SERVICES EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if CREATING POWER BI LAYOUTS USING POWERPOINT To start the creation of a layout, open PowerPoint with a blank side and add a rectangle. Next, add glow to the rectangle, glow is found in the drawing ribbon under shape effects. Repeat the process of adding rectangles with glow and lay them out so the visuals will fit. If there is an important visual that needs to be a certain size you can CAPTURING INSERT AND UPDATE COUNTS FROM MERGE There is a limitation, though, you can’t aggregate the table. So if we want to summarise the actions into a single row of insert, update and delete counts, we have to use a temporary table such as in the sample code below. CREATE TABLE #MergeActions ( VARCHAR (10)) INSERT INTO #MergeActions ( ) SELECT FROM ( MERGE.
LOOKUPS AND IF CONDITIONS IN AZURE DATA FACTORY V2 (ADFV2 Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. This WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
MAP POSTCODES IN SSRS REPORTING SERVICES EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
JUNE, 2021 | PURPLE FROG SYSTEMS Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
SYSTEM OUTOFMEMORYEXCEPTION WHEN DEPLOYING SSIS .ISPAC Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
SORTING A POWER BI TABLE BY MULTIPLE COLUMNS A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a while, there was no way (at least no easy way) to do this until the Power BI March 2020 update. I learnt this tip from the CUBE DEPLOYMENT ERROR: CANNOT RESOLVE ALL PATHS WHILE DE Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
PATTERN MATCHING IN SSIS USING REGULAR EXPRESSIONS AND THE Well it turns out this is the easy bit, with the help of the script component. Step 1 – Add a script component into your data flow pipeline, configure it as a data transform. I’m using C#, but you can use VB.NET if you want. Step 2 – Give the script access to the input and output columns. Open the script component and select theinput
QUERYING DIMENSION MEMBERS IN MDX Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let’s look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the “Adventure Works DW 2008 USING MERGE TO LOAD DATA WAREHOUSE DIMENSIONS In my last blog post I showed the basic concepts of using the T-SQL Merge statement, available in SQL Server 2008 onwards.. In this post we’ll take it a step further and show how we can use it for loading data warehouse dimensions, and managing the SCD (slowly changingdimension) process.
CREATING AZURE DATA FACTORY CUSTOM ACTIVITIES When creating an Azure Data Factory (ADF) solution you’ll quickly find that currently it’s connectors are pretty limited to just other Azure services and the T within ETL (Extract, Transform, Load) is completely missing altogether. AZURE SSIS – HOW TO SETUP, DEPLOY, EXECUTE & SCHEDULE I confess I’ve stolen this from Microsoft in there documentation here and tweaked it slightly to use the more precise subscription ID parameter as well as a couple of other things that I felt made life easier. While this is running you should get a process bar from the PowerShell ISE for the SSIS IR service starting, which really doestake around 30mins.
PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. JUNE, 2021 | PURPLE FROG SYSTEMS Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
CUBE DEPLOYMENT ERROR: CANNOT RESOLVE ALL PATHS WHILE DE Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
CREATING POWER BI LAYOUTS USING POWERPOINT To start the creation of a layout, open PowerPoint with a blank side and add a rectangle. Next, add glow to the rectangle, glow is found in the drawing ribbon under shape effects. Repeat the process of adding rectangles with glow and lay them out so the visuals will fit. If there is an important visual that needs to be a certain size you can SYSTEM OUTOFMEMORYEXCEPTION WHEN DEPLOYING SSIS .ISPAC Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
CAPTURING INSERT AND UPDATE COUNTS FROM MERGE There is a limitation, though, you can’t aggregate the table. So if we want to summarise the actions into a single row of insert, update and delete counts, we have to use a temporary table such as in the sample code below. CREATE TABLE #MergeActions ( VARCHAR (10)) INSERT INTO #MergeActions ( ) SELECT FROM ( MERGE.
LOOKUPS AND IF CONDITIONS IN AZURE DATA FACTORY V2 (ADFV2 Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. ThisPURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. JUNE, 2021 | PURPLE FROG SYSTEMS Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
CUBE DEPLOYMENT ERROR: CANNOT RESOLVE ALL PATHS WHILE DE Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
CREATING POWER BI LAYOUTS USING POWERPOINT To start the creation of a layout, open PowerPoint with a blank side and add a rectangle. Next, add glow to the rectangle, glow is found in the drawing ribbon under shape effects. Repeat the process of adding rectangles with glow and lay them out so the visuals will fit. If there is an important visual that needs to be a certain size you can SYSTEM OUTOFMEMORYEXCEPTION WHEN DEPLOYING SSIS .ISPAC Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
CAPTURING INSERT AND UPDATE COUNTS FROM MERGE There is a limitation, though, you can’t aggregate the table. So if we want to summarise the actions into a single row of insert, update and delete counts, we have to use a temporary table such as in the sample code below. CREATE TABLE #MergeActions ( VARCHAR (10)) INSERT INTO #MergeActions ( ) SELECT FROM ( MERGE.
LOOKUPS AND IF CONDITIONS IN AZURE DATA FACTORY V2 (ADFV2 Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. ThisPURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. JUNE, 2021 | PURPLE FROG SYSTEMS Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
POWER BI DATABRICKS SPARK CONNECTION ERROR When querying data from Azure Databricks (spark) into Power BI you may encounter an error: “ODBC:ERROR (100) The host and port specified for the connection do not seem to belong to a Spark server. Please check your configuration.“ This is usually caused by trying to connect to a ‘Standard’ Databricks instance,but Power
REGULAR EXPRESSION TO GET TABLES FROM SQL QUERY Regular Expression to get tables from SQL query. If you’ve not come across regular expressions (RegEx) before then you’re missing out, they’re an incredibly powerful tool for matching, extracting or validating patterns of text. I had a use case this week where I needed to take a SQL query, and quickly identify every table or view that was QUERYING DIMENSION MEMBERS IN MDX Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let’s look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the “Adventure Works DW 2008 PATTERN MATCHING IN SSIS USING REGULAR EXPRESSIONS AND THE Well it turns out this is the easy bit, with the help of the script component. Step 1 – Add a script component into your data flow pipeline, configure it as a data transform. I’m using C#, but you can use VB.NET if you want. Step 2 – Give the script access to the input and output columns. Open the script component and select theinput
EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) Inline Pipelines. For me this is a deployment convenience thing. Before and currently our linked services, datasets and pipelines were separate JSON files within our Visual Studio solution. OPEN CSV CORRECTLY IN EXCEL FROM SQL SERVER DBMAIL A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. Sometimes, depending on your language settings, CSV files don’t open correctly in Excel. Excel ignores the ‘,’ and puts all data in column A. You then have to go through the hassle of closing the file and opening it throug the flat file wizard.PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
CREATING AZURE DATA FACTORY CUSTOM ACTIVITIES When creating an Azure Data Factory (ADF) solution you’ll quickly find that currently it’s connectors are pretty limited to just other Azure services and the T within ETL (Extract, Transform, Load) is completely missing altogether. CREATING A U-SQL DATE DIMENSION & NUMBERS TABLE IN AZURE Now we all know what a date dimension is and there are plenty of really great examples out there for creating them in various languages. Well, here’s my U-SQL SSAS TABULAR PERFORMANCE So, with 32 cores to play with, we should be looking at the default segment size (8m) or maybe reduce it to 4m to get 40 segments. But the extra compression with 16m segment size may be EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
LOGPARSER PERFORMANCE INSERTING INTO SQL SERVER Recently I’ve been using LogParser a lot to import log files, such as W3C logs from an IIS web server. The distasteful format of these files is made palatable by the awesomeness that is LogParser; it just takes care fo it for you. (Check out this SQLBits session on OPEN CSV CORRECTLY IN EXCEL FROM SQL SERVER DBMAIL A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. Sometimes, depending on your language settings, CSV files don’t open correctly in Excel.PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
CREATING AZURE DATA FACTORY CUSTOM ACTIVITIES When creating an Azure Data Factory (ADF) solution you’ll quickly find that currently it’s connectors are pretty limited to just other Azure services and the T within ETL (Extract, Transform, Load) is completely missing altogether. CREATING A U-SQL DATE DIMENSION & NUMBERS TABLE IN AZURE Now we all know what a date dimension is and there are plenty of really great examples out there for creating them in various languages. Well, here’s my U-SQL SSAS TABULAR PERFORMANCE So, with 32 cores to play with, we should be looking at the default segment size (8m) or maybe reduce it to 4m to get 40 segments. But the extra compression with 16m segment size may be EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
LOGPARSER PERFORMANCE INSERTING INTO SQL SERVER Recently I’ve been using LogParser a lot to import log files, such as W3C logs from an IIS web server. The distasteful format of these files is made palatable by the awesomeness that is LogParser; it just takes care fo it for you. (Check out this SQLBits session on OPEN CSV CORRECTLY IN EXCEL FROM SQL SERVER DBMAIL A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. Sometimes, depending on your language settings, CSV files don’t open correctly in Excel. JUNE, 2021 | PURPLE FROG SYSTEMS Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. CREATING POWER BI LAYOUTS USING POWERPOINT First question, why bother with layouts?Using layouts in Power BI allows a user to make their visuals stand out better, the page looks professional and more appealing to its audience. Second question, why PowerPoint?The default page size in Power BI desktop is 16:9, (this trick doesn’t work for other Power BI page sizes), which is SORTING A POWER BI TABLE BY MULTIPLE COLUMNS A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a while, there was no way (at least no easy way) to do this until the Power BI March 2020 update. I learnt this tip from the CONTROLLING YOUR WINDOWS 10 IOT CORE DEVICE Now if using the IoT Dashboard above from My Devices you have the option just to right click on the auto detected device and select Connect using PowerShell.This handles all the above prerequisites for connecting and only prompts for credentials. Lovely! Note; both PowerShell methods of connection to the device will require elevatedpermissions.
QUERYING DIMENSION MEMBERS IN MDX Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let’s look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the “Adventure Works DW 2008 CHAINING AZURE DATA FACTORY ACTIVITIES AND DATASETS As I work with Azure Data Factory (ADF) and help others in the community more and more I encounter some confusion that seems to existsurrounding how to
RDP TO AZURE BATCH SERVICE COMPUTE NODES Did you know it’s now possible to RDP to your Azure Batch Service compute nodes? I’ve used the batch service to handle the compute for my Azure Data Factory custom activities for a while now. EXCEL CUBE PIVOT DRILLTHROUGH LIMITED TO 1000 ROWS When browsing a cube using Excel 2007, you can drillthrough the measures to display up to 1000 rows of the transaction level source data. I often get asked whether this limit of 1000 rows is configurable – well the good news is yes it is. There is an option in the actions tab of the PATTERN MATCHING IN SSIS USING REGULAR EXPRESSIONS AND THE One of my favourite features of SSIS is the script component, and I know I’m not alone. Why? Because it brings the entire might of the .NET framework to SSIS, providing C# (in SQL 2008 onwards) and VB.NET extensibility for all those times where SSIS doesn’t quite have enough functionality outPURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if CREATING AZURE DATA FACTORY CUSTOM ACTIVITIES When creating an Azure Data Factory (ADF) solution you’ll quickly find that currently it’s connectors are pretty limited to just other Azure services and the T within ETL (Extract, Transform, Load) is completely missing altogether. WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
CREATING A U-SQL DATE DIMENSION & NUMBERS TABLE IN AZURE Now we all know what a date dimension is and there are plenty of really great examples out there for creating them in various languages. Well, here’s my U-SQL LOGPARSER PERFORMANCE INSERTING INTO SQL SERVER The following is an extract of the trace on the same file when executed using the following command. LogParser.exe “SELECT * INTO staging.test FROM Test.log” -i:IISW3C -o:sql -server:localhost -database:Staging -cleartable:ON -transactionRowCount:-1. You can clearly see that only a single transaction is opened, with all insertsbatched
SSAS TABULAR PERFORMANCE SSAS Tabular performance – DefaultSegmentRowCount. I’m currently investigating a poorly performing Tabular model, and came across some interesting test results which seem to contradict the advice in Microsoft’s Performance Tuning of Tabular Models white paper. 7.6Gb SSAS tabular cube, running on a 2 x CPU 32 core (Xeon E5-2650 2Ghz, 2x
OPEN CSV CORRECTLY IN EXCEL FROM SQL SERVER DBMAIL A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. Sometimes, depending on your language settings, CSV files don’t open correctly in Excel. Excel ignores the ‘,’ and puts all data in column A. You then have to go through the hassle of closing the file and opening it throug the flat file wizard. EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if CREATING AZURE DATA FACTORY CUSTOM ACTIVITIES When creating an Azure Data Factory (ADF) solution you’ll quickly find that currently it’s connectors are pretty limited to just other Azure services and the T within ETL (Extract, Transform, Load) is completely missing altogether. WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
CREATING A U-SQL DATE DIMENSION & NUMBERS TABLE IN AZURE Now we all know what a date dimension is and there are plenty of really great examples out there for creating them in various languages. Well, here’s my U-SQL LOGPARSER PERFORMANCE INSERTING INTO SQL SERVER The following is an extract of the trace on the same file when executed using the following command. LogParser.exe “SELECT * INTO staging.test FROM Test.log” -i:IISW3C -o:sql -server:localhost -database:Staging -cleartable:ON -transactionRowCount:-1. You can clearly see that only a single transaction is opened, with all insertsbatched
SSAS TABULAR PERFORMANCE SSAS Tabular performance – DefaultSegmentRowCount. I’m currently investigating a poorly performing Tabular model, and came across some interesting test results which seem to contradict the advice in Microsoft’s Performance Tuning of Tabular Models white paper. 7.6Gb SSAS tabular cube, running on a 2 x CPU 32 core (Xeon E5-2650 2Ghz, 2x
OPEN CSV CORRECTLY IN EXCEL FROM SQL SERVER DBMAIL A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. Sometimes, depending on your language settings, CSV files don’t open correctly in Excel. Excel ignores the ‘,’ and puts all data in column A. You then have to go through the hassle of closing the file and opening it throug the flat file wizard. EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
JUNE, 2021 | PURPLE FROG SYSTEMS Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
CREATING POWER BI LAYOUTS USING POWERPOINT To start the creation of a layout, open PowerPoint with a blank side and add a rectangle. Next, add glow to the rectangle, glow is found in the drawing ribbon under shape effects. Repeat the process of adding rectangles with glow and lay them out so the visuals will fit. If there is an important visual that needs to be a certain size you can SORTING A POWER BI TABLE BY MULTIPLE COLUMNS A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a while, there was no way (at least no easy way) to do this until the Power BI March 2020 update. I learnt this tip from the CONTROLLING YOUR WINDOWS 10 IOT CORE DEVICE Now if using the IoT Dashboard above from My Devices you have the option just to right click on the auto detected device and select Connect using PowerShell.This handles all the above prerequisites for connecting and only prompts for credentials. Lovely! Note; both PowerShell methods of connection to the device will require elevatedpermissions.
QUERYING DIMENSION MEMBERS IN MDX Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let’s look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the “Adventure Works DW 2008 RDP TO AZURE BATCH SERVICE COMPUTE NODES Did you know it’s now possible to RDP to your Azure Batch Service compute nodes? I’ve used the batch service to handle the compute for my Azure Data Factory custom activities for a while now. PATTERN MATCHING IN SSIS USING REGULAR EXPRESSIONS AND THE Well it turns out this is the easy bit, with the help of the script component. Step 1 – Add a script component into your data flow pipeline, configure it as a data transform. I’m using C#, but you can use VB.NET if you want. Step 2 – Give the script access to the input and output columns. Open the script component and select theinput
CHAINING AZURE DATA FACTORY ACTIVITIES AND DATASETS As I work with Azure Data Factory (ADF) and help others in the community more and more I encounter some confusion that seems to existsurrounding how to
EXCEL CUBE PIVOT DRILLTHROUGH LIMITED TO 1000 ROWS Excel Cube Pivot drillthrough limited to 1000 rows. When browsing a cube using Excel 2007, you can drillthrough the measures to display up to 1000 rows of the transaction level source data. I often get asked whether this limit of 1000 rows is configurable – well the good news is yes it is. There is an option in the actions tab of the BIDSPURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if CUBE DEPLOYMENT ERROR: CANNOT RESOLVE ALL PATHS WHILE DE Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
CAPTURING INSERT AND UPDATE COUNTS FROM MERGE There is a limitation, though, you can’t aggregate the table. So if we want to summarise the actions into a single row of insert, update and delete counts, we have to use a temporary table such as in the sample code below. CREATE TABLE #MergeActions ( VARCHAR (10)) INSERT INTO #MergeActions ( ) SELECT FROM ( MERGE.
LOOKUPS AND IF CONDITIONS IN AZURE DATA FACTORY V2 (ADFV2 Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. This QUERYING DIMENSION MEMBERS IN MDX Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let’s look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the “Adventure Works DW 2008 WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
LOGPARSER PERFORMANCE INSERTING INTO SQL SERVER The following is an extract of the trace on the same file when executed using the following command. LogParser.exe “SELECT * INTO staging.test FROM Test.log” -i:IISW3C -o:sql -server:localhost -database:Staging -cleartable:ON -transactionRowCount:-1. You can clearly see that only a single transaction is opened, with all insertsbatched
PURPLE FROG SYSTEMS
Power BI. Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. HOW TO MAKE YOUR MATRIX COLUMN WIDTHS ALL EQUAL TO EACH Have you ever come across an issue where your Power BI matrix column widths just aren’t the same width and visually just don’t look right? Unfortunately (as of April 21’) there is no easy way to make all column widths equal in the format pane of a matrix visual. Howeverthere is a hack to
ADF SWITCH ACTIVITY
Whilst carrying out some work for a client using Azure Data Factory I was presented with the challenge of triggering different activities depending on the result of a stored procedure. In fact the challenge posed was to Execute ‘Copy A’ activity if the result of a stored procedure returned (A), Execute ‘Copy B’ activity if CUBE DEPLOYMENT ERROR: CANNOT RESOLVE ALL PATHS WHILE DE Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
CAPTURING INSERT AND UPDATE COUNTS FROM MERGE There is a limitation, though, you can’t aggregate the table. So if we want to summarise the actions into a single row of insert, update and delete counts, we have to use a temporary table such as in the sample code below. CREATE TABLE #MergeActions ( VARCHAR (10)) INSERT INTO #MergeActions ( ) SELECT FROM ( MERGE.
LOOKUPS AND IF CONDITIONS IN AZURE DATA FACTORY V2 (ADFV2 Azure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. This QUERYING DIMENSION MEMBERS IN MDX Today we’re back looking at MDX with a quick how-to. How do you extract a list of dimension members using MDX? This could be used for example to populate a user interface/parameter of a report/dashboard. Let’s look at two scenarios; normal dimensions, and then hierarchies. All the queries here use the “Adventure Works DW 2008 WHAT’S NEW IN AZURE DATA FACTORY VERSION 2 (ADFV2) That’s the high-level concepts dealt with. Now, for ease of reading let’s break the new features down into two main sections. The service level changes and then the additions to our toolkit of ADFactivities.
EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
LOGPARSER PERFORMANCE INSERTING INTO SQL SERVER The following is an extract of the trace on the same file when executed using the following command. LogParser.exe “SELECT * INTO staging.test FROM Test.log” -i:IISW3C -o:sql -server:localhost -database:Staging -cleartable:ON -transactionRowCount:-1. You can clearly see that only a single transaction is opened, with all insertsbatched
ABOUT US - PURPLE FROG SYSTEMS - THE DATA WAREHOUSE AND About Purple Frog Systems. It is all too common these days for data collection to be a very high priority but without proper consideration given to what benefit can be gained from it. POWER BI DRILL THROUGH USING MULTIPLE DATA POINTS Power BI Drill Through using Multiple Data Points. A drill through in Power BI allows the reader to see secondary data related to the original page with the context of a specific data point applied, for example, drilling through on sales data can display the demographic information of the relevant customers for those sales. One limitationof
CREATING POWER BI LAYOUTS USING POWERPOINT To start the creation of a layout, open PowerPoint with a blank side and add a rectangle. Next, add glow to the rectangle, glow is found in the drawing ribbon under shape effects. Repeat the process of adding rectangles with glow and lay them out so the visuals will fit. If there is an important visual that needs to be a certain size you can SYSTEM OUTOFMEMORYEXCEPTION WHEN DEPLOYING SSIS .ISPAC Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning andmore.
POWER BI SENTINEL
Step forward a new SaaS tool, Power BI Sentinel. Sentinel is a new Software as a Service (i.e. hosted in the cloud) tool which sits alongside your PowerBI.com account, helping you manage things better. Core features include: Data Lineage documentation – visibility of which reports are using which datasets, and which data sources. EXCEL CRASHES WHEN ENABLING MACROS I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem”message.
CREATING A U-SQL DATE DIMENSION & NUMBERS TABLE IN AZURE Now we all know what a date dimension is and there are plenty of really great examples out there for creating them in various languages. Well, here’s my U-SQL SSAS TABULAR PERFORMANCE SSAS Tabular performance – DefaultSegmentRowCount. I’m currently investigating a poorly performing Tabular model, and came across some interesting test results which seem to contradict the advice in Microsoft’s Performance Tuning of Tabular Models white paper. 7.6Gb SSAS tabular cube, running on a 2 x CPU 32 core (Xeon E5-2650 2Ghz, 2x
OPEN CSV CORRECTLY IN EXCEL FROM SQL SERVER DBMAIL A nice little nugget today for anyone who uses SQL dbmail to send data in csv attachments. Sometimes, depending on your language settings, CSV files don’t open correctly in Excel. Excel ignores the ‘,’ and puts all data in column A. You then have to go through the hassle of closing the file and opening it throug the flat file wizard. EXCEL CUBE PIVOT DRILLTHROUGH LIMITED TO 1000 ROWS Excel Cube Pivot drillthrough limited to 1000 rows. When browsing a cube using Excel 2007, you can drillthrough the measures to display up to 1000 rows of the transaction level source data. I often get asked whether this limit of 1000 rows is configurable – well the good news is yes it is. There is an option in the actions tab of the BIDS0845 643 64 63
* Home
*
About Us
* About Us
* SQL Midlands
*
Services
* Business Intelligence * BI Managed Service* BI In the Cloud
* Business Intelligence Mentoring* Data Warehousing
* OLAP Cubes
* ETL
* Reporting Systems
* SharePoint - Services * Kimball Dimensional Design - Services* Machine Learning
* Management Information - Services * SQL Server Training - Services* Power BI Training
* Vacancies
* News
*
Clients
* Clients
* Testimonials
* Case Studies
* Blogs
* Contact Us
*
*
*
USING BUSINESS INTELLIGENCE AND DATA ANALYTICS TO HELP YOUR BUSINESSDATA ANALYTICS
We take your existing data to enable you to make better decisions through a combination of:* data profiling
* cleaning
* transformation
* data modelling
* dashboards
* machine learning
It is critical for any machine learning project to have all of these for it to be a success.ENTERPRISE BI
Helping businesses develop and manage entire BI infrastructure,components of:
* architecture and planning* design
* data modelling
* system development * ongoing management, monitoring, maintenance* training
Long term projects for long term gains and strategic views of yourbusiness.
POWER BI
Short term tactical solutions to get something in place quickly with high quality deliverables. We will help structure and manage your data in a way that doesn't comprise your long term vision. We have also developed a world leading Power BI software as a service solution called Sentinel which enables you to do backups, documentation, change tracking and data lineage. Check out the Power BI Sentinel website for more information: click here We are also on the Microsoft Partner Network website: click here All of these services can be delivered either as a proof of concept or production ready chargeable by the day or on a fixed price basis tosuit you.
BUSINESS INTELLIGENCE MENTORING We can also help guide your existing SQL Server development team, ensuring that your BI project sets off on the right path and helping you overcome any obstacles. WHAT OUR CLIENTS SAY "THANKS FOR THE SUPPORT YOU HAVE GIVEN US THROUGH THE YEAR –THE WORK YOU DO AND SPEED WITH WHICH YOU REACT TO PROBLEMS IS FANTASTIC. GLAD TO HAVE YOU AS OUR PARTNER." JOHN NOTHER, CTO, CARD FACTORY "THE DEPTH OF THEIR TECHNICAL SKILL IN ALL MANNER OF BI TECHNOLOGIESIS MATCHED BY THEIR
ABILITY TO GET TO GRIPS WITH THE DYNAMICS OF THE CORE BUSINESS ANDPROPOSE
AND DEVELOP INNOVATIVE SOLUTIONS." GEOFF BARBER, HEAD OF FINANCIAL MI SYSTEMS, PRINCIPALITY BUILDINGSOCIETY
Copyright © 2020 Purple Frog Systems Ltd | Registered in the UK No 05672331 | VAT Reg No 884 4403 08 Privacy Policy | Cookie Policy| Terms of Use
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0