Analyzing Data with Power BI and Power Pivot for Excel

DOWNLOAD NOW »

Author: Alberto Ferrari,Marco Russo

Publisher: Microsoft Press

ISBN: 1509302816

Category: Computers

Page: 320

View: 3209

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

Analyzing Data with Power Bi and Power Pivot for Excel

DOWNLOAD NOW »

Author: Alberto Ferrari,Marco Russo

Publisher: Microsoft Press

ISBN: 9781509302765

Category: Business & Economics

Page: 320

View: 5555

To get the right insights from your data, you need to model it right. From Power BI to Power Pivot for Excel, Microsoft offers extremely powerful and accessible tools for modeling data. Now, for the first time, there's a complete guide to building exceptionally effective models using Microsoft's tools. World-renowned Microsoft data analytics experts Marco Russo and Alberto Ferrari introduce all the data modeling theory you'll need, and show how to apply it in the context of Microsoft's current and evolving products. Step by step, you'll learn how to transform simple tables into full analytical models of immense power. You'll master data modeling through a collection of realistic scenarios of increasing sophistication. For each, the authors start with a simple "naive" model that can't provide robust solutions. Next, they guide you to update and improve the model, so it can deliver the knowledge and insights you really need."

The Definitive Guide to DAX

Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

DOWNLOAD NOW »

Author: Alberto Ferrari,Marco Russo

Publisher: Microsoft Press

ISBN: 0735698376

Category: Computers

Page: 592

View: 5867

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio

Microsoft Excel 2013

Building Data Models with PowerPivot

DOWNLOAD NOW »

Author: Alberto Ferrari,Marco Russo

Publisher: Pearson Education

ISBN: 0735676348

Category: Computers

Page: 487

View: 3075

Shows readers how to perform complex data analysis, create reports with the data analysis expressions language, and add hierarchies to data models to enable faster browsing.

Introducing Microsoft Power BI

DOWNLOAD NOW »

Author: Alberto Ferrari,Marco Russo

Publisher: Microsoft Press

ISBN: 1509302751

Category: Computers

Page: 189

View: 6285

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/.

Beginning Power BI

A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop

DOWNLOAD NOW »

Author: Dan Clark

Publisher: Apress

ISBN: 1484225775

Category: Business & Economics

Page: 348

View: 9326

Analyze your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualizations and share them with your colleagues. Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This second edition includes new material on advanced uses of Power Query, along with the latest user guidance on the evolving Power BI platform. Beginning Power BI is your hands-on guide to quick, reliable, and valuable data insight. What You'll Learn Simplify data discovery, association, and cleansing Build solid analytical data models Create robust interactive data presentations Combine analytical and geographic data in map-based visualizations Publish and share dashboards and reports Who This Book Is For Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data

Beginning DAX with Power BI

The SQL Pro’s Guide to Better Business Intelligence

DOWNLOAD NOW »

Author: Philip Seamark

Publisher: Apress

ISBN: 1484234774

Category: Computers

Page: 264

View: 2013

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling challenges. Beginning DAX with Power BI teaches key concepts such as mapping techniques from SQL to DAX, filtering, grouping, joining, pivoting, and using temporary tables, all aimed at the SQL professional. Join author Philip Seamark as he guides you on a journey through typical business data transformation scenarios and challenges, and teaches you, step-by-step, how to resolve challenges using DAX. Tips, tricks, and shortcuts are included and explained, along with examples of the SQL equivalent, in order to accelerate learning. Examples in the book range from beginner to advanced, with plenty of detailed explanation when walking through each scenario. What You’ll Learn Turbocharge your Power BI model by adding advanced DAX programming techniques Know when to use calculated measures versus calculated columns Generate new tables on the fly from existing data Optimize, monitor, and tune Power BI to improve performance of your models Discover new ideas, tricks, and time-saving techniques for better models Who This Book Is For Business intelligence developers, business analysts, or any SQL user who wants to use Power BI as a reporting tool. A solid understanding of SQL is recommended, as examples throughout the book include the DAX equivalents to SQL problem/solution scenarios.

Collect, Transform and Combine Data Using Power Bi and Power Query in Excel

DOWNLOAD NOW »

Author: Gil Raviv

Publisher: Pearson Professional

ISBN: 9781509307951

Category: Computers

Page: 368

View: 2888

Did you know that there is a technology inside Excel, and Power BI, that allows you to create magic in your data, avoid repetitive manual work, and save you time and money? Using Excel and Power BI, you can: Save time by eliminating the pain of copying and pasting data into workbooks and then manually cleaning that data. Gain productivity by properly preparing data yourself, rather than relying on others to do it. Gain effiiciency by reducing the time it takes to prepare data for analysis, and make informed decisions more quickly. With the data connectivity and transformative technology found in Excel and Power BI, users with basic Excel skills import data and then easily reshape and cleanse that data, using simple intuitive user interfaces. Known as "Get & Transform" in Excel 2016, as the "Power Query" separate add-in in Excel 2013 and 2010, and included in Power BI, you'll use this technology to tackle common data challenges, resolving them with simple mouse clicks and lightweight formula editing. With your new data transformation skills acquired through this book, you will be able to create an automated transformation of virtually any type of data set to mine its hidden insights.

Super Charge Power BI

Power BI Is Better When You Learn to Write DAX

DOWNLOAD NOW »

Author: Matt Allington

Publisher: Tickling Keys, Inc.

ISBN: 1615473602

Category: Computers

Page: 180

View: 4728

Power BI is a powerful self-service (and enterprise) business intelligence (BI) tool that was first made generally available by Microsoft in July 2015. Power BI is a complete BI package that covers the end to end BI process including data acquisition (get data), data modelling (prepare/model the data) and data visualisation (analyse the data). And there is a lot of good news about this tool including the fact that the skills needed to succeed with Power BI are fully transferable to Microsoft Excel. There are 3 learning areas required to master everything Power BI Desktop has to offer.1. The M Language - used for data acquisition2. The DAX Language - used to prepare and model data3. Visualisation and analysis - used to present data in a compelling wayPower BI is probably the first commercial grade software product that brings all of these areas into a single software package that is completely accessible to a business user (you don't need to be an IT pro). This book focuses on number 2 above, the DAX language (Data Analysis Expressions). Super Charge Power BI Desktop is the second book written by Matt Allington and is a sister book to his first book Learn to Write DAX (first released Dec 2015). Super Charge Power BI Desktop uses the same learning and practice exercise framework as used in Learn to Write DAX however the entire book is written using the Power BI Desktop user interface. Unfortunately simply reading a book is normally not enough for Excel users wanting to get the most out of Power BI Desktop and to learn the DAX language - most people will also need some practice. Super Charge Power BI Desktop is different to other books - it is written in such a way to clearly explain the concepts of Power BI data modelling while at the same time giving hands-on practice to deeply engage the reader to help the new knowledge and concepts stick. The book first presents the theory, then provides worked through sample exercises demonstrating each of the concepts, and finally it provides the reader with practice exercises and answers to maximize learning retention.

Power Query for Power BI and Excel

DOWNLOAD NOW »

Author: Christopher Webb,Crossjoin Consulting Limited

Publisher: Apress

ISBN: 1430266929

Category: Computers

Page: 272

View: 4056

Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet or directly into the new Excel 2013 Data Model used by Power Pivot. This concise, practical book provides a complete guide to Power Query and how to use it to solve all of your Excel data-loading problems. Power Query for Power BI and Excel goes well beyond the surface of what Power Query can do. The book goes deep into the underlying M language, showing you how to do amazing things that aren’t going to be possible from just the GUI interface that is covered in most other books. You’ll have full command of the GUI, and you’ll be able to drop into the M language to go beyond what the GUI provides. The depth in this book makes it a must-have item for anyone who is pushing Power BI and Excel to their limits in the pursuit of business intelligence from data analysis. Teaches the basics of using Power Query to load data into Excel Helps you solve common, data-related problems with Power Query Shows how to write your own solutions in the powerful M language

Excel Power Pivot and Power Query For Dummies

DOWNLOAD NOW »

Author: Michael Alexander

Publisher: John Wiley & Sons

ISBN: 111921064X

Category: Computers

Page: 288

View: 8367

A guide to PowerPivot and Power Query no data cruncher should be without! Want to familiarize yourself with the rich set of Microsoft Excel tools and reporting capabilities available from PowerPivot and Power Query? Look no further! Excel PowerPivot & Power Query For Dummies shows you how this powerful new set of tools can be leveraged to more effectively source and incorporate 'big data' Business Intelligence and Dashboard reports. You'll discover how PowerPivot and Power Query not only allow you to save time and simplify your processes, but also enable you to substantially enhance your data analysis and reporting capabilities. Gone are the days of relatively small amounts of data—today's data environment demands more from business analysts than ever before. Now, with the help of this friendly, hands-on guide, you'll learn to use PowerPivot and Power Query to expand your skill-set from the one-dimensional spreadsheet to new territories, like relational databases, data integration, and multi-dimensional reporting. Demonstrates how Power Query is used to discover, connect to, and import your data Shows you how to use PowerPivot to model data once it's been imported Offers guidance on using these tools to make analyzing data easier Written by a Microsoft MVP in the lighthearted, fun style you've come to expect from the For Dummies brand If you spend your days analyzing data, Excel PowerPivot & Power Query For Dummies will get you up and running with the rich set of Excel tools and reporting capabilities that will make your life—and work—easier.

Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

DOWNLOAD NOW »

Author: Daniil Maslyuk

Publisher: Microsoft Press

ISBN: 0134857798

Category: Computers

Page: 416

View: 2187

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. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI

High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI

DOWNLOAD NOW »

Author: Adam Aspin

Publisher: Apress

ISBN: 1484224000

Category: Computers

Page: 599

View: 5810

Take business intelligence delivery to a new level that is interactive, engaging, even fun, all while driving commercial success through sound decision making. Do this through the power of visualization using this updated edition covering new features and added support for visualization in Excel 2016, and describing the latest developments in Get & Transform and DAX. The example data set has also been updated to demonstrate all that Microsoft's self-service business intelligence suite is now capable of. High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition helps in harnessing the power of Microsoft’s flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease. Learn the essential techniques needed to enhance the look and feel of reports and dashboards so that you can seize your audience’s attention and provide them with clear and accurate information. Also learn to integrate data from a variety of sources and create coherent data models displaying clear metrics and attributes. Power View is Microsoft's ground-breaking tool for ad-hoc data visualization and analysis. It's designed to produce elegant and visually arresting output. It's also built to enhance user experience through polished interactivity. Power Map is a similarly powerful mechanism for analyzing data across geographic and political units. Get & Transform lets you load, shape and streamline data from multiple sources. Power Pivot can extend and develop data into a dynamic model. Power BI allows you to share your findings with colleagues, and present your insights to clients. High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, 2nd Edition helps you master this suite of powerful tools from Microsoft. You'll learn to identify data sources, and to save time by preparing your underlying data correctly. You'll also learn to deliver your powerful visualizations and analyses through the cloud to PCs, tablets and smartphones. Simple techniques take raw data and convert it into information. Slicing and dicing metrics delivers interactive insight. Visually arresting output grabs and focuses attention on key indicators. What You Will Learn Produce designer output that will astound your bosses and peers. Drive business intelligence from Excel using BI in the Cloud. Gather source data from corporate and public sources. Integrate charts, maps, and tables to deliver visually stunning information. Discover new insights as you chop and tweak your data as never before. Adapt delivery to mobile devices. Outshine competing products and enhance existing skills. Who This Book Is For Any Power BI Desktop, Excel or SharePoint user. Business Intelligence developers, power users, IT managers, finance experts, and more can use this book to outshine the competition by producing high-impact business intelligence reporting on a variety of devices from a variety of sources.

Mastering Microsoft Power BI

Expert techniques for effective data analytics and business intelligence

DOWNLOAD NOW »

Author: Brett Powell

Publisher: Packt Publishing Ltd

ISBN: 1788292286

Category: Computers

Page: 638

View: 7936

Design, create and manage robust Power BI solutions to gain meaningful business insights Key Features Master all the dashboarding and reporting features of Microsoft Power BI Combine data from multiple sources, create stunning visualizations and publish your reports across multiple platforms A comprehensive guide with real-world use cases and examples demonstrating how you can get the best out of Microsoft Power BI Book Description This book is intended for business intelligence professionals responsible for the design and development of Power BI content as well as managers, architects and administrators who oversee Power BI projects and deployments. The chapters flow from the planning of a Power BI project through the development and distribution of content to the administration of Power BI for an organization. BI developers will learn how to create sustainable and impactful Power BI datasets, reports, and dashboards. This includes connecting to data sources, shaping and enhancing source data, and developing an analytical data model. Additionally, top report and dashboard design practices are described using features such as Bookmarks and the Power KPI visual. BI managers will learn how Power BI’s tools work together such as with the On-premises data gateway and how content can be staged and securely distributed via Apps. Additionally, both the Power BI Report Server and Power BI Premium are reviewed. By the end of this book, you will be confident in creating effective charts, tables, reports or dashboards for any kind of data using the tools and techniques in Microsoft PowerBI. What you will learn Build efficient data retrieval and transformation processes with the Power Query M Language Design scalable, user-friendly DirectQuery and Import Data Models Develop visually rich, immersive, and interactive reports and dashboards Maintain version control and stage deployments across development, test, and production environments Manage and monitor the Power BI Service and the On-premises data gateway Develop a fully on-premise solution with the Power BI Report Server Scale up a Power BI solution via Power BI Premium capacity and migration to Azure Analysis Services or SQL Server Analysis Services Who this book is for Business Intelligence professionals and existing Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book to be useful. While understanding of the basic BI concepts is required, some exposure to Microsoft Power BI will be helpful.

Power Pivot and Power BI

The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

DOWNLOAD NOW »

Author: Rob Collie,Avichal Singh

Publisher: Tickling Keys, Inc.

ISBN: 1615473491

Category: Computers

Page: 271

View: 4616

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as "Year over Year" and "Moving Averages" whether they use a standard, fiscal, or a complete custom calendar. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2015.

Microsoft PowerPivot for Excel 2010

Give Your Data Meaning

DOWNLOAD NOW »

Author: Alberto Ferrari,Marco Russo

Publisher: Pearson Education

ISBN: 0735657068

Category: Computers

Page: 416

View: 6304

Microsoft PowerPivot for Excel 2010: Give Your Data Meaning introduces PowerPivot in Excel 2010 to power users and data analysts who want to give their data meaning by creating their own Business Intelligence models. And with Microsoft Excel 2010: Data Analysis and Business Modeling, you'll learn the best ways to use Office Excel 2010 for data analysis and business modeling. Award-winning professor and statistician Wayne Winston shares practical examples to help you transform data into bottom-line results. Web site includes practice files. The two books included in this kit are: 9780735640580 Microsoft PowerPivot for Excel 2010 9780735643369 Microsoft Office Excel 2007: Data Analysis and Business Modeling, 3E

Business Analysis

Microsoft Excel 2010

DOWNLOAD NOW »

Author: Conrad Carlberg

Publisher: Pearson Education

ISBN: 9780789746894

Category: Computers

Page: 528

View: 2122

ANSWER KEY BUSINESS QUESTIONS CONTROL COMPANY FINANCES FORECAST SALES PREPARE BUSINESS CASES MAKE BETTER INVESTMENT DECISIONS IMPROVE QUALITY USE EXCEL 2010 TO GAIN DEEPER INSIGHTS, MAKE SMARTER DECISIONS, AND EARN MORE PROFITS Using real-world examples, Carlberg helps you put Excel’s features and functions to work and get the power of quantitative analysis behind your management decisions. Excel expert Conrad Carlberg shows how to use Excel 2010 to perform the core financial tasks every manager and entrepreneur must master: analyzing statements, planning and controlling company finances, making investment decisions, and managing sales and marketing. Using real-world examples, Carlberg helps you get the absolute most out of Excel 2010’s newest features and functions. Along the way, you’ll discover the fastest, best ways to handle essential tasks ranging from importing business data to analyzing profitability ratios. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions, insider insights, complete step-by-step projects, and more. It’s all complemented by an extraordinary set of web-based resources, from sample journals and ledgers to business forecasting tools. • Use Excel analysis tools to solve problems throughout the business • Build and work with income statements and balance sheets • Value inventories and current assets, and summarize transactions • Calculate working capital and analyze cash flows • Move from pro formas to operating budgets that help guide your management decisions • Prepare business cases incorporating everything from discount rates to margin and contribution analysis About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel skills, and presents focused tasks and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will: • Dramatically increase your productivity–saving you 50 hours a year, or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make

Analyzing Data With Power BI

Introduction to Power BI

DOWNLOAD NOW »

Author: Anthony Williams

Publisher: Createspace Independent Publishing Platform

ISBN: 9781548974718

Category:

Page: 86

View: 9432

Analyzing Data with Power BI If you are thinking of doing some data science work, first you have to get familiar with data libraries, various techniques of data modelling, in other words you have to dive into data analysis discipline with some fundamental understanding of this science. This book provides you that, fundamental of business and data analytics and insight into various data models and algorithms all written having a beginner in mind. Further chapters will introduce you to powerful business analytics tool provided by Microsoft Power BI. By the time you are done with the book you will master business analytics modelling with Power BI and share it to other users who are interested in same topic as you are. Data analytics also may be the right answer for you if you are involved in marketing management since it can help you with operating, strategic and financial performance. On the other hand Power BI will let you to ask all the right questions and help you to make wise business decisions. If this sounds good to you, let`s dive in together into the data analysis with Power BI. What you will learn in Analyzing Data with Power BI: Basics of data analysis processes Fundamental data analysis algorithms Basic of data and text mining, data visualization and business intelligence Techniques used for analysing quantitative data Basic data analysis tasks Conceptual, logical and physical data models Power BI service and data modelling Creating reports and visualizations in Power BI Data transformation and data cleaning in Power BI Real world applications of data analysis Get this book today and learn more on Analyzing Data with Power BI !! Buy the Paperback version AND get the eBook for FREE!!

M Is for (Data) Monkey

A Guide to the M Language in Excel Power Query

DOWNLOAD NOW »

Author: Ken Puls,Miguel Escobar

Publisher: Tickling Keys, Inc.

ISBN: 1615473459

Category: Computers

Page: 212

View: 4716

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

DOWNLOAD NOW »

Author: Chris Sorensen

Publisher: Microsoft Press

ISBN: 1509308105

Category: Computers

Page: 256

View: 8664

Prepare for Microsoft Exam 70-779–and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Microsoft Excel Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis