Books published by Microsoft Press,U.S.

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data-and transform it into actionable knowledge. Prepare and analyse your data the easy way, with Power Query Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI Solve common data preparation problems with a few mouse clicks and simple formula edits Combine data from multiple sources, multiple queries, and mismatched tables Master basic and advanced techniques for unpivoting tables Customise transformations and build flexible data mashups with the M formula language Address collaboration challenges with Power Query Gain crucial insights into text feeds Streamline complex social network analytics so you can do it yourself

Whether you're a new developer seeking a sound introduction to the practice of software development or a veteran exploring strategic new approaches to problem solving, you'll find a wealth of practical suggestions and methods for strengthening your skills.

This well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsGÇôall students need to make the most of ExcelGÇÖs most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle todayGÇÖs key tasksGÇôand challenge yourself to new levels of mastery.

Microsoft Power BI Dashboards Step by Step guides you through creating world-class business analysis dashboards that integrate today's most widely-used data sources, using any of Microsoft's Power BI platforms, including the new Power BI Premium. Author Errin O'Connor has worked with 70+ Fortune® 500 companies and led 450+ Power BI engagements: he is singularly well-qualified to guide you through successfully designing, architecting, and implementing Power BI in your organisation. Using real-world examples and success stories, this full-colour, hands-on guide walks through the key decisions analysts and developers need to make upfront, and introduces all the concepts, skills, and techniques you'll need to achieve your goals. Coverage includes: Aggregating data and data elements from numerous internal and external data sources Building rich, live dashboards to monitor crucial data from across your organisation Developing dynamic visualisations, including charts, maps, graphs, and more Creating stunning interactive reports Driving user adoption through effective training Taking full advantage of Microsoft's powerful new Power BI Premium Whether you're new to Power BI or you've already built Power BI dashboards, O'Connor supports you throughout your entire data journey, as you bring raw data to life through dynamic visualisations that deliver actionable intelligence for your entire organisation.

Marco Russo and Alberto Ferrari walk students step-by-step through creating powerful data models, and then illuminate advanced features such as optimization, deployment, and scalability. Tabular Modeling in Microsoft SQL Server Analysis Services will be indispensable for everyone moving to Analysis Services Tabular, regardless of their previous experience with tabular-style models or with Microsoft's older Analysis Services offerings. It will also be an essential follow-up for every reader of the authors' highly-praised Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model.

Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps readers get the absolute most out of features and improvements ranging from AutoFill to ExcelGÇÖs newest functions. Along the way, students will discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! Students will find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. GÇó Quickly create powerful spreadsheets with range names and array formulas GÇó Use conditional formatting to instantly reveal anomalies, problems, or opportunities GÇó Analyze your data with standard tables and PivotTables GÇó Use complex criteria to filter data in lists GÇó Understand correlations between data GÇó Perform sophisticated what-if analyses GÇó Use regression to track trends and make forecasts GÇó Build loan, investment, and discount formulas GÇó Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

This bundle contains the following three Exam Refs, direct from Microsoft:Exam Ref 70-740 Installation, Storage, and Compute with Windows Server 2016, 9780735698826Exam Ref 70-741 Networking with Windows Server 2016, 9780735697423Exam Ref 70-742 Identity with Windows Server 2016, 9780735698819These are the three exams necessary to receive MCSA certification in Windows Server 2016. This bundles saves the customer $20 versus the price of purchasing the three Exam Refs separately. Prepare for Microsoft certification Exams 70-740, 70-741, and 70-742 Covers all three exams needed for the MCSA in WIndows Server 2016 Save $20 versus the cost of buying the Exam Refs individually Organizes its coverage by the exam objectives Features strategic, what-if scenarios to challenge the exam candidate

Exam Ref 70-761 Querying Data with Transact-SQL offers professional-level preparation that helps candidates maximise their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with T-SQL database queries. Exam Ref 70-762 Developing SQL Databases offers professional-level preparation that helps candidates maximise their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with SQL database development. These are the two exams necessary for the MCSA certification in SQL Server 2016 Database Development.

This is learning made easy. Get more done quickly with Word 2019. Jump in wherever you need answers--brisk lessons and colourful screenshots show you exactly what to do, step by step. Get easy-to-follow guidance from a certified Microsoft Office Specialist Master Learn and practice new skills while working with sample content, or look up specific procedures Create visually appealing documents for school, business, community, or personal purposes Use built-in tools to capture and edit graphics Present data in tables, diagrams, and charts Track and compile reference materials Manage document collaboration and review Fix privacy, accessibility, and compatibility issues Supercharge your efficiency by creating custom styles, themes, and templates

Learn how to use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if youGÇÖve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical powerGÇöincluding valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical GÇ£recipesGÇ¥ for solving real business problems, help you avoid common mistakes, and present tips and tricks youGÇÖll find nowhere else.

This book shows students how to make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help students instantly visualize information, so they can act on it… capture data from anywhere, and use it anywhere… automate Excel 2019's best new features. Students will find simple, step-by-step instructions, real-world case studies, and workbooks packed with bonus examples, macros, and solutions-straight from MrExcel!

Prepare for Microsoft Exam 70-778-and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.

Transform your skills, data, and business - and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling.

Prepares students for Microsoft Exam 70-480-and helps them demonstrate their real-world mastery of programming with HTML5, JavaScript, and CSS3. Designed for experienced developers ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Specialist level.

This is learning made easy. Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files

The quick way to learn Microsoft Excel 2019!This is learning made easy. Get more done quickly with Excel 2019. Jump in wherever you need answers--brisk lessons and many screen shots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarize, and combine data Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need