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 Interview – … 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

http://www.jenunderwood.com/2017/02/22/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 previous decade something like that to … 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

premium 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 … 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

https://www.simple-talk.com/blogs/statistics-sql-pearsons-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 the body of waste. … 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