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:
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
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? 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/
![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)](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:xpiehblln2cworixrwklvoyv/bafkreihxqfxrui2pfe7yyoq7xeiu35iwfwwdouftl2ifvomnyml3sxqmsy)
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.
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
@DiCoDaMo stands for #DigitalContent #DataModel, a #GenericDataModel common to 2 Economic Activity Sections, 3 Ecosystems and 16 Activity Sectors of the Digital Content (including 10 Media and Entertainment Sectors), natively including #Blockchain and #DLT.
dicodamo.org
Converting a classic #Excel PivotTable to a Power Pivot-based #PivotTable actually takes a lot of work to load the #DataModel, recreate the calculations in #DAX, and then rebuild the pivots. 😔
The Modern Pivot Monkey takes care of all of this for you! 😎 Learn more about it at mkyt.ca/modernpivot
Our #DimensionalModeling course at @skillwave.training pairs 2 of #SelfServiceBI’s most powerful features: #PowerQuery and the #DataModel. Learn to use each for what they were designed to do and build your data models the RIGHT way. ✅
Use code SUMMER50 to save 50%: skw-t.com/datamodel50
