Category: Databases & Big Data

200+ Excel Formulas and Functions 0

200+ Excel Formulas and Functions

eBook Details: Paperback: 270 pages Publisher: WOW! eBook (May 23, 2023) Language: English ISBN-10: 935551378X ISBN-13: 978-9355513786 eBook Description: 200+ Excel Formulas and Functions: Improve your daily work efficiency and productivity using Microsoft Excel Microsoft Excel is one of the most significant and widely used tools in various professions and industries. If you want to master Excel, then this book is for you. This book focuses on Excel formulas and functions that transform Excel from a simple spreadsheet into a dynamic and powerful analytics data source for business intelligence. The book demonstrates the formulas and functions with examples, big datasets, and storytelling...

Excel 2022 Pro 100 + PivotTables, Charts & Reports 0

Excel 2022 Pro 100 + PivotTables, Charts & Reports

eBook Details: Paperback: 302 pages Publisher: WOW! eBook (November 4, 2022) Language: English ISBN-10: 9355512473 ISBN-13: 978-9355512475 eBook Description: Excel 2022 Pro 100 + PivotTables, Charts & Reports: Learn Everything about Excel Charts, PivotTables, Dashboards and Master Analytic Techniques for Decision Making Excel’s charts, graphs, and reports are beneficial, so it’s time to use them to your advantage. Learn how to execute the most innovative analysis on your preferred data using PivotTables, PivotCharts, What-if-Analysis, descriptive statistics, correlations, histograms, sparklines, animated charts, dashboards, trendlines, and more than 100 other charts and graphs. The book includes the following: Try and practice new Excel 2022...

MongoDB Complete Guide 0

MongoDB Complete Guide

eBook Details: Paperback: 470 pages Publisher: WOW! eBook (June 17, 2021) Language: English ISBN-10: 9389898862 ISBN-13: 978-9389898866 eBook Description: MongoDB Complete Guide: Master MongoDB: The widely used modern database in a step-by-step, practical, and easy-to-understand approach covering all major topics MongoDB Complete Guide book starts with the basics of MongoDB, what exactly is MongoDB, and how to use it practically. You will understand how MongoDB is different from the traditional RDBMS. Perform write operations, search documents, and define complex queries in MongoDB Perform indexing, aggregation, and data replication End-to-end MongoDB administration along with authentication and authorization Running backups, restoring, and monitoring of...

Learn SQL with MySQL 0

Learn SQL with MySQL

eBook Details: Paperback: 132 pages Publisher: WOW! eBook (July 17, 2020) Language: English ISBN-10: 9389898080 ISBN-13: 978-9389898088 eBook Description: Learn SQL with MySQL: A step-by-step guide that will help you manage data in a relational database using SQL with ease This book starts with the concepts in RDBMS (Relational Database Management Systems) and SQL (Structured Query Language). The first few chapters cover the definitions and a brief explanation of all the important concepts. They also cover the installation of MariaDB and MySQL on Windows and Raspberry Pi, as well as the setup of various tools used to connect to MySQL and MariaDB...

Power BI for Jobseekers 0

Power BI for Jobseekers

eBook Details: Paperback: 534 pages Publisher: WOW! eBook (April 25, 2023) Language: English ISBN-10: 9355518145 ISBN-13: 978-9355518149 eBook Description: Power BI for Jobseekers: A practical guide that will help you leverage Power BI to extract valuable and meaningful insights from your data Power BI is a powerful Business Intelligence tool developed by Microsoft that helps you connect, analyze, and visualize data from a wide range of sources. If you are looking to gain a solid understanding of Power BI, then this Power BI for Jobseekers book is for you. This book starts by covering the fundamentals of using the tool. It then...