Nick Teliska, PE

P.E. | CMVP | CBCP | CEM
Energy management, performance contracting, measurement & verification
#PowerBI #PowerPlatform

[Nick Teliska, PE @NickTeliska]

6/6 OTHER
Ctrl 6: Clear chart covering dataset out of the way (and back again)
Ctrl F: Search
Ctrl F2: Opens Print Preview
Ctrl S: Save
F12: Save As
Ctrl ;: Insert current date
Ctrl Shift :: Insert current time

[Nick Teliska, PE @NickTeliska]

Shortcuts building a career = bad.
Shortcuts building a spreadsheet = aok.

Excel shortcuts for energy freaks follow.

#exceltips #gofaster

[Nick Teliska, PE @NickTeliska]

5/6 SELECTING
Ctrl [: Highlights precedent cells
Ctrl ]: Highlights dependent cells
Ctrl Shift arrow key: Extend selection to last nonblank cell
Ctrl Shift Home: Selects to A1 from cursor position
Ctrl Shift O: Select all cells with comments
Ctrl Spacebar: Select the whole column

[Nick Teliska, PE @NickTeliska]

March 1st begins month-long National Measurement & Verification Professional Celebration Week. It's a big deal if you're a fan of the truth. So big it's a quinquennial event.

https://t.co/e0JtLmys6J

#EnergyManagement
#ESCO
#PerformanceContracting

[Nick Teliska, PE @NickTeliska]

@UberFacts

[Nick Teliska, PE @NickTeliska]

Were these lifespans widely believed in the late 1800s? From book "Knowledge, Wisdom, and Power" (pub. 1890) - an encyclopedic book of sorts.

#animals #history

[Nick Teliska, PE @NickTeliska]

LSD (least significant difference) is a neat application of statistics, as I'm beginning to believe statistics was a neat application of LSD (lysergic acid diethylamide).

#statistics #acid

[Nick Teliska, PE @NickTeliska]

@OzExcel More things I never knew. And I haven't thought of kaleidoscopes in way too long. Thx.

[Nick Teliska, PE @NickTeliska]

Comparisons are key for #energyengineers - against baselines, previous timeframes, and other buildings and systems. Power BI December 2022 update has 3 new DAX functions to help: INDEX, OFFSET, and WINDOW.
#ESCO #PerformanceContracting

[Nick Teliska, PE @NickTeliska]

Numbers are dumb. First, we tell them what # they are. Second, they're meaningless without units. "It is 12 today." 12 what? Degrees outside or the time of that important meeting?

#celebrateunits

[Nick Teliska, PE @NickTeliska]

A few new features to #PowerBI in November update are especially great for #ESCO and #PerformanceContracting markets.
> Dynamic slicers using field parameters
> New DAX function TOCSV
> Optimize ribbon

#PowerBIEnergy #MeasurementAndVerification

https://t.co/zAH0kXpGhy

[Nick Teliska, PE @NickTeliska]

@DataScienceDojo I remain surprised how many advanced Excel users do not use the Power BI modeling and query engines within Excel (Power Pivot and Power Query). Gives you same familiar UI of Excel but with tremendous new horsepower and capabilities.

[Nick Teliska, PE @NickTeliska]

@Kjonge @FerrariAlberto Will tune in for the plane story alone.

[Nick Teliska, PE @NickTeliska]

@EdwardTufte Great commercial. I wonder if we all, secretly or not, admire rule-breakers and non-conformists - the different thinkers. Forget about the whole person package and focus on that one element. Maybe some don't at all. But if we do, why aren't there more of them? Or maybe there are.

[Nick Teliska, PE @NickTeliska]

@PaulRandal A gracious invitation. I can tend to (incorrectly) think my questions or remarks are peculiar to my own industry. But knowledge translation is accelerated incredibly by helpful souls like yourself and that is appreciated.

[Nick Teliska, PE @NickTeliska]

"As data are aggregated, they lose their context and their usefulness. Aggregated data may be used as a report card, but they will not pin-point what needs to be fixed." - John Wheeler, Understanding Variation: The Key to Managing Chaos (Wheeler, 1993)

#SenseMaking #data