Power BI bento canvases
How a 16:9 background is laid out before it reaches the report, and what Bento Designer is for.
LayoutNotes on Power BI, SQL, SSRS, reporting operations, and the tools on this site.
38 shown
How a 16:9 background is laid out before it reaches the report, and what Bento Designer is for.
LayoutTurning a column of values into a quoted IN clause without breaking the query.
SQLGenerate a date table in DAX or M, then mark the Date column as a date table in Model view.
DAXModelBuild YTD, prior year, and YoY measures from a date table and a base measure.
DAXFormat a DAX measure in the browser before it goes into the semantic model.
DAXBrowse tables, columns, and measures from TMDL or a .pbix without opening Desktop.
ModelDAXBuild a theme.json with readable contrast and export it for use in a report.
ThemeDiff two scripts with SQL formatting and a semantic check before you merge them.
SQLDesign the model and the SQL so operations can run the report after release.
PracticeModelWhen a report fault is a gateway, a schedule, or a warehouse issue that presents as a visual.
OperationsScheduled operational reports that still belong in SSRS, next to a Power BI model.
SSRSPracticeRelationships and measures that more than one report can share, instead of a model per page.
PracticeModelFilters, layout, and a model that let operations answer the next question themselves.
PracticeReplace file handling and row-by-row checks with automation, including AI when it is reliable.
PracticeA solutions engineer with a background in business intelligence, publishing Power BI and SQL tools.
StudioA personal project. Cars learn a track with neural networks and a genetic algorithm, from scratch in the browser.
StudyWhen to export a raster background and when a vector file keeps the edges clean.
LayoutThe report page has a fixed aspect ratio. The background has to match it or the cells will crop.
LayoutKeep DAX in the semantic model so more than one page can use it, and a review can find it.
DAXModelDesign the SQL, the model, and the report as one piece of work, not three hand-offs.
PracticeSQLA public report on fraud concentration and loss exposure, built from a Kaggle dataset, not client work.
StudyA public report on NO2, O3, and PM10 by time and location, built from a Kaggle dataset.
StudySingle quotes, values that already contain an apostrophe, and why the paste still has to be checked.
SQLAdministration that keeps a live report refreshing after the model has been handed over.
OperationsThe background carries hierarchy before any visual is placed. Without it, the page is a pile of charts.
LayoutA finished-looking canvas makes the next number obvious. People stay in the report instead of asking for a slide.
LayoutA single page background is one image. A frame built from shapes is a stack of visuals that the report has to render.
LayoutOpen TMDL or a .pbix in the browser to confirm a measure or a hidden column without waiting for Desktop.
ModelA theme.json file sets colours, text, and visual defaults so every page shares one palette.
ThemeA theme.json file is a contract. Colours and text defaults survive the next page and the next author.
ThemeName the file, check contrast, keep the palette short, and apply the theme before you format visuals.
ThemeSQL Server Reporting Services. Paginated, print-stable reports on a schedule, usually as a file or an email.
SSRSPixel-stable pages, a mailbox delivery, and no workspace login. That is still the right tool for some operational reports.
SSRSSubscriptions, a fixed PDF or Excel file, and a mailbox that does not depend on someone opening a workspace.
SSRSOperationsA free browser game. You solve short cases by writing real SQL against SQLite in the page, with no install.
StudySQLA free lesson-and-exercise path from SELECT through joins, aggregates, and table changes, run in the browser.
StudySQLA free, ad-free book by Zi Chong Kao. You write queries against a real dataset in the browser, about thirty minutes a chapter.
StudySQLNick Singh’s site for SQL and analytics interview questions, with an editor, hints, and worked solutions.
StudySQLNo notes match that search.