Analytics and Dashboard Development Lab

P 4 C 2

Internal Evaluation: as per university examination norms. End Term Practical Examination: as per university examination norms.

Course outcomes

• The ability of students to apply advanced spreadsheet techniques using Excel for data entry, manipulation, formula creation, functions, lookups, conditional analysis, and worksheet management. [K3]
• The ability of students to Analyze and summarize data using Excel tools such as charts, Pivot Tables, Power Query, Data Validation, Analysis ToolPak, and data visualization techniques. [K4]
• The ability of students to develop interactive business intelligence solutions using Power BI by creating data models, reports, dashboards, visualizations. [K6]
• The ability of students to design and implement effective data visualizations and dashboards using Tableau, including data preparation, calculations, mapping, and visualization. [K6]

Unit I (12 lectures)

Excel Fundamentals, Formulas, and Data Analysis: Introducing Excel, exerting and editing worksheet data- exploding, modifying, performing best worksheet operations, working with excel ranges and tables, formatting worksheet, understanding excel files and templates, printing your work, customizing the excel user interface, working with formulas and functions- array, math, dates. Using formulas to manipulate text, conditional analysis, matching, LookUps.

Unit II (10 lectures)

Advanced Excel Data Visualization and Analytical Tools: Getting started with excel charts, advanced charting techniques, creating graphics, managing and analysing data, data validation, linking and consolidating worksheet, pivot tables, analyzing data with pivot tables, analysis toolPak, protecting your work, internal data model, power query, summarizing data using data visualization, power view and 3D maps.

Unit III (10 lectures)

Power BI for Data Modeling, Reporting, and Dashboarding: Getting started with Power BI, uploading data, introducing natural language queries, quick insight, reports, visual interactions, decorating, saving report, pinning, filtering, sharing the dashboard, understanding data refresh, using Power BI Desktop, getting data from services and content packs, building a data model, improving power BI reports, getting data from existing system, integrating Power Bi with office, managing security to access data, extending and customising power BI.

Unit IV (10 lectures)

Tableau for Data Preparation, Visualization, and Dashboard Design: Tableau Introduction, creating Worksheet,dashboard, connecting tableau to your data, measure name and values, tableau concepts, exporting data to other devices. Getting your data ready, tableau prep builder, all about data-joins, blends, data structure, table calculations, data densification, cubes and big data, level of detail calculations, beyond the basic chart types, mapping, tableau for presentations, visualization best practices and dash board design.

Textbooks

• Winston, W. (2021). Microsoft Excel data analysis and business modeling (Office 2021 and Microsoft 365). Microsoft Press.
• Ferrari, A., & Russo, M. (2016). Introducing Microsoft Power BI. Microsoft Press.
• Meier, M., & Baldwin, D. (2021). Mastering Tableau 2021: Implement advanced business intelligence techniques and analytics with Tableau. Packt Publishing Ltd.

References

• Alexander, M., & Kusleika, D. (2025). Microsoft Excel 365 Bible. John Wiley & Sons.
• Machiraju, S., & Gaurav, S. (2018). Power Bi data analysis and visualization. DeG Press.
• Jackson, A., & Stanke, L. (2021). Tableau Strategies. " O'Reilly Media, Inc