Jon wants to generate 6-letter sequences using only the letters B and P.
So, for example: BBBBBB, PPPPPP, BPBPPB, BBBPPP, and so on. There are 64 such combinations and Bill shows you one way to solve this use BASE and SUBSTITUTE.
Formulas Continue reading “Random Combination Of PBPBBP – 2448”
We’re pleased to announce the upcoming release of the first installment of our new course tackling R for Power BI users developed by Enterprise DNA Expert, George Mount.
R is a free platform perfect for statistical computing and visualization. It’s mostly Continue reading “Why Power BI Users Should Learn R – Upcoming New Course”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn how to create a Cross Tabulated Report using a PivotTable and the appropriate visualizations. Lean about in the internal calculation in a cross tab report: AND Logical Test. Learn about how a hidden Continue reading “Excel Statistical Analysis 7: Cross Tabulation, Visualizations, AND Logical Tests, Simpson’s Paradox”
For this tutorial, I’d like to focus on the data modeling concept called the “junk dimensions”. From the name, you might think that it’s a technique that you’d want to avoid but it’s actually a really useful approach on the Continue reading “What Are “Junk Dimensions” And Why They’re Anything But Junk – Power BI Data Modeling Pro Technique”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about creating frequency distributions and visualizations for quantitative data, including Column Charts for Discrete Data, Line and Clustered Column charts for Date Data and Column Chart Histograms for Continuous Data.
Topics:
1. (00:00) Introduction
2. (00:35) Continue reading “Excel Statistical Analysis 06: Frequency Distributions, Visualizations & Skew for Quantitative Data”
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
December 2nd, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
December 3rd, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “10 Things You Need to Build for a Successful Data Career – Lessons of the Past 30 Years”
Download Excel File: https://excelisfun.net/files/Ch02-ESA.xlsm
Learn about creating Frequency Distributions & Column and Bar Chart Visualizations for Categorical Data. See an Epic Summary of EVERYTHING you need to know about Column and Bar Charts.
Topics:
1. (00:00)
2. (00:22) Download Excel
3. Continue reading “Excel Statistical Analysis 05: Frequency Distributions & Visualizations for Categorical Data”
For this video, I’d like to talk about and demo the newly released Deneb custom visual for Power BI. It’s an amazing visual, and provides an interface for the Vega-lite language for interactive visuals to be used within Power BI. Continue reading “Using Deneb For Flexible Custom Visuals In Power BI”