Arquivo de artigos

Forbes - Single Version Of Truth: Why Your Company Must Speak The Same Data Language

11/07/2020 19:54
A group of executives came together to discuss important issues that were challenging their fast-growing organization but soon discovered they weren’t speaking the same language. While they could understand the words coming from each other’s lips, there was a problem with the foundation of their...

Power BI - Free Training

11/05/2020 11:45
This is the link to learn from the scratch all about Power BI:   https://docs.microsoft.com/en-us/learn/paths/create-use-analytics-reports-power-bi/  

DAX Functions for SSAS and Power BI

12/02/2020 21:55
Harvest Power BI Slicer Selections To Use With Other Measures - Advanced DAX  - Auxiliar table and selections https://www.youtube.com/watch?v=vo2-s2Rbl2Y   Change measures using slicers in Power BI Desktop- Power BI Tips & Tricks #20 - Switch,iscrossfiltered, customized...

Simple guidelines for more efficient report & dashboard design

11/02/2020 21:46
It is already for more than three years that I’m engaged with the topic of business information design. It was during a regular Crystal Reports project. We were about to finalize the IT concept phase and the project was on track. Crystal Reports was already selected as the tool to go forward with....

Power BI DAX Dynamic Coding Table

08/11/2019 11:27
Static Tables in Data Models A static table has a fixed number of rows and columns and cannot be refreshed. Usually it is useful whenever you have a list of settings or parameters or values that will never change unless you will modify other parts of the data model and/or of DAX...

Power BI Pareto Formula

08/11/2019 11:17
  Metrics: PercentageIssues = (Pareto[IssuesTotal] / [SubTotalIssues])*100   Pareto_Value = SumX(TOPN([Rank],ALL(Pareto[Equipment]),[Total_Amount]),[Total_Amount])   Rank = RANKX(ALL(Pareto[Equipment]),[Total_Amount])   SubTotalIssues =...

SQL 2016 and CTE Pareto Formula

08/11/2019 11:14
  Declare @start date = '2018-09-05 23:45:52.153', @end date = '2018-09-06 21:36:12.473';   With Base    as    ( select  a.id as livecount , ad.EquipmentName, ad.[Message]   from  AlarmLive a join DimAlarmTrigger ad on a.AlarmTriggerId = ad.Id Join...

Machine Learning Transformed the Porsche 919 Hybrid Evo

01/10/2019 20:22
The history of Porsche Endurance Racing is one of the most exciting and successful and probably unparalleled by any. During the decades, legends like 917, 956, 911 GT1 collected victories on racetracks around the world. Among those, surely, the 24-hours of Le Mans is the absolute pinnacle. No other...

New features for SQL 2019

01/10/2019 19:58
Microsoft and is available in many versions, aiming at different audience set. The software applications which communicate with the SQL server can either be present in the same system or can be remotely located.   SQL Server 2019 - Table of Contents Introduction to SQL Server...

SSIS - Log Error - Retrieve the column causing an error in SQL Server Integration Services

29/09/2019 15:52
In versions of SSIS before SQL Server 2016, there was no easy way in the data flow to retrieve the name of the column that caused a component to fail.    To make it works, you should follow these steps:   1 - Add a new Script Transformation (Error Details)   2 - Select only the...
Itens: 41 - 50 de 224
<< 3 | 4 | 5 | 6 | 7 >>