About the author:
Rob Frye served in the NC Army National Guard for nearly two decades and is a combat veteran of Operation Iraqi Freedom. After retiring from military service, he completed his Bachelor's degree in Computer Science at Lenoir-Rhyne University, where he was the first honor graduate with a 4.0 overall GPA. Currently, Rob is the manager of ComeritLabs, in Huntersville, NC. ComeritLabs provides infrastructure, remote development, and training services for COMERIT, Inc. Rob is an experienced SAP BusinessObjects and SAP HANA developer and has delivered training on SAP HANA and the BusinessObjects toolset in the United States, Canada, Mexico, and South Africa.
Joe Darlak, Senior Director of SAP Analytics at COMERIT Inc., has successfully implemented SAP BW at clients since 1998, including several large-scale, full lifecycle global rollouts. He has significant experience increasing the capacity, reliability, and performance of SAP BI systems, defining and implementing processes and controls to stabilize service and mitigate risk, and improving the competency and skill sets of implementation and client service teams. Recently, he architected one of the largest SAP NetWeaver BW migrations to SAP HANA on record and has been instrumental in defining best practices for SAP HANA at Fortune 100 clients. He is the lead author of SAP BW: Administration and Performance Optimization, published in 2014. Over the past decade, he presented at multiple conferences on various SAP BW performance tuning topics. He is a former principal consultant in the iAnalytics practice at PricewaterhouseCoopers and holds a Master of Business Administration degree from the McCombs School of Business at The University of Texas at Austin.
Dr. Bjarne Berg is the senior director of BI at COMERIT, Inc., and one of the most respected and dedicated thought leaders in the BI market. Prior to joining COMERIT, he was a senior manager at PwC's global data warehouse group, the director of BI at VIP Consulting, and the VP of BI at COMERIT. In these positions, he managed multi-year BI and data warehouse projects for various clients . He is an internationally recognized expert in BI and analytics, a published author in international BI journals, and a frequent speaker at major BI and SAP conferences worldwide.
Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
Many data science resources incorporate statistical methods but lack a deeper statistical perspective. If you’re familiar with the R programming language, and have some exposure to statistics, this quick reference bridges the gap in an accessible, readable format.
With this book, you’ll learn:Why exploratory data analysis is a key preliminary step in data scienceHow random sampling can reduce bias and yield a higher quality dataset, even with big dataHow the principles of experimental design yield definitive answers to questionsHow to use regression to estimate outcomes and detect anomaliesKey classification techniques for predicting which categories a record belongs toStatistical machine learning methods that “learn” from dataUnsupervised learning methods for extracting meaning from unlabeled data
The first edition of Ralph Kimball's The Data WarehouseToolkit introduced the industry to dimensional modeling,and now his books are considered the most authoritative guides inthis space. This new third edition is a complete library of updateddimensional modeling techniques, the most comprehensive collectionever. It covers new and enhanced star schema dimensional modelingpatterns, adds two new chapters on ETL techniques, includes new andexpanded business matrices for 12 case studies, and more.Authored by Ralph Kimball and Margy Ross, known worldwide aseducators, consultants, and influential thought leaders in datawarehousing and business intelligenceBegins with fundamental design recommendations and progressesthrough increasingly complex scenariosPresents unique modeling techniques for business applicationssuch as inventory management, procurement, invoicing, accounting,customer relationship management, big data analytics, and moreDraws real-world case studies from a variety of industries,including retail sales, financial services, telecommunications,education, health care, insurance, e-commerce, and more
Design dimensional databases that are easy to understand andprovide fast query response with The Data WarehouseToolkit: The Definitive Guide to Dimensional Modeling, 3rdEdition.
Focus on the expertise measured by these objectives:
• Design, and implement, and maintain a data warehouse
• Extract, transform, and load data
• Build data quality solutionsThis Microsoft Exam Ref:
• Organizes its coverage by exam objectives
• Features strategic, what-if scenarios to challenge you
• Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse.
Implementing a SQL Data Warehouse
About the Exam
Exam 70-767 focuses on skills and knowledge required for working with relational database technology.
About Microsoft Certification
Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management
Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification.
See full details at: microsoft.com/learning