Author: Scott F. Wilson
Publisher:
ISBN: 9780735608542
Category : Application software
Languages : en
Pages : 0
Book Description
This Microsoft Official curriculum training kit delivers comprehensive preparation for MCP Exam 70-100--a core exam on the Microsoft Certified Solution Developer (MCSD) track and the only exam every MCSD candidate must pass. The CD-ROM contains hands-on lab exercises, demos, and complete model application for a complete learning solution.
Analyzing Requirements and Defining Solution Architectures
Author: Scott F. Wilson
Publisher:
ISBN: 9780735608542
Category : Application software
Languages : en
Pages : 0
Book Description
This Microsoft Official curriculum training kit delivers comprehensive preparation for MCP Exam 70-100--a core exam on the Microsoft Certified Solution Developer (MCSD) track and the only exam every MCSD candidate must pass. The CD-ROM contains hands-on lab exercises, demos, and complete model application for a complete learning solution.
Publisher:
ISBN: 9780735608542
Category : Application software
Languages : en
Pages : 0
Book Description
This Microsoft Official curriculum training kit delivers comprehensive preparation for MCP Exam 70-100--a core exam on the Microsoft Certified Solution Developer (MCSD) track and the only exam every MCSD candidate must pass. The CD-ROM contains hands-on lab exercises, demos, and complete model application for a complete learning solution.
Introducing Microsoft Power BI
Author: Alberto Ferrari
Publisher: Microsoft Press
ISBN: 1509302751
Category : Computers
Languages : en
Pages : 453
Book Description
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment. Be sure to watch for the publication of Alberto Ferrari and Marco Russo's upcoming retail book, Analyzing Data with Power BI and Power Pivot for Excel (ISBN 9781509302765). Go to the book's page at the Microsoft Press Store here for more details:http://aka.ms/analyzingdata/details. Learn more about Power BI at https://powerbi.microsoft.com/.
Publisher: Microsoft Press
ISBN: 1509302751
Category : Computers
Languages : en
Pages : 453
Book Description
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment. Be sure to watch for the publication of Alberto Ferrari and Marco Russo's upcoming retail book, Analyzing Data with Power BI and Power Pivot for Excel (ISBN 9781509302765). Go to the book's page at the Microsoft Press Store here for more details:http://aka.ms/analyzingdata/details. Learn more about Power BI at https://powerbi.microsoft.com/.
Practitioner’s Guide to Data Science
Author: Nasir Ali Mirza
Publisher: BPB Publications
ISBN: 9391392873
Category : Computers
Languages : en
Pages : 273
Book Description
Covers Data Science concepts, processes, and the real-world hands-on use cases. KEY FEATURES ● Covers the journey from a basic programmer to an effective Data Science developer. ● Applied use of Data Science native processes like CRISP-DM and Microsoft TDSP. ● Implementation of MLOps using Microsoft Azure DevOps. DESCRIPTION "How is the Data Science project to be implemented?" has never been more conceptually sounding, thanks to the work presented in this book. This book provides an in-depth look at the current state of the world's data and how Data Science plays a pivotal role in everything we do. This book explains and implements the entire Data Science lifecycle using well-known data science processes like CRISP-DM and Microsoft TDSP. The book explains the significance of these processes in connection with the high failure rate of Data Science projects. The book helps build a solid foundation in Data Science concepts and related frameworks. It teaches how to implement real-world use cases using data from the HMDA dataset. It explains Azure ML Service architecture, its capabilities, and implementation to the DS team, who will then be prepared to implement MLOps. The book also explains how to use Azure DevOps to make the process repeatable while we're at it. By the end of this book, you will learn strong Python coding skills, gain a firm grasp of concepts such as feature engineering, create insightful visualizations and become acquainted with techniques for building machine learning models. WHAT YOU WILL LEARN ● Organize Data Science projects using CRISP-DM and Microsoft TDSP. ● Learn to acquire and explore data using Python visualizations. ● Get well versed with the implementation of data pre-processing and Feature Engineering. ● Understand algorithm selection, model development, and model evaluation. ● Hands-on with Azure ML Service, its architecture, and capabilities. ● Learn to use Azure ML SDK and MLOps for implementing real-world use cases. WHO THIS BOOK IS FOR This book is intended for programmers who wish to pursue AI/ML development and build a solid conceptual foundation and familiarity with related processes and frameworks. Additionally, this book is an excellent resource for Software Architects and Managers involved in the design and delivery of Data Science-based solutions. TABLE OF CONTENTS 1. Data Science for Business 2. Data Science Project Methodologies and Team Processes 3. Business Understanding and Its Data Landscape 4. Acquire, Explore, and Analyze Data 5. Pre-processing and Preparing Data 6. Developing a Machine Learning Model 7. Lap Around Azure ML Service 8. Deploying and Managing Models
Publisher: BPB Publications
ISBN: 9391392873
Category : Computers
Languages : en
Pages : 273
Book Description
Covers Data Science concepts, processes, and the real-world hands-on use cases. KEY FEATURES ● Covers the journey from a basic programmer to an effective Data Science developer. ● Applied use of Data Science native processes like CRISP-DM and Microsoft TDSP. ● Implementation of MLOps using Microsoft Azure DevOps. DESCRIPTION "How is the Data Science project to be implemented?" has never been more conceptually sounding, thanks to the work presented in this book. This book provides an in-depth look at the current state of the world's data and how Data Science plays a pivotal role in everything we do. This book explains and implements the entire Data Science lifecycle using well-known data science processes like CRISP-DM and Microsoft TDSP. The book explains the significance of these processes in connection with the high failure rate of Data Science projects. The book helps build a solid foundation in Data Science concepts and related frameworks. It teaches how to implement real-world use cases using data from the HMDA dataset. It explains Azure ML Service architecture, its capabilities, and implementation to the DS team, who will then be prepared to implement MLOps. The book also explains how to use Azure DevOps to make the process repeatable while we're at it. By the end of this book, you will learn strong Python coding skills, gain a firm grasp of concepts such as feature engineering, create insightful visualizations and become acquainted with techniques for building machine learning models. WHAT YOU WILL LEARN ● Organize Data Science projects using CRISP-DM and Microsoft TDSP. ● Learn to acquire and explore data using Python visualizations. ● Get well versed with the implementation of data pre-processing and Feature Engineering. ● Understand algorithm selection, model development, and model evaluation. ● Hands-on with Azure ML Service, its architecture, and capabilities. ● Learn to use Azure ML SDK and MLOps for implementing real-world use cases. WHO THIS BOOK IS FOR This book is intended for programmers who wish to pursue AI/ML development and build a solid conceptual foundation and familiarity with related processes and frameworks. Additionally, this book is an excellent resource for Software Architects and Managers involved in the design and delivery of Data Science-based solutions. TABLE OF CONTENTS 1. Data Science for Business 2. Data Science Project Methodologies and Team Processes 3. Business Understanding and Its Data Landscape 4. Acquire, Explore, and Analyze Data 5. Pre-processing and Preparing Data 6. Developing a Machine Learning Model 7. Lap Around Azure ML Service 8. Deploying and Managing Models
AWS Certified Developer - Associate (DVA-C01) Cert Guide
Author: Marko Sluga
Publisher: Pearson IT Certification
ISBN: 0135783585
Category : Computers
Languages : en
Pages : 644
Book Description
This is the eBook version of the print title. Note that the eBook does not provide access to the practice test software that accompanies the print book. Access to the personal video mentoring is available through product registration at Pearson IT Certification; or see instructions in back pages of your eBook. Learn, prepare, and practice for AWS Certified Developer — Associate (DVA-C01) exam success with this Cert Guide from Pearson IT Certification, a leader in IT Certification learning. Explore the AWS Certified Developer - Associate (DVA-C01) exam topics as defined in the latest official exam objectives from Amazon Pre-test your knowledge before each chapter with core concept quizzes Assess your knowledge and retention with chapter-ending quizzes Review key concepts with exam preparation tasks Practice with realistic exam questions covering the entire body of exam objectives Learn from more than one hour of video mentoring AWS Certified Developer — Associate (DVA-C01) Cert Guide is a best-of-breed exam study guide. Best-selling author and expert instructor Marko Sluga shares preparation hints and test-taking tips, helping you identify areas of weakness and improve both your conceptual knowledge and hands-on skills. Material is presented in a concise manner, focusing on increasing your understanding and retention of exam topics. The book presents you with an organized test preparation routine through the use of proven series elements and techniques. Exam topic lists make referencing easy. Chapter-ending Exam Preparation Tasks help you drill on key concepts you must know thoroughly. End-of-chapter quizzes help you assess your knowledge, and a final preparation chapter guides you through tools and resources to help you craft your final study plan. Well regarded for its level of detail, assessment features, and challenging quizzes, this study guide helps you master the concepts and techniques that will enable you to succeed on the exam the first time, including Deployment: CLI, SDKs, CI/CD pipelines, CloudFormation, Elastic Beanstalk, deployment/provisioning processes and patterns, serverless design, and more Security: Authentication via AWS CLI and SDKs; IAM users, groups, roles, and policies; IAM federation with external directories and identity providers; security groups and NACLS Development with AWS services: Implementing designs in code; interacting with infrastructure via AWS CLI, SDKs, and APIs; DevOps approaches and Code tools Refactoring: AWS data transfer, transport, and transform tools; managed AWS services for refactoring new or migrated applications Monitoring and troubleshooting: CloudWatch data capture and analysis; application problem solving, scaling, and optimization; CloudTrail tracing and auditing; and more
Publisher: Pearson IT Certification
ISBN: 0135783585
Category : Computers
Languages : en
Pages : 644
Book Description
This is the eBook version of the print title. Note that the eBook does not provide access to the practice test software that accompanies the print book. Access to the personal video mentoring is available through product registration at Pearson IT Certification; or see instructions in back pages of your eBook. Learn, prepare, and practice for AWS Certified Developer — Associate (DVA-C01) exam success with this Cert Guide from Pearson IT Certification, a leader in IT Certification learning. Explore the AWS Certified Developer - Associate (DVA-C01) exam topics as defined in the latest official exam objectives from Amazon Pre-test your knowledge before each chapter with core concept quizzes Assess your knowledge and retention with chapter-ending quizzes Review key concepts with exam preparation tasks Practice with realistic exam questions covering the entire body of exam objectives Learn from more than one hour of video mentoring AWS Certified Developer — Associate (DVA-C01) Cert Guide is a best-of-breed exam study guide. Best-selling author and expert instructor Marko Sluga shares preparation hints and test-taking tips, helping you identify areas of weakness and improve both your conceptual knowledge and hands-on skills. Material is presented in a concise manner, focusing on increasing your understanding and retention of exam topics. The book presents you with an organized test preparation routine through the use of proven series elements and techniques. Exam topic lists make referencing easy. Chapter-ending Exam Preparation Tasks help you drill on key concepts you must know thoroughly. End-of-chapter quizzes help you assess your knowledge, and a final preparation chapter guides you through tools and resources to help you craft your final study plan. Well regarded for its level of detail, assessment features, and challenging quizzes, this study guide helps you master the concepts and techniques that will enable you to succeed on the exam the first time, including Deployment: CLI, SDKs, CI/CD pipelines, CloudFormation, Elastic Beanstalk, deployment/provisioning processes and patterns, serverless design, and more Security: Authentication via AWS CLI and SDKs; IAM users, groups, roles, and policies; IAM federation with external directories and identity providers; security groups and NACLS Development with AWS services: Implementing designs in code; interacting with infrastructure via AWS CLI, SDKs, and APIs; DevOps approaches and Code tools Refactoring: AWS data transfer, transport, and transform tools; managed AWS services for refactoring new or migrated applications Monitoring and troubleshooting: CloudWatch data capture and analysis; application problem solving, scaling, and optimization; CloudTrail tracing and auditing; and more
Microsoft Certification
Author: David Mayer
Publisher:
ISBN:
Category :
Languages : en
Pages : 810
Book Description
A comprehensive and practical Guide designed to help you pass the Microsoft Exams! Do you want to increase your productivity through Microsoft exams? Do you want to advance your I.T career through Microsoft exams? If you answered "yes" to any of these, then this is the perfect, educational and informational book for you! Hello! Welcome to "ALL IN ONE Microsoft Certification." Microsoft, a leader in the IT industry, has established several certification programs for experts working in the business. The programs allow you to adopt which certification is suitable and best suitable for your profession. There are over 2 million IT experts with Microsoft certification. You can join their positions and greatly improve your professional career with Microsoft Certification. It's significant to note that Microsoft has rationalized their programs to be very targeted. This practical guide takes you through each of the topics that you will need to master to pass the Microsoft exams This book teaches all of the requirements for each exam, one by one. Each of the things that Microsoft tests will be covered in this book. Having Microsoft certifications on your resume will only help you get in front of more hiring managers, and land more jobs. This book includes new exercises and sample questions never before in print. Offering numerous sample questions, critical time-saving tips, plus information available nowhere else. Here's what makes this book special: Become Master in Microsoft Exams Prepare for Microsoft Certification for SQL server, Office, Azure, Data etc. Detailed explanation of answers 100% verified answers and explanations to each question By the end of this book you will be prepared to take the Microsoft Exams Build the skills and confidence to crush the Microsoft exam By the end of this book, you will be well versed in all the topics required to pass Microsoft certification exams Much, much more! Interested?Then Scroll up, Click on "Buy now with 1-Click", and Get Your Copy Now! Also you will get a 50% discount on the simulator!To get a discount for the simulator, you have to send an email to the mentioned email address in eBook. In your email, please write "I have purchased eBook on Amazon"
Publisher:
ISBN:
Category :
Languages : en
Pages : 810
Book Description
A comprehensive and practical Guide designed to help you pass the Microsoft Exams! Do you want to increase your productivity through Microsoft exams? Do you want to advance your I.T career through Microsoft exams? If you answered "yes" to any of these, then this is the perfect, educational and informational book for you! Hello! Welcome to "ALL IN ONE Microsoft Certification." Microsoft, a leader in the IT industry, has established several certification programs for experts working in the business. The programs allow you to adopt which certification is suitable and best suitable for your profession. There are over 2 million IT experts with Microsoft certification. You can join their positions and greatly improve your professional career with Microsoft Certification. It's significant to note that Microsoft has rationalized their programs to be very targeted. This practical guide takes you through each of the topics that you will need to master to pass the Microsoft exams This book teaches all of the requirements for each exam, one by one. Each of the things that Microsoft tests will be covered in this book. Having Microsoft certifications on your resume will only help you get in front of more hiring managers, and land more jobs. This book includes new exercises and sample questions never before in print. Offering numerous sample questions, critical time-saving tips, plus information available nowhere else. Here's what makes this book special: Become Master in Microsoft Exams Prepare for Microsoft Certification for SQL server, Office, Azure, Data etc. Detailed explanation of answers 100% verified answers and explanations to each question By the end of this book you will be prepared to take the Microsoft Exams Build the skills and confidence to crush the Microsoft exam By the end of this book, you will be well versed in all the topics required to pass Microsoft certification exams Much, much more! Interested?Then Scroll up, Click on "Buy now with 1-Click", and Get Your Copy Now! Also you will get a 50% discount on the simulator!To get a discount for the simulator, you have to send an email to the mentioned email address in eBook. In your email, please write "I have purchased eBook on Amazon"
Microsoft Azure Essentials - Fundamentals of Azure
Author: Michael Collier
Publisher: Microsoft Press
ISBN: 0735697302
Category : Computers
Languages : en
Pages : 400
Book Description
Microsoft Azure Essentials from Microsoft Press is a series of free ebooks designed to help you advance your technical skills with Microsoft Azure. The first ebook in the series, Microsoft Azure Essentials: Fundamentals of Azure, introduces developers and IT professionals to the wide range of capabilities in Azure. The authors - both Microsoft MVPs in Azure - present both conceptual and how-to content for key areas, including: Azure Websites and Azure Cloud Services Azure Virtual Machines Azure Storage Azure Virtual Networks Databases Azure Active Directory Management tools Business scenarios Watch Microsoft Press’s blog and Twitter (@MicrosoftPress) to learn about other free ebooks in the “Microsoft Azure Essentials” series.
Publisher: Microsoft Press
ISBN: 0735697302
Category : Computers
Languages : en
Pages : 400
Book Description
Microsoft Azure Essentials from Microsoft Press is a series of free ebooks designed to help you advance your technical skills with Microsoft Azure. The first ebook in the series, Microsoft Azure Essentials: Fundamentals of Azure, introduces developers and IT professionals to the wide range of capabilities in Azure. The authors - both Microsoft MVPs in Azure - present both conceptual and how-to content for key areas, including: Azure Websites and Azure Cloud Services Azure Virtual Machines Azure Storage Azure Virtual Networks Databases Azure Active Directory Management tools Business scenarios Watch Microsoft Press’s blog and Twitter (@MicrosoftPress) to learn about other free ebooks in the “Microsoft Azure Essentials” series.
Microsoft Manual of Style
Author: Microsoft Corporation
Publisher: Pearson Education
ISBN: 0735669791
Category : Computers
Languages : en
Pages : 823
Book Description
Maximize the impact and precision of your message! Now in its fourth edition, the Microsoft Manual of Style provides essential guidance to content creators, journalists, technical writers, editors, and everyone else who writes about computer technology. Direct from the Editorial Style Board at Microsoft—you get a comprehensive glossary of both general technology terms and those specific to Microsoft; clear, concise usage and style guidelines with helpful examples and alternatives; guidance on grammar, tone, and voice; and best practices for writing content for the web, optimizing for accessibility, and communicating to a worldwide audience. Fully updated and optimized for ease of use, the Microsoft Manual of Style is designed to help you communicate clearly, consistently, and accurately about technical topics—across a range of audiences and media.
Publisher: Pearson Education
ISBN: 0735669791
Category : Computers
Languages : en
Pages : 823
Book Description
Maximize the impact and precision of your message! Now in its fourth edition, the Microsoft Manual of Style provides essential guidance to content creators, journalists, technical writers, editors, and everyone else who writes about computer technology. Direct from the Editorial Style Board at Microsoft—you get a comprehensive glossary of both general technology terms and those specific to Microsoft; clear, concise usage and style guidelines with helpful examples and alternatives; guidance on grammar, tone, and voice; and best practices for writing content for the web, optimizing for accessibility, and communicating to a worldwide audience. Fully updated and optimized for ease of use, the Microsoft Manual of Style is designed to help you communicate clearly, consistently, and accurately about technical topics—across a range of audiences and media.
Mastering Microsoft Dynamics 365 Business Central
Author: Stefano Demiliani
Publisher: Packt Publishing Ltd
ISBN: 1789952654
Category : Computers
Languages : en
Pages : 753
Book Description
Develop customized business management solutions with the latest features of Microsoft Dynamics 365 Business Central Key FeaturesLearn Dynamics 365 Business Central, the next generation of Dynamics NAVExplore advanced topics for handling complex integrations such as using APIs, OData, and Azure FunctionsDiscover best practices for developing SaaS extensions and moving existing solutions to the cloudBook Description Dynamics 365 Business Central is an all-in-one business management solution, which is easy to adopt and helps you make smarter business decisions. This book is a comprehensive guide to developing solutions with Microsoft ERP (in the cloud and also on-premises). It covers all aspects of developing extensions, right from preparing a sandbox environment to deploying a complete solution. The book starts by introducing you to the Dynamics 365 Business Central platform and the new Modern Development Environment. You'll then explore the sandbox concept, and see how to create sandboxes for development. As you advance, you'll be able to build a complete advanced solution for Dynamics 365 Business Central with AL language and Visual Studio Code. You'll then learn how to debug and deploy the extension and write automatic testing. The book will also take you through advanced topics like integration (with Azure Functions, web services, and APIs), DevOps and CI/CD techniques, and machine learning. You'll discover how Dynamics 365 Business Central can be used with Office 365 apps. Finally, you'll analyze different ways to move existing solutions to the new development model based on extensions. By the end of this book, you'll be able to develop highly customized solutions that meet the requirements of modern businesses using Dynamics 365 Business Central. What you will learnCreate a sandbox environment with Dynamics 365 Business CentralHandle source control management when developing solutionsExplore extension testing, debugging, and deploymentCreate real-world business processes using Business Central and different Azure servicesIntegrate Business Central with external applicationsApply DevOps and CI/CD to development projectsMove existing solutions to the new extension-based architectureWho this book is for If you're a new developer looking to get started with Dynamics 365 Business Central, this book is for you. This book will also help experienced professionals enhance their knowledge and understanding of Dynamics 365 Business Central.
Publisher: Packt Publishing Ltd
ISBN: 1789952654
Category : Computers
Languages : en
Pages : 753
Book Description
Develop customized business management solutions with the latest features of Microsoft Dynamics 365 Business Central Key FeaturesLearn Dynamics 365 Business Central, the next generation of Dynamics NAVExplore advanced topics for handling complex integrations such as using APIs, OData, and Azure FunctionsDiscover best practices for developing SaaS extensions and moving existing solutions to the cloudBook Description Dynamics 365 Business Central is an all-in-one business management solution, which is easy to adopt and helps you make smarter business decisions. This book is a comprehensive guide to developing solutions with Microsoft ERP (in the cloud and also on-premises). It covers all aspects of developing extensions, right from preparing a sandbox environment to deploying a complete solution. The book starts by introducing you to the Dynamics 365 Business Central platform and the new Modern Development Environment. You'll then explore the sandbox concept, and see how to create sandboxes for development. As you advance, you'll be able to build a complete advanced solution for Dynamics 365 Business Central with AL language and Visual Studio Code. You'll then learn how to debug and deploy the extension and write automatic testing. The book will also take you through advanced topics like integration (with Azure Functions, web services, and APIs), DevOps and CI/CD techniques, and machine learning. You'll discover how Dynamics 365 Business Central can be used with Office 365 apps. Finally, you'll analyze different ways to move existing solutions to the new development model based on extensions. By the end of this book, you'll be able to develop highly customized solutions that meet the requirements of modern businesses using Dynamics 365 Business Central. What you will learnCreate a sandbox environment with Dynamics 365 Business CentralHandle source control management when developing solutionsExplore extension testing, debugging, and deploymentCreate real-world business processes using Business Central and different Azure servicesIntegrate Business Central with external applicationsApply DevOps and CI/CD to development projectsMove existing solutions to the new extension-based architectureWho this book is for If you're a new developer looking to get started with Dynamics 365 Business Central, this book is for you. This book will also help experienced professionals enhance their knowledge and understanding of Dynamics 365 Business Central.
Microsoft Azure Architect Technologies and Design Complete Study Guide
Author: Benjamin Perkins
Publisher: John Wiley & Sons
ISBN: 1119559553
Category : Computers
Languages : en
Pages : 768
Book Description
Become a proficient Microsoft Azure solutions architect Azure certifications are critical to the millions of IT professionals Microsoft has certified as MCSE and MCSA in Windows Server in the last 20 years. All of these professionals need to certify in key Azure exams to stay current and advance in their careers. Exams AZ-303 and AZ-304 are the key solutions architect exams that experienced Windows professionals will find most useful at the intermediate and advanced points of their careers. Microsoft Azure Architect Technologies and Design Complete Study Guide Exams AZ-303 and AZ-304 covers the two critical Microsoft Azure exams that intermediate and advanced Microsoft IT professionals will need to show proficiency as their organizations move to the Azure cloud. Understand Azure Set up your Microsoft Cloud network Solve real-world problems Get the confidence to pass the exam By learning all of these things plus using the Study Guide review questions and practice exams, the reader will be ready to take the exam and perform the job with confidence.
Publisher: John Wiley & Sons
ISBN: 1119559553
Category : Computers
Languages : en
Pages : 768
Book Description
Become a proficient Microsoft Azure solutions architect Azure certifications are critical to the millions of IT professionals Microsoft has certified as MCSE and MCSA in Windows Server in the last 20 years. All of these professionals need to certify in key Azure exams to stay current and advance in their careers. Exams AZ-303 and AZ-304 are the key solutions architect exams that experienced Windows professionals will find most useful at the intermediate and advanced points of their careers. Microsoft Azure Architect Technologies and Design Complete Study Guide Exams AZ-303 and AZ-304 covers the two critical Microsoft Azure exams that intermediate and advanced Microsoft IT professionals will need to show proficiency as their organizations move to the Azure cloud. Understand Azure Set up your Microsoft Cloud network Solve real-world problems Get the confidence to pass the exam By learning all of these things plus using the Study Guide review questions and practice exams, the reader will be ready to take the exam and perform the job with confidence.
Analyzing Data with Power BI and Power Pivot for Excel
Author: Alberto Ferrari
Publisher: Microsoft Press
ISBN: 1509302816
Category : Business & Economics
Languages : en
Pages : 439
Book Description
Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data
Publisher: Microsoft Press
ISBN: 1509302816
Category : Business & Economics
Languages : en
Pages : 439
Book Description
Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data