We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.
The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ...
Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.
Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.
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”