Welcome
What’s inside every chapter
Bring in data from Excel, CSV files and SQL databases, then shape and clean it in the Power Query Editor.
Build star schemas where fact and dimension tables connect through well-defined relationships for fast, reliable analysis.
Core visualizations, slicers, filters, drilldowns and cross-filtering that let users explore the data themselves.
Calculated columns, measures and time intelligence that answer real analytical questions, not surface summaries.
Key Influencers, advanced visualizations and paginated reports for deeper, decision-grade insight.
The Power BI Service — scheduled refresh, workspace roles, embedding and Q&A so the right people see the right data.
Browse the modules
How to use this book
Read a chapter top to bottom the first time: each builds an idea from the ground up, shows it in Power BI step by step, and explains why it works the way it does. Follow the workflow in order — connect and clean, model, visualize, calculate with DAX, then publish — so every later chapter rests on solid foundations. When you need a refresher, the Syllabus page is your map to every module and topic.
Welcome
Data Visualisation using Power BI guides you through the complete analytics workflow, from connecting to data all the way to sharing insights across your organization. You will learn to bring in data from Excel, CSV files, and SQL databases, clean and reshape it in Power Query Editor, and build star schema models where fact and dimension tables are connected through well-defined relationships.
From there, the book moves into report building, covering core visualizations, slicers, filters, and DAX (Data Analysis Expressions) measures that go beyond what drag-and-drop alone can produce. Advanced chapters extend this further with time intelligence calculations, Key Influencers, and paginated reports that address real analytical questions rather than surface-level summaries. The final part introduces the Power BI Service, where reports are published, datasets refresh on a schedule, and access is managed through workspace roles, so the right people always see the right data. Whether you are building your first dashboard or scaling analytics across a team, this book gives you the practical skills to work with data confidently at every stage.
About the authors
Vijayakumar P is an Educator & Data Analytics Professional with 8+ years in Analytics, AI and HR. UGC-JRF-NET in Management.
Rani C is an Educator & HR Business Intelligence Professional with 8+ years in HRM and HR Analytics. UGC-NET in Management.
References
Text Books
- Microsoft Power BI: A Comprehensive Guide. Rad, Reza. (1st ed.). Microsoft Press.
- Power BI: Data Analysis and Visualization with Microsoft Power BI. Chmait, Mazen. (1st ed.). McGraw-Hill Education.
Reference Books
- The Complete Guide to Power BI. Frye, Curt. (1st ed.). Apress.
- Mastering Microsoft Power BI. Gordon, Leon. (2nd ed.). Packt.