Cengage India

Home

Higher Education

Data Analytics and Business Intelligence: Using Excel and Power BI

Author(s): Ashim Raj Singla

ISBN: 9789366600956

1st Edition

₹795

Binding: Paperback

Pages: 708

Trim Size : 241*181mm

Refer Book > Order Inspection Copy >

This textbook is designed to provide a comprehensive understanding of Data Analytics and Business Intelligence (BI) concepts, along with practical implementation using Microsoft Excel and Power BI. It is suitable for students of management, commerce, and information technology, as well as professionals aiming to develop strong analytical and data-driven decision-making skills.

The book begins with fundamental concepts such as data, databases, data warehousing, OLTP, OLAP, and data lakes, and gradually progresses toward advanced topics, including data mining, data visualization, and big data analytics. It further explores the real-world applications of Business Intelligence across domains such as marketing, finance, retail, healthcare, and supply chain management.

A major strength of this book lies in its practical orientation. It provides hands-on exposure to Microsoft Excel features such as formulas, functions, PivotTables, What-If Analysis, Solver, and statistical tools. In addition, it offers in-depth coverage of Power BI, including data transformation using Power Query, data modeling, DAX calculations, dashboard creation, and report publishing.

Covers key concepts such as data warehousing, data mining, data visualization, and big data analytics
Includes advanced Excel techniques like PivotTables, What-If Analysis, Solver, and statistical tools
Explains Power BI components, including Power Query, data modeling, DAX functions, dashboards, and report publishing
Incorporates real-world examples and case-based approach for better understanding
Suitable for academic courses as well as professional development and learning

1. Fundamental Concepts in Business Analytics

2. Understanding the Concept of Business Intelligence

3. Data Warehousing

4. Data Mining

5. Data Visualization

6. Data Lake and Big Data Analytics

7. Fundamental Excel Skills

8. Developing Charts and Graphs Using Excel

9. Advance Excel Methods

10. Data Modeling and Power Pivot

11. Introduction to Power BI

12. Data Transforming Methods