Using Monkey Tools Learn about all of the amazing features of Monkey Tools with our FREE course! "I loved the direct, clear examples, well separated into what each video will show so I can come back and see it again if I forgot how to do something." Valerie Strafe (5 stars) (Image of a cyborg monkey jumping to up cheer with its eye closed, mouth open, and fist up in the air) Register today at https://mkyt.ca/course

Monkey Tools adds a broad set of features specifically for working with #PowerQuery and the #DataModel. They're divided into 2 general collections:
🐒Monkeys - make things happen
🔎Sleuths - figure out what has happened
In the FREE Using Monkey Tools course, I demo how they work. Go to mkyt.ca/course

Ken recommended using the "Analyze in Excel" feature to pull historical actuals from the Power BI #DataModel into Excel, build granular forecasts by department or product line, and store the resulting budget files in a SharePoint folder. Power BI can then read directly from that folder on refresh.

At the core of every BI solution is the Data Model. But do you really know how to work with is properly? Dimensional Modeling for the Excel and Power BI Pro Start Learning (Image of a many setting in front of a laptop looking up and to the left thoughtfully with his chin in his hand) (Skillwave Training logo)

Unlock the power of #DimensionalModeling by learning the right way to build solid and scalable Data Models in #Excel and #PowerBI. 💪 This on-demand training brings together #PowerQuery and the #DataModel for powerful #BusinessIntelligence.
➡️Enroll today at skw-t.com/modeling

#DataModeling

Screenshot of a Wikidata WikiProject page background is green with mostly black text and an image of a moth specimen illustrates the page.

I've been working on data models for #Wikidata type specimen items & structured data for #WikimediaCommons specimen images. This is part of my WiR & is a collaboration with Brodie Satherley from Auckland Museum.
See www.wikidata.org/wiki/Wikidat...
#Wikidata #NaturalHistory #TypeSpecimen #DataModel

Monkey Tools Build better data models, faster Developed by Excelguru (Image of a cyborg monkey with its fist up for a fist bump) TimeSleuth Have you ever hit the refresh button in Excel and then waited... and waited... and waited for your queries to refresh? Want to know which query is causing the bottleneck? Then check out the TimeSleuth! (Screenshot of the Query Timing Results chart created by TimeSleuth, comparing how long 3 queries take to refresh) monkeytools.ca

A complex #DataModel can take a long time to refresh. ⏱While timing with a stopwatch is easy, it only times the global refresh for complicated query chains.
🔍The TimeSleuth allows you to test the global or individual refresh times of queries within your #Excel workbook. See how: mkyt.ca/timesleuth

When a feature goes into public preview that should be the final stage before a full release, so it should be clear from the roadmap when we can expect full release. Yes, things can change, yes things may not work properly and may change... But ROADMAP! #powerbi #datamodel #dax #udf

LinkML: An Open Data Modeling Framework. #DataModel #DataSharing #FAIRdata @gigascience.bsky.social

academic.oup.com/gigascience/...

linkml.io

Group picture

Presentation slide showing the data model

The @openaire.bsky.social team is in Athens this week for an intensive technical meeting. We're making exciting progress on expanding the #OpenAIREGraph #DataModel to include infrastructure assets essential to science and capture the full complexity of today's research ecosystem. Stay tuned!

Join @excelguru.ca and the Data Monkey as they explore how to enhance an #Excel #PowerPivot #DataModel to handle commissionable items. This video walks through the practical process of retrofitting an existing data model and when to use #DAX vs #PowerQuery:

Join me and the Data Monkey as we explore how to enhance an #Excel #PowerPivot #DataModel to handle commissionable items. This video walks through the practical process of retrofitting an existing data model and when to use #DAX vs #PowerQuery:

In this video, @excelguru.ca shows how to build a dynamic forecast sheet in #Excel that connects directly to a #PowerPivot #DataModel. 📉
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution in #Excel:

✅ Power BI Data Model-2

www.youtube.com/watch?v=eOwi...
#powerbi #datamodel #relationship

It's the last day to save on our Monkey Tools #Excel add-in! ⏰ Don't miss out, go to monkeytools.ca and apply these these codes at checkout:
🔵 20% off Annual Licenses = MDANNUAL20
🟢 15% off Lifetime Licenses = MDLIFETIME15

#BusinessIntelligenceTools #DataAnalysis #DataModel #PowerBI

In this video, I demonstrate how to build a dynamic forecast sheet in #Excel that connects directly to a #PowerPivot #DataModel. 📉
This tutorial provides a practical, step-by-step approach to building an advanced, interactive forecasting solution: www.youtube.com/watch?v=y1fz...

#FinancialModeling

Ask Ken Anything Get more than just a course – get access to an expert who will help you build real world solutions. The Ask Ken Anything (AKA) sessions are live, interactive coaching calls that are held twice each…

It was a fantastic example of turning fragile #Excel spreadsheets into a robust #DataModel!

Want help stabilizing your own reporting workflows? Sign up for the AKAs at skw-t.com/aka, or get access with my #Excel Fundamentals (skw-t.com/excelfun) or #SelfServiceBI (skw-t.com/ssbi) Academies.

In this step-by-step demo, @excelguru.ca highlights how Auto Refresh brings standard #PivotTables up to par with a Power Pivot #DataModel and the importance of #PowerQuery in managing data refreshes, plus gives insights on SPILL errors: youtube.com/watch?v=cCKI...

#Excel #DataAnalytics

In this step-by-step demo, I highlight how Auto Refresh brings standard #PivotTables up to par with a Power Pivot #DataModel and the importance of #PowerQuery in managing data refreshes, plus give insights on SPILL errors: www.youtube.com/watch?v=cCKI...

#Excel #DataAnalytics #BusinessIntelligence

What is DAX I have written a series of articles over the last few years including: What is Power BI What is Power Query What is Power Pivot But I have never written an article about the DAX language, so I…

What is #DAX? It is an acronym for Data Analysis eXpressions, and is a programming language used to write measures in order to add business logic to your #PowerBI or Excel #DataModel.
💡 Matt Allington explains the DAX language and how to use it for #DataModeling: exceleratorbi.com.au/what-is-dax/

✅ Power BI Data Model-2

www.youtube.com/watch?v=eOwi...
#powerbi #datamodel #relationship

A More Dynamic Commission Report A student asked what do if you have sales items that shouldn’t count towards a team member’s commission earnings? Instead of filtering out rows in the report, Ken Puls suggested creating a column in the underlying data model to flag the item Yes/No and then add a simple DAX formula to the report so that only commissionable items are included: =CALCUALTE( [Sales $], Product[Commissionable] = "Yes" ) (Skillwave Training logo)

In an AKA session, one attendee asked how to handle sales items that shouldn’t count toward commissions in their #PowerBI report.🤔 Instead of filtering out rows, I suggested they add a Y/N flag column in the #DataModel and then use a #DAX measure to calculate commissions only when the flag = Yes. 🧵

The Financial “Star” Schema To build our statements we need: - Chart of Accounts Classifications (3 required tables) - Fact Table 1 (Required), e.g. Sales or Actuals - Fact Table 2 (Optional), e.g. Budget or Forecast - Calendar Dimension (Required) - Other Dimension(s) (Recommended), e.g. Customers, Products, GL Descriptions

I'm capping off the week by leading a course on how to build #FinancialStatements in #Excel with #PowerPivot for CPABC.

💡One of the first things we need to understand is how to properly architect the #DataModel so we have the required fact and dimension tables.

#FinancialModeling #ExcelForFinance

Dynamic Financial Forecasts In an ‘Ask Ken Anything’ session, Ken Puls and the attendees worked together to build a forecast sheet that is fully dynamic so that is would update upon a data model refresh, forecasting the next two years of sales! (Screenshot of chart showing sales figures from 2020-01-31 to 2021-12-31 and forecasted sales from 2022-01-31 to 2024-12-31) (Skillwave Training Logo)

In an AKA session, I had a spontaneous question about budgeting and #FinancialForecasting techniques. That led us through several #Excel features including Goal Seek, Data tables and Excel’s built-in Forecast Sheet function, which resulted in a nice forecast sheet built against a #DataModel.

Power BI Data Model Concepts with examples

www.youtube.com/watch?v=OB4R...
#powerbi #datamodel #innozant

Power BI Data Model Concepts with examples

www.youtube.com/watch?v=OB4R...
#INNOZANT #POWERBI #DATAMODEL

Dynamic Financial Forecasts In an ‘Ask Ken Anything’ session, Ken Puls and the attendees worked together to build a forecast sheet that is fully dynamic so that is would update upon a data model refresh, forecasting the next two years of sales! (Image of the forecast sheet showing sales from 2020-01-31 to 2021-11-30 and forecasted sales from 2022-01-31 to 2024-11-30) (Skillwave Training logo)

In an AKA session, we had a spontaneous question about budgeting and #FinancialForecasting techniques. That led us through several #Excel features including Goal Seek, Data tables and Excel’s built-in Forecast Sheet function, which resulted in a nice forecast sheet built against a #DataModel.

Their solution? Bring it to the Ask Ken Anything (AKA) sessions! 💡
I was able to identify that the solution had outgrown the original architecture design and needed to be rebuilt. The client ended up with a better designed #DataModel and a collection of much simpler #DAX formulas they can expand.

Learn the right way to build solid and scalabel data models in both Excel and Power BI Dimensional Modeling for the Excel & Power BI Pro "I loved the structure, the examples, and the recipes." - C.D. (5 stars) (Skillwave Training logo)

See why this course has 4.95/5 stars! 🌟
#DimensionalModeling is the key to unlocking the power of #Excel and #PowerBI. 🔏 Learn to design and optimize your #DataModel with our on-demand course. Get access to video lessons, practice files, downloadable patterns, and more. Sign up at skw-t.com/modeling

@excelguru.ca was able to identify that the solution had outgrown the original architecture design and really needed to be rebuilt. After reviewing it, our client ended up with a better designed #DataModel and a collection of much simpler #DAX formulas they can expand for future.

Self Service Business Intelligence Boot Camp (Munich, Germany) | Global Excel Summit | Microsoft Excel Conference Prepare to change your company’s reporting game forever, as 18x Microsoft MVP Ken Puls joins us in Munich for a 3-day exclusive Self-Service BI boot camp.

It will empower you to transform how you manage and analyze date within your organization. We'll cover:
✅Day 1: Gather and transform data with #PowerQuery
✅Day 2: Leverage #DimensionalModeling to build a solid #DataModel
✅Day 3: Gain deeper #DataInsights by using #DAX
Go to: xlguru.ca/ssbi-munich

A Gentle Introduction to GDAL, Part 1 [of 6]
--
medium.com/planet-stori...
-
#GIS #spatial #mapping #GDAL #tutorial #workedexamples #opensource #alternative #translatorlibrary #vector #raster #usecase #OSGEO #datamodel #onlinelearning
@osgeo.bsky.social