Category Archives: Business Intelligence

PowerBI Power Query / M lookups

Posted on May 6, 2022 by pfb_admin

I’m building a dynamic bucketing system with filtering based on process and program. I’m facing several interesting challenges. First- bucket sizes are based on the program, so I need dynamic buckets, and bucket labels. Second- max number of buckets is … Continue reading →

Posted in Business, Business Intelligence, Design and UX, PowerBI | Leave a comment

Dynamic Titles in PowerBI

Posted on August 31, 2020 by Eric Weberg

TL;DR: Copy this code into your DAX formatter. Selected Program = VAR _program = IF ( ISFILTERED ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( HASONEFILTER ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ), IF ( ISBLANK ( SELECTEDVALUE ( ‘db_datareader uvw_aca_wipInfoPrior12Buckets'[program] ) ), “Unspecified programs”, … Continue reading →

Posted in Business Intelligence, PowerBI | Leave a comment

Microsoft PowerBI training, + other areas

Posted on September 11, 2018 by pfb_admin

training material https://docs.microsoft.com/en-us/power-bi/guided-learning/ https://mva.microsoft.com/# (may need to use IE for this site) https://mva.microsoft.com/training-topics/c-app-development#!jobf=Developer&lang=1033 After all, this is what relationships buying that online cialis no prescription really should be. It would viagra canada price not wrong say Kamagra as true friend … Continue reading →

Posted in Business, Business Intelligence | Leave a comment

Linkdump: BIML, BI, Elastisearch-Kibana, SS Interviews, Data protection

Posted on March 9, 2018 by pfb_admin

BIML Business Markup Language https://www.mssqltips.com/sqlservertutorial/9089/introduction-to-the-biml-language/ BI – Logi Analytics. Responsive design, Dashboard design https://www.logianalytics.com/art-responsive-design-dzone-archive/ http://go.logianalytics.com/webinar-art-of-dashboard-design.html?mkt_tok=eyJpIjoiTkRJMk56aGpNamd6TkRreiIsInQiOiJSM05kQXBCaTM2SzF5UVBDazhMVGhBdmlFSE1CYU5TdjRKWStPMVwvcktSdWk0RTV1djRLUm1kYU9Bc2xJT0NRVDJOZG9PWkVhOXoyb1VBcG1jQTNtMXZLMWk0VDc4a09IRzdOSlVuNzVDVGVBWE5xUDFzajFwUnpPMEJVczBqV1oifQ%3D%3D Helping your BI Consultant be successful:  http://www.sqlservercentral.com/blogs/data-savvy/2018/01/30/ten-ways-to-help-your-bi-consultant-be-successful/?utm_source=SSC&utm_medium=pubemail Vagrant Command line interface: https://www.vagrantup.com/docs/cli/ Elastisearch and Kibana Client guide: https://www.elastic.co/guide/en/elasticsearch/client/index.html Downloads: https://www.elastic.co/content-pack Getting started: https://www.elastic.co/webinars/getting-started-elasticsearch?baymax=rtp&elektra=docs&storm=top-video&iesrc=ctr Forums: https://discuss.elastic.co/?ultron=es-get-started&blade=touch&hulk=email&mkt_tok=eyJpIjoiTlRCak16WTVNalZrWVdFeSIsInQiOiIxR3BlcW5HZ3IxRDdrbytSRnZpZ3JOcTZaMlNoUkZoTGdFU3VWTU5FMTNDaW5LdzNLTG9VMHhpZm5jek9mVEhCdmNENEo3S3ZqSjJHS3U5RTJKM1JHRk1OaGh3bUdUdk82Tks3Z1YyaFwvVXdGOFwvXC9sR3dFQlBGbUI1aTRwUm5PUSJ9 SS Interview https://mohammaddarab.com/interview-aaron-bertrand/?utm_source=SSC&utm_medium=pubemail Moving … Continue reading →

Posted in Business Intelligence, Linkdump, Project Management, SQL Server | Leave a comment

Gartner magic quarter analyses for BI, Q1 2018

Posted on January 30, 2018 by pfb_admin

Exploring 2017 Gartner BI Magic Quadrant Results   https://www.gartner.com/doc/reprints?id=1-3TYE0CD&ct=170221&st=sb https://www.logianalytics.com/gartner-critical-capabilities/ http://ir.microstrategy.com/releasedetail.cfm?releaseid=953331 Alcohol, fatty foods and grapefruits are not allowed while taking this medicine, as cheap cialis pills they readily hamper drug assimilation. Professionals have already been doing work over the … Continue reading →

Posted in Business Intelligence, Linkdump | Leave a comment

Linkdump: Various learnings: SD, JS. SS/BI/BD

Posted on January 30, 2018 by pfb_admin

10 books every web developer should read to increase their software IQ Backtracking algorithmic approach: http://blog.dailycodingproblem.com/an-introduction-to-backtracking/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300 Javascript framework Comparison: https://javascriptreport.com/js-frameworks-fastest/?utm_campaign=News%20on%20Monday&utm_source=hs_email&utm_medium=email&utm_content=60133300&_hsenc=p2ANqtz-8wUu0X1MNw7Ka4qWf8k5TgFDmfpiT6ecVsss07oZuypsu4t3kozhxperXdqM_8hp9YYaZbrEcMBuo2C-2sH3Y7QNx1iGWGWHqcJCplbP3RRpSbZ5c&_hsmi=60133300 Inferno Javascript framework: https://infernojs.org And moreover they sell a segment cheap cialis http://www.solboards.com/cialis-1455.html of medicines which don’t need doctor’s prescriptions. … Continue reading →

Posted in Business Intelligence, Linkdump, Programming, SQL Server | Leave a comment

Linkdump: Dynatrace- app monitoring with AI

Posted on July 12, 2017 by pfb_admin

https://info.dynatrace.com/apm_wc_ai_webinar_na_registration.html  It s a medicine, which aids man bear with http://videoleadspro.com/about-us/ generic cialis online impotence & comfort them to enjoy a healthy sexual life. The viagra without prescription will reach you as soon as possible. Looking at such majority of … Continue reading →

Posted in Business Intelligence, Linkdump | Leave a comment

Phil Factor @ SimpleTalk: Statistics in SQL: Pearson’s Correlation

Posted on June 9, 2017 by pfb_admin

Statistics in SQL: Pearson’s Correlation The series so far: Statistics in SQL: Pearson’s Correlation Men who use buy pill viagra recreational substances may experience the same problem, and in some cases, use of certain chemicals that are either produced within … Continue reading →

Posted in Business Intelligence, SQL Server, System/DB Administration | Leave a comment

DAX formatter

Posted on December 13, 2016 by pfb_admin

http://www.daxformatter.com by Marco The FDA has listed the following problems as possible hypersensitivity reactions that may be experienced by patients: Rashes – this is one of the most common problem among male during sexual activity is erectile dysfunction. order generic … Continue reading →

Posted in Business Intelligence, Linkdump | Leave a comment