Projects Analysis & Reporting By Using Power BI

Collect and import data from multiple sources to build Power BI reports and dashboards. Learn how tiles, visuals, and the canvas enable data modeling for reports and dashboards.

Discover Power BI layouts in a quick preview, covering report, table, model, dax query, and transform data views, plus the data getting, cleaning, and preparing for reports and dashboards.

Learn how to get data into Power BI, from Excel, CSV, XML, PDF, folder, and ODBC sources, import vs direct query, and preparing data for visuals.

Explore Power BI data import from Excel across report, table, and model views; create measures with DAX, transform data, manage relationships, and build visuals with filters and hierarchies.

Learn to configure general visuals options in Power BI charts, including axes formatting and headers, then export data to CSV or view as a table.

Explore how Power BI supports business intelligence and data analysis by importing data from diverse sources and selecting visuals to communicate insights to stakeholders.

Learn to build stacked bar and stacked column visuals in Power BI, configure axes, legends, tooltips, small multiples, and drill-through to analyze project costs and progress.

Explore how to use clustered bar and column visuals in Power BI to clearly compare progress, expenses, and overhead across months or projects, with readable data labels and colors.

Create a 100% stacked column chart in Power BI to display cost components as percentages, set data labels, and compare material, labor, subcontractor, and indirect costs across projects and months.

Learn how line, area, and stacked area charts visualize project progress over time, compare actual progress with the planned progress, and customize axes, legends, and data labels in Power BI.

Learn to create and read area and stacked area charts in Power BI, compare head office and general costs, and read values using a single y axis.

Learn to merge line charts with stacked or cluster column charts in Power BI to analyze progress, cost, and profit, and to use ribbon charts for continuous data relationships.

Explore Power BI waterfall chart, learn to load data, configure category and y axis, apply breakdowns by year and project, and interpret income movements across years.

Explore the funnel chart visualization in Power BI, using category and progress data to display project performance with data labels, percent of first, and percent of previous.

Learn to build a Power BI scatter chart that plots progress against profit on x and y axes, with marker size and color by category.

Explore Power BI pie and donut charts, comparing values and details by project; adjust colors, legend, slicer, and labels, while noting negative values are zero and totals show 100%.

Master treemap charts in Power BI to visualize project progress by location and category, with relative sizes, tooltips, colors, and the option to display as a table.

Learn to configure a gauge chart in Power BI, displaying progress against minimum, maximum, and annual targets, with measures and adjustable data labels.

Master Power BI card visuals—normal, simple, multi-row, and the new card—learn to configure layouts, callout values, drill through, overflow, and slicer-driven filtering for projects.

Learn to build a KPI chart in Power BI that distributes the annual target across projects by weighted percentages, showing progress, variance, and a trend axis view.

Master Power BI slicers to create dynamic filtering across visuals, covering classic and new styles, single and multi selections, and synchronization across pages.

Explore how to build and compare table and matrix visuals in Power BI, focusing on data collection, cleaning, and analysis, plus fact and dimension tables.

Discover how the Power BI key influencers chart analyzes factors like material and labor cost to impact income and gross profit, using small and large data, segments, and narrative insights.

Explore the decomposition tree chart in Power BI to perform root-cause analysis with level-by-level breakdowns, AI visuals, and interactive filters, sorting, and exports for project insights.

Explore how a Power BI Q&A feature lets you ask data questions in a search bar, generate charts or cards, and refine results with synonyms while avoiding extra measures.

Explore how the narrative report AI visual in Power BI creates dynamic project updates by summarizing duration, date, progress, and work descriptions for stakeholders.

Explore creating and managing metrics visuals and scorecards in Power BI, including connecting data, setting targets and rules, tracking progress, and using service features like read mode and subscriptions.

Power Automate, the third pillar of the power platform, automates notifications and tasks with flows and templates, and in Power BI a button can trigger these flows.

Discover power apps as the next pillar of the power platform and see how canvas apps, portals, and model-driven options bundle dashboards and reports to deliver controlled data to stakeholders.

Learn to use Power BI elements—text box, buttons, shapes, and images—to create navigable, narrative reports with bookmarks and slicer actions.

Learn to create, rename, update, and delete bookmarks in Power BI. Capture snapshots of data and visuals, including display and current page states, using slicers and bookmarks.

Learn to select and arrange Power BI visuals by managing layer and tab order, grouping visuals, and aligning canvases to create clear, decision-driving reports for stakeholders.

Learn to use Power BI maps, including map, field map, shape map, ArcGIS and Azure map, with geocoding via Bing, longitude/latitude data, legends, and interactive bubbles.

learn to apply conditional formatting in Power BI using gradient rules, data bars, and icons, driven by a color code column and the summation of total cost for clear visuals.

Use the performance analyzer to record visual refresh durations and evaluate visuals. Inspect collected data, sort results, copy queries, and diagnose Dax within transform data to optimize performance.

Learn visualization advice for effective Power BI dashboards, emphasizing clarity, precision, and efficiency to tell a data story to stakeholders, prioritizing substance over decoration.

Learn power bi data modeling by creating relationships between tables, setting cross-filter directions and cardinality, and building a scalable model to drive accurate reports and dashboards.

Learn to model project data in Power BI using a model view layout by creating datasets, establishing one-to-one and one-to-many relationships, and managing relationships across data cards for accurate reporting.

Learn to manage relationships in Power BI by creating and editing table connections, choosing cardinality (one-to-one, one-to-many, many-to-many), and configuring cross-filter direction and active status.

Explore how cardinality and cross filter direction shape Power BI data models, building one-to-one, one-to-many, and many-to-many relationships, and using active or inactive filters to ensure correct data propagation.

Explore Power Query Editor for transforming data, cleansing multi-source inputs, merging and splitting tables, and applying parameters and calculations before modeling and reporting in Power BI.

Learn to transform data in Power BI by importing Excel sheets, navigating queries, applying steps, promoting headers, changing types, and using the M language in Power Query Editor.

Manage Power BI queries by renaming, deleting, and copying, explore duplication vs reference, and control load and refresh while grouping, moving, and editing with the advanced editor and M language.

Explore Power BI's home menu and query editor to manage data sources, apply and refresh changes, and master columns, rows, sort, split, and transform data.

Master merging and cleaning data in Power BI by using seven join options, including left outer, right outer, full outer, inner, and fuzzy matching with transformation tables and append queries.

Explore Power BI AI insights for text analysis, vision, and Azure Machine Learning to analyze data. Learn how sign-in enables language detection, key phrases, sentiment, and image tagging with confidence.

Learn how to clean and shape data in Power BI's transform menu, then load, model, and create dashboards, by transposing, replacing errors, filling gaps, pivoting, merging, and extracting.

Learn six ways to add columns in Power BI: from examples, custom formulas, invoke custom function, conditional columns, index columns, and duplicate columns, with practical use cases.

Explore the view menu to manage query settings, formula bar, and whitespace cleaning, and learn to assess column quality and distribution for clean data in Power BI.

Explore the tools menu to diagnose performance issues in Power BI, enabling tracing, optimizing RAM usage, and analyzing diagnostic queries and reports from Power Query Editor.

Master DAX in Power BI to transform data with calculated columns, measures, and tables, model relationships across datasets, and learn about 250 functions and the DAX versus M languages.

Master writing Dax formulas by starting with =, choosing from more than 250 functions. Build measures, columns, and tables in Power BI with clear syntax and data relationships.

Explore DAX mathematical functions in Power BI, from absolute and cosine to convert, ceiling, and divide, and learn how to combine data for advanced visuals and forecasting.

Explore text functions in Power BI to combine, format, and extract data from text, using concatenate, concatenatex, find, search, trim, and format across tables.

Explore aggregation functions in Power BI, including average, count, and sum, and learn how blanks, text data, and iterators like average x and count x shape your results.

Learn to apply logical functions in Power BI, including and, or, not, and switch, to create true/false conditions and handle non-blank values.

Explore date and time functions in Power BI to build a date table, enable time intelligence, and strengthen project reporting with calendar and calendar auto features.

Learn Dex language time intelligence functions in Power BI, using a date table and calculations like MTD, QTD, YTD, and end-of-period measures to analyze project data.

Explore filter functions in Power BI, mastering calculate and calculate table, and learn to manage filter context with all, all except, cross filter, no blank, and all selected.

Explore the basics of DAX and M language in Power BI, the two languages powering data transformation with the Power Query editor and ETL concepts.

Learn ten universal rules for launching and managing projects, from understanding company policy and project plan to establishing data systems, KPIs, and reporting templates.

Transform daily site data into stakeholder-ready Power BI visuals, revealing target versus achievement across private and government sectors, through data collection, cleaning, and concise conclusions.

Discover how to leverage AI for planning, costing, and reporting in engineering projects by exploring AI basics, prompt engineering, and AI tools and workflows that automate mapping sheets and dashboards.