IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
Designing Fact and Dimension Tables
Practical rules for designing fact and dimension tables: declaring the grain, choosing transaction, snapshot or factless fact tables, why averages and distinct counts must not be summed, shown on three million taxi trips where an average of averages nearly doubled the true fare, junk dimensions, and keys.
Power BI Mobile: Designing Reports for Phones
How to design Power BI report pages for phones: when mobile-optimised views appear and when they do not, building a layout in the mobile layout editor or with auto-create, choosing and ordering the few visuals that matter on a small screen, formatting for touch, publishing, and testing in the Power BI mobile apps.
KPIs and Cards in Power BI: Designing Scorecards
Designing KPI cards and scorecards in Power BI: when to use the card visual, the KPI visual or scorecards in the Power BI service, why every headline number needs a comparison, measures for prior period, variance and status, a worked row of cards from Microsoft's Financial Sample, and layout rules for a scorecard page.