๐”– Scriptorium
โœฆ   LIBER   โœฆ

๐Ÿ“

Data Analysis & Dashboarding with Microsoft Excel

โœ Scribed by Jasmeen Kaur


Year
2022
Tongue
English
Category
Library

โฌ‡  Acquire This Volume

No coin nor oath required. For personal study only.

โœฆ Synopsis


With the world brimming with data, data analysis is one of the most in-demand digital skills today. Microsoftยฎ Excelยฎ remains the most popular number-crunching tool across all businesses of any size and type. This book will teach you a highly desirable combination of data analysis with Excel skills by walking you through the data analytics lifecycle. You will download practice spreadsheets and follow step-by-step instructions to learn powerful Excel features relevant to data analysis, including

  • Cleaning and organizing data,
  • Analyzing data with basic and advanced functions,
  • Exploring aggregated data interactively with PivotTables and PivotCharts,
  • Visualizing data with charts, and
  • Creating professional and interactive dashboards.
The book is designed in a way that previously covered features are recalled in future chapters to ensure you solidify your understanding of how those features tie together as building blocks of the data analytics lifecycle. You will also develop a couple of cool dashboards from scratch!

About the Author
Jasmeen Kaur is an experienced business intelligence professional passionate about supporting managementโ€™s decision-making with quantitative evidence. She has worked with data for over eight years and is keen on sharing her knowledge of the most business-relevant Excel features with her readers. She has a masterโ€™s degree from McGill University, Canada and currently works in the public service.


๐Ÿ“œ SIMILAR VOLUMES


Balanced Scorecards and Operational Dash
โœ Ron Person ๐Ÿ“‚ Library ๐Ÿ“… 2008 ๐Ÿ› Wiley ๐ŸŒ English

Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or processโ€”both features are in high demand for many large organizations. This book serves as the first guide to focus on c

Data analysis with Microsoft Excel (upda
โœ Kenneth N. Berk, Partrick Carey ๐Ÿ“‚ Library ๐Ÿ“… 2009 ๐Ÿ› Cengage Learning ๐ŸŒ English

This popular best-selling book shows students and professionals how to do data analysis with Microsoft Excel. DATA ANALYSIS WITH MICROSOFT EXCEL teaches the fundamental concepts of statistics and how to use Microsoft Excel to solve the kind of data-intensive problems that arise in business and elsew

Data Visualization with Excel Dashboards
โœ Dick Kusleika ๐Ÿ“‚ Library ๐Ÿ“… 2021 ๐Ÿ› Wiley ๐ŸŒ English

<p><span>Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons. An effective analyst not only has to have the technical skills to use Exce

Data Visualization with Excel Dashboards
โœ Dick Kusleika ๐Ÿ“‚ Library ๐Ÿ“… 2021 ๐Ÿ› Wiley ๐ŸŒ English

<p>Large corporations like IBM and Oracle are using Excel dashboards and reports as a Business Intelligence tool, and many other smaller businesses are looking to these tools in order to cut costs for budgetary reasons. An effective analyst not only has to have the technical skills to use Excel in a