62 Ergebnisse für ‘CTPRP Exam Dumps 100% Guarantee You Get CTPRP Exam - Pdfvce 🦆 Copy URL ▷ www.pdfvce.com ◁ open and search for ( CTPRP ) to download for free 🍛Pdf Demo CTPRP Download’
Blog
Monte Carlo Simulation with DAX and Power Query
In this blog post I show you how to do a simple Monte Carlo Simulation by using DAX or Power Query. I will compare both approaches and evalute the pros and cons. Last month a colleague of mine wrote about the amazing possibilities of the R integration into SQL Server 2016.
Blog
Data Vault Satellite Loads explained
With this blog post i want to continue the series on explaining Data Vault Loads. Today i want to describe the load pattern for Data Vault Satellite. In a Data Vault model satellites are used to store descriptive attributes associated with Hubs or Links with tracking of all historical values.
Blog
Show Top N and Rest in Power BI
Hello Everybody, today I would like to show you how you can create a dynamic Top N selection in Power BI which shows you the rest of the data (the data that is not in the Top N). The October Update brought us a cool new Top N filter for Power BI.
Blog
Use Regular Expressions in Power BI
Hello All, in this blog post I’ll show you how you can use regular expressions in Power BI by using the R transformation steps. Power BI itself is not capable to filter or select by a regular expression. It is a favored feature by some users (see community), but until now there is no way to use regular expressions in Power BI.
Blog
How to use Power BI as data source in SSIS
Power BI is a fascinating tool. Built for self service BI in the last year it has grown to a full BI and analytical platform. The huge wave of new features and updates every month is amazing.
Blog
Fill down table in T-SQL (last-non-empty value)
A common task in data processing is to fill null values in a table with the latest existing value. For example, look at the following inventory table
Let’s assume we only get an inventory record, if the inventory changes but we want to fill the missing values (for example to create a snapshot fact table).
Blog
Local date formats in Power BI
I work with Power BI almost every day, nevertheless there are sometimes moments where the tool surprises me. One of this moments I had two weeks ago, when a colleague showed me an easy way to convert date from the US Format (mm.dd.yyyy) to the german format (dd.mm.yyyy).
Blog
How to create relative week column in Power BI?
Time Intelligence is often a major topic of many BI implementations. Also in small self-service projects like Power BI one requirement is often to compare the devolpment of a KPI over time.
Blog
Power Query: How to unpivot a dynamic number of columns
A powerful function in Power Query is to unpivot a given data set which means to rotate data in columns to rows. This is useful for a lot of statistical data sets that you will find on the web because those data sets usually have the time (for example the year) on the columns.
Blog
Databricks vs Snowflake: Myths, Marketing and Performance
A PoC seems to confirm: Snowflake is faster and cheaper as Databricks when it comes to data retrieval. But is this really the case? Our expert takes a closer look at the PoC results and reveals questionable practices. Read more.
Blog
Using Group By and Row Number in SQL statements
In this article I want to show some features about the Group By clause and the Row Number window function that you can use in SQL statements.
There are many situations where you want a unique list of items. But in the data source the items are not unique.
Blog
DAX vs. MDX: An example
I’m often asked about the key differences between DAX and MDX or in more general, the difference between the tabular and the multidimensional model. From my presentation on the PASS Camp 2012 in Germany I’d like to share some of the ideas here.