Take a look at our COM005030 books. Shulph carries a great selection of COM005030 books, and we are always adding more.
Explore different ways and methods to consolidate data, complex analysis, and prediction or forecast based on trends Key Features Use the Analysis ToolPak to perform complex Data analysis Get well versed with the formulas, functions, and components in Excel Handy templates to give you a head start Usage of multiple examples to explain the application in a real-world scenario Implement macros for your everyday tasks that will help you save your time Explore different Charts types for Data visualization Description Book explains and simplify the usage of Excel features and functionalities, with the help of examples. It starts with ‘Getting Started with Excel’ and ‘Performing functions with shortcut keys’ which will help you in getting started with Excel. Then ‘Formulas and Functions’ gives an initial understanding of what are operators, formulas, functions, their components. Further ‘Data Visualization with new Charts types’, ‘Gantt and Milestone chart’, ‘SmartArt and Organization Chart’ give details on the different chart types available in Excel. In the intermediate section, you will learn ‘Get creative with Icons, 3D models, Digital Inking’ details multiple new and improved features that got introduced to enhance the visual presentation. In the end, Chapters ‘Mail Merge using Excel’, ‘Create Custom Excel Template’ and ‘Macros in Excel’ explain the Excel features that help in automating tasks. You will learn how to generate multiple documents automatically with customization, create and use your own templates and use of macros to do repeated task automatically. And at last Chapter ‘Get help for your problem’ lists few problem statements and their probable solutions with references to the Excel feature or functionality that can be used to resolve the problem. What will you learn Get familiar with the most used advanced Excel formulas and functions for Data analysis Learn how to create a Gantt / Timeline / Milestone Chart in Excel Use charts for Better Data visualization Build organization charts with SmartArt tools in Excel Use the Analysis ToolPak & Power Pivots to perform complex Data analysis Learn how to link and share workbooks for automatic updates Who this book is for This book is for professionals from any domain, who are searching for shortcuts & advanced methods to resolve their daily problems. Table of Contents 1. Getting Started with Excel 2. Perform Functions with Shortcut Keys 3. Formulas and Functions 4. Data Visualization with New Chart types 5. Gantt and Milestone Chart 6. SmartArt & Organization Chart 7. Get creative with Icons, 3D models, Digital Inking 8. Putting Data in perspective with Pivots 9. Complex Data Analysis using ToolPak 10. Forecasting in Excel 11. Mail Merge using Excel 12. Create Custom Excel Template 13. Macros in Excel 14. Get help for your problem About the Author Manisha Nigam is a seasoned management professional with twenty plus years of information technology experience, working with multinationals across the globe. Her expertise in Excel comes from the vast experience she has in using and understanding the software over the years, that helped her in working efficiently and managing complex programs. A certified PMP (PMI – Project Management Professional), CSM (Scrum Alliance – Scrum Master), TOGAF 9.1 (The Open Group – Enterprise Architecture) and holds a post graduate degree in computer science and business management from prestigious universities in India.
Step-by-step guide to different data movement and processing techniques, using Google Cloud Platform Services Key Features Learn the basic concept of Cloud Computing along with different Cloud service provides with their supported Models (IaaS/PaaS/SaaS) Learn the basics of Compute Engine, App Engine, Container Engine, Project and Billing setup in the Google Cloud Platform Learn how and when to use Cloud DataFlow, Cloud DataProc and Cloud DataPrep Build real-time data pipeline to support real-time analytics using Pub/Sub messaging service Setting up a fully managed GCP Big Data Cluster using Cloud DataProc for running Apache Spark and Apache Hadoop clusters in a simpler, more cost-efficient manner Learn how to use Cloud Data Studio for visualizing the data on top of Big Query Implement and understand real-world business scenarios for Machine Learning, Data Pipeline Engineering Description Modern businesses are awash with data, making data-driven decision-making tasks increasingly complex. As a result, relevant technical expertise and analytical skills are required to do such tasks. This book aims to equip you with enough knowledge of Cloud Computing in conjunction with Google Cloud Data platform to succeed in the role of a Cloud data expert. The current market is trending towards the latest cloud technologies, which is the need of the hour. Google being the pioneer, is dominating this space with the right set of cloud services being offered as part of GCP (Google Cloud Platform). At this juncture, this book will be very vital and will be cover all the services that are being offered by GCP, putting emphasis on Data services. What will you learn By the end of the book, you will have come across different data services and platforms offered by Google Cloud, and how those services/features can be enabled to serve business needs. You will also see a few case studies to put your knowledge to practice and solve business problems such as building a real-time streaming pipeline engine, Scalable Datawarehouse on Cloud, fully managed Hadoop cluster on Cloud and enabling TensorFlow/Machine Learning API’s to support real-life business problems. Remember to practice additional examples to master these techniques. Who this book is for This book is for professionals as well as graduates who want to build a career in Google Cloud data analytics technologies. One-stop shop for those who wish to get an initial to advance understanding of the GCP data platform. The target audience will be data engineers/professionals who are new, as well as those who are acquainted with the tools and techniques related to cloud and data space. -Individuals who have basic data understanding (i.e. Data and cloud) and have done some work in the field of data analytics, can refer/use this book to master their knowledge/understanding. -The highlight of this book is that it will start with the basic cloud computing fundamentals and will move on to cover the advance concepts on GCP cloud data analytics and hence can be referred across multiple different levels of audiences. Table of Contents 1. GCP Overview and Architecture 2. Data Storage in GCP 3. Data Processing in GCP with Pub/Sub and Dataflow 4. Data Processing in GCP with DataPrep and Dataflow 5. Big Query and Data Studio 6. Machine Learning with GCP 7. Sample Use cases and Examples
Analyzing business data points with greater precision, efficiency, and speed Key Features -Exposure to work on large datasets, data mining techniques, and SAS built-in functions. -Exciting examples and a step-by-step guide to the entire field of business analytics. -Additional support of sophisticated SQL queries and the creation of strong visualization reports. Description This book teaches readers how to properly use SAS (R) Studio to enhance business analytics summaries and graphical reports to make more informed business decisions. Since the examples in the book are laid out in a logical sequence, no prior knowledge is required to get started with implementing what you learn in them. The book begins with configuring your SAS® OnDemand instance, complete with sample datasets and scripts. The book explains programming syntaxes before delving into sophisticated programming principles for managing data values and concludes with creating graphical reports for business data values. It explores how to implement datasets, read external files, execute conditional statements, loops, formats, text, date, numeric functions, and arrays. The book also helps writing SQL Statements such as joins, sets, index, views, etc. with Proc SQL, Univariate (PROC MEAN, PROC FREQ), Multivariate (PROC FREQ), and Design Graphs with the help of PROC SGPLOT. After reading this book, readers will be able to evaluate business data values and create excellent visualizations that will assist enterprises in making more informed business decisions. Readers will become confident to use SAS Studio's rich interface and develop analytical programs. What you will learn -Configuring Online SAS® OnDemand for Academics. -Writing BASE SAS Programming, and writing conditional, looping-based programs. -Implementing SAS built-in text, date, numeric functions, and reading external data files. -Using the SQL Statement with PROC SQL Processing. -Plotting attractive data visualization using PROC SGPLOT. -End-to-end case study on Employee Skill Development’s Data Analytics and Visualization. Who this book is for This book is for those who wish to learn how to use SAS Studio's rich interface and develop an analytical program that helps make better decisions. Having a basic understanding of how data analytics works helps. Table of Contents 1. Introducing SAS Environment 2. Starting with SAS Programming 3. Data Mining and Storage Techniques in SAS 4. Controlling the Program Flow in SAS 5. Using SAS Built-In Functions 6. Working with Advanced Data Input Techniques 7. Getting Started with SQL Processing in SAS 8. Managing Database Tables in SAS 9. Working with Dataset in SAS 10. Data Visualization and Macro Programming with SAS 11. Case Study
A Complete Data Analytics Guide for Learners and Professionals. Key Features -Learn Big Data, Hadoop Architecture, HBase, Hive and NoSQL Database. -Dive into Machine Learning, its tools, and applications. -Coverage of applications of Big Data, Data Analysis, and Business Intelligence. Description These days critical problem solving related to data and data sciences is in demand. Professionals who can solve real data science problems using data science tools are in demand. The book “Data Analytics: Principles, Tools, and Practices” can be considered a handbook or a guide for professionals who want to start their journey in the field of data science. The journey starts with the introduction of DBMS, RDBMS, NoSQL, and DocumentDB. The book introduces the essentials of data science and the modern ecosystem, including the important steps such as data ingestion, data munging, and visualization. The book covers the different types of analysis, different Hadoop ecosystem tools like Apache Spark, Apache Hive, R, MapReduce, and NoSQL Database. It also includes the different machine learning techniques that are useful for data analytics and how to visualize data with different graphs and charts. The book discusses useful tools and approaches for data analytics, supported by concrete code examples. After reading this book, you will be motivated to explore real data analytics and make use of the acquired knowledge on databases, BI/DW, data visualization, Big Data tools, and statistical science. What you will learn -Familiarize yourself with Apache Spark, Apache Hive, R, MapReduce, and NoSQL Database. -Learn to manage data warehousing with real time transaction processing. -Explore various machine learning techniques that apply to data analytics. -Learn how to visualize data using a variety of graphs and charts using real-world examples from the industry. -Acquaint yourself with Big Data tools and statistical techniques for machine learning. Who this book is for IT graduates, data engineers and entry-level professionals who have a basic understanding of the tools and techniques but want to learn more about how they fit into a broader context are encouraged to read this book. Table of Contents 1. Database Management System 2. Online Transaction Processing and Data Warehouse 3. Business Intelligence and its deeper dynamics 4. Introduction to Data Visualization 5. Advanced Data Visualization 6. Introduction to Big Data and Hadoop 7. Application of Big Data Real Use Cases 8. Application of Big Data 9. Introduction to Machine Learning 10. Advanced Concepts to Machine Learning 11. Application of Machine Learning
Primer into the multidisciplinary world of Data Science Key Features Explore and use the key concepts of Statistics required to solve data science problems Use Docker, Jenkins, and Git for Continuous Development and Continuous Integration of your web app Learn how to build Data Science solutions with GCP and AWS Description The book will initially explain the What-Why of Data Science and the process of solving a Data Science problem. The fundamental concepts of Data Science, such as Statistics, Machine Learning, Business Intelligence, Data pipeline, and Cloud Computing, will also be discussed. All the topics will be explained with an example problem and will show how the industry approaches to solve such a problem. The book will pose questions to the learners to solve the problems and build the problem-solving aptitude and effectively learn. The book uses Mathematics wherever necessary and will show you how it is implemented using Python with the help of an example dataset. What you will learn Understand the multi-disciplinary nature of Data Science Get familiar with the key concepts in Mathematics and Statistics Explore a few key ML algorithms and their use cases Learn how to implement the basics of Data Pipelines Get an overview of Cloud Computing & DevOps Learn how to create visualizations using Tableau Who this book is for This book is ideal for Data Science enthusiasts who want to explore various aspects of Data Science. Useful for Academicians, Business owners, and Researchers for a quick reference on industrial practices in Data Science. Table of Contents 1. Data Science in Practice 2. Mathematics Essentials 3. Statistics Essentials 4. Exploratory Data Analysis 5. Data preprocessing 6. Feature Engineering 7. Machine learning algorithms 8. Productionizing ML models 9. Data Flows in Enterprises 10. Introduction to Databases 11. Introduction to Big Data 12. DevOps for Data Science 13. Introduction to Cloud Computing 14. Deploy Model to Cloud 15. Introduction to Business Intelligence 16. Data Visualization Tools 17. Industry Use Case 1 – FormAssist 18. Industry Use Case 2 – PeopleReporter 19. Data Science Learning Resources 20. Do It Your Self Challenges 21. MCQs for Assessments About the Author The book has been written by collective experience of many of Probyto past client projects, academic collaborations and team members for last 5 years. The collective work is represented by different experts in data driven decision making and portion they deal with in creating value for the clients at Probyto. The team has experienced professionals and freshers who have gained from the approach as mentioned in the book as well. Two key contributions for the book goes to Parvej Reja Saleh (Manager) and Namachivayam Dharmalingam (Senior Analyst). Blog links: https://probyto/resources/blogs LinkedIn Profile: https://www.linkedin.com/company/probyto
Leverage SharePoint Online Modern Experience to create beautiful, dynamic and mobile-ready sites and pages Description Lots of small, medium and large organizations or enterprises are using Office 365 for their business. And Microsoft is also investing heavily on Office 365 and providing lots of new features in Office 365 and other services in Office 365 like Office application or SharePoint Online, Yammer, Teams, Flow or PowerApps, etc. SharePoint is one of the popular portal technologies and web-based business collaboration and document management system. With Office 365 subscription, organizations can use SharePoint Online. Microsoft has announced the Modern features in SharePoint for a long time. Modern Experience is the future of SharePoint Online and on-premises also. This book is a comprehensive guide that lets you explore the Modern features in SharePoint Online or SharePoint Server 2019. In the book, I have covered details on Modern Team sites, communication sites, how you can customize the team sites according to your business requirement. You will also get hands-on Experience on how you can customize Modern site pages. I have also explained in detail various new features of Modern list and document libraries in SharePoint. This book also contains a few SharePoint portal examples, you will get in-depth knowledge on how to design team sites with various useful web parts. Few Organizations are still using SharePoint On-premises versions like SharePoint server 2019. I have also explained the Modern Experience in SharePoint 2019. Always it is better to know also, what are the things which are not possible in SharePoint Modern Experience, based on which you can check the impact, before moving to the SharePoint Online Modern Experience. Audience This book is for the site owners, power users or administrators who want to design attractive pages for SharePoint Modern team sites or publishing sites. Though the book is intended for SharePoint developer knowledge, but a little understanding of SharePoint is required. We have provided detailed steps with proper screenshots for references. This book is also for the developers who are trying to build pages for Modern SharePoint team sites or publishing site in SharePoint Online or SharePoint server 2019. What you will Learn In this book, you will learn what are Modern Experiences in SharePoint. How we can handle at the organizational level. What are the things which are not possible in SharePoint Online Modern Experience. Various new features of SharePoint Online Modern list and document libraries. You will also learn various web parts and how we can use those web parts while designing pages for your sites. Various examples of SharePoint Modern portal designs. How we can create and customize Modern site pages. How we can also start with SharePoint Server 2019 and use various Modern web parts in SharePoint 2019 sites. Key Features Learn how to use SharePoint Online Modern Experience (Modern UI) Create a Modern team site and communication site for your organization in SharePoint Online or SharePoint Server 2019 Effectively use Modern list and Libraries in SharePoint Online or SharePoint 2019 Learn about various Modern SharePoint web parts Create attractive and responsive portals in SharePoint Online or SharePoint 2019 Table of Contents Data Science Fundamentals Installing Software and Setting up Lists and Dictionaries Function and Packages NumPy Foundation Pandas and Dataframe Interacting with Databases Thinking Statistically in Data Science How to import data in Python? Cleaning of imported data Data Visualization Data Pre-processing Supervised Machine Learning Unsupervised Machine Learning Handling Time-Series Data Time-Series Methods Case Study – 1 Case Study – 2 Case Study – 3 Case Study – 4 About the Author Bijaya is a Microsoft MVP (Office Servers & Services) and having more than 11 years of experience in Microsoft Technologies specialized in SharePoint. He is Co-founder of TSInfo Technologies, a SharePoint consulting, training & development company in Bangalore, India. He has been a technology writer for many years and writes many SharePoint articles on his websites SharePointSky.com and EnjoySharePoint.com. Bijaya is a passionate individual who loves public speaking, blogging and training others to use Microsoft products. Before co-founding TSInfo Technologies, he was working with small and large organizations in various SharePoint On-premises as well as SharePoint Online office 365 & various related technologies. Bijaya also likes to publish SharePoint videos on his EnjoySharePoint YouTube Channel.
Learn RPA using Automation Anywhere with step-by-step practical implementation Key Features Get an overview of different stages in the Business Process Automation Learn how to use Automation Anywhere to automate business processes using commands such as Excel, Email, PDF, Database, XML, Web Services etc. Learn how to use commands together to automate process flows and standard industry use cases Learn how to develop bots in Bot Creator Learn to use Citrix AISense to capture objects in Citrix, Virtual Machine and Remote environment Description The book starts by giving an overview of Robotic Process Automation (RPA), its tools, and industry use cases. You will then get familiar with the Automation Anywhere Enterprise components and Architecture. Moving on, you will deep dive into the options provided in a Client application such as recorders, workbench, metabot designer and the types of bots in Automation Anywhere. You will then come across the practical implementation of variables in Automation. The book will then show how to implement commands such as Error Handling, XML, Web Services, FTP, OCR, PGP, String Operation, Files & Folders, etc. You will also get familiar with the working of Workflows and Workflow Manager. Towards the end, the book will teach you how to transfer bots to and from the Web Control Room and schedule bots from the Web Control Room. By the end of the book, you will be able to implement different commands provided in Automation Anywhere. What you will learn Understand the fundamentals of Business Process Automation and its stages. Use commands such as Excel, PDF, Email, Database, Object Cloning, Loops, If-Else etc. together to create a bot to automate industry use cases. Use Variables, MetaBots, IQ bots and Citrix AISense to incorporate features such as Reusability, Cognitive Automation capabilities and Object Capturing in Citrix, Virtual Machine and Remote environment. Learn how to create reusable bots using MetaBots Develop bots in Bot Creator and upload and schedule them in Web Control Room to be automatically executed on Bot Runner. Who this book is for The book is for anyone who wants to become a RPA developer. Professionals working in this field who want to upgrade themselves will find this book helpful. Table of Contents 1. Chapter 1: Automation Overview 2. Chapter 2: Introduction of RPA 3. Chapter 3: AAE Architecture 4. Chapter 4: Client Application 5. Chapter 5: Variables 6. Chapter 6: Use Cases 7. Chapter 7: Command Library 8. Chapter 8: Metabot 9. Chapter 9: Recorder 10. Chapter 10: Credential Variable 11. Chapter 11: IQ Bot 12. Chapter 12: Workflows 13. Chapter 13: System & Audit Logs 14. Chapter 14: Bot Transfer About the Authors Vaibhav Srivastava is a Software Delivery Manager with 11 years of experience in which he has implemented multiple assignments with varying roles like Architect, Business Analyst, Solution Consultant and Instructor for various technologies like RPA, Data Science, Machine Learning and .NET. Some of the organizations Vaibhav has been associated with are ContactPoint360, IBM, HPE, KPMG, Novartis, Unisys, TCL, HCL Technologies, Ryan India, NSEIT, to name a few. In 2017, Vaibhav moved into RPA and started his journey with Automation Anywhere. The journey has been a cherished one and has taken him on multiple unexplored areas. After Automation Anywhere, Vaibhav also developed expertise in UiPath, another market-leading RPA tool and later upgraded tech stack with gaining knowledge about Machine Learning, Data Science and Artificial Intelligence. Outside work, Vaibhav volunteers his spare time in helping, coaching, and mentoring young people in taking up careers in technology. LinkedIn Profile: https://www.linkedin.com/in/vaibhav-srivastava-44227113/
Guidance for successful installation of a wide range of IBM software products Key Features -Complete installation guide of IBM software systems, Redhat Enterprise, IBM Cloud, and Docker. -Expert-led demonstration on complete configuration and implementation of IBM software solutions. -Includes best practices and efficient techniques adopted by banks, financial services, and insurance companies. Description This book provides instructions for installation, configuration and troubleshooting sections to improve the IT support productivity and fast resolution of issues that arise. It covers readers' references that are available online and also step-by-step procedures required for a successful installation of a broad range of IBM Data Analytics products. This book provides a holistic in-depth knowledge for students, software architects, installation specialists, and developers of Data Analysis software and a handbook for data analysts who want a single source of information on IBM Data Analysis Software products. This book provides a single resource that covers the latest available IBM Data Analysis software on the most recent RedHat Linux and IBM Cloud platforms. This book includes comprehensive technical guidance, enabling IT professionals to gain an in-depth knowledge of the installation of a broad range of IBM Software products across different operating systems. What you will learn -Step-by-step installation and configuration of IBM Watson Analytics. -Managing RedHat Enterprise Systems and IBM Cloud Platforms. -Installing, configuring, and managing IBM StoredIQ. -Best practices to administer and maintain IBM software packages. -Upgrading VMware stations and installing Docker. Who this book is for This book is a go-to guide for IT professionals who are primarily Solution Architects, Implementation Experts, or Technology Consultants of IBM Software suites. This will also be a useful guide for IT managers who are looking to adopt and enable their enterprise with IBM products. Table of Contents 1. Getting Started with IBM Resources for Analytics 2. IBM Component Software Compatibility Matrix 3. IBM Download Procedures 4. On-Premise Server Configurations and Prerequisites 5. IBM Fix Packs 6. IBM Cloud PAK Systems 7. RedHat OpenShift 4.x Installations 8. IBM Cloud Private System 9. Base VMWare System Platform 10. IBM Cloud Private Cluster on CentOS 8.0 11. UIMA Pipeline and Java Code Extensions 12. IBM Watson Explorer Foundational Components V12 13. IBM Watson Explorer oneWEX 12.0.3 14. IBM StoredIQ for Legal       APPENDIX References and End of Life Support About the Authors Alan Bluck, has over 45 years of IT experience. He has been a Solutions Architect for IBM for over 10 years. He is now the Director and owner of ASB Software Development Limited, an IBM PartnerWorld partner and a consultancy providing systems architecture for a broad range of services. He is a member of the British Computer Society (MBCS, CITP).