Advanced Excel Essentials
Advanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer—this is the book you've been waiting for! Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. ...
Advanced Excel Essentials is the only book for experienced Excel developers who want to channel their skills into building spreadsheet applications and dashboards. This book starts from the assumption that you are well-versed in Excel and builds on your skills to take them to an advanced level. It provides the building blocks of advanced development and then takes you through the development of your own advanced spreadsheet application. For the seasoned analyst, accountant, financial professional, management consultant, or engineer—this is the book you've been waiting for! Author Jordan Goldmeier builds on a foundation of industry best practices, bringing his own forward-thinking approach to Excel and rich real-world experience, to distill a unique blend of advanced essentials. ...
Building Dynamics CRM 2015 Dashboards with Power BI
Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales analytics, Power BI when connected to Dynamics CRM offers a self-service approach to build, shape, and present data through an easy-to-use interface. The set of features within Power BI will give all users a tool to generate real-time sales productivity reports and dashboards to enhance their sales performance. This book will provide you with the skills you need to learn how to build and present Dynamics CRM 2015 sales dashboards using Power BI. It follows a step-by-step process to build an interactive dashboard by organizing and consolidating datasets, improving the look and feel of graphs, charts, and maps, and enhancing data clarity with filters an ...
Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales analytics, Power BI when connected to Dynamics CRM offers a self-service approach to build, shape, and present data through an easy-to-use interface. The set of features within Power BI will give all users a tool to generate real-time sales productivity reports and dashboards to enhance their sales performance. This book will provide you with the skills you need to learn how to build and present Dynamics CRM 2015 sales dashboards using Power BI. It follows a step-by-step process to build an interactive dashboard by organizing and consolidating datasets, improving the look and feel of graphs, charts, and maps, and enhancing data clarity with filters an ...
Ansible Playbook Essentials
Ansible combines configuration management, orchestration, and parallel command execution into a single tool. Its batteries-included approach and built-in module library makes it easy to integrate it with cloud platforms, databases, and notification services without requiring additional plugins. Playbooks in Ansible define the policies your systems under management enforce. They facilitate effective configuration management rather than running ad hoc scripts to deploy complex applications. This book will show you how to write a blueprint of your infrastructure encompassing multi-tier applications using Ansible's playbooks. Beginning with the basic concepts such as plays, tasks, handlers, inventory, and the YAML syntax that Ansible uses, you will see how to organize your code into a modular structure. Building on this, you will master techniques to create data-driven playbooks with variables, templates, logical constructs, and encrypted data. This book will also take you through advan ...
Ansible combines configuration management, orchestration, and parallel command execution into a single tool. Its batteries-included approach and built-in module library makes it easy to integrate it with cloud platforms, databases, and notification services without requiring additional plugins. Playbooks in Ansible define the policies your systems under management enforce. They facilitate effective configuration management rather than running ad hoc scripts to deploy complex applications. This book will show you how to write a blueprint of your infrastructure encompassing multi-tier applications using Ansible's playbooks. Beginning with the basic concepts such as plays, tasks, handlers, inventory, and the YAML syntax that Ansible uses, you will see how to organize your code into a modular structure. Building on this, you will master techniques to create data-driven playbooks with variables, templates, logical constructs, and encrypted data. This book will also take you through advan ...
HTML5 For Dummies
HTML is the predominant programming language used to create Web pages. HTML5 has enhanced rich media, geolocation, database and mobile capabilities, and is now able to script APIs, making it a must-have for Web developers. This convenient reference, comb-bound to lie flat, makes it easy to find the information you need in a hurry so you can get those terrific Web pages designed and online right now. ...
HTML is the predominant programming language used to create Web pages. HTML5 has enhanced rich media, geolocation, database and mobile capabilities, and is now able to script APIs, making it a must-have for Web developers. This convenient reference, comb-bound to lie flat, makes it easy to find the information you need in a hurry so you can get those terrific Web pages designed and online right now. ...
Agile Web Development with Rails, 3rd Edition
Rails just keeps on changing. Rails 3 and Ruby 1.9 bring hundreds of improvements, including new APIs and substantial performance enhancements. The fourth edition of this award-winning classic has been reorganized and refocused so it's more useful than ever before for developers new to Ruby and Rails. ...
Rails just keeps on changing. Rails 3 and Ruby 1.9 bring hundreds of improvements, including new APIs and substantial performance enhancements. The fourth edition of this award-winning classic has been reorganized and refocused so it's more useful than ever before for developers new to Ruby and Rails. ...
Redis Essentials
Redis is the most popular in-memory key-value data store. It's very lightweight and its data types give it an edge over the other competitors. If you need an in-memory database or a high-performance cache system that is simple to use and highly scalable, Redis is what you need. Redis Essentials is a fast-paced guide that teaches the fundamentals on data types, explains how to manage data through commands, and shares experiences from big players in the industry. We start off by explaining the basics of Redis followed by the various data types such as Strings, hashes, lists, and more. Next, Common pitfalls for various scenarios are described, followed by solutions to ensure you do not fall into common traps. After this, major differences between client implementations in PHP, Python, and Ruby are presented. Next, you will learn how to extend Redis with Lua, get to know security techniques such as basic authorization, firewall rules, and SSL encryption, and discover how to use Tw ...
Redis is the most popular in-memory key-value data store. It's very lightweight and its data types give it an edge over the other competitors. If you need an in-memory database or a high-performance cache system that is simple to use and highly scalable, Redis is what you need. Redis Essentials is a fast-paced guide that teaches the fundamentals on data types, explains how to manage data through commands, and shares experiences from big players in the industry. We start off by explaining the basics of Redis followed by the various data types such as Strings, hashes, lists, and more. Next, Common pitfalls for various scenarios are described, followed by solutions to ensure you do not fall into common traps. After this, major differences between client implementations in PHP, Python, and Ruby are presented. Next, you will learn how to extend Redis with Lua, get to know security techniques such as basic authorization, firewall rules, and SSL encryption, and discover how to use Tw ...
Beginning NetBeans IDE
Beginning NetBeans IDE is your authoritative guide for getting started learning and using the free and open source NetBeans IDE. Written by Geertjan Wielenga, who has worked on the NetBeans Team since 2004, it shows you what the IDE is all about and how to use it with real-world case studies built from the ground up as you learn all about the IDE. In this book, you get a tour of the various, essential, and key NetBeans features, including a range of wizards and plug-ins. Then, you start building a more complex Java EE-based application using Maven with the NetBeans IDE. And, you learn how to improve that application by exploring the NetBeans refactoring, testing, debugging, and profiling tools. After reading and using this guide, you'll come away with a working case study and many insights into how to understand and optimally make use of NetBeans IDE. ...
Beginning NetBeans IDE is your authoritative guide for getting started learning and using the free and open source NetBeans IDE. Written by Geertjan Wielenga, who has worked on the NetBeans Team since 2004, it shows you what the IDE is all about and how to use it with real-world case studies built from the ground up as you learn all about the IDE. In this book, you get a tour of the various, essential, and key NetBeans features, including a range of wizards and plug-ins. Then, you start building a more complex Java EE-based application using Maven with the NetBeans IDE. And, you learn how to improve that application by exploring the NetBeans refactoring, testing, debugging, and profiling tools. After reading and using this guide, you'll come away with a working case study and many insights into how to understand and optimally make use of NetBeans IDE. ...
Advanced Java EE Development with WildFly
This book starts with an introduction to EJB 3 and how to set up the environment, including the configuration of a MySQL database for use with WildFly. We will then develop object-relational mapping with Hibernate 4, build and package the application with Maven, and then deploy it in WildFly 8.1, followed by a demonstration of the use of Facelets in a web application. Moving on from that, we will create an Ajax application in the Eclipse IDE, compile and package it using Maven, and run the web application on WildFly 8.1 with a MySQL database. In the final leg of this book, we will discuss support for generating and parsing JSON with WildFly 8.1. ...
This book starts with an introduction to EJB 3 and how to set up the environment, including the configuration of a MySQL database for use with WildFly. We will then develop object-relational mapping with Hibernate 4, build and package the application with Maven, and then deploy it in WildFly 8.1, followed by a demonstration of the use of Facelets in a web application. Moving on from that, we will create an Ajax application in the Eclipse IDE, compile and package it using Maven, and run the web application on WildFly 8.1 with a MySQL database. In the final leg of this book, we will discuss support for generating and parsing JSON with WildFly 8.1. ...
Windows Azure Step by Step
Your hands-on, step-by-step guide to the programming fundamentals for Windows Azure. Teach yourself how to build and host scalable applications in the cloud using Windows Azure - one step at a time. Ideal for those with basic programming skills, this tutorial provides practical, learn-by-doing exercises for working with the core services and features of the Windows Azure platform. ...
Your hands-on, step-by-step guide to the programming fundamentals for Windows Azure. Teach yourself how to build and host scalable applications in the cloud using Windows Azure - one step at a time. Ideal for those with basic programming skills, this tutorial provides practical, learn-by-doing exercises for working with the core services and features of the Windows Azure platform. ...
Learning ELK Stack
The ELK stack - Elasticsearch, Logstash, and Kibana, is a powerful combination of open source tools. Elasticsearch is for deep search and data analytics. Logstash is for centralized logging, log enrichment, and parsing. Kibana is for powerful and beautiful data visualizations. In short, the Elasticsearch ELK stack makes searching and analyzing data easier than ever before. This book will introduce you to the ELK (Elasticsearch, Logstash, and Kibana) stack, starting by showing you how to set up the stack by installing the tools, and basic configuration. You'll move on to building a basic data pipeline using the ELK stack. Next, you'll explore the key features of Logstash and its role in the ELK stack, including creating Logstash plugins, which will enable you to use your own customized plugins. The importance of Elasticsearch and Kibana in the ELK stack is also covered, along with various types of advanced data analysis, and a variety of charts, tables ,and maps. Finally, by th ...
The ELK stack - Elasticsearch, Logstash, and Kibana, is a powerful combination of open source tools. Elasticsearch is for deep search and data analytics. Logstash is for centralized logging, log enrichment, and parsing. Kibana is for powerful and beautiful data visualizations. In short, the Elasticsearch ELK stack makes searching and analyzing data easier than ever before. This book will introduce you to the ELK (Elasticsearch, Logstash, and Kibana) stack, starting by showing you how to set up the stack by installing the tools, and basic configuration. You'll move on to building a basic data pipeline using the ELK stack. Next, you'll explore the key features of Logstash and its role in the ELK stack, including creating Logstash plugins, which will enable you to use your own customized plugins. The importance of Elasticsearch and Kibana in the ELK stack is also covered, along with various types of advanced data analysis, and a variety of charts, tables ,and maps. Finally, by th ...