Data Analysis With Power BI
Science And Technology

Data Analysis With Power BI

Data Analysis with Power BI is the process of collecting, cleaning, transforming, and visualizing data using Microsoft Power BI to generate meaningful insights, create interactive dashboards, and support effective data-driven decision-making.
Course ModeOnline
Duration2 Weeks
Starts05 Jan 2027
Ends16 Jan 2027
Course Fee
₹1,000/-
Enroll Now
About The Course

Overview

This intensive course teaches learners how to turn raw data into useful business insights with Microsoft Power BI. Students will connect to data, clean and transform it with Power Query, build a data model, write essential DAX measures, design interactive reports, and present findings through a final dashboard project.

Learning Goals

Course Outcomes

 Course outcomes

• Understand the data analysis workflow and the role of business intelligence.

• Import Excel and CSV files and inspect data quality.

• Clean, reshape, and combine data with Power Query

• Build relationships and a star-schema data model.

• Create calculated columns and measures with DAX.

• Use common charts, slicers, filters, drill-down, and drill-through

• Publish and validate reports where Power BI Service access is available.

• Present a portfolio-ready dashboard with evidence-based recommendations.

Curriculum

Course / Modules

Day 1: Introduction to Data Analysis and Power BI Learning objective: Understand analytics basics, business questions, and the Power BI interface. 1.1 Data analysis foundations • Data, information, insight, and decision-making • Structured versus unstructured data • Descriptive, diagnostic, predictive, and prescriptive analytics • Business questions, metrics, and KPIs 1.2 Power BI ecosystem • Power BI Desktop, Power BI Service, and mobile experience • Reports, dashboards, semantic models, and workspaces • Typical workflow: connect, transform, model, analyse, visualise, publish 1.3 Desktop interface • Report, Data/Table, and Model views • Ribbon, data pane, visualisations pane, filters pane, and canvas • Saving PBIX files and organising project folders Hands-on practical • Open Power BI Desktop, import a sample sales CSV, inspect fields, create a table and a total-sales card, and save the report. Assignment • Write five business questions for a retail manager and identify the fields needed to answer them. Review questions: Define BI, KPI, report, dashboard, and the data analysis workflow.

Day 2: Connecting to Data and Data Profiling Learning objective: Import data from common sources and inspect its quality before transformation. 2.1 Data sources and import • Excel workbooks, CSV/text files, folders, and database connectors • Get Data, Navigator, selecting sheets/tables, and loading data • Import versus DirectQuery: introductory differences 2.2 Understanding columns and rows • Rows, columns, grain, data types, distinct values, and unique values • Dates, currency, percentages, identifiers, and locale • Column quality, distribution, and profile in Power Query 2.3 Source management • File paths and stable file naming • Source credentials and privacy considerations • Refresh basics and documenting source ownership Hands-on practical • Import an Excel workbook and CSV. Inspect row counts, data types, distinct values, and missing values. Assignment • Create a source inventory describing the source, row grain, important columns, and possible data-quality problems. Review questions: Explain grain, null versus zero, and distinct versus unique values

Day 3: Data Cleaning with Power Query Learning objective: Clean messy data and build repeatable transformation steps. 3.1 Power Query Editor • Queries, preview grid, formula bar, and Applied Steps • Changing data types and fixing conversion errors • Renaming columns and queries; removing unnecessary rows and columns 3.2 Cleaning text and values • Handle nulls, blanks, and placeholder text • Remove duplicates only when the business rule supports it • Trim, Clean, Replace Values, and standardise case • Split columns by delimiter and merge columns 3.3 Reshaping and combining • Filter and sort rows; remove errors • Fill down/up when valid • Pivot and unpivot columns • Append queries to stack rows; merge queries to match keys 3.4 Validation • Conditional columns and custom columns • Review Applied Steps • Compare row counts and totals before and after cleaning Hands-on practical • Clean a messy dataset: correct data types, standardise text, remove true duplicates, split names, handle missing values, and unpivot monthly columns. Assignment • Submit a cleaning log listing each issue, the action taken, the reason, and the validation performed. Review questions: Differentiate append and merge, pivot and unpivot, null and error

Day 4: Data Modelling and Relationships Learning objective: Create a reliable model for correct filtering and aggregation. 4.1 Modelling fundamentals • Tables, rows, columns, primary keys, and foreign keys • Fact tables versus dimension tables • Choosing the grain of each table 4.2 Relationships • One-to-many and many-to-one relationships • Active/inactive relationships and cardinality • Filter direction and filter propagation • Risks of many-to-many relationships 4.3 Star schema • Sales fact table with Date, Product, Customer, and Region dimensions • Keys and unmatched records • Date table basics and sorting month names • Hide technical keys and use clear business names Hands-on practical • Create a model from sales, products, customers, and calendar tables. Link them and test whether a product selection filters sales correctly. Assignment • Draw the model diagram and document each table's purpose, grain, key, and relationships. Review questions: Explain fact versus dimension tables, cardinality, and star schema.

Day 5: DAX Fundamentals: Measures and Calculated Columns Learning objective: Create reusable calculations for business reporting. 5.1 DAX basics • What DAX is and where it is used • Calculated columns, measures, and calculated tables • Syntax, operators, data types, and naming conventions 5.2 Aggregation functions • SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, DISTINCTCOUNT • DIVIDE for safe division • SUMX and the idea of iterators • Total Sales, Total Profit, Orders, Average Order Value 5.3 Logic and formatting • IF, SWITCH, AND, OR, and comparison operators • Concatenation and FORMAT basics • Currency, decimal, and percentage formatting 5.4 Evaluation concepts • Introductory row context and filter context • How slicers affect measures • Why measures change by category in a visual Hands-on practical • Create measures for Total Sales, Total Profit, Total Orders, Average Order Value, Units Sold, and Profit Margin. Assignment • Create at least six measures and write one sentence explaining each measure. Review questions: Explain measure versus calculated column, SUM versus SUMX, and DIVIDE.

Day 6: Intermediate DAX and Time Intelligence Learning objective: Compare performance across periods, categories, and targets. 6.1 Filter context • CALCULATE and how it changes filter context • FILTER, ALL, and REMOVEFILTERS • VALUES and SELECTEDVALUE 6.2 Comparisons • Percentage of total and contribution • Ranking products with RANKX • Actual versus target and variance • Year-over-year and month-over-month comparisons 6.3 Date calculations • Build a continuous calendar table • Mark as date table and sort month labels • Year-to-date sales and previous-year sales • YoY difference and YoY percentage using DIVIDE • Running totals and validation Hands-on practical • Build a calendar table and measures for Sales YTD, Previous Year Sales, YoY Change, YoY %, and product ranking. Assignment • Verify three DAX calculations manually against a small sample of source data. Review questions: Explain CALCULATE, calendar table requirements, and percentage variance

Day 7: Data Visualisation and Chart Selection Learning objective: Choose charts that communicate trends, comparisons, and patterns clearly. 7.1 Visual design principles • Match visuals to the question being asked • Clear titles, labels, units, and number formats • Colour, contrast, accessibility, and avoiding clutter • Avoid misleading axes and unsupported conclusions 7.2 Core visuals • Bar and column charts for comparisons • Line charts for trends • Cards and KPI visuals for headline metrics • Tables and matrices for details • Scatter charts for relationships; pie/donut only for simple compositions 7.3 Additional visuals • Combo, waterfall, funnel, treemap, and decomposition tree • Maps and geographic data quality • Conditional formatting • Custom visuals and organisational policies Hands-on practical • Create a page with KPI cards, a monthly line chart, a category bar chart, a region chart, and a detail table. Assignment • Build a one-page executive overview and write two evidence-based takeaways. Review questions: Choose suitable visuals for ranking, trend, relationship, and detailed lookup.

Day 8: Interactive Reports and Navigation Learning objective: Make reports easy to explore using filters and navigation. 8.1 Filters and slicers • Visual-, page-, and report-level filters • Slicers for dates, categories, and numeric ranges • Sync slicers and edit interactions 8.2 Drill and navigation • Drill down/up through hierarchies • Drill-through detail pages • Report page tooltips • Buttons, bookmarks, and page navigation 8.3 Usability testing • Reset filters and show filter state • Consistent page layouts and names • Test cross-highlighting and interactions • Gather feedback and improve report usability Hands-on practical • Build a three-page report: Executive Summary, Product Analysis, and Region/Customer Detail. Add slicers, drill-through, and navigation. Assignment • Ask a peer to complete three tasks with your report and record three usability improvements. Review questions: Differentiate filter and slicer, drill-down and drill-through, bookmark and page navigation.

Day 9: Business KPIs and Analytical Insights Learning objective: Use reports to investigate performance and recommend action. 9.1 KPI design • Define numerator, denominator, time period, target, and owner • Revenue, profit, margin, growth, and average order value • Return rate, fulfilment time, customer retention concepts 9.2 Segment analysis • Compare product, region, channel, and customer segment • Top-N analysis and ranking • Contribution and Pareto-style analysis • Target variance and segment comparisons 9.3 Analytical features • Decomposition tree and key influencers where available • What-if parameters for scenario analysis • Forecasting and its limitations • Correlation versus causation and alternative explanations 9.4 Communicating insights • State finding, evidence, implication, and action • Identify seasonality and one-off events • Acknowledge uncertainty and data limitations Hands-on practical • Investigate a change in profit by month, category, and region. Use comparisons and, if available, a what-if parameter. Assignment • Write an insight brief with three findings, supporting metrics, and two practical recommendations. Review questions: Define KPI, explain Pareto analysis, and distinguish correlation from causation.

Day 10: Power BI Service, Publishing, Refresh, and Security Learning objective: Understand deployment, sharing, refresh, and access control. 10.1 Publishing • Publish from Desktop to Power BI Service • Workspaces, reports, semantic models, and apps • Sharing versus app distribution and licensing considerations 10.2 Refresh and gateways • Manual and scheduled refresh concepts • Credentials and refresh history • On-premises data gateway purpose • Common failures: changed paths, credentials, and schema 10.3 Security • Row-level security concepts and roles • Test report access and least-privilege permissions • Data privacy, classification, and governance 10.4 Maintenance • Validate published report against Desktop • Document owner, refresh schedule, and dependencies • Change log and backup PBIX file Hands-on practical • If Service access is available, publish a report and inspect refresh and workspace settings. Otherwise, prepare an annotated deployment checklist. Assignment • Create a deployment checklist covering publishing, permissions, refresh, validation, and ownership. Review questions: Explain workspace, semantic model, refresh, gateway, and RLS

Day 11: Performance, Troubleshooting, and Professional Practice Learning objective: Improve reliability and diagnose common modelling and reporting errors. 11.1 Performance • Model size, cardinality, and unnecessary columns • Clean star schema and careful relationship direction • Import versus DirectQuery trade-offs • Performance Analyzer where available 11.2 DAX and Power Query • Variables using VAR and RETURN • Readable and reusable measures • Query folding basics and why it matters • Measure performance before and after changes 11.3 Troubleshooting • Incorrect totals, blank visuals, and relationship errors • Data type, locale, and refresh errors • Systematic debugging: reproduce, isolate, inspect, test, document 11.4 Delivery practice • Requirements gathering and metric definitions • Data dictionary and assumptions log • Accessibility, privacy, and responsible reporting • Explain insights to technical and non-technical audiences Hands-on practical • Review your report for unused columns, broken relationships, slow visuals, formatting, and incorrect totals. Fix and document issues. Assignment • Submit a QA checklist and list the issues found and resolved. Review questions: Name three causes of slow reports and describe a systematic debugging process.

Day 12: Capstone Project and Presentation Learning objective: Combine all course skills in a complete, portfolio-ready Power BI project. 12.1 Project scope • Choose retail, finance, HR, marketing, or operations • Define stakeholder, business problem, questions, and success criteria • Record sources, assumptions, and limitations 12.2 End-to-end build • Clean data with Power Query • Build a star schema and calendar table • Create reusable DAX measures • Build interactive report pages and validate calculations 12.3 Present results • Summarise top findings and recommendations • Demonstrate filters and answer a stakeholder question • Explain model, measures, and design decisions • Acknowledge data limitations 12.4 Portfolio • Organise PBIX, screenshots, and documentation • Write a project summary or README • Review Microsoft Learn and current PL-300 skills outline if certification is a goal Hands-on practical • Complete and present your capstone dashboard using the project requirements below. Assignment • Submit the PBIX file, model diagram, cleaning log, DAX definitions, dashboard, insight brief, and presentation. Review questions: Explain the business problem, cleaning choices, model, key measures, findings, and recommendations.

 

Learn From Experts

Our Trainers

Shiladitya Raj
Shiladitya Raj
Centre Head, Saksham Digital Technology, Bhopal (MP)
Need Help?

Frequently Asked Questions

Data Analysis with Power BI is the process of collecting, cleaning, transforming, analyzing, and visualizing data to gain meaningful insights and support better decision-making.
Microsoft Power BI is a business intelligence tool developed by Microsoft that helps users analyze data and create interactive reports and dashboards.
The main features include data visualization, interactive dashboards, data transformation, data modeling, report generation, and data sharing.
Power Query is a data transformation tool used to clean, filter, combine, and prepare data before analysis.
DAX stands for Data Analysis Expressions. It is a formula language used to create calculated columns, measures, and tables.
Data modeling is the process of creating relationships between different tables to organize data and perform accurate analysis.
A slicer is an interactive visual filter that allows users to filter report data based on selected values.
Excel is commonly used as a data source for Power BI. Users can import Excel data and create interactive reports and visualizations.
Power BI is used in sales analysis, financial reporting, marketing analysis, business performance monitoring, inventory management, and customer analysis.
The main objective is to convert raw data into meaningful information through interactive reports and dashboards to support accurate and effective decision-making.