🧩 Design Before Build
While developing the dashboards, I also created a wireframe to plan:
•KPI placement
•Chart structure
•Overall user flow
#PowerPivot #DataModeling #AnalyticsJourneyA
508: Deprecated push features create data model headaches. SQL Server emerges as a write-back alternative, balancing licensing and efficiency. #DataModeling#SQLServer
Before dashboards, I focused on the foundation.
Built a Star Schema, added surrogate keys, created a proper date table, and designed a wireframe for my Colgate dataset project.
💡 Good dashboards start with great data models.
#PowerBI #DataModeling #DataEngineering #DAXs
Power BI report ready.
Deadline: today evening.
Client: “Just one more Excel file.” 😄
That means:
new structure
fix relationships
clean data
update model & measures
Hardest part of BI?
Understanding the data before adding it.
#PowerBI #DataModeling #DeveloperLife
No no no… don’t do that 😄
Don’t force many-to-many in Power BI.
That’s how you get:
weird totals
broken filters
confused reports
Do this instead:
👉 Build a Bridge Table
When tables don’t talk… build a bridge. 🌉
#PowerBI #DataModeling #PowerBITips
Managing asset models for thousands of devices is a nightmare. TDengine IDMP introduces element templates and CSV import/export. You can now version-control your database asset hierarchy just like application code. #IIoT#DataModeling